All articles
Article

Reconcile vendor statements against your bills: a step-by-step AP routine for contractors

A practical monthly routine to reconcile supplier vendor statements against your accounts payable, stop duplicate payments, and capture missing bills. Includes what to do for matched lines, amount mismatches, and missing bills — plus a ready-to-run checklist for this week.

5 min readBy the Trade Books team

Why reconciling vendor statements matters

If you leave supplier statements sitting unreviewed, you pay the same invoice twice, miss vendor credits, and let billing errors hide in plain sight. For a small office those errors add up to a lot of wasted time chasing vendors and fixing checks.

Trade Books handles vendor statements in a way that prevents accidental changes to your books until someone in the office confirms them. The supplier's monthly vendor statement is loaded into Trade Books and each statement line is matched against the bills already in the books. Every line lands in one of a few states: matched, missing from the books, missing from the statement, or amount mismatch, so the office sees exactly where the two disagree. The statement is a read-only overlay on accounts payable: nothing in the ledger moves until the office acts on a line.

The routine: one reliable pass that catches the big problems

Set aside a regular window each month for vendor-statement reconciliation. Make this the step before your AP check run. The routine below assumes you have the vendor statement PDFs and your AP aging ready.

  1. Load the vendor statements.

    Scan or download the supplier's vendor statement and load it into Trade Books. The system will compare each statement line to bills in accounts payable and assign a state to each line.

  2. Start with the lines flagged as matched.

    A matched line means Trade Books found a corresponding bill in your books. Don’t assume matched = correct. Open a matched bill and check two things: the vendor invoice number and any supporting receipt or packing slip. If both match, pin the statement line to the bill to record that you’ve confirmed it. Remember: a close-but-not-exact match is never imported automatically; a person pins a statement line to a bill, and only that action changes anything.

  3. Handle amount mismatches next.

    Lines in the amount mismatch state need investigation. Typical causes are partial credits, sales tax differences, short shipments, or data entry errors. For each mismatch:

    • Compare the bill to the vendor invoice PDF and the packing list or delivery receipt on the job.
    • If the vendor issued a credit memo, attach it to the bill and adjust the bill amount according to your office policy; document the credit on the vendor statement line. Pin once the bill reflects the credit.
    • If the vendor’s statement is wrong, contact the vendor and ask for a corrected statement or credit. Leave the line unpinned until the vendor provides support.
    • Do not mark the bill paid or remove it from AP until you have resolved the mismatch and pinned or documented it.
  4. Resolve lines marked “missing from the books.”

    When the statement shows a charge but you have no bill in the system, treat it like an uncoded expense:

    • Find the vendor invoice that supports the charge. If you don’t have an invoice, request one from the vendor.
    • Create a bill in your accounts payable using the vendor invoice and attach the PDF. Include job or cost-code details so the cost lands on the right job or GL account.
    • Once the bill is entered and supported, pin the statement line to that bill so the statement and your books reconcile.
  5. Investigate lines marked “missing from the statement.”

    These are bills in your books that don’t appear on the vendor statement. Possible reasons include early payments, returns, or timing differences. For each:

    • Confirm whether you already paid the bill. If you did, attach the paid check or bank payment to the bill for audit trail clarity.
    • If the bill should be on the statement (vendor omitted it), escalate to the vendor and add a note to the bill describing the discrepancy. Keep the bill in AP until the vendor confirms.
  6. Document everything you change.

    Because the vendor statement is a read-only overlay, every change you make lives in the bill or in your notes — not silently. Always attach vendor emails, corrected statements, credit memos, or photos of packing slips to the bill. That paper trail is what lets you pin a statement line with confidence.

  7. Sign off and schedule payments.

    Only pin and mark for payment the lines you’ve confirmed. Hold payments for any unresolved mismatches until the vendor provides documentation. When the clean-up pass is done, run your AP payables and generate the payment file or checks.

Practical roles: who does what

  • Office admin: loads statements, performs the first-pass review, and creates missing bills.
  • Purchasing or project manager: verifies job-related lines, supports investigations into mismatches, and approves pins for large or disputed items.
  • Bookkeeper: signs off on pinned statements before the payment run and ensures attachments and notes are complete.

A short checklist you can run this week (even without Trade Books)

  • Collect the most recent vendor statements for your key suppliers.
  • Run an AP aging report and flag any supplier totals that don't match their statement totals.
  • Pick the top few supplier differences and either find the missing invoice in your files or call the vendor for clarification.
  • Put a hold on payments for any invoices with unresolved discrepancies until you have vendor documentation.
  • Start a simple audit folder where you attach all vendor emails, corrected statements, and credit memos for month-end review.

What this prevents

Using a consistent vendor-statement routine eliminates duplicate payments, captures credits before you pay, and keeps accounts payable from hiding errors that inflate job costs. The key is that the statement in Trade Books acts as a read-only overlay on accounts payable, so mismatches are visible but nothing in the ledger changes until a person pins a statement line to a bill. That manual confirmation step is what stops accidental ledger edits and gives you a clear audit trail.

Ready to try it in the app?

If you want to run this exact workflow in Trade Books, there’s a 30-day free trial with no credit card required and no contracts. Trade Books is flat monthly pricing with no per-truck or per-user overage fees within plan limits. Start by importing a single vendor statement and practice the steps above — you’ll see where your AP problems are hiding and how much time the pinned-confirmation step saves the office.

See it on your own data

Trade Books runs field service and accounting from one database.

No setup fee. No credit card. Cancel anytime.

Start Free Trial