A bank deposit analysis matches every dollar credited to your account against the internal records that should explain it, then applies a set of techniques to expose errors, fraud, and compliance risks. Done well, it reconciles totals, tracks patterns over time, compares payment-type mixes, and flags anomalies like deposits clustered just below the $10,000 federal reporting threshold or check float that has quietly lengthened by three days since last quarter. The work has two halves: assembling clean data from independent sources, then running that data through techniques that each catch something the others miss.
Data You Need Before You Start
The analysis depends on comparing two independent streams: what the bank says happened, and what your internal records say should have happened. Neither stream is complete on its own, and the gaps between them are where findings live.
External Records
Bank statements are the authoritative source for deposit dates, amounts, and descriptions. Pull statements for the entire period under review, along with any supplemental detail pages your bank provides for individual deposit transactions. If your business uses a lockbox service, request the lockbox reports separately; they show which customer payments were processed, often before those payments appear on the statement itself. Deposit slips, physical or electronic images from remote deposit capture, document the initial composition of each deposit so you can verify that what was prepared internally matches what the bank actually processed.
Internal Records
General ledger entries for cash and revenue accounts show the recorded intent of every transaction. Point-of-sale reports give you the raw data: time, amount, and payment method for each sale. Sales invoices document what customers owed, and cash receipts logs record when payments came in. If you accept payments through multiple channels (in-person, online, lockbox, wire), each channel produces its own data stream that has to be pulled into the analysis.
Standardize Before You Compare
Aggregate all deposit records by date, source, and payment type. Every deposit tied to a single day’s sales belongs together regardless of whether it came from a register, a lockbox, or an ACH payment. Aggregated internal totals for each period then need to reconcile to the deposit totals on the bank statement, and any difference needs a name: deposit in transit, bank fee, timing difference, or unidentified variance. Skip this matching step and you spend the rest of the analysis chasing phantoms.
Techniques That Actually Surface Findings
Once the data is standardized, no single method catches everything. A comprehensive review runs several in sequence, because each one answers a different question about the same records.
Reconciliation
The fundamental technique compares total recorded internal sales and receipts to total bank deposits over a defined period. If your books show $950,000 in sales for the quarter, reconciled bank deposits should land close to that figure, with any difference explained by deposits in transit, bank fees, or timing adjustments. Unexplained gaps are where investigation starts.
Trend Analysis
Trend analysis examines deposit patterns across a longer timeline, typically 12 to 36 months, to reveal seasonal cycles, growth patterns, and shifts in customer payment behavior. Track both average deposit size and deposit frequency. A business that runs daily deposits should show that rhythm clearly. Any break in the pattern, like a shift from daily to weekly deposits without a business reason, warrants follow-up. This is also where you catch gradual deterioration, such as a slow decline in average deposit size that no single month’s reconciliation would flag.
Ratio Analysis
Ratio analysis compares the proportional mix of payment types. The most telling metric is the ratio of cash deposits to electronic deposits (ACH, wire transfers, card settlements). A sudden spike in cash deposits without a corresponding increase in cash sales recorded at the point of sale is one of the clearest signals of a control problem. Ratio analysis also reveals shifts in customer payment preferences that affect cash flow timing, since electronic payments clear faster and more predictably than checks.
Stratification
Stratification sorts deposits into tiers by size, source, or other characteristics. You might group deposits into bands: under $1,000, $1,000 to $5,000, $5,000 to $10,000, and over $10,000. The distribution tells you where transaction volume falls and, more importantly, highlights unusual concentrations. A cluster of deposits just below $10,000 is a classic structuring indicator. A sudden run of large deposits from an unfamiliar source demands investigation at any amount.
Rolling Averages and Float
A rolling average smooths daily volatility to reveal the underlying trend line, which helps when comparing your patterns to industry benchmarks or judging whether a recent change is a blip or a genuine shift. Float analysis measures the time gap between when payment is received and when funds actually clear. If average float on check deposits is creeping upward, that can signal inefficiency in cash handling, delays in making deposits, or intentional holding of funds by someone in the deposit chain. Tracking float over time gives you a benchmark that makes deviations obvious.
Red Flags Worth Investigating
The point of the analysis is to flag transactions that break from established patterns. Some anomalies point to honest error, others to fraud or a compliance violation. Knowing which patterns to look for is what separates a useful review from a rote comparison of numbers.
Round Numbers and Structuring Patterns
A high frequency of perfectly round deposits (exactly $5,000, $8,000, $9,500) when the underlying sales are variable amounts is worth investigating. This is especially true when deposits consistently cluster just below $10,000. That pattern is the textbook indicator of structuring, which is a federal crime in itself.1Office of the Law Revision Counsel. United States Code Title 31 – Section 5324 Banks are specifically trained to watch for customers breaking large transactions into smaller ones, running transactions at multiple branches on the same day, or using multiple people to keep individual deposits under the threshold.
Timing Anomalies
Deposits made at unusual times, on unexpected days, or significantly later than your cash receipts log indicates can signal two common fraud schemes. Lapping is when someone steals a cash payment from one customer, then covers the shortage by applying the next customer’s payment to the first customer’s account. It shows up as a persistent, shifting delay between when payments are logged internally and when they hit the bank. Skimming is the outright theft of cash before it is ever recorded, leaving a permanent gap between sales records and bank deposits. A consistent small variance, a few hundred dollars every week that no one can explain, often points to low-level internal theft.
Source and Description Anomalies
Deposits originating from personal accounts, unfamiliar entities, or locations unconnected to normal business operations deserve scrutiny. Any deposit described as “miscellaneous income” or carrying a vague description needs to be traced to a specific invoice or service before it is accepted as legitimate revenue. Vague descriptions are sometimes laziness, but they also create cover for funds that have no legitimate business purpose.
Duplicate Remote Deposits
Businesses using remote deposit capture face a specific duplicate-deposit risk. A check can be submitted electronically and then deposited physically at a branch, or submitted through apps at two different banks. This happens both by accident and by design, and because banks do not always share real-time deposit data, duplicates can clear before anyone catches them. Your analysis should include a specific check for duplicate amounts on the same or adjacent dates, especially when the dollar amounts match customer payment records exactly. Requiring a “For Mobile Deposit Only” endorsement on scanned checks, and promptly voiding or securing physical checks after scanning, are basic controls that reduce this risk.
Federal Reporting Thresholds That Explain the Red Flags
Deposit analysis intersects directly with federal anti-money-laundering law, and understanding the reporting requirements explains why certain patterns matter so much.
Currency Transaction Reports
Banks must electronically file a Currency Transaction Report for every cash transaction over $10,000, whether it is a deposit, withdrawal, or currency exchange. When a customer makes multiple cash transactions on the same business day that collectively exceed $10,000, the bank must treat them as a single transaction for reporting purposes if it knows they are conducted by or on behalf of the same person.2FFIEC BSA/AML InfoBase. FFIEC BSA/AML Manual – Currency Transaction Reporting
Form 8300 for Businesses
The CTR obligation sits with the bank, but businesses have their own parallel requirement. Any trade or business that receives more than $10,000 in cash in a single transaction or in related transactions must file Form 8300 with FinCEN within 15 days. For this purpose, “cash” includes coins, currency, and certain monetary instruments like cashier’s checks and money orders with a face value of $10,000 or less. Personal checks do not count. The filing obligation also applies when installment payments from the same buyer exceed $10,000 within a 12-month period.3Internal Revenue Service. IRS Form 8300 Reference Guide
Penalties for failing to file are steep. Negligent failure to file on time carries a penalty of $310 per return. Intentional disregard of the filing requirement jumps to the greater of $31,520 or the total cash amount received in the transaction.3Internal Revenue Service. IRS Form 8300 Reference Guide
Structuring Is a Standalone Crime
Breaking a large cash transaction into smaller ones to avoid the $10,000 reporting threshold is structuring, and it is a federal crime regardless of whether the underlying money is legitimate. A person convicted of structuring faces up to five years in prison and fines. If the structuring is part of a broader pattern of illegal activity involving more than $100,000 in a 12-month period, penalties increase substantially.1Office of the Law Revision Counsel. United States Code Title 31 – Section 5324
Suspicious Activity Reports
Banks must file a Suspicious Activity Report for any transaction or pattern of transactions involving $5,000 or more when the bank suspects the funds are derived from illegal activity, the transaction is designed to evade Bank Secrecy Act requirements, or the transaction has no apparent business or lawful purpose. When the bank has no identified suspect, the threshold rises to $25,000.4FFIEC. Part 353 – Suspicious Activity Reports Banks are watching for these patterns at relatively low dollar amounts, and the anomalies your own analysis uncovers may already be generating regulatory scrutiny on the banking side.
What Deposit Analysis Tells You About Bank Fees
Deposit analysis is not only about verifying revenue. It should also evaluate what you are paying the bank and whether your balances are working to offset those costs. Most businesses do not scrutinize this side carefully enough.
Your bank provides a monthly account analysis statement itemizing every service charge: transaction fees, maintenance fees, lockbox processing, wire fees, positive pay, and other cash management services. Each line shows the volume, unit price, and total. The statement separates fee-based charges that cannot be offset from balance-compensable charges that can.
The earnings credit rate is a percentage the bank applies to your average daily collected balance to produce a dollar credit that offsets service charges. Multiply the average daily balance by the ECR by the number of days in the period, then divide by 365. A $500,000 average balance at a 4% ECR produces roughly $1,644 in monthly credit, subtracted from service charges. Once fees are fully offset, additional credits stop accruing. The ECR is not interest; it is a bank-set rate that varies by institution and is negotiable. If your analysis shows you are consistently paying out-of-pocket fees despite maintaining large balances, the ECR is the first place to push back.
Reviewing the account analysis statement serves two purposes. It confirms the bank is charging fees consistent with your contract (volume spikes in transaction fees or unexpected new line items should be questioned), and it tells you whether your deposit strategy is optimized. If balances generate far more earnings credits than you need, those excess funds are earning nothing and may belong in an interest-bearing account or short-term investment.
Controls That Prevent What the Analysis Catches
Deposit analysis works retroactively. It catches problems after they happen. Internal controls are the preventive side, and weaknesses in those controls are often the root cause of the anomalies you find.
The single most important control is segregation of duties. The person who receives cash should not prepare the deposit, and neither should reconcile the bank statement. When one employee handles the entire chain from receipt to reconciliation, fraud becomes trivially easy and nearly invisible. In smaller organizations where full segregation is impossible, the employee with the least involvement in recording financial transactions should handle the reconciliation, and a second person, even a board member or owner, should review and sign off.
Other controls that directly affect deposit accuracy:
- Deposit cash and checks daily. Holding receipts overnight or over weekends increases both theft risk and float time.
- Use pre-numbered deposit slips so a missing deposit in the sequence is obvious.
- Require dual custody for cash, with two people counting and signing the deposit slip.
- Record payments in the accounting system the same day they arrive, before they are deposited, to create the internal record the analysis relies on.
- Stamp checks “For Deposit Only” immediately on receipt to prevent diversion to another account.
When the same discrepancy keeps turning up, the fix is almost always a control weakness rather than a data problem. Tracing the anomaly back to the point where it entered the system tells you which control failed or does not exist.
Turning Deposit Data Into Cash Flow Forecasts
Historical deposit data becomes a forecasting tool once you have enough of it. The trend, ratio, and stratification work described above feeds directly into projections that drive working capital decisions.
Seasonal patterns are the most obvious input. If deposits show a consistent 30% dip every January and a surge in March, you can plan for the gap rather than scrambling when it arrives. Growth trends layer on top: a business growing 8% annually should see that reflected in average deposit sizes over time, and any divergence between expected growth and what deposits actually show is a signal worth investigating.
Timing data is where forecasting gets granular. If the average time between invoicing and deposit clearance is 45 days, you can schedule accounts payable to align with when cash actually arrives rather than when you hope it will. That timing also tells you whether you need a short-term credit line to bridge predictable gaps. If large deposits consistently land on specific dates, you can plan to repay short-term borrowings immediately after, cutting interest costs.
The ratio of electronic to check payments matters for forecasting accuracy. ACH and wire transfers clear on predictable schedules and are rarely returned. Checks involve variable hold times and the occasional bounce. A business whose deposits are 80% electronic has much tighter forecasting precision than one still processing mostly checks. As your payment mix shifts, your forecasting model has to shift with it, and the deposit analysis is what keeps the model honest.