Blog

Vendor statement reconciliation in Zoho Books: how to reconcile supplier statements

How to reconcile a supplier's statement with the vendor balance in Zoho Books: the screens and reports to use, how to clear each difference with bills, vendor credits and payments, and an example.

2026-11-06 · Invoreg · 6 min read

Short answer: to reconcile a vendor statement in Zoho Books, open the vendor under Purchases > Vendors, run the Statement tab for the same period as the supplier's statement, and tick off every bill, vendor credit and payment that appears on both. What is left is either a timing item, usually a payment the supplier has not received yet, or an error you fix in Zoho (a missing bill, a duplicate, an unrecorded credit) or ask the supplier to fix in theirs.

This guide covers the Zoho Books side of the job. For the general method, with no particular software in mind, see supplier statement reconciliation, step by step. Feature details come from Zoho's help pages on 6 November 2026; Zoho updates the product often, so check the current page before you rely on a label.

Which screens in Zoho Books you need

Zoho Books calls suppliers vendors, and a supplier statement is reconciled against four places:

What you need Where it is in Zoho Books
Your balance with one vendor Purchases > Vendors > the vendor > Overview, "Outstanding Payables"
Your record of the account for a period The vendor's Statement tab, with the time period selected
Balances for all vendors at once Reports > Payables > Vendor Balance Summary
Unpaid amounts by age Reports > Payables > AP Aging Summary

The Statement tab can be downloaded as a PDF, printed or emailed to the vendor from the icons at the top. To pull statements for many vendors at once, select them in the Vendors list, click the Print icon, enter the date range and choose Print Statements.

One thing to know before you start: Zoho's help pages describe producing a statement from your own records. They do not describe importing the statement the supplier sends you and matching it automatically. The comparison itself is still manual.

How to reconcile a supplier statement in Zoho Books

  1. Fix the cut-off. Note the supplier statement date and select the same period on the vendor's Statement tab.
  2. Write down both balances. The closing balance on the supplier's statement and the closing balance in Zoho. Note the difference.
  3. Download the Zoho statement as a PDF and put it next to the supplier's. Two documents side by side are quicker to tick than one screen and one paper copy.
  4. Tick off bills. A bill matches when the supplier's invoice number and the gross amount agree. Check the Bill# field in Zoho, which is where the supplier's invoice number should be.
  5. Tick off payments and credits. Payments by date and amount, credit notes against vendor credits.
  6. List what is only on the supplier's statement. Usually invoices not yet booked, credit notes not yet recorded as vendor credits, and payments booked to another vendor.
  7. List what is only in Zoho. Usually payments in transit, bills entered twice, and bills recorded under the wrong vendor.
  8. Correct Zoho, using the actions in the next section.
  9. Send queries to the supplier for anything wrong on their side, such as a payment they have not allocated.
  10. Rerun the Statement tab and check that the corrected balance plus timing items equals the supplier's balance exactly.

How to clear each difference in Zoho Books

  • Invoice on the statement, no bill in Zoho. Ask the supplier for a copy of the invoice and record the bill from it. Never create a bill from the statement line itself: the statement is a list of invoices, not an invoice.
  • Credit note on the statement, nothing in Zoho. Record a vendor credit under Purchases > Vendor Credits. Then click Apply to Bills to set it against open bills (it can be split across several), or open a bill and choose Use Credits. A fully used credit shows as Closed.
  • Same invoice entered twice. Keep the bill that matches the original invoice and delete or void the copy. If a payment was already made against the copy, deal with that first. Duplicates often come from two intake routes, for example the same invoice arriving by email and as a scan; see how to detect and prevent duplicate invoices.
  • Bill under the wrong vendor. Common where a supplier trades through two companies with similar names. Compare the VAT or tax number on the invoice with the vendor record, not just the name.
  • You paid more than you owed. Zoho holds the excess under Unused Credits on the vendor's Overview page. If the supplier refunds it, open the excess payment and choose More > Refund to record the refund.
  • Payment on the supplier's statement, not in Zoho. Usually a payment recorded from the bank feed without being linked to the vendor's bills. Find the bank line and record it as a vendor payment against the right bills; bank reconciliation in Zoho Books covers matching bank lines.
  • Payment in Zoho, not yet on the statement. A timing difference. No correction; check it appears on next month's statement.

A worked example

A client's Zoho Books shows €4,180 owed to a packaging supplier at 31 October. The supplier's statement at the same date shows €6,905, a difference of €2,725. Ticking off leaves five items:

Item Where found Fix in Zoho Books Effect
Invoice 2291, €1,480, still in an inbox Statement only Record the bill from a copy of the invoice +€1,480
Credit note CN-77, €265, for a damaged pallet Statement only Record a vendor credit and apply it to bills −€265
Invoice 2240, €540, entered twice Zoho only Delete the duplicate bill −€540
Invoice 2263, €1,150, booked to a sister company's vendor record Statement only Move the bill to the right vendor +€1,150
Payment of €900 made 30 Oct Zoho only None, timing none

The reconciliation then reads:

€
Balance in Zoho Books, 31 Oct 4,180
Add: invoice 2291 not booked 1,480
Less: credit note CN-77 not recorded (265)
Less: invoice 2240 duplicate (540)
Add: invoice 2263 under wrong vendor 1,150
Corrected balance in Zoho Books 6,005
Add: payment in transit, 30 Oct 900
Balance per supplier statement 6,905

Without the reconciliation, the client would have paid invoice 2240 twice, missed the credit, and let invoice 2291 go overdue. The bill under the sister company would also have overstated that other supplier's balance by €1,150, so its statement would not have agreed either.

A monthly routine for firms running Zoho Books for clients

  • Run Vendor Balance Summary at month end and pick the suppliers to reconcile: the largest balances, weekly suppliers, and anyone sending reminders.
  • Ask those suppliers for statements at the same date, so the cut-off is clean.
  • Reconcile the rest quarterly and every supplier with a balance at year end.
  • Keep the reconciliation with the statement, so next month starts from the open items.
  • Put statements in the same queue as bills, so the person who books a client's bills also sees its statements. The multi-client invoice workflow guide shows one way to set this up.

Most differences in the example started when the bills were entered: a missed invoice, a duplicate and a wrong vendor. Fix the intake and the statements start agreeing on their own.

Where Invoreg fits

Invoreg does not reconcile supplier statements itself. It works on the step that causes most of the differences. It reads every supplier invoice, including scans and phone photos, line by line, suggests the account and tax code from the client's history, checks for duplicates against the workspace and the bills already in Zoho Books, and registers the bill through the Zoho Books connector only after a person approves it. Its bank reconciliation matches payments to bills, including one payment for several bills, and marks them paid.

That means fewer missing bills, duplicates and wrong vendors to find at month end. If your Zoho Books vendor balances rarely agree with supplier statements, start with the bills behind them: try it on your own invoices, the first 20 invoices are free.

Sources

  1. Zoho Books Help, Other actions for contacts (Statement tab), accessed 06 Nov 2026
  2. Zoho Books Help, Vendor credits: functions, accessed 06 Nov 2026
  3. Zoho Books FAQ, Outstanding payable amount vendor-wise, accessed 06 Nov 2026
  4. Zoho Books FAQ, Download statements from multiple vendors in bulk, accessed 06 Nov 2026
  5. Zoho Books FAQ (Australia), Refund of excess vendor payment, accessed 06 Nov 2026

Questions accountants ask

How do I reconcile vendor statements in Zoho Books?

Open Purchases > Vendors, select the vendor and use the Statement tab for the same period as the supplier's statement. Tick off every bill, vendor credit and payment that appears on both, then clear what is left: book missing bills from copies of the invoices, record missing vendor credits, delete duplicates and note payments in transit.

Where do I see what I owe each vendor in Zoho Books?

The Outstanding Payables figure on the vendor's Overview page shows what you owe that vendor. Across all vendors, use Reports > Payables > Vendor Balance Summary, or the AP Aging Summary for unpaid amounts grouped by age.

Does Zoho Books reconcile supplier statements automatically?

Zoho's help pages describe producing a vendor statement from your own records, which you can download as a PDF, print or email. They do not describe importing the supplier's own statement and matching it line by line, so the comparison is done by a person or by a separate tool.

How do I record a supplier credit note in Zoho Books?

Record it as a vendor credit under Purchases > Vendor Credits, then use Apply to Bills to set it against open bills, or Use Credits from the bill itself. If the supplier pays the credit back, use More > Refund on the vendor credit.

What is creditor statement reconciliation?

It is the same check under another name: creditor, supplier and vendor statement reconciliation all mean agreeing the balance you owe a supplier in your books with the balance on the statement the supplier sends you. Zoho Books calls suppliers vendors.