Bill.com sits between your bills and your books: it captures invoices, routes approvals, sends payments, and syncs the lot to QuickBooks or NetSuite. Set up well, it's invisible: bills go in, approved payments go out, and the ledger just agrees. Set up loosely, it produces the quiet kind of mess: duplicate vendors, payments recorded twice, and a clearing account balance nobody can explain. The difference is almost entirely in the first week of setup.
Decide where records live before you connect anything
The single most important decision is which system owns what. Once Bill.com is your AP tool, bills and their payments should be created there and flow to the ledger through the sync, not entered in both places. The classic failure is a helpful hand recording a payment directly in QuickBooks that the sync then delivers again. Write the rule down, tell everyone who touches the books, and treat manual AP entries in the ledger as the exception that needs a reason.
Get the first sync clean
The initial sync copies lists both ways, so it faithfully reproduces whatever mess exists. Before connecting:
- Merge duplicate vendors.
- Retire the ones you no longer use.
- Confirm the chart of accounts is the one you actually want mapped.
Then check the mapping itself: GL accounts, and classes, locations, or departments if your ledger uses them. Ten minutes of list hygiene before the first sync saves hours of untangling doubled vendors after it.
Make the approval chain mean something
Approvals are the reason to use Bill.com rather than paying straight from the bank, so don't leave them switched off "until things settle." Set approval policies that match how you really authorize spending. Even a single threshold (over a set amount needs a second person) is real control. And separate duties: the person who approves a bill shouldn't be the same person who releases the payment.
Use the roles, sparingly
Bill.com ships with roles for a reason:
- Clerks enter bills.
- Approvers approve.
- Payers pay.
- Accountants run the payables process without paying.
- Auditors can see everything but change nothing.
- Administrators change settings.
The common mistake is making everyone an administrator to get launched. Hand out the smallest role that does the job, and keep the administrator list to one or two names.
Reconcile the clearing account
Payments flow through a Bill.com clearing account in your ledger, and that account should net to zero once everything posts and clears. A balance that lingers is your early-warning light: something was double-recorded, a sync entry failed, or a payment is stuck mid-flight. Put the clearing account on the month-end checklist next to the bank reconciliation.
Work the sync errors, and mind the payment clock
Sync errors wait until someone fixes them and syncs again, and a backlog nobody owns grows quietly until the books drift. Make checking it part of someone's routine. Same for payment timing: electronic payments and mailed checks each have lead times between "pay" being clicked and money arriving, so schedule payments around when funds actually leave; your cash flow and your vendors will both behave better.
The QuickBooks Online sync errors, by message
Bill.com's help centre has one article per sync error, and most of the QuickBooks Online ones trace back to the two habits this guide warns about: paying the same bill in two places, and letting the lists drift. Here they are by the message you'll see.
This bill's already been paid
The bill was marked paid in QuickBooks Online before Bill.com's payment synced, usually because someone recorded the payment by hand in the ledger. The same problem can read "Invalid updated amount for fully paid bill". Bill.com's fix is to delete or void the QuickBooks payment and sync again. If you need to keep that payment, clear the error from the bill's sync status instead, and if Bill.com really did send the money, make sure the QuickBooks payment comes out of the Money Out Clearing account so the ledger stays in balance.
Cannot import payment - it would result in overpayment
The same habit, partway: the bill was paid or credited in QuickBooks Online and paid again in Bill.com. Find the bill in QuickBooks Online, remove the credit or partial payment applied to it there, and sync again.
The vendorId cannot be updated on the Bill because there are existing payments
QuickBooks Online locks a bill once it's paid, so an edit made in Bill.com afterwards can't sync. Check the bill is right and marked paid in QuickBooks Online, correct it there by hand if it needs it, and ask Bill.com support to clear the error.
Duplicate Document Number Error: You must specify a different number. This number has already been used
Either the reference number on an offline payment recorded in Bill.com is already in use in QuickBooks Online, or a funds transfer is trying to take the next journal entry number and that number is taken. For the payment, void it and record it again with a unique reference number. For the funds transfer, give the latest journal entry in QuickBooks Online a number that's unique, or, as Bill.com's alternative, untick Warn if duplicate journal number in the journal entry settings.
We can't sync because your books are closed in QuickBooks Online
The transaction is dated in a period you've closed. Change its date in Bill.com to an open period if you can. A payment's date can't be changed, and neither can a bill dated before the closing date, so for those, record the transaction in QuickBooks Online by hand and ask Bill.com support to clear the error. Bill.com itself advises against reopening the books to let it through, because other transactions can sync into the reopened period too.
The following fields are missing
A vendor or customer in QuickBooks Online has no street address, city, state or ZIP code, or no country when multicurrency is on, and Bill.com won't accept the record without them. Add what the message names in QuickBooks Online and sync again. Cleaning the vendor list before the first sync heads this one off.
If errors keep coming back after you've worked them, or nothing syncs and no error shows, Bill.com's next step is to disconnect and reconnect the sync. It deletes nothing, but it needs administrator or sync-management permissions in Bill.com, and it's also the fix when the person who first set up the sync has been deactivated or a password has changed.
When to bring in help
A single company file with a tidy vendor list is a reasonable DIY. Syncing with NetSuite, multiple entities, class or department mapping, or moving an existing pile of AP process into Bill.com mid-year is where a clean setup pays for itself. That's the wiring I do: the technical setup and integration, while your accountant owns how the books are kept.
Ten Rivers Systems handles technical setup, configuration, and data migration only and does not provide accounting or tax advice. I am not an accountant or tax adviser. How you keep your books and what you owe stays between you and your own professionals.
Common questions
Does Bill.com sync with QuickBooks and NetSuite?
Yes. Bill.com has two-way sync with QuickBooks Online and Desktop, NetSuite, and other ledgers. The sync itself is rarely the problem; loose account mapping, duplicate vendors, and keeping two sources of truth are what make the numbers drift.
Why doesn't my Bill.com activity match my books?
The usual cause is double entry: a payment recorded by hand in the ledger that also came across in the sync, or a clearing account nobody reconciles. Check that the Bill.com clearing account nets to zero; a lingering balance points at the transactions to fix.
Who should be an administrator in Bill.com?
As few people as possible. Use the built-in roles so clerks enter bills, approvers approve, and payers pay. Keep the person who approves a bill separate from the person who releases the payment.