Vendor Statement Reconciliation Template
Reconcile vendor monthly statements to your AP records. Resolve discrepancies and identify missing or incorrectly recorded invoices.
How to use this template
Collect vendor statements
Obtain monthly statements from all significant vendors. Note vendor name, statement date, and statement total amount due.
Extract your AP records
Pull all invoices from that vendor in your system for the same time period. Include invoice number, date, amount, and payment status.
Match invoices
Line-by-line, match invoices on your records to vendor statement. Check off invoices that both parties agree have been received.
Identify discrepancies
Flag items that don't match: invoices you recorded but vendor doesn't show, invoices vendor shows but you haven't recorded, or amount differences.
Resolve and document
Investigate each discrepancy. Document resolution: payment made after statement date, invoice not yet received, or correction needed.
Why use this template
- Catches duplicate invoices before payment
- Identifies invoices you forgot to record or paid incorrectly
- Resolves vendor billing disputes before they escalate
- Ensures AP balance accurately reflects your actual obligations
Related templates
AP Aging Report
Formal aging report of all outstanding accounts payable. Shows vendor balances and payment status for management and audit review.
Accounts PayableInvoice Processing Checklist
Standardize the invoice processing workflow to ensure all invoices are received, coded, and recorded consistently.
Accounts PayableAccrued Expense Roll-forward
Track the beginning balance, new accruals, payments, and ending balance of accrued expenses each period.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.