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
Prepaid Expense Workpaper
Track and amortize prepaid expenses with a structured workpaper that keeps your schedules accurate and audit-ready every close.
Close ManagementStandard Month-End Close Checklist
A comprehensive checklist to ensure nothing falls through the cracks during your month-end close. Track every task, owner, and deadline in one place.
Close ManagementClose Calendar Template
Plan out your entire month-end and quarter-end close timeline with a structured calendar. Coordinate across teams and set clear deadlines.
Ready to streamline your close?
Vergo turns templates into automated workflows with real-time collaboration, integrations, and AI built in.