Construction Supplier Statement Reconciliation at Month-End

Construction supplier statement reconciliation is the month-end control that ties a supplier's monthly statement — from a lumber yard, building-materials chain, ready-mix plant, or specialty distributor — to the underlying invoices, credit memos, and POs in the AP system before the period closes. The bookkeeper's job is to explain every dollar of difference between what the supplier says is open and what the AP aging says is open, post the adjustments that close the gap, and sign off the supplier balance.

Construction makes the walk harder than generic AP for three reasons. Credit memos from lumber yards and building-materials suppliers carry restocking-fee lines that change the net cost; capturing only the gross credit and ignoring the restock charge is the most common posting mistake. Supplier billing lags the delivery ticket on long jobs, so cutoff has to handle invoices that genuinely should be in AP but are not yet. And the supplier balance has to allocate cleanly across jobs and cost codes, so a credit memo posted to a generic returns account drifts the job-profitability report.

The article walks the variance-pattern catalog, the investigation order that resolves variances fastest, the credit-memo and restocking-fee posting mechanics, the cutoff and RNI accrual that closes the period cleanly, and the reconciliation packet that supports sign-off.

---

The Variance-Pattern Catalog

Every supplier-statement variance in US construction fits a small set of named patterns. The catalog below extends ACCA Global's six causes of difference — timing, allocation errors, unprocessed credits, unprocessed debits, discount miscalculations, and transposition errors — into the construction-AP reality, where credit memos carry restock lines, allocation errors split across jobs as well as tax buckets, and timing differences resolve through delivery-ticket evidence. Each row is a pattern, a one-line description, and the diagnostic handle — the thing to look at first to confirm you are looking at that pattern rather than another.

Pattern	One-line description	Diagnostic handle
Timing / received-not-invoiced	Supplier billed in the period; we have not received and posted the invoice, or have but cutoff put it in the next period.	Compare statement-side invoices missing from AP against open POs and signed delivery tickets.
Credit memo not yet posted	Supplier issued a credit memo (return, price adjustment, short delivery) we have not posted, or we have posted one the supplier has not yet applied.	Walk credit-memo lines on both sides; check return-authorization numbers and material-pickup tickets.
Restocking-fee variance	Supplier credit memo includes a negative restock-fee line; if the original credit or the restock portion is not posted, or the wrong sign is used, the net will not match.	Net the credit-memo lines on the AP side and compare to the statement's net entry for the credit.
Duplicate invoice	Supplier double-statemented; we double-posted; or one side has a duplicate the other does not.	Invoice-number match on the statement-to-AP join; same-vendor / same-date / same-amount fuzzy match for un-numbered duplicates.
Misapplied payment	Our payment hit the supplier's general AR rather than being applied to a specific invoice; the open-item statement still shows the invoice as outstanding.	Trace the payment on both sides; the supplier conversation usually clears it once the remittance is matched to the invoice.
PO-vs-line mismatch	Invoice line items do not cleanly match PO lines because of split lines, merged lines, substitute items, or UOM conversions.	Compare invoice line totals to PO line totals before chasing the rolled-up variance; line-level work is its own deep dive in investigating line-level invoice and PO mismatches.
Sales-tax bucket drift	Supplier applied tax we expected to be exempt (resale or project-exemption certificate on file) or vice versa.	Check the tax bucket on each variance line against certificate-on-file status before assuming the supplier is wrong.
Currency / FX	Rare in pure-US construction; relevant when materials are imported or the supplier bills in non-USD.	Confirm the bill currency and the conversion rate the supplier used.
Manual adjustment not posted	Supplier issued a manual adjustment (a goodwill credit, a rebill correction, a freight reclass) we have not seen yet.	Often surfaces only through the variance; ask the supplier to send the adjustment detail with the next statement.

When a variance doesn't fit one pattern, it is almost always two patterns stacked — a duplicate credit memo, a misapplied payment against a timing-deferred invoice, a restocking-fee posting that also crossed the wrong tax bucket — not a new failure mode.

The same patterns transfer beyond construction with industry-specific surface details, and the same reconciliation workflow applied to restaurant supplier statements walks them in that vertical.

---

The Investigation Order That Resolves the Variance Fastest

The catalog tells you what you might be looking at. The investigation order tells you what to look at first. The principle behind the order is this: walk the easy-to-confirm patterns first, because they account for the largest share of variances and resolve without a supplier conversation, and defer everything that requires a phone call until you have the evidence packet ready. Calling the supplier's AR clerk before you have checked your own duplicates wastes both sides' time and damages the relationship.

The vendor statement variance investigation runs in this sequence:

1. Compare totals. Take the statement-side outstanding total and the AP-side aged balance for the supplier and note the differential. This is the number every subsequent step has to resolve to zero. Do not start ticking off matched invoices yet — the differential is what gives every later finding its meaning.
2. List statement-side invoices not in AP. Pull the statement detail and look for invoice numbers that do not appear in the AP listing for the period. These are timing variances, where the supplier billed and we have not yet posted, or invoices the supplier billed that never reached the contractor's AP inbox at all. For anything you cannot find, request a copy from the supplier and tag the line in your working file.
3. List AP-side invoices not on the statement. Reverse the join. Anything in the aged AP that does not appear on the statement is either a timing variance the other direction (we posted faster than the supplier billed, common for invoices uploaded close to month-end) or a duplicate. Same-vendor / same-date / same-amount matches against statement-side lines are the duplicate flag; treat them as duplicates until you can prove otherwise.
4. Walk credit memos on both sides. Match each credit memo to its original invoice and verify the restocking-fee handling. Both lines — the original credit and the restock charge — must post, and the net must agree with the statement entry for the credit. The credit-memo and restocking-fee mechanics get a section of their own below.
5. Check tax buckets. When a variance line shows the gross matching but the total off, the cause is almost always a sales-tax bucket mismatch. Reconcile the tax line against the resale or project exemption certificate on file before assuming the supplier is wrong. A surprising share of "the supplier overcharged us" findings turn out to be a missing certificate on the supplier's side.
6. Resolve, post adjustments, document the residual. What is left after the first five steps is either an RNI accrual decision, covered next, or a question for the supplier's AR clerk, covered below. Post the adjustments, document the residual variance, and route the package to sign-off.

The same procedure runs in Sage 100 Contractor, QuickBooks Online, Foundation, Buildertrend, JobTread, or Knowify; the platform-specific clicks change but the workflow does not. Most variances clear in steps 2 through 4; tax-bucket and supplier-conversation residuals clear in steps 5 and 6.

Calling the supplier's AR clerk

The variances that survive steps 1 through 5 are the ones that need a phone call. The supplier's AR clerk on the other end is running the same reconciliation in reverse against the same statement. Keep the question short and tied to a specific line:

• "Can you re-send invoice X" for invoices on the statement that cannot be found in AP after the timing check has resolved as much as it can.
• "Can you confirm credit memo Y was applied to the statement, and to which invoice" for credit memos posted on the contractor's side that the statement does not reflect.
• "Can you confirm payment Z was applied to invoice A" for misapplied-payment cases where an invoice still shows open after the bookkeeper's payment record shows it cleared.
• "Can you re-send the RA and the credit memo for return R" when the field returned material but no credit memo ever reached AP.

The sales-tax bucket dispute is the special case. Send the resale or project exemption certificate on file along with the question — a surprising share of tax variances clear once the supplier updates the customer record from "taxable" to the exemption on file.

---

Credit Memos and Restocking Fees Done Properly

Credit memos are the variance pattern most likely to break a construction reconciliation, because the supplier's credit memo is rarely a simple negative invoice. It carries adjustment lines — restocking fees on returns, re-shelving charges on yard-pickup, pickup fees when a truck is sent to the jobsite — that change the net cost the bookkeeper has to capture.

The lumber-yard restocking-fee structure is the most common construction-specific shape. Yards typically charge a percentage on customer-returned, good-condition material. The percentage is lower when the contractor brings the material back to the yard in the original packaging within a defined window (often 10 to 15 percent), higher when the yard sends a truck to pick the material up from the jobsite (often 15 to 25 percent or more, reflecting freight and handling), and stricter still on special-order, custom-cut, or non-stock items. What matters operationally is that the credit memo reflects both lines — the gross credit and the negative restock charge — and the bookkeeper has to post both.

The credit memo prints the original return as a positive credit and the restocking-fee line as a negative offset; both lines have to post on the AP side, and the net agrees with the statement entry. The most common mistake is capturing only the gross credit and ignoring the restock line, which produces a recurring variance — the AP shows the credit at gross, the statement shows it at net, and the difference is the restock charge that nobody booked.

Code the restock charge to the same job and cost code as the original receipt — not to a generic returns or shrinkage account. Miss the per-job allocation and the project manager sees the gross credit on the cost report and assumes the return cleaned up the cost when it did not; the variance compounds across multiple returns over the life of the job.

Timing variant: the supplier may have issued the credit memo in the prior period but not applied it to the statement until this period, or the reverse. Don't re-post the credit memo — confirm with the supplier which statement period the credit is intended to land in, and accept the timing residual into the working file.

The supplier may have issued a credit memo the contractor never received, because it went to the project manager who handled the return at the jobsite, or to the field office that authorized the pickup, and never made it to AP. Ask the supplier for the RA number and the date the credit memo was issued, then ask the field for the matching pickup ticket. Once the credit memo is in hand, post it with the same per-job coding the original invoice carried, including the restock charge to the same job. The lesson the working file captures: returns happening in the field need a documented hand-off back to AP, not a verbal note from the project manager.

---

Cutoff, RNI, and the Accrual That Closes the Period Cleanly

When the variance investigation surfaces a statement-side invoice that should be in AP but is not, the cause is almost always one of three. The invoice is in transit, scanned by the supplier and on its way to the contractor's AP inbox but not yet posted. The supplier billed late and the invoice will arrive in the next few days. Or the goods were received against an open PO and no supplier invoice has yet followed. The first two resolve themselves when the invoice arrives, often within a day or two, and the bookkeeper can leave the variance line open and re-test next morning. The third needs a received-not-invoiced accrual, because the cost has been incurred and the period is about to close on it.

Received-not-invoiced in the construction context means something specific: the materials were delivered, a signed delivery ticket is on file, the cost is therefore real and belongs to the job, but no supplier invoice has yet posted to the AP system. Closing the period without the accrual understates the supplier balance, understates AP, and misstates the job cost on the project manager's report. An RNI accrual is the entry that fixes all three at once.

The accrual entry is mechanical once the evidence is on file. The PO line gives the unit cost (or the delivery ticket gives the unit cost where the PO is open and partially-billed and the line price has been confirmed). The delivery ticket gives the quantity received in the period. The accrual journal debits the job cost — to the same job and the same cost code the eventual invoice will hit — and credits an RNI liability account that sits on the balance sheet until the actual invoice posts. When the supplier's invoice finally arrives, post the invoice normally to AP and reverse the accrual against the same job and cost code. The job cost ends up correct, the supplier balance ends up correct, and the RNI liability clears.

Per-job discipline is the load-bearing part. Coding the accrual to the same job and cost code the eventual invoice will hit keeps job profitability accurate even when supplier billing lags by weeks, which it routinely does on long jobs and monthly billing cycles. Generic "AP accrued" entries that wash through a single month-end clearing account hide the cost from the project manager, defeat the cost-report, and create a second variance next month when nothing reverses cleanly. The mechanic is the same as estimating month-end accruals for bills that arrive late for utility billing: accrue at the job-and-code level, reverse on the same level when the bill arrives.

The cutoff policy decision belongs to the controller. Which delivery tickets without invoices get accrued? Common construction conventions are to accrue everything material to the job above a per-line dollar threshold, or everything older than a defined ageing window (commonly seven or fourteen days) with a delivery ticket on file.

When the inverse occurs — an invoice posts before the delivery ticket arrives — the GRNI or invoice-receipt balance carries the timing until the receipt comes in. The PO and delivery-receipt evidence that anchors a clean RNI accrual is the same scaffolding that supports a three-way match against the eventual invoice; the workflow walked in matching HVAC supplier invoices to POs and delivery receipts is the line-level version of the cutoff discipline this section frames at the period-close level.

---

The Reconciliation Packet and Why Extracted Data Speeds the Walk

Sign-off needs evidence, and the evidence is the reconciliation packet. For one supplier and one period, the packet contains the supplier's monthly statement; the supporting invoices and credit memos posted in the period, matched to the statement lines; the accrual journal for any RNI on open POs and delivery tickets, with the reversal scheduled for next period; the per-job coding for every variance posted; and a sign-off note from whoever ran the reconciliation, naming the residual variance accepted and the rationale. This is what a CPA at year-end expects to see — the packet itself, not just a summary line that says the supplier reconciled. Coding construction supplier invoices by job, phase, and cost code at the source means the packet practically writes itself.

The variance walk is fast or slow depending on what data the bookkeeper has to work with. When supplier invoices and credit memos are already in a structured spreadsheet — one row per invoice or one row per line item, columns for date, supplier, invoice number, net, tax, total, and a reference back to the source PDF — the walk is a few minutes per supplier. Pivot by supplier and date range, compare the totals to the statement, drill on the variance line, click through to the source PDF for the disputed line. When the same supplier invoices live as PDFs in an email inbox or a shared drive, the same walk takes hours. The catalog and the investigation order are operationally workable on extracted data; on un-extracted PDFs they are aspirational, which is why the work compresses to a single hectic week at month-end for so many AP teams. Automated invoice and credit memo data extraction is the precondition this workflow assumes; the article walks what happens after the extraction is done.