Receivables in an Acquisition: Reconcile the Balance and Test the Cash

Establish which receivables the analysis includes

Start with a dated invoice subledger and a matching general-ledger control. Record the entity, currency, cutoff, whether balances are gross or net of credits, and whether the report includes tax, retainage, related parties or amounts not yet billed. A customer statement, sales report and aged receivables report answer different questions. A ledger balance is also different from the receivables population defined in a purchase agreement.

Document the right to collect. An asset purchase may leave specified receivables with the seller; an agreement may deliver some balances and exclude others. The parties also need rules for receipts sent to the wrong bank account, credit notes raised after closing, disputed work, customer advances and collection expenses. Do not treat a projection of receipts as a legal assignment, an agreed working-capital value or a borrowing-base calculation.

Build a reviewable bridge from invoice to bank

Sampling should be deliberate. Include large balances, older balances, new invoices near cutoff, credits after cutoff and unusual customers; identify the total population and the amount tested. A clean sample is not a statement that every invoice is collectible. Keep any customer-identifying documents in the private data room. Public tools should use anonymous references and local inputs.

Age by due date, and retain the invoice date

Invoice age and days past due are different. A September 15 invoice due October 15 is current on October 1 even though it was issued sixteen days earlier. Missing or changed payment terms can make bucket comparisons misleading. Reconcile date conventions before comparing periods. The companion tool uses due-date aging: current or due today, 1–30, 31–60, 61–90 and more than 90 days past due.

The age buckets use balances after entered credits. Disputed amounts and retainage remain in those balances; they are shown separately in the receipt model. This preserves the difference between an accounting balance, a timing assumption and a valuation or reserve decision. An invoice should not disappear simply because it lacks a credible receipt date.

Separate credits, disputed amounts and retainage

A credit reduces the modeled opening balance only if it was not already included in the export. A dispute identifies a known issue requiring evidence. Retainage can depend on project acceptance or other actual terms. Do not mark the same dollar as both disputed and retained. The tool treats those two categories as unscheduled until the user changes the underlying classification and support. It neither calculates an accounting allowance nor determines that held amounts will never be paid.

A documented payment plan may split one invoice into several installments. Represent each installment as a unique row, with only its allocated opening balance and credit; retain an external reconciliation to the original invoice. Do not repeat the full invoice amount on every installment. Payments received before the snapshot belong in the opening balance reconciliation, rather than being forecast again.

A $120,000 opening-population example

This is a timing comparison of opening invoices, not a full company cash forecast. It excludes new sales, operating payments, tax, capital spending and debt service. The thirteen-week tool preserves receipts beyond the horizon and shows amounts without dates. A later receipt is not automatically an economic loss, but the delay may create a funding need when combined with actual payroll and supplier obligations.

Connect the collection review to cash and closing only once

The collection schedule supplies weekly receipts from the entered opening invoices. Add them to an operating forecast only after separating new cash sales and new-credit collections so the same invoice is not counted twice. The existing acquisition cash-flow tool accepts monthly receipts manually; use matching calendar months and do not paste seven-day week totals into calendar months without reconciling dates.

For the closing peg, apply the agreement’s included-account definition and agreed reserve method. A lower negotiated value, a seller-retained invoice and a cash collection delay are different treatments. A working-capital deduction and an additional price deduction for the same invoice can duplicate the effect. Carry a single issue reference across the working-capital schedule, funds flow and post-close collection log.

Complete the review file

1. Save the opening export, ledger control and immutable date reference.
2. List tested invoices and subsequent receipts, including unmatched cash.
3. Assign each credit, dispute and retainage item an owner and evidence request.
4. Use explicit collection dates and a separate delay case.
5. Reconcile post-close cash to the right legal owner and ledger posting.
6. Have the accountant review financial presentation and counsel review collection rights and agreement treatment.

Sources and scope

Source links support the specific topics noted. Examples and analytical frameworks are illustrative; confirm current requirements and transaction facts with the responsible advisers.

1. SBA — Manage your finances
   General bookkeeping, receivables and cash/accrual context. Not an accounting standard, collection forecast or purchase-agreement definition.