How to reconcile vendor statements with open rental invoices and credits

By RentalSpend · October 8, 2026

Tie the statement to your AP open-items report, then match each line to an invoice, payment, credit memo, or unapplied credit. Do not clear a credit until it is actually applied in your system.

Reconcile a vendor statement the same way you reconcile AP open items: start with your open invoice list, then match every statement line to a specific invoice, payment, credit memo, or unapplied credit until the difference is explained. Do not treat a credit as used until your AP system shows it applied to a particular invoice or vendor account, and check your rental agreement for the dispute window, surcharge rules, and any charge categories that may be contestable under the contract.^{[1][2][3][4][5]}

Reconciliation steps in order

1. Pull the vendor statement, your AP open-items report, and the invoice register for the same cutoff date.
2. Match each statement line to a specific invoice, payment, credit memo, or unapplied credit and mark what is still open.
3. Investigate every difference by category: missing invoice, missing credit, misapplied credit, duplicate charge, timing difference, or disputed rental charge.
4. Check the rental agreement, rate sheet, and any addenda before accepting surcharges, mileage, transportation, fuel, or other pass-through charges.
5. Post only the items you can support, then escalate unresolved differences with the supplier using the invoice reference, amount, and transaction dates.

Sources: ^{[1][2][6][3][4][7]}

Start with the open-items report, not the statement total

The statement total is only a summary. Your control total should be the AP open-items report, because it shows what your system still considers unpaid or partially paid. That report should include the invoice date, due date, invoice reference, original amount, and outstanding amount so you can tie each open item back to a document in your AP ledger. If the statement omits detail, build the tie-out from your own records first and use the statement as a secondary check.^[1][2][4][5]

If your ERP distinguishes open invoices from open credits, keep both in the tie-out. Unapplied credits often sit in a separate status until they are matched and posted, so a balance that looks “closed” on paper may still be open in the system. In some systems, a credit must be applied first and posted afterward before the general ledger reflects the offset. Check whether your platform auto-applies credits or requires manual matching.^[3][8][9]

Match each line to the right document

Work one statement line at a time. For each open invoice, confirm that you have the matching invoice number, date, amount, and vendor account. Then look for a payment, credit memo, refund, or debit memo that explains any remaining difference. Matching the credit memo to the original invoice is usually the cleanest approach because it keeps the offset in the same spend category and job or cost center that was originally charged.^[7][10]

• Invoice appears on the statement and in AP: confirm the outstanding amount after any partial payment.
• Invoice appears on the statement but not in AP: look for a missed receipt, a duplicate vendor account, or a cut-off timing issue.
• Credit memo appears in AP but not on the statement: verify whether it was applied, refunded, or left unapplied.
• Statement shows a credit but AP does not: trace the application record and posting history to see whether it was applied to a different invoice or branch account.

Sources: ^{[2][3][8][10][9]}

What usually causes a mismatch

Check the rental-specific charges carefully

Equipment-rental statements often include more than base rental. Review transportation, pickup and delivery, mileage, fuel, environmental, cleaning, damage, and administrative surcharges line by line. Whether those charges belong on the statement depends on the signed rental agreement, any rate sheet, and addenda. Do not assume that one vendor’s billing practice matches another’s. If the supplier’s contract says a charge is allowed only under certain conditions, verify those conditions before you accept the balance.^[1][2][6][5]

Also watch for billing period issues. A rental may start in one month and end in the next, while the invoice or statement cutoff sits in between. When that happens, the amount on the statement can be correct for the vendor’s cutoff but still incomplete for your AP period. Tie the item to the actual rental dates and to the date it was entered in AP so you know whether you have a true discrepancy or just a timing difference.^[2][6][5]

In a case like this, the statement total is not the final answer. The right balance is the amount supported by documents you can tie to invoices and contract terms today. The missing invoice is recorded, the credit is applied, and the disputed fee remains unresolved until the supplier’s documentation supports it or your agreement allows it.^[3][8][7][5]

What to do when something does not match

If the difference is a missing invoice, search your invoice intake queue, receiving records, and job cost backup before you ask the vendor to reissue anything. If the difference is a credit that was received but not applied, trace the application history and make sure your system posted it to the correct open invoice. If the difference is a disputed charge, pull the contract and invoice detail together and challenge only the line items that the agreement does not support. Keep the issue open until the vendor can tie the charge to the agreed rate sheet or you can resolve it internally.^{[1][2][3][8][7][10]}

If the statement and your AP aging still disagree after the obvious items are cleared, look for payments posted to the wrong vendor account, credits applied to a different branch, foreign-currency or manual postings, or transactions sitting outside the reconciliation window. Those items often live in the accounting system rather than on the face of the statement, so the fix may require a posting correction instead of a vendor dispute.^[6][8][9]

Practical next steps

• Reconcile the next vendor statement from the open-items report outward, not from the statement inward.
• Keep a credit memo log that shows the original invoice, application date, and remaining balance.
• Require a clear tie-out for any rental surcharge, fee, or adjustment before approving payment.
• Use one cutoff date for the statement, the AP report, and your supporting documents.
• Escalate unresolved differences with the invoice number, amount, and document trail attached so the supplier can respond faster.

Sources: ^{[1][2][3][4][7][5]}

← All resources