Connect QuickBooks Online

QuickBooks Online stays your accounting ledger. Connecting it brings your customers, suppliers and price book items into CREW25, sends QuickBooks the invoices you approve and your expenses, and reads back which invoices were paid and the bills entered in QuickBooks. Only owners and admins can connect it. Everyone else in the office can see the page.

Before you start

  • One accounting system at a time. If Xero is connected, disconnect it first. Connecting QuickBooks then starts afresh, with its own accounts and choices.
  • QuickBooks Online only. QuickBooks Solopreneur (formerly Self-Employed) can't be connected, and CREW25 says so when you try.
  • What your plan has switched on counts. CREW25 reads your company's QuickBooks settings when you connect and again each night. If your plan tracks quantity on hand, items tracked as inventory in QuickBooks keep only their name and sell price in step with CREW25.

Connect

  1. Go to Settings → Integrations and choose QuickBooks.
  2. Choose Connect to QuickBooks and sign in to Intuit.
  3. Choose the QuickBooks company to use.

Connecting starts syncing straight away. CREW25 reads your customers, suppliers, price book items and business details, which can take a few minutes. It also picks a sales account, a bills account and the GST and GST-free tax codes from your company. If it can't find the usual ones, it asks you to choose them. If the page shows Bring in from QuickBooks, choose it to run that first import.

Choose how it works

Choices

  • Invoices: a switch. When it is on, approving an invoice sends it to QuickBooks. Invoices approved before you turned it on are not sent.
  • Bills: a switch that sends the expenses you make in CREW25 to QuickBooks as bills, with their files.

Accounts

  • Sales account: where invoice lines go when the price book item or job category doesn't have its own account.
  • Card payments account and Other payments account: where payments are deposited in QuickBooks, such as a bank account or Undeposited Funds. Other payments are the ones you record yourself, such as bank transfer, cash or cheque.
  • Bills account: where the lines of those bills are coded.
  • GST and GST free: the tax codes for invoices, if CREW25 couldn't find the standard ones.

What syncs

Sent to QuickBooks:

  • Approved invoices, with their lines, CREW25's number and GST worked to the cent. Voiding an invoice in CREW25 voids it in QuickBooks.
  • Payments: card payments and payments you record, linked to their invoice.
  • Expenses made in CREW25, as bills with their files, if the Bills switch is on.
  • Customers, suppliers and price book items, matched or created. A business that is both a customer and a supplier gets a second record in QuickBooks, named "(supplier)" or "(customer)", because QuickBooks needs each name to be unique.

Brought back from QuickBooks:

  • Paid invoices. An invoice paid in QuickBooks, including one matched from your bank feed, shows as paid in CREW25.
  • Bills entered in QuickBooks, with their files, which appear under Expenses. Open one and choose its Job to put it against a job.
  • Changes to customers, suppliers and price book items.

What doesn't sync: quotes, purchase orders and credit notes. Only the expense you make from an order goes to QuickBooks.

Sync now, disconnect or reconnect

Choose the sync icon beside the connection to check QuickBooks straight away. Anything that didn't go through is in the Sync log, with the reason and a Retry. Choose Disconnect to stop syncing. Records already sent stay in QuickBooks. If you see Reconnect needed, choose Reconnect.

Need a hand? Choose Help in the account menu to message us.

Did this answer your question?

Still stuck?

Email us and tell us what you tried.

support@crew25.com