QuickBooks

Keep QuickBooks Online in step with your invoicing — copy invoices to QuickBooks, link clients to QuickBooks customers, bring payments, expenses, vendors and statements back in, and optionally add expense claims as bills.

Updated 15 min read

If you keep your books in QuickBooks Online, AspirePro can copy your invoicing to your QuickBooks company — so the invoices you raise in AspirePro appear in QuickBooks without double entry, and payments come back.

A company's Finance tab, including QuickBooks

The QuickBooks connection is set up under System → Integrations → QuickBooks: choose Connect QuickBooks, sign in at QuickBooks and pick your QuickBooks company. The page then shows your QuickBooks company, whether it's Live or a Test company (a QuickBooks test company never reaches your real books), and when it was Last checked. The page's tabs are Overview, Invoices, Products and services, Payments, Sync and Reimbursements. In the header, Bring in payments now checks QuickBooks for new payments straight away, and the ⋯ menu has View sync activity (Finance → Sync) and Disconnect QuickBooks….

Copying an invoice to QuickBooks#

Choose once who emails your invoices, under Who emails your invoices — on System → Finance settings → Invoices, or on the QuickBooks page's Overview tab (it's the same setting):

  • QuickBooks — Send adds the invoice to QuickBooks with the recipients as its email, then QuickBooks emails it (the invoice's button reads Email from QuickBooks).
  • AspirePro (our PDF and email), with Also add each invoice to QuickBooks on — Send adds the invoice to QuickBooks, or updates it there, as AspirePro emails it. An invoice already in QuickBooks is always brought up to date before AspirePro emails it, whichever is set (with payments recorded, only in who it goes to, its number, memo, due date and terms — see below).
  • Copy to QuickBooks in the invoice's ⋯ menu (Update in QuickBooks once it's there) adds the invoice to QuickBooks, or updates it, and emails no one — the invoice stays a draft in AspirePro, marked In QuickBooks, until it's sent. A draft's copy carries no client email until then, so QuickBooks can't email or remind the client about it; sending puts the recipients on it.

The invoice shows when it was last updated in QuickBooks, any problem QuickBooks reported, and its QuickBooks pay link. Its billing period is the month its agreement's Invoices count for says (the month it's dated by default); change it in Details, and AspirePro asks first. Nothing changes in QuickBooks, and a sync won't undo a month you set. Void or empty invoices can't be copied to QuickBooks, and neither can one with money already on it that isn't in QuickBooks yet (it would bill the full amount again).

Every line goes across for exactly its amount. Sales tax goes as its own line booked to the account you choose, or QuickBooks works it out itself — see Sales tax. If QuickBooks ends up with a different total, it's flagged on Finance → Sync.

Where each line posts#

Every line of an invoice copied to QuickBooks posts to a real QuickBooks product or service — and so to its income account — so your QuickBooks revenue reports split the way you sell:

  1. A QuickBooks product or service chosen on the line — click Posts to … under the line's description, on the create page or in the editor, and pick from QuickBooks' own list. Choose Automatic to go back to the order below.
  2. A line for a product in your catalog posts to the QuickBooks product it's linked to (link your products and services to QuickBooks on the Products and services tab).
  3. An agreement's fee posts to the product the agreement is for — the one product its recurring lines share — or, if they're mixed, the product its type is billed as (System → Finance settings → Agreements → Types).
  4. Anything else posts to the Product or service for other lines, under Default product or service on the QuickBooks page's Invoices tab.
  5. Only when nothing is chosen does AspirePro use AspirePro Services (general, added for you) — a general product it adds to QuickBooks on your first income account. The invoice page flags those lines so you can fix it.

The invoice page shows, under each line, where it will post. A line's service date goes to QuickBooks as its service date. (With Xero connected instead, Posts to chooses the line's Xero sales account; unchosen lines use the default sales account.) A product AspirePro adds to QuickBooks goes under the Income account for new products (Products and services tab); a product already in QuickBooks keeps its own — copying an invoice never moves it.

Terms#

An invoice's payment terms go to QuickBooks as its Terms as well as its due date. AspirePro uses QuickBooks' own term with the same number of days (the same name first); when QuickBooks has none, it makes one named as it is here ("Net 45", "Due on receipt"). A term that is due on a day of the next month ("Due on the 1st of next month") goes as a date-driven term: AspirePro uses QuickBooks' own date-driven term due on that day, or makes one. The due date is still sent explicitly. On the invoice, choose a term from the list, or Custom… to type the number of days.

Linking a company to a QuickBooks customer#

On a company's Finance → Integrations tab you manage the QuickBooks link for that client:

  • Enable QuickBooks for this company.
  • Search your QuickBooks customers and pick one to link the company to (a customer already linked to another company says so and can't be picked).
  • Unlink to remove the link.
  • Bring in invoices pulls that customer's invoices in from QuickBooks.

Linking is one-to-one — a company is linked to a single QuickBooks customer — so there's never any doubt about where an invoice belongs.

Adding missing customers#

Add missing customers to QuickBooks, on the QuickBooks page's Invoices tab under Copying invoices to QuickBooks, is off by default (and recommended off). While it's off, an invoice is only copied to QuickBooks if its company is linked to a QuickBooks customer, or has exactly the same name as one. Switch it on and copying an invoice for a company that isn't in QuickBooks adds the company as a new QuickBooks customer, with its main contact's email and its phone number — handy, but it can fill QuickBooks with customers you'd rather keep out. (It adds customers, not invoices; when an invoice is copied to QuickBooks is set out under What AspirePro adds to QuickBooks.)

Receiving payments#

When you record a payment on an invoice that's in QuickBooks, it's added to QuickBooks too — no need to log in to QuickBooks to mark it paid. The invoice's Receive payment dialog asks for what QuickBooks' own Receive payment asks for: the deposit to account (Undeposited Funds or a bank account), QuickBooks' payment method, the reference number and a memo. Choose the account the dialog starts with under Receiving payments → Deposit payments to, on the QuickBooks page's Payments tab. Undeposited Funds is QuickBooks' holding account for payments not yet banked, which you later group into one bank deposit.

  • Invoices brought in from QuickBooks always record their payments there — QuickBooks is the source of truth for their balance — and read QuickBooks' new balance straight back.
  • Invoices AspirePro copied to QuickBooks add the payment there by default; switch it off in the dialog to record it only here — except while QuickBooks' copy carries a live pay link. Then it has to go to QuickBooks too (the switch is on and locked), or QuickBooks would keep asking the client for the full amount.
  • A payment is never recorded twice: each one AspirePro adds carries a marker in its memo, so if QuickBooks' answer is lost and AspirePro tries again, it finds the payment already there, and the next check for payments sees it as the same money.
  • Removing a payment AspirePro added to QuickBooks deletes it from QuickBooks too — never a payment someone entered in QuickBooks themselves.

Recurring invoices#

QuickBooks' recurring invoices show in Finance → Recurring invoices, marked Runs in QuickBooks, and can be set up, changed, ended or moved to AspirePro from there. See Recurring invoices.

Keeping in step#

AspirePro keeps its view of QuickBooks up to date: it refreshes a company's QuickBooks invoices when you open its Finance tab if they're out of date, and a payment usually shows up as soon as QuickBooks tells AspirePro about it. While any invoice is unpaid, AspirePro also checks every 15 minutes, and it checks everything again every night (how soon payments show up). Payments recorded in QuickBooks are brought in so AspirePro shows what really happened — including every page of a large client's invoices, and payments edited, moved or deleted in QuickBooks (an edit becomes a dated correction, never an overwrite). The Sync tab on the QuickBooks page sums this up, with a Bring in payments now button.

Your organization is linked to one QuickBooks company. Connecting a different one on top of linked records is refused; to switch, use the Linked QuickBooks company card on the page's Overview tab — see Finance sync.

When the connection needs reconnecting#

QuickBooks sometimes stops accepting AspirePro's sign-in — most often after a long stretch with no activity, or when someone removes AspirePro's access in QuickBooks. When that happens:

  • System → Integrations → QuickBooks shows Needs reconnecting, with QuickBooks' reason, a Reconnect QuickBooks button and Disconnect QuickBooks. The settings tabs stay hidden until it's back, since they read their lists from QuickBooks.
  • A banner across the top of every page tells the people who can change Finance settings, with a link to that page. It says what's paused: syncing with QuickBooks waits (nothing is lost — it catches up after the reconnect), invoices QuickBooks works out the tax for wait unsent, and your other Finance settings that use QuickBooks fall back to AspirePro meanwhile, each card saying how (see Finance settings).
  • The same people get one notification.

Reconnect keeps everything. Reconnect and choose the same QuickBooks company, and everything carries on where it left off: every linked invoice, customer and payment, and every setting on this page — the default product, where payments are deposited, the income and sales tax accounts. Your Finance settings apply again by themselves and the banner goes. (Connecting a different company is refused, as above.)

Disconnecting starts over. Disconnect QuickBooks… stops invoices, bills and payments syncing with QuickBooks. Your sales tax, deposit and product choices on the page are cleared, and anything QuickBooks handled in Finance settings goes back to AspirePro. Invoices already in QuickBooks stay there.

What AspirePro brings in from QuickBooks#

The connection works both ways. Besides copying invoices to QuickBooks, AspirePro brings your spending in every hour, read-only:

  • Expenses — purchases, bills, and vendor credits, with split lines and exact category attribution. Bills AspirePro made itself, from an expense claim or a pay run, are skipped, so they're never counted twice.
  • Vendors — everyone you pay.
  • Expense categories — with their COGS/expense classification and parent/child hierarchy.

This powers Expenses & Vendors, feeds customer-tagged spend into Profitability, and lights up Statements — your P&L, Balance Sheet, Cash Flow, and aging reports, read straight from QuickBooks' own reports. All edits to this spending happen in QuickBooks; AspirePro just shows it.

Invoices made in QuickBooks#

Invoices your team writes in QuickBooks, and the ones its recurring templates make, come into AspirePro for linked customers, so a client's Finance tab, Finance → Invoices, reports and profitability show all of them. QuickBooks owns them: they're read-only here, and payments, changes and voids made in QuickBooks come back on the next sync. The exception is which agreement an invoice is on, which is AspirePro's own. It's set automatically only when one agreement clearly covers the invoice's month (a prepaid block billed up front only in the month its price is due), and you can change or clear it on the invoice. See Which agreement an invoice is on.

What AspirePro adds to QuickBooks#

Reading your books and changing them are very different levels of trust, so what AspirePro adds to QuickBooks is set in two places — Who emails your invoices (on System → Finance settings → Invoices, or the QuickBooks page's Overview tab), and the QuickBooks page's Invoices and Reimbursements tabs on System → Integrations → QuickBooks — and each kind of thing is its own choice. Turning any of it on is a decision your organization makes deliberately; an organization that only wants AspirePro to read its books can have that, and stay there.

Three things can be added today:

  • Invoices — AspirePro adds an invoice to QuickBooks, or updates what it says there, at these moments and no others (voiding an invoice cancels its copy too — see Invoices; payments are under Receiving payments):
  • When it's sent, according to Who emails your invoices: with QuickBooks, every invoice is added to QuickBooks first; with AspirePro (our PDF and email), every invoice is added as it's emailed while Also add each invoice to QuickBooks is on — and it starts out on once QuickBooks is connected. A recurring invoice sent automatically follows the same setting (with its own Put it in QuickBooks when it's sent switch when AspirePro emails them). An invoice already in QuickBooks is brought up to date before AspirePro or QuickBooks emails it, whichever is set.
  • When QuickBooks works out its sales tax (Sales tax) — as it's sent, whoever emails it (Stripe and Xero included), or when it's put in QuickBooks: the tax comes from QuickBooks' copy.
  • When Pay now is taken by QuickBooks Payments — as AspirePro or QuickBooks sends it, since the pay link lives on QuickBooks' copy. Add Pay now to them on Finance settings updates the copies of open invoices that were added before Pay now was on, so each gets a pay link; it never adds a new one.
  • When it's renumbered, if it's already there — its copy takes the new number.
  • Copy to QuickBooks in an invoice's ⋯ menu, whenever you choose, emailing no one.

To send invoices without adding any to QuickBooks, choose AspirePro (our PDF and email), switch Also add each invoice to QuickBooks off (and each recurring invoice's Put it in QuickBooks when it's sent), keep sales tax with AspirePro and Pay now with Stripe or off; then only Copy to QuickBooks adds one. A draft put in QuickBooks carries no client email there until it's sent, so QuickBooks can't email or remind the client about it (nor make it a pay link). An invoice with payments recorded is never copied to QuickBooks, and its copy there is only ever updated in who it goes to, its number, memo, due date, terms and online-payment switches — after checking QuickBooks' total matches — never in its lines. Add missing customers to QuickBooks and the Sales tax account are on the Invoices tab. - Expense claims → Bills — one claim at a time, only when you press Copy to QuickBooks, from the expense claim, or several at once from Finance → Reimbursements → Not in QuickBooks. Each one adds one Bill to QuickBooks for that person's vendor, one line per item, each recorded in the account linked to its category. AspirePro checks the vendor and each line's account first, and shows you the bill before adding it. Approving a claim never changes anything in QuickBooks. Nothing here happens automatically. - Pay-run contractor bills — when you choose QuickBooks Online under Bills in the pay run settings, each contractor on a pay run gets one Bill in QuickBooks, made through Finance → Sync when the run is approved (or marked paid, as you choose). It's off until you turn it on. See Pay-run contractor bills.

Why bills against a vendor#

Reimbursements go through accounts payable, not payroll — that's how they actually work in practice. Contractors are vendors by definition, and most organizations already keep a vendor record for employees who submit expenses, precisely so reimbursements don't get tangled up with wages, taxes, and withholding they have nothing to do with. So AspirePro adds what your accountant would: a bill, for a vendor.

Linking people to vendors#

Because of that, each person must be linked to a QuickBooks vendor before their claims can become bills — from the Payees list on the Reimbursements tab, where each person shows the QuickBooks vendor they're linked to, or Not linked yet. Link vendor (Change vendor once linked) searches your QuickBooks vendors, starting with the person's first name, and a person confirms the match; the × beside a linked vendor unlinks it. AspirePro never creates vendors for you: auto-created payees are how you end up with three spellings of the same person and no idea which one your history hangs off. If no QuickBooks vendor matches, add the person in QuickBooks first, then search again. A claim from a person who isn't linked is refused with a message telling you exactly who to link.

Linking categories to accounts#

People log expenses against a short local category list ("Travel", "Software", "Meals") — never your chart of accounts. Each local category is linked to one QuickBooks expense account, set once under Expense accounts on the Reimbursements tab, or on Finance → Reimbursements → Categories. Only people who review expense claims or manage Finance settings can change these accounts. A reviewer can still change a single item's account on the claim.

Adding a bill is refused — with the category named — when any line has no account, instead of picking a plausible one for you. A guessed account produces a bill in your books that looks perfectly normal and is quietly wrong, the kind of error that surfaces months later during a reconciliation. A clear refusal costs you thirty seconds: link the category, or set the account on the item, and try again.

When QuickBooks says no#

A bill QuickBooks refuses never undoes the approval. The approval is a fact about your team's decision; whether QuickBooks accepted the bill is a separate question, and the two shouldn't be able to break each other. Whether the claim is in QuickBooks, and any problem QuickBooks reported, are shown on the claim itself in Finance → Reimbursements — never hidden.

Pay-run contractor bills#

Pay runs can bill contractors instead of paying them through payroll. With QuickBooks Online chosen as Where bills go, each contractor on an approved run gets one bill, with one line per account: the Expense accounts you choose in the pay run settings, with recoveries netted off so no line is negative. A bill's reference is AP-PAY plus the run and person numbers, so it's easy to spot in QuickBooks.

Pay-run payees. Like expense-claim bills, a pay-run bill goes to a vendor you've linked yourself; AspirePro never creates one. On the Reimbursements tab, the Pay-run payees section (shown once your organization has started pay runs) lists everyone a pay run bills, including people without a sign-in. Use Link vendor (Change vendor once linked) on each, and Unlink vendor in its ⋯ menu to undo it. A person without a sign-in can only be billed once linked here.

Staff contractors are the exception: if one has no vendor of their own in Pay-run payees, their bill goes to the vendor linked for them on the Payees list above (the one used for expense claims). That list says so under its heading. A vendor linked in Pay-run payees always wins.

Anyone who isn't linked isn't billed and stays in the payroll provider file instead, so nobody is missed. QuickBooks bills are made through Finance → Sync, which shows each one and lets you retry or cancel it. AspirePro doesn't mark them paid; payments are yours to record in QuickBooks. A pay-run bill is never brought back as an expense, because its cost is already counted from the pay.

QuickBooks keeps a copy, not the original — you continue to raise and manage invoices in AspirePro (where they're tied to your time and agreements), and QuickBooks stays in step for your accounting.

Bring your whole services business together

Stop stitching together five tools. Run sales, delivery, support, and billing from one organization — with an AI assistant on every page.