Supplier statement reconciliation for QuickBooks Online: find what disagrees before you pay
Also called QuickBooks vendor statement reconciliation, without checking every line by hand. Forward the statement your supplier already sent, and the differences come back named in both directions — and any line that cannot be tied out is named too, rather than quietly matched.
No card required. Setup takes about two minutes, and you can forward your first statement straight away. See pricing.
Why you can believe the number
We are not going to show you a testimonial we do not have. Here is the proof that exists: the product proving its own arithmetic, two clients’ own numbers, and a free tier you can check both on.
The balance is proven before it is reported
Opening balance plus every signed movement is checked against the closing balance. If it does not close, the statement comes back as unproven rather than as a number you are expected to take on trust.
What it cannot tie out, it names
A line that cannot be matched with confidence is reported with its reference, date and amount instead of being folded into a difference total. The only work left is the work that genuinely needs a person.
Two AP teams, on their own count
Two accounts payable teams using earlier versions of Statement Zen went from 80–100 hours a month to under four. That is their figure rather than a measurement of ours, and it came from earlier versions of the product.
Check it on your own books, free
25 reconciled statements every month, no card. A statement that cannot be reconciled does not use that allowance, so trying it costs you nothing.
Reads your accounts payable position from Xero, QuickBooks Online and Vista by Viewpoint — and from anything else through the Statement Zen API.
Statement Zen does one job: the supplier statement reconciliation that lands on an accounts payable desk every month, right before the payment run. It was built for that job and it does not try to be an accounts payable suite.
What Statement Zen does for QuickBooks accounts payable
QuickBooks reconciles your bank. It has nothing for supplier statements — so that job is still done by hand, every month, right before the payment run.
About 80% of the time, given back
An eighty-page supplier statement hiding five missing invoices is 15 to 45 minutes of checking line by line, because finding those five means checking all eighty pages against QuickBooks. Two AP teams using earlier versions of Statement Zen reported it removed about 80% of the time that job took them — their figure, not ours. Forwarded here, the five come back named.
Proven before it is reported
Opening balance plus every signed movement is checked against the closing balance before any result is recorded. When it closes, the balance is reported as proven. When it does not, the statement comes back as unproven rather than as a number you are expected to take on trust.
Names what it could not tie out
Each uncertain line is named individually rather than folded into a difference total you then have to go hunting through — so the only work left is the work that genuinely needs a person. That statement is not charged for either.
The exceptions arrive ready to send
Missing invoices, unmatched amounts, credits the supplier has not applied and payments in transit each come back with reference, date and amount. One button copies the complete list into your reply. Finding the problem ends the job rather than starting a second one.
Your suppliers never hear from us
Nothing is sent to your vendors. No supplier portal, no registration email, nobody to onboard but you. They keep emailing statements exactly as they do now — so none of this costs you goodwill with the people you depend on.
Read-only, and it stays that way
The Intuit sign-in cannot create, edit, void, pay or delete anything in your company file. It reads your accounts payable ledger so there is something to match the statement against, and no write endpoint is ever called.
Free for 25 statements a month, forever
No card, no expiry, no countdown. The allowance resets monthly, and if 25 covers you it stays free indefinitely. Paid plans are $99, $299 and $899 a month. One reconciled supplier account is one statement — page count never affects the price.
What supplier statement reconciliation is, and why the balance is not enough
Supplier statement reconciliation for QuickBooks Online, also called QuickBooks vendor statement reconciliation, means comparing what a supplier says you owe with the bills QuickBooks Online holds for that supplier. A supplier statement is the supplier’s own record of what they invoiced, what they credited and what you paid. Your QuickBooks Online ledger is your record of the same thing.
Matching the closing balance is not enough. A missing invoice and an unapplied credit of the same size cancel out, and the balance still agrees. Only a line-by-line check catches both.
How to reconcile a supplier statement in QuickBooks Online by hand
QuickBooks Online’s Reconcile screen is built for bank and credit card accounts, not supplier statements. For a supplier statement the work looks like this:
- Note the statement date, the opening balance and the closing balance printed on the statement.
- In QuickBooks Online, run a vendor balance report for that supplier, set to the statement date. It shows what QuickBooks says you owe.
- Compare the two totals. The gap is the amount you need to explain.
- Tick each statement line against a bill in QuickBooks, using the invoice number, the date and the amount. Do not match on amount alone.
- List what is left over on each side: statement lines with no bill in QuickBooks, and bills with no line on the statement.
- Fix your own side where you are wrong. Ask the supplier about the rest, and quote the reference and amount.
Want the method behind each step? Take the free vendor statement reconciliation course.
On a long statement this takes 15 to 45 minutes, because finding the five wrong lines means checking all eighty pages. It is the same job whether you call it vendor statement reconciliation or supplier statement reconciliation. QuickBooks Online says “Vendor” in some editions and “Supplier” in others.
Why a supplier statement and your QuickBooks bills disagree
Almost every difference falls into one of six groups. Knowing which one you are looking at tells you who has to act.
Supplier invoices on the statement that are not in QuickBooks
The bill was never entered, or the invoice never reached you. This is the costly one to miss: you cannot pay what you do not know you owe, and the supplier will chase it later.
Who acts: You: enter the bill, or ask the supplier for a copy
Bills in QuickBooks that are not on the statement
The supplier has not billed it yet, the bill is dated after the statement, or it was entered under a different vendor name.
Who acts: You: check the date and the vendor before raising it
Credits that sit on one side only
The supplier issued a credit you never recorded, or you recorded one the supplier has not applied. The balance is wrong until it sits on both sides.
Who acts: Whichever side is missing it
Payments in transit
You paid after the statement date, or the supplier has not allocated your payment yet, so the invoice still shows as open.
Who acts: Supplier: allocate it. Send them the payment date and bank reference
Duplicates, overpayments and refunds
The same invoice entered twice, a payment larger than the bill, or a refund the supplier owes you. These are easy to miss when you only compare totals.
Who acts: You and the supplier
Different invoice numbers or amounts
A prefix, a space or a branch code your bill does not carry, or a different tax split. The invoice is on both sides but looks missing from each.
Who acts: You: correct the reference or amount
Most of these differences are small and ordinary. The costly ones are the first and the fifth, and a balance check hides both.
What supplier statement reconciliation costs you today
Use your own numbers — the arithmetic is the same for every QuickBooks accounts payable team.
By hand
15–45 min
per statement
Two hundred statements a month is on the order of 100 hours — two and a half weeks of one person’s time, almost always compressed into the days before the payment run.
Statement Zen
25 free
statements every month
No card needed. Then $99 for 100 statements, $299 for 300, $899 for 1,000. A statement we can't reconcile doesn't use your allowance.
Where the saving is
the search
not the sending
Writing to the supplier was never the hard part — it takes about a minute, and one button copies the list. Finding which five of eighty pages are wrong is the half hour that disappears.
How to start, in three steps
Sign in to Intuit, copy the address it gives you, forward statements to it. The connection only reads your ledger — no write endpoint is ever called. The walkthrough video above shows the whole thing on a real supplier statement.
A secure Intuit sign-in that only ever reads — it reads your open accounts payable ledger so there is something to match statements against, and no write endpoint is ever called against your company file.
- 1Create a free Statement Zen account and open the Connections page.
- 2Click Connect QuickBooks, approve the Intuit sign-in for the company you want reconciled, and copy the forwarding address that appears for it.
- 3Forward supplier statements to that address. The reconciliation appears in your Statements dashboard.
What Statement Zen does on QuickBooks Online, at a glance
Every row is something you can check for yourself — the free tier, the read-only sign-in and the published price are all on this site.
Time to first reconciled statement
Same day
Cost to start
Free — 25 statements a month
Setup
~2 minutes, read-only sign-in
Write access to your company file
None — read-only
When it is uncertain
Names the line, costs nothing
Telling the supplier what is missing
One button copies the full list
What your suppliers have to do
Nothing — they are never contacted
Billing unit
One supplier account
Demo required to see pricing
No — published
Frequently asked questions
Short answers about reconciling QuickBooks Online supplier statements, with the limits stated.
Does QuickBooks Online reconcile supplier statements?
Which version of QuickBooks does this work with?
How do I reconcile a supplier statement in QuickBooks?
How long does it take to set up?
Can Statement Zen change anything in my QuickBooks company file?
What file formats can I send?
How long does one statement take?
How do I tell the supplier which invoices are missing?
Do my suppliers have to sign up for anything?
What happens when a statement does not reconcile?
What does it cost?
Is my QuickBooks data secure?
Running something else?
Xero, QuickBooks Online and Vista connect themselves. Any other accounting system or ERP can send its whole position, paid and unpaid, through the Statement Zen API, or by an arrangement we set up with you — the supplier statement still just gets forwarded by email. Tell us what you use and we will tell you straight whether we can reconcile against it.
Tell us what you useStill have a question?
Email support@statementzen.com and we’ll reply with a real answer for your exact case.
Reconcile your first QuickBooks supplier statement today
Connect QuickBooks Online, forward one statement, and see the differences named. Free — 25 statements every month.