Matching deposits to reported revenue, month by month

Revenue is the foundation of every valuation. But reported revenue and actual cash received rarely align perfectly—not because of fraud, but because of timing, customer payment behavior, refunds, and accounting method differences. When you’re evaluating a small acquisition, matching bank deposits to reported revenue isn’t a formality. It’s the first line of defense against discovering, post-close, that the $2M you thought you were buying generated only $1.6M in real cash. This guide walks through the exact method to perform this match, why the gaps matter, and what discrepancies signal about the business you’re considering.

The Deposit-to-Revenue Match: Why It Matters

A business can report $100K in monthly revenue under accrual accounting while depositing only $60K in cash. That’s not necessarily a red flag—it could be timing (invoices issued but not yet paid, or payments received after month-end). But without a systematic deposit-to-revenue match, you won’t know whether the gap is normal working capital timing or a sign of collection problems, aggressive revenue recognition, or unrecorded refunds eating into deposits.

The match also catches a pattern many buyers miss: deposits that don’t correlate to reported revenue at all. Imagine a business reports $120K in sales in March but bank deposits show $95K. You dig in and find $25K in cash collected in March was actually payment for February invoices—or worse, a cash advance from the owner that was never recorded as a liability.

For normalization purposes, you need to know whether reported revenue is backed by real cash flow. A Quality of Earnings analysis without a deposit match is incomplete because you can’t tell if EBITDA was inflated by timing alone or by structural issues in how the business recognizes sales.

Step-by-Step: How to Match Deposits to Revenue

1. Gather Your Data Sources

You need three documents aligned to the same period (typically 12-24 months):

• Bank statements — all deposit transactions, with dates and amounts. If the business has multiple accounts, pull all of them.
• Revenue ledger or sales journal — from the company’s accounting system, with transaction date, customer name, amount, and invoice number.
• Accounts receivable aging report — shows which invoices are outstanding and when they were issued.

Ask the seller for an A/R aging as of the last day of each month in your analysis period. This shows how much revenue was recorded but not yet collected, which is essential to reconcile.

2. Create a Month-by-Month Deposit Schedule

Build a spreadsheet with columns for:

• Month
• Total bank deposits (sum of all customer payments)
• Reported revenue (accrual basis)
• Difference (deposits minus revenue)
• A/R at month-end (to explain timing gaps)
• Notes (refunds, owner draws, transfers, adjustments)

Start with the simplest check: Are deposits roughly tracking revenue? If revenue grows 30% month-over-month but deposits stay flat, that’s your first question mark.

3. Identify and Categorize Gaps

A gap between deposits and revenue will exist. The goal is to explain it. Common sources:

• Timing (normal): A business invoices customers in Month 1 but receives payment in Month 2. A/R grows; deposits lag revenue. This is expected and not a red flag unless A/R days outstanding are rising dangerously.
• Refunds and chargebacks (legitimate cost of revenue): A business reports $100K in sales but issues $8K in refunds. Deposits will be $92K. You’ll need to see refund records to confirm.
• Multiple payment methods (complicates tracking): Revenue might be split across credit card processors, PayPal, checks, and ACH. Make sure you’re capturing all of them. Credit card deposits often arrive 1–3 days after transaction, compounding timing gaps.
• Owner draws or personal transactions (non-revenue cash): If the owner withdraws cash or the business deposits money from a personal loan, those won’t tie to revenue. Look for deposits that have no corresponding invoice or customer record.

4. Worked Example: A Three-Month Match

Imagine a service business with the following profile:

January: Reported revenue $80K, bank deposits $72K, A/R at month-end $15K. The $8K gap is explained: four invoices totaling $8K were issued late in January and paid in early February. Not a problem.

February: Reported revenue $90K, bank deposits $95K, A/R at month-end $18K. Deposits exceed revenue. Why? Because those $8K late-January invoices came in this month, plus one large customer pre-paid for March work ($3K). You adjust: February’s core revenue deposits were $92K (95 minus the 3K prepayment), which aligns with the $90K reported—a $2K timing gap is normal.

March: Reported revenue $95K, bank deposits $88K, A/R at month-end $30K. Revenue up, deposits down, A/R surged. Red flag territory. Dig into March invoices: Did the business take on a new customer who pays net-45 instead of net-30? Did they issue $7K in credit memos? Did a large check bounce? Without the A/R aging and customer-level detail, you’d misinterpret this as a revenue problem when it’s actually a customer mix shift or a collection delay on specific deals.

5. Calculate Days Sales Outstanding (DSO) Trend

A rising DSO trend is often buried in the deposit-to-revenue gap. Formula:

(A/R at month-end ÷ Monthly revenue) × 30 = Days Sales Outstanding

If DSO rises from 18 to 35 over a 12-month period, cash conversion is deteriorating. The business isn’t losing revenue—it’s losing collection velocity. That’s a working capital adjustment in a normalization, and it signals operational friction you need to understand before close.

Red Flags in the Deposit-to-Revenue Match

Persistent deposits exceeding revenue (without prepayment explanation): If deposits run 10–15% higher than reported revenue for multiple months without corresponding prepayments or prior-period collections, the seller may be recording revenue conservatively (overstating the number of unpaid invoices) or mixing in non-revenue cash. Clarify the source of every deposit above reported revenue.

Unexplained deposits with no customer record: A $20K deposit that doesn’t correspond to any invoice or customer is a massive question. It could be a loan, an owner contribution, a tax refund, or a sale of an asset. Any of those changes the working capital or adds back non-recurring items. You must identify every such deposit before signing an LOI.

Large gap between deposits and revenue that widens: If Month 1 has a $5K gap (normal timing) but Month 12 has a $40K gap, the business’s collection function is breaking. This isn’t a quality-of-earnings adjustment—it’s a sign the business requires working capital support post-close, or the customer base is changing in ways that hurt cash flow.

Refund rate climbing: Pull refund records alongside the deposit match. If refunds were 2% of revenue in Year 1 but 8% in Year 2, product quality, customer satisfaction, or billing accuracy issues are present. That’s normalization work and sometimes a re-rating of risk.

How to Document Your Match for the Offer

When you’re ready to move forward, create a reconciliation memo that shows:

• Reported revenue by month vs. bank deposits by month (side by side)
• A/R aging at key month-ends, with trend analysis
• All non-revenue deposits or unusual items, with brief explanations
• A summary of collection velocity (DSO trend) and any concerns flagged

This becomes part of your working capital peg or post-close adjustment framework. If you find the business typically carries $50K in A/R and your working capital peg is set at $40K, you’ve signaled that the seller is responsible for funding the difference—which may be negotiated into the sale price or earn-out.

A proper deposit-to-revenue match takes 4–6 hours for a small, single-location business with clean accounting. If it takes longer or raises questions, that’s not wasted time—that’s you avoiding a bad deal. Outsourcing Processing’s platform organizes this data in a standardized format so you can spot trends faster and document your findings without building spreadsheets from scratch.

The core takeaway: Real revenue is revenue your customer actually paid for, deposited into your bank account. Everything else is timing, working capital, or risk. A methodical deposit match turns vague revenue numbers into concrete cash-flow evidence. When you’re building your offer and your normalization case, that evidence is worth far more than the seller’s accounting opinion. Start with the deposits. Everything else flows from there.

This article is educational and does not constitute M&A, investment, or accounting advice — confirm findings with a licensed CPA or M&A advisor before making an offer.

Frequently Asked Questions

Why would deposits be lower than reported revenue if the business is healthy?

Timing is the most common reason. A business invoices on net-30 terms but receives payment 30–45 days later, so March deposits include money from February sales. Rising accounts receivable indicates this timing gap. You can verify by comparing the gap to the month-end A/R balance. If the gap roughly matches the increase in A/R, cash flow is normal; if A/R is steady and deposits are consistently short, collection problems exist.

How do I account for credit card processing delays in the deposit match?

Credit card transactions are often deposited 1–3 business days after the sale and may appear in the bank statement on a different date than the sale date. Pull credit card processing reports (settlement reports) showing transaction date and deposit date separately, then allocate them to the correct sales month. Most accounting systems timestamp the transaction date, not the deposit date, so reconcile using the transaction date from the processor’s report, not the bank date.

What if the business has multiple bank accounts or payment processors?

Consolidate all deposits across all operating accounts, merchant processors, and payment platforms (PayPal, Square, Stripe, etc.) into one total for each month. Some businesses spread revenue across accounts intentionally; others do it accidentally. The match must include every source of cash. If you’re missing an account, the deposit-to-revenue match will show a persistent, unexplained gap that forces you to dig deeper—which is exactly what you want to happen during due diligence.

How should I handle refunds in the deposit-to-revenue match?

Refunds are typically recorded as negative revenue or a separate refund line item in the sales journal. If revenue was $100K and refunds were $5K, net revenue is $95K, and deposits should track the $95K after refunds process (though timing may lag). Pull a refund report separately and verify that refund amounts were actually returned to customers (check for corresponding negative deposits or credits). Some sellers bury refunds in overstated gross revenue, making EBITDA look better than it is.

Can a deposit-to-revenue match replace a full Quality of Earnings review?

A deposit match is a critical first step—it validates the foundation of revenue—but it doesn’t replace a full Quality of Earnings engagement, especially for larger deals. A QoE covers add-backs, customer concentration, recurring revenue mix, contract terms, and other items beyond cash reconciliation. For smaller acquisitions ($1M–$5M), a systematic deposit match combined with human review of the results is often sufficient for your own internal analysis. Larger or more complex deals benefit from a licensed CPA review to ensure all normalization adjustments are defensible.

This article is educational and does not constitute M&A, investment, or accounting advice — confirm findings with a licensed CPA or M&A advisor before making an offer.

For a faster alternative to a traditional QoE engagement, see IncomeReady for M&A Buyers.