Accounting: QuickBooks, Xero, NetSuite, Sage or CSV
Your books stay where they are. Pick them once: Settings, Billing, Accounting, Your books are in.
QuickBooks Online or Xero: link it live.
- Click Link QuickBooks live (or Link Xero live).
- Sign in to your accounting company and allow the link.
- From then on, every invoice and payment goes over by itself, and payments your bookkeeper records there come back.
For QuickBooks Online, Bring in two years of history teaches the cash forecast who pays late.
One list, not two (QuickBooks Online). Once linked, your customers, vendors and products come in from QuickBooks, and stay in step. Add or change one in QuickBooks and it shows up here within the hour.
- It goes one way: from QuickBooks to here.
- QuickBooks fills in what's empty here. It never overwrites something you changed here. If you fix a phone number here, it stays.
- A record that came from QuickBooks shows In QuickBooks next to its name.
- A customer you add here goes to QuickBooks with their first invoice.
- Products and services with a price land on your price list. Inventory items land in Inventory. QuickBooks sets the starting count only. After that the count here is your own, and goes down as jobs use material.
- A sub-customer in QuickBooks (a job filed under a customer) is not brought in as a customer.
- Something you remove here is not brought back.
To pick which lists follow:
- Click Settings, then Billing.
- Find Accounting, then Kept in step from QuickBooks.
- Untick a list to leave it alone.
To bring things in right now, click Check QuickBooks now in the same place.
Any system: export.
- Pick the dates and what to export: Invoices, Payments or Customers.
- Click Download the file.
- Import it in your accounting system:
- QuickBooks Desktop: File, Utilities, Import, IIF Files.
- QuickBooks Online: Gear, Import Data, Invoices.
- Xero: Business, Invoices, Import.
- NetSuite: Setup, Import/Export, Import CSV Records.
- Sage or anything else: the CSV has a column for each thing your system asks for.
The last export date shows, so you know where to start next time. Only the owner, the office manager or the bookkeeper can link or export.
Purchase orders and supplier bills Invoices show what a job sold for. To have the books show what it cost too, send your purchases over.
- Click Settings.
- Click Invoices and payments.
- Find Accounting, then Purchases.
- Tick Send each purchase order when it goes to the supplier if you want purchase orders in your books.
- Tick Send a bill when all of an order has come in if you want the bill.
What happens:
- A purchase order goes over when you send it to the supplier.
- A bill goes over when the whole order has been received, for what came in at what it cost, dated the day it came in. An order that is only part in waits.
- In QuickBooks Online the lines go to your Cost of Goods Sold account. The supplier is matched by name, or added.
- In Xero both arrive as drafts, for your bookkeeper to check and approve.
- Voiding the order here closes the purchase order there and takes the bill back.
- Whoever receives the order doesn't need a billing role. It is sent for them.
Not linked live, or on QuickBooks Desktop? Under Export, pick Purchase orders or Supplier bills, pick the dates and download the file.
This is the manual that's inside the app, where every screen also has Ed to ask. Still stuck? Contact support.