New plan10 templates a month$14.95/month, cancel anytime

Start your plan
Supplier Statement Reconciliation Template for QuickBooks Desktop (Vendor Reconciliation in Excel) preview 1 of 3
Accounting & Bookkeeping · Trial Balance & Reconciliation

Supplier Statement Reconciliation Template for QuickBooks Desktop (Vendor Reconciliation in Excel)

A supplier statement reconciliation template in Excel for QuickBooks Desktop users: paste a vendor report exported from QuickBooks Desktop, enter the supplier's statement, and every line is matched on invoice number or amount, with a reconciliation statement and a list of what to fix.

Get this template

.xlsx · 7 sheets · includes charts

This template

$7.95single payment

  • Nothing renews
  • Download it again whenever you need
  • Yours to keep and edit
Buy this template
Cheaper than buying 2 separately

Monthly plan

$14.95/month

  • This template plus 9 more every month
  • About $1.50 a template if you use all 10
  • Thousands of templates to choose from
  • Cancel anytime
Start your plan
  • Secure checkout via Creem
  • Instant download after payment
  • 14-day refund policy

Supplier Statement Reconciliation takes the manual work out of reconciling a supplier's statement to your accounts payable in QuickBooks Desktop. Export a vendor report such as Vendor Balance Detail, Transaction List by Vendor or Unpaid Bills Detail to Excel and paste it in as it is. The header row and the Type, Date, Num, Memo and Amount (or Debit and Credit) columns are found automatically, spacer columns, vendor headings and total rows are handled, and every column can be set by hand if your report uses different headings.

Pick the supplier from the list of vendors found in the report, enter the statement date, the period start and the opening and closing balances on the statement, then type or paste the statement lines. QuickBooks lines dated before the period start make up the QuickBooks opening balance, and lines after the statement date are left out.

Each line is matched both ways. References are cleaned first, removing spaces, dashes, slashes, prefixes such as INV and leading zeros, so INV-24518 in QuickBooks matches 24518 on the statement. Lines left over are paired on the same amount within a date window you set, which catches payments recorded with your check number on one side and the supplier's receipt number on the other. Every line is marked Matched, Matched on amount, Amount differs, Not on statement or Not in QuickBooks, with a suggested next step.

The Reconciliation tab sets out the classic supplier reconciliation: balance per supplier statement, less items on the statement not in QuickBooks, add items in QuickBooks not on the statement, amount differences and any difference in opening balances, giving the adjusted balance against the balance per QuickBooks and an unexplained difference that should be zero. The items are listed with what to do, alongside a match summary, a chart of the reconciling items and a sign-off block, ready to print or save as PDF.

Capacity covers 3,000 report rows and 500 lines on each side. Calculated cells are locked and sheet protection has no password; the paste tab is left unprotected. Sample data for a fictional packaging supplier is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros. QuickBooks is a trademark of Intuit Inc. This template is not made by, affiliated with or endorsed by Intuit.

What's inside

  • 7 tabs, from a quick-start guide to Settings
  • Paste a QuickBooks Desktop vendor report as exported
  • Header and columns detected, with manual override
  • Amount or Debit and Credit columns, either sign
  • Vendor list with balances from the report
  • Supplier statement lines with charges and credits
  • Reference cleaning: prefixes, symbols, leading zeros
  • Match on reference, then on amount within a date window
  • Five statuses with a suggested next step
  • Reconciliation statement with unexplained difference
  • Opening balance and statement cut-off handled
  • Printable reconciliation with sign-off
  • Locked formulas, no macros
#supplier statement reconciliation#vendor statement reconciliation#supplier statement reconciliation template#vendor reconciliation#supplier reconciliation#accounts payable reconciliation#supplier account reconciliation#vendor reconciliation template excel#supplier reconciliation template excel#quickbooks desktop#vendor balance detail#accounts payable#month end#excel

More in Accounting & Bookkeeping

Balance Sheet Format in Excel with Income Statement (P&L) and Cash Flow Statement previewAccounting & Bookkeeping

Balance Sheet Format in Excel with Income Statement (P&L) and Cash Flow Statement

A balance sheet format in Excel linked to an income statement and a cash flow statement: enter one trial balance and get all three statements by month, with prior year comparatives, 16 financial ratios, a dashboard and checks that show at once if anything does not balance.

  • 9 tabs, from a quick-start guide to Settings
  • Trial balance with account mapping to statement lines
  • Closing balance or monthly movement entry
intermediate.xlsx
Statement of Account Template Excel with Accounts Receivable Aging Report previewAccounting & Bookkeeping

Statement of Account Template Excel with Accounts Receivable Aging Report

A statement of account template in Excel with an accounts receivable aging report: log invoices and payments once, print a customer statement with a running balance and remittance slip, age every balance into current, 30, 60, 90 and 90+ days, and follow a collection priority list with DSO.

  • 8 tabs, from a quick-start guide to Settings
  • Invoice, payment, credit note and write-off log
  • Payments and credits applied to specific invoices
beginner.xlsx
Cash Flow Forecast Template Excel: 13-Week Cash Flow with 12-Month Projection previewAccounting & Bookkeeping

Cash Flow Forecast Template Excel: 13-Week Cash Flow with 12-Month Projection

A cash flow forecast template in Excel for the next 13 weeks: receipts and payments by category, receivables collections and payables timing, recurring and one-off items, opening balance roll-forward, minimum cash alerts, actual vs forecast variance and a 12-month cash flow projection.

  • 12 tabs, from a quick-start guide to the forecast engine
  • 13 weeks of receipts and payments by category
  • Opening balance roll-forward to closing balance
intermediate.xlsx
Fixed Assets Register Template Excel with Depreciation Schedule previewAccounting & Bookkeeping

Fixed Assets Register Template Excel with Depreciation Schedule

A fixed assets register template in Excel with a depreciation schedule: track each asset's location and custodian, depreciate monthly by straight-line, declining balance or sum-of-years' digits, record disposals with gain or loss, and produce the year-end roll-forward and net book value report.

  • 10 tabs, from a quick-start guide to the depreciation engine
  • Asset register with location, custodian, supplier and serial or tag
  • Straight-line, declining balance and sum-of-years' digits
intermediate.xlsx