Key takeaways
- Match the location, date basis, and settlement accounts.
- Document each timing difference in both periods.
- Investigate individual shortfalls even when monthly totals balance.
Select one complete settlement period. Use closed invoices as the starting point. Keep sales tax, parts returns, fleet invoices on terms, gift balances, and card processing fees visible as separate adjustments.
How do you apply the three steps?
Fix one closing date for your invoice export, settlement batches, and bank statement. Bridge the three totals in order so you can distinguish an unpaid fleet invoice from a card deposit arriving tomorrow.
Set the cutoff
Use one location and one date range. Record whether the export uses invoice close date, payment date, or posting date.
Build the bridge
Start with invoice totals, subtract open balances, add collections on older invoices, and identify deposits that cross the cutoff.
Test the residual
Trace the remaining dollars to settlement batches and the ledger. Keep an unexplained residual open until someone can document it.
What does a completed bridge look like?
Suppose your closed repair-order total includes $50,000 of invoices for one settlement period. Of those, $8,000 remain unpaid fleet receivables. You also collect $6,000 invoiced in an earlier period. Your card processor withholds $900 in fees and $1,100 of current receipts will settle the following week. With those illustrative assumptions, you would expect $46,000 in deposits. Keep sales tax on the same basis throughout the example.
| Reconciliation line | Illustrative amount |
|---|---|
| Closed invoices | $50,000 |
| Less current invoices still unpaid | ($8,000) |
| Add collections from earlier invoices | $6,000 |
| Less deducted merchant fees | ($900) |
| Less current funds settling next period | ($1,100) |
| Expected bank deposits | $46,000 |
What if your statement shows a different amount?
Separate a timing difference from an unexplained residual. You can test a delayed batch by identifying its processor ID and the date it reached the next statement. A short payment requires different evidence, such as a credit memo, fee, chargeback, or customer remittance. Avoid allocating the difference to fees simply because that balances the spreadsheet.
Watch for money that never came from customers. Owner contributions, loan proceeds, and transfers between bank accounts can appear in deposits without corresponding repair orders. Keep these items in a separate column. Start again with another complete period to find out whether your reconciliation method works consistently.
Use the shop report request to gather records for the bridge. The IRS discussion of business recordkeeping provides background on source documents. The worksheet method and the numbers above are an original illustration.
Which date belongs on each side of the bridge?
Use the invoice-close date for the work-order population and the posted bank date for deposits if those are the dates your source systems can reproduce. Record that choice in the first row of the worksheet. A sale closed at six on Friday may settle on Monday. Your invoice export and bank statement can both be correct even though the money appears in different calendar periods.
Write down the business location, local time zone, first and last day, and which bank and merchant accounts you included. Confirm whether the shop changed systems or processors during the period. If it did, you may need two exports with different field names and a small overlap test. Use invoice number, location, and date together when numbering restarts in a new system.
Choose a cutoff you can verify in both directions. A month-end statement helps establish the bank population. The first few business days of the following month help you identify delayed settlements. Obtain the prior period’s ending fleet aging so you can distinguish money collected on earlier invoices from newly invoiced work. Record the documents you still need before treating the bridge as complete.
How do you handle split tickets, deposits, and returns?
Start with the customer obligation and follow the money. A customer might pay a deposit on a special-order part, finance part of the final bill, and pay the balance by card. You may see three payment events for one repair order. A sales report may show the whole ticket on the day it closes. Reconcile the payments to the invoice without counting the earlier deposit a second time.
Consider an illustrative $2,400 repair with a $600 deposit received in June and $1,800 collected when the invoice closes in July. If you start July with the full $2,400 invoice, remove the $600 already received in June when calculating July collections. Do not reduce the job’s earned revenue merely because the deposit crossed month-end. Your accountant can determine the correct recognition treatment for the actual books.
For a refund, identify when the original sale was recorded and where the processor deducted the refund. A $180 customer credit issued on the last business day might reduce the next settlement. A parts credit from a supplier is a different transaction on the purchasing side. Carry both records under their own identifiers so a legitimate reimbursement does not mask a customer payment discrepancy.
What should you do with sales tax and shop fees?
Choose a consistent gross or net starting point. If your repair-order total includes sales tax, the cash collected can include tax the business later owes to a taxing authority. The bank deposit may match the tax-inclusive invoice even though the income statement reports revenue exclusive of tax. Put the liability and the eventual remittance on separate lines when you bridge to the ledger.
Use one invoice to identify which components your management system includes in reported sales. Parts, labor, disposal fees, sublet work, discounts, and tax can appear in separate columns. Your accountant should verify how the business treats each category in its jurisdiction. The bridge documents how amounts move through your records and where professional review is needed.
Watch for fees collected on behalf of another business or agency. A financing provider may settle the approved amount less a merchant charge. The customer invoice, provider remittance, and bank deposit form a three-document trail. Keep the gross amount and the deduction visible so you can compare the actual cost of payment options over time.
How do you test a fleet receivable that crosses several months?
Create an aging schedule by invoice and account. Select a material customer, trace a prior outstanding invoice to the later remittance, and identify the bank posting that includes it. Then work backward from one deposit to every invoice the customer applied it against. Working in both directions makes it easier to recognize one payment applied to several vehicles or an amount the customer short-paid.
If your customer pays $8,700 against nine invoices totaling $9,000, establish the reason for the $300 difference. It could be an agreed fleet discount, a disputed repair, a credit note, or an unapplied balance. Each possibility has a different effect on recognized revenue, collectible receivables, and the sale agreement. Preserve the customer’s remittance and the ledger treatment while you investigate.
For a pending transaction, link the aging to the proposed treatment of receivables. If the seller keeps pre-closing fleet invoices, the buyer might receive a payment that belongs to the seller. The closing documents should define how the parties identify, report, and remit such money. Retain a copy of the relevant invoice list so the new operator can recognize the deposit without giving the former owner ongoing access to customer systems.
Which bank deposits belong outside operating revenue?
Inspect unfamiliar deposits before classifying them as unrecorded sales. A business account may receive owner funding, transfers between locations, insurance proceeds, a loan advance, a tax refund, or the sale of an old service vehicle. Put each deposit on a separate non-customer schedule with its bank reference and supporting document. The goal is to identify its source and financial treatment, not to force it into repair-order totals.
A cash deposit deserves the same discipline. Match the cash drawer close, deposit slip, and bank posting. Identify whether cash was held for several days or used to replenish petty cash under a documented policy. A buyer should evaluate documented earnings and discuss any inconsistencies with qualified advisers. Unverified claims about collections do not provide a reliable basis for increasing the purchase price.
If two locations use one settlement account, identify the merchant IDs and deposit references for each location. Some processors combine daily settlements. Ask for a batch-detail export that allocates the combined deposit across terminals or stores. Keep transfers between the stores outside customer collections, even if both sides label the movement as a deposit.
How do you decide whether an unresolved amount matters?
Define the purpose of your review before setting a tolerance. A few dollars of documented rounding can have little effect on a purchase decision. A small unexplained deduction repeated on every fleet payment can reveal a pricing concession or collection problem. Evaluate size, frequency, direction, and whether one person can reproduce the explanation from independent records.
Work from individual discrepancies to the monthly result. A short settlement and an unrelated deposit can offset so the month appears to balance. Sample both positive and negative adjustments. Look at the largest open items and several ordinary ones rather than relying entirely on the net difference at the bottom of the sheet.
Maintain a list of unresolved items. For each, identify the invoice or deposit, amount, period, current explanation, evidence requested, and the person who can supply it. Use a separate column for the effect on your underwriting if the explanation proves incorrect. A timing difference that clears next month has a different implication from revenue you cannot support at all.
How do you carry the result into valuation and closing?
Send the reviewer a copy of the original exports, the bridge formulas, and a short description of how to reproduce the final amount. Use redacted copies when confidentiality requires it. A reviewer should be able to change the cutoff date, substitute the next month’s records, and see the same types of reconciling items without asking the preparer to rebuild the file.
If the bridge changes supported revenue or expected collection costs, reflect the evidence in your earnings recast. Avoid subtracting a receivable permanently from annual earnings simply because cash arrived late. Separately test whether the later collection increases the working capital you need to fund payroll and parts. Earnings quality and timing of cash are distinct purchase questions.
At closing, retain a final bridge for the agreed cutoff and another for the first settlement cycle under new ownership. Confirm how ordinary card receipts, fleet balances, deposits, refunds, and chargebacks were allocated. Your next conversation should concern the few open items you can name, quantify, and trace, rather than a general disagreement about whether the shop’s sales are real.
What else should you know?
Which month should I reconcile first?
Choose a complete month with original invoice, payment, settlement, and bank records. Include an ordinary fleet invoice or a known timing exception if possible. Obtain the adjacent settlement dates so you can verify delayed batches. After the method works, repeat it in a different operating period.
Can I rely on a processor’s monthly total?
Use the total as a control figure and trace selected batches to the bank. Check whether the processor deducts fees, refunds, chargebacks, or reserves before settlement. You also need to account for cash, checks, financing providers, and fleet payments that did not pass through the processor.
What happens if two stores share a bank account?
Rebuild the deposit by merchant ID, terminal, processor batch, or another documented location identifier. Keep intercompany transfers outside the customer collection schedule. If the records cannot allocate a combined deposit reliably, identify the uncertainty and test its effect before using location-level sales in a valuation.
Does a balanced bridge verify every sale?
A balanced period establishes that the documented categories reconcile at the level tested. Individual errors can offset, and the bridge does not establish future customer retention. Sample individual tickets and deposits in both directions, review unusual items, and compare results across additional periods before relying on the revenue.
Which sources can you check?
- Business recordkeeping · Internal Revenue Service · 2026-11-21
- Publication 538, Accounting Periods and Methods · Internal Revenue Service · 2026-11-21
- Repair-order reporting in service operations · Tekmetric · 2026-11-21