Small-business outsourcing research
How often do supplier statements disagree with the accounts payable ledger?
A protocol for counting supplier statement differences by type, amount, and age so the bookkeeping review can target the right fix.

Research question and scope
This protocol asks how often a supplier statement disagrees with the accounts payable ledger at the end of a reconciliation period. The unit is one supplier statement compared with one ledger extract for the same period. The study measures the share with at least one difference, the types of difference, and the amount left open. It does not judge whether the supplier or the business is correct.
Set the scope to one business, one ledger, and one statement period. Record the currency, the cut-off date, and the supplier population. If the business changes its accounts payable system during the window, analyze the periods separately. A new matching tool can reduce the difference count without any change in supplier behavior.
Define the population as every active supplier with a statement for the period, including suppliers with a zero balance. A zero-balance statement can still contain a credit or a duplicate that the ledger missed. Exclude suppliers with no statement only if the exclusion is stated and counted. Test the comparison on two suppliers before collection begins.
Definitions that make the measure reproducible
Define a difference as a statement line that cannot be matched to the ledger at the invoice level, or a ledger line that does not appear on the statement. Do not count a timing difference as a match merely because the total agrees. Define open as a difference that remains at the end of the reconciliation window. A difference resolved during the window is recorded with its resolution date.
Use the supplier invoice number as the primary key when both sides use it. If the numbers differ, record both and use the combination of date, amount, and reference as the secondary key. Write the matching rule down before matching so the analyst does not choose a convenient key per supplier. A rule that changes between suppliers makes the count incomparable.
Measure the difference in the supplier's currency and record the exchange rate and date used for any conversion. A currency movement can create a difference that is not a billing error. Report currency differences separately from quantity, price, and missing-item differences. The reader should be able to see which differences are economic and which are record errors.
Evidence standard and data dictionary
For each supplier, capture the statement date, the ledger cut-off, the opening balance, the closing balance, and the number of lines. Add the matched count, the unmatched count, and the total amount unmatched. Record the difference type for each unmatched line: timing, missing invoice, duplicate, price, quantity, credit, or payment allocation. A line without a supplier reference should be marked unverified rather than matched.
Keep the statement PDF and the ledger extract with the record. Record the person who performed the match and the person who reviewed it. If a difference was resolved by a credit note, record the credit number and the date it was applied. Evidence should let a second bookkeeper rebuild the comparison without asking the supplier.
Capture whether the supplier is new, whether the bank details changed during the period, and whether the statement came from a portal or an email. These facts help explain unusual differences without treating them as errors. Record the source and the date received. A statement that arrives late may produce a timing difference that looks like a missing invoice.
Sampling and collection
Collect every supplier statement for the period, or a random sample drawn from the supplier master with the method recorded. Do not select only the suppliers with large balances, because small balances can hide duplicate payments and missed credits. Record the export date, the filters, and the number of suppliers excluded. Keep the excluded suppliers in a separate list with the reason for each.
If the supplier population is large, stratify by spend and by whether the supplier is new. Report the results by stratum so one high-volume supplier does not dominate the rate. Keep the number of statements behind every percentage. A rate without the supplier count is not a finding.
Ask the bookkeeper to identify the statements that were difficult to match and why. A missing invoice number, a different currency, or a portal export can explain a cluster of differences. Record the reason before looking at the result so the explanation is not fitted to the number. Use the same reason codes across suppliers.
Analysis and reporting
Report the share of suppliers with at least one difference, the median number of differences per affected supplier, and the total amount open. Show the results by difference type and by supplier stratum. Present the number of statements that could not be compared and the reason. A statement that could not be read is not a clean statement.
Separate differences that affect cash from differences that affect only the record. A missing invoice may lead to a duplicate payment, while a price difference may lead to a credit. Report the cash exposure beside the count. The owner needs to know which differences can change the next payment run.
Age the open differences and report how many have been open for more than one period. A difference that survives two reconciliations is a process problem, not a timing issue. Compare the age with the follow-up date and the assigned owner. The reader should be able to see which items are actually moving.
Limits of the evidence
The comparison can show that the records disagree, but it cannot show which record is correct. The supplier statement may omit a credit, and the ledger may omit an invoice. The protocol also cannot capture a verbal agreement that changed a price without a document. State that limitation before presenting the result.
A small business may have too few suppliers to support a stable rate. Describe the statements and the amounts instead of ranking suppliers. If one bookkeeper handles every reconciliation, the result may reflect that person's method more than the supplier behavior. Do not use the rate as a performance score without the context of volume and system changes.
Do not compare a business that reconciles monthly with one that reconciles quarterly. The two have different windows even when the difference rate looks similar. Report the reconciliation frequency beside the result. A target that can be met by reconciling less often is not a control target.
What to change
Give the result to the bookkeeper and the owner and ask them to choose one observable change. The change might be a required purchase order, a statement request schedule, a duplicate-payment check, or a credit follow-up. Record the owner, the effective date, and the measure that will show whether the change worked. Bring the reconciliation file to that review so the choice is based on evidence.
If the difference count falls but the open amount rises, the team may be closing small items while leaving large ones. If duplicate differences fall but missing invoices rise, the fix may have moved the problem. Report the movements together before declaring success. Close the review when the owner accepts the finding and the next collection date is set.
Ask the bookkeeper which supplier was hardest to reconcile and what document was missing. A concrete answer is more useful than a general complaint. Add the missing document to the supplier onboarding checklist. The next measurement should test whether that supplier type reconciles faster.
Sources
- U.S. Small Business Administration, manage your business, U.S. Small Business Administration; checked 2026-11-10
- U.S. Government Accountability Office, internal control standards, U.S. Government Accountability Office; checked 2026-11-10
- Association of Certified Fraud Examiners, fraud resources, Association of Certified Fraud Examiners; checked 2026-11-10
- IRS, recordkeeping for small businesses, IRS; checked 2026-11-10
Frequently asked questions
Does a favorable sample prove the routine caused the result?
No. The design is observational and supports a bounded operating decision, not a universal causal claim.
What should an owner review first?
Start with high-consequence defects, missing denominators, exceptions, and cases that required the owner to reconstruct the evidence.
Related research
How often do payroll timesheets reach approval with a missing manager sign-off?
A protocol for measuring how many weekly timesheets reach the pay run without the manager approval the written policy requires.
What share of customer complaints wait more than two business days for an owner decision?
A protocol for measuring how long customer complaints wait for an owner decision and which case types account for the delay.
How long does new-client document collection take after the sales handoff?
A protocol for measuring the time from sales handoff to a complete client document file, with stage times and the causes of delay.