Connect QuickBooks
Customry One can link straight to your company in QuickBooks Online, so there are no files to download and import. You connect once, then set up how VAT rates, nominal codes, payment terms and customers match theirs.
Before you connect
Section titled “Before you connect”QuickBooks only keeps our invoice numbers if its Custom transaction numbers setting is on. In QuickBooks, open Settings → Account and settings → Sales, and under Sales form content switch on Custom transaction numbers.
QuickBooks also takes numbers of 21 characters at most. The standard numbers (INV-002471, CN-000123) fit easily. If you’ve lengthened the prefix or digits under Administration → Numbering, check the next invoice and credit note numbers are short enough.
If either isn’t right, connecting stops and the page says what to change. Nothing is linked until it’s put right.
Connect
Section titled “Connect”You need to be able to manage the accounting link. Ask your administrator if you can’t see Administration → Accounts Package.
- Open Administration → Accounts Package.
- Under How they get there, pick Live link to QuickBooks Online. Intuit’s sign-in page opens.
- Sign in, pick the company, and select Connect.
- QuickBooks sends you back to the Accounts Package page, which shows the company, its home currency, and who connected it.
The company can be linked to one accounts package at a time. If it’s linked to Xero, pick File export (Sage 50) first to disconnect it, then connect QuickBooks.
Set it up
Section titled “Set it up”The Accounts Package page then shows what to set up before anything goes. Nothing is sent to QuickBooks while you do this.
VAT rates
Section titled “VAT rates”Each of your VAT rates goes over as one of QuickBooks’ VAT codes. The page suggests one for each: 20% → 20.0% S, 5% → 5.0% R, 0% → 0.0% Z. Check the suggestions, change any that are wrong, and select Save. Reverse charge, EC and exempt rates work the same way: pick the QuickBooks code that matches.
Customry One sends the VAT it worked out for each invoice, so the totals in QuickBooks match the invoice your customer got, to the penny.
A line in QuickBooks can’t name an income account directly. It goes through an item, and the item says which income account the sale goes to. So each nominal code Customry One uses needs an item there. Carriage has its own item.
Under Items, for each nominal code either:
- pick one of your QuickBooks items under Their item, and select Save; or
- leave Their item blank, choose the income account under Or create one for, and select Create one service item per income account. Customry One makes a service item for each income account, called something like Sales 4000 (Customry One), and maps it. Carriage gets Carriage (Customry One).
If your QuickBooks company uses account numbers, the income account with the same number as the nominal code is chosen for you.
The lines on the invoice in QuickBooks still carry your description, quantity and price. The item is only the route to the right income account.
Payment terms
Section titled “Payment terms”Under Payment terms, pick the QuickBooks terms for each of your payment terms. Suggestions are made by name, then by the number of days. Customers go to QuickBooks with the terms you pick. Leave one blank and QuickBooks uses its own default.
Customers
Section titled “Customers”Each customer that’s invoiced is paired with its customer in QuickBooks, so nobody is created twice. They’re matched on account ref first (from the line in their Notes), then on exactly the same name. Check the rest, then select Save matches. A customer left blank is created in QuickBooks when its first invoice goes. QuickBooks Online has no account number for a customer, so your account ref goes in its Notes, as Customry One account: ACME01; leave that line there, as it is what matching on account number reads. See Accounting mappings.
The start date and sending
Section titled “The start date and sending”When you first connect, the start date is set to today. Invoices and credit notes dated before it are treated as already in the accounts, so they’re never sent. Change it under Start date if you go live on another day.
Under Sending:
- Send as they’re issued: on, each invoice and credit note goes as soon as it’s issued. Off, they wait on the sync queue until someone selects Send all held now.
- Attach our PDF: the invoice in QuickBooks carries the PDF your customer got.
QuickBooks has no draft invoices, so everything goes as a finished invoice. Customry One still emails your customers as it does now; QuickBooks is never asked to email them, so nobody gets two copies.
If QuickBooks turns something down, it waits on the sync queue with the reason, and the people who look after the link are told under the bell.
Reconnect
Section titled “Reconnect”QuickBooks asks for the connection to be renewed if it hasn’t been used for about 100 days, or if someone disconnects Customry One in QuickBooks. When that happens, the Accounts Package page shows Needs reconnecting, and everyone who can manage the accounting link sees a banner across the top of every page and is told under the bell, and by email unless they’ve turned it off (Notifications). Select Reconnect and sign in again, picking the same company. Everything you set up carries on.
Pause or disconnect
Section titled “Pause or disconnect”Switch on Pause sending to stop anything going for a while. Invoices and credit notes still queue as they’re issued, and go when you switch it off.
To go back to the file export, pick File export (Sage 50) under How they get there and confirm. Customry One tells QuickBooks to forget the connection, and invoices go to your accounts package as a file again (Sage 50 export). What was linked is kept, so connecting the same company again carries on where it left off.
Connecting, disconnecting and changes to the mappings are recorded in Administration → Audit Log.