Philippines staffing guide · Published
Write a supplier statement reconciliation script for an outsourced bookkeeping desk
A supplier statement is only useful when the desk can explain every difference between it and the ledger. A fixed reconciliation script keeps the matching, the evidence request, and the credit decision in the same place before month-end close.

The short answer
A supplier statement reconciliation works when the desk matches the opening balance, the period activity, and the closing balance in that order. Every unmatched line needs an owner, an evidence request, and a deadline before the close calendar moves on.
Gather the statement and the ledger export
Start with a complete statement for the period, not a screenshot of the balance. Save the supplier name, the statement date, the currency, and the page count.
Then export the matching ledger detail for the same supplier and period. Both files should carry the time they were pulled, because a payment posted later can change the comparison.
Check that the statement covers the full period in the close calendar. A statement that ends three days before month-end will leave recent invoices unexplained.
If the supplier issues statements on a different cycle, ask for a cut-off statement that matches the ledger period. Record that request in the reconciliation file so the next desk can see why the dates differ.
Match the opening balance before the activity
The opening balance tells the desk whether an old difference is still open. Agree the opening balance to the prior reconciliation, not to the current ledger.
If the prior file is missing, rebuild the opening position from the last agreed statement and note the gap. Starting with activity while the opening balance is unproven usually doubles the work later.
Once the opening balance agrees, compare the period invoices, credits, and payments as three separate groups. This makes a missing credit easier to spot than a single net difference.
A supplier may post a credit note in the same month the desk posted a debit, which nets to zero and hides the real issue. Separating the groups prevents that illusion.
Work unmatched lines by evidence
For each unmatched line, write the amount, the document number, the date, and the reason it does not match. Common reasons include a payment posted to the wrong supplier account, an invoice recorded at a different value, and a credit note that never arrived.
The reason should point to a document the desk can request, not to a guess about the supplier. If the desk cannot name the document, the line is not ready to be worked.
Set a short evidence window for each item. Ask the supplier for the missing credit note or the remittance advice by a named date. If the supplier cannot provide it, ask the internal team that approved the purchase.
Do not clear a difference by posting a round-number adjustment unless the client has approved that treatment in writing. The reconciliation should explain the balance, not disguise it.
Decide when to request a credit
A credit request is appropriate when the supplier billed more than the agreed price, billed a duplicate, or failed to apply a return. Attach the purchase order, the receiving record, and the supplier's own document to the request.
The supplier should be able to verify the claim without calling the desk for context. Send the request from the client's approved address and keep the sent copy in the reconciliation file.
Set a response deadline for the credit and check it on a named date. If the supplier disputes the claim, ask for the document they rely on and compare it with the purchase record.
The desk should not keep resending the same request without new evidence. Escalate to the client owner when the deadline passes and the amount is above the agreed threshold.
If the difference is small and old, the client may prefer to write it off rather than chase it. That is a client decision, and the desk should present the cost of chasing it.
Record the decision, the approver, and the date. A write-off without an approver looks like an unexplained adjustment at audit, even when the amount is trivial.
Record the reconciliation outcome
End the file with three numbers: the statement closing balance, the ledger closing balance, and the total of the agreed differences. The agreed differences should reconcile the two balances exactly.
If they do not, the file is not finished, even when every line has a note. A reviewer should be able to follow the arithmetic without opening the supplier portal.
Include a short list of open items with owners and next dates. Keep the list in the same file as the completed work so the next month starts from a known position.
Send the client a summary that separates resolved differences from items still waiting on the supplier. The summary should not repeat the full detail unless the client asks for it.
Name the file with the supplier, the statement period, and the reconciliation date. Store it in the shared close folder rather than a personal drive.
If the client uses an audit trail, upload the final version and mark the earlier drafts as working papers. The next reviewer should not have to guess which copy was agreed.
Hand unresolved items into close
Some differences will not close before the month-end deadline. Move those items into the close checklist with a clear description and the amount at risk.
The accountant can then decide whether the balance is materially correct or whether an accrual is needed. Do not leave them only in the reconciliation file, where the close team may never look.
Review the prior month's open items at the start of the next reconciliation. An item that appears for three months is not a timing difference anymore.
It is a process problem, and it needs a named owner outside the desk. Raise it in the monthly review with the supplier contact and the client owner in the same conversation.
Questions to copy for the sales call
- "Does the statement cover the same period as the ledger export?"
- "Which prior reconciliation supports the opening balance?"
- "What document would clear each unmatched line?"
- "Who approved any write-off or round-number adjustment?"
Sources
- IRS: Recordkeeping for small businesses: General recordkeeping guidance for supporting business transactions and balances.
- IRS: Publication 583, Starting a Business and Keeping Records: Recordkeeping principles that apply to purchases, payments, and supporting documents.
- SBA: Manage your business finances: Operational guidance on tracking cash flow, payables, and financial records.
Common questions
Who should request the missing supplier document?
The desk can send the request when the client has approved that contact path. Name the supplier contact and the internal owner in the same message so the reply does not stall.
How often should statements be reconciled?
Match the close calendar, usually monthly for active suppliers. High-volume or high-value suppliers may need a weekly check on payments and credits.
What if the supplier statement is in another currency?
Reconcile in the statement currency and show the exchange rate used by the ledger. Do not mix currencies in one total, and record the rate date.
Can the desk approve a small write-off?
Only if the client has set a written threshold and named the approver. Otherwise the desk should prepare the item for client review.