Vendor statement reconciliation guides
Practical, step-by-step guides for reconciling vendor statements with QuickBooks Online - and for explaining every difference down to the cent.
A practical way to reconcile a vendor's statement against QuickBooks Online - which reports to run, how to match the invoices, and how to explain every difference down to the cent.
Read the guide → Invoice paid but still on the vendor statement? How to find and fix itHow to find invoices you already paid in QuickBooks Online that a vendor still shows as open - using the Transaction List by Vendor - and what to send the vendor so they apply your payment.
Read the guide → Free vendor statement reconciliation template for ExcelA free Excel template for reconciling a vendor statement with your QuickBooks Online A/P Aging Detail - plain COUNTIF and SUMIF formulas, a summary that proves the difference, and a worked example.
Read the guide → Why your A/P aging doesn't match the vendor statement (8 common reasons)The eight reasons a vendor's statement and your QuickBooks Online A/P aging disagree - how to spot each one, and what to do about it.
Read the guide →