Proof of Cash vs Bank Reconciliation: What Is the Difference?

Last updated July 2026.

Quick answer: A bank reconciliation agrees one number, the ending balance, at one point in time. A proof of cash agrees four numbers across a whole period: beginning balance, receipts, disbursements, and ending balance. That difference means a proof of cash catches offsetting errors and deliberate manipulation that leave the ending balance perfectly reconciled.

The failure a bank reconciliation cannot see

Start with the case that explains everything else. Suppose a bookkeeper records a customer deposit of 50,000 twice in the general ledger, and also records a vendor payment of 50,000 twice. The bank shows each once. At month end, the errors cancel. The ending balance per books equals the ending balance per bank after the usual reconciling items, and the reconciliation ties cleanly.

Nothing is wrong with the reconciliation. It did its job, which is to agree one number. But revenue is overstated by 50,000 and expenses are overstated by 50,000, and no one looking at the reconciliation will ever know. A proof of cash catches it immediately, because it compares total receipts and total disbursements as well as the ending balance, and those columns do not agree.

What each one actually does

How a proof of cash is built

The schedule has four columns and works from the bank figures to the book figures, adjusting for items that hit one side in a different period than the other. Deposits in transit at the start of the month were bank receipts in the prior period but book receipts in this one, so they come out of receipts. Deposits in transit at the end of the month are the reverse. Outstanding checks work the same way on the disbursements column. Bank items never recorded on the books, such as service charges and NSF returns, are adjusted where they belong.

Two checks then have to pass. Every row must satisfy beginning balance plus receipts minus disbursements equals ending balance. Every column must reconcile from the bank figure through the adjustments to the book figure. When both directions foot, the period is proved. When a column fails, either the reconciling items are wrong or the underlying activity genuinely disagrees, and you go to the transactions to find out which. The proof of cash template for Excel lays out the format with a worked numerical example.

When should you prepare a proof of cash?

It is not a replacement for the monthly reconciliation and it is not something most businesses need every period. It earns its keep in specific situations.

• Elevated fraud risk over cash. Particularly where one person handles receipts, recording, and reconciliation, since that combination allows lapping and skimming to be covered up.
• Weak or missing controls over receipts and disbursements. Common in smaller entities where segregation of duties is not practical.
• Audit engagements where cash carries higher risk. The converter for auditors page covers where this sits in a cash testing program.
• Forensic investigations. When you already suspect something, the activity columns are where it shows.
• Quality of earnings work. Buy side due diligence uses a proof of cash to tie reported revenue and expenses to money that actually moved, which is one of the more persuasive tests available to a buyer.
• After a reconciliation has been failing or forced. Plugged reconciliations are a warning sign, and a proof of cash finds what is being plugged.

What a failed proof of cash usually means

When the balances agree but the activity does not, the cause is usually mundane before it is sinister. Interbank transfers recorded gross on one side and net on the other are the most common culprit, and they inflate both columns without changing any balance. After that: a deposit posted twice on one side, bank fees or returned items never recorded on the books, and journal entries made directly to the cash account with no corresponding bank transaction. That last one deserves attention, because a manual journal to cash is the classic place a misstatement gets parked.

Lapping is the pattern the schedule is really built for. When receipts from one customer are applied to another customer's balance and covered by later collections, the ending balance stays right the whole way through. The receipts timing does not.

Why the bank side is the bottleneck

The arithmetic of a proof of cash is straightforward. Getting the inputs is what takes the day. You need total receipts and total disbursements for every month on the bank side, and plenty of statements print only a running balance rather than clean monthly totals. Twelve months means opening twelve PDFs and transcribing four numbers from each, with a transcription risk on every one, and if a month fails you need the underlying transactions anyway.

The practical fix is to convert the statements into rows once, stack the months into a single sheet with a month column, and pivot. Sum of credits by month gives bank receipts, sum of debits gives disbursements, and the balance column supplies the opening and closing figures. Because you kept the line level detail, investigating a failing month is a filter rather than a re-read. To stack the files see combine bank statements in Excel, and running balance extraction covers keeping the balance column intact. For a routine month, the bank reconciliation template for Excel is the lighter tool, and the reconciliation workflow page covers the monthly process. A full year of source files converts in one pass with batch bank statement conversion, and the general bank statement converter handles any statement format.

Which should you actually run?

Reconcile every account every month. That is the baseline and nothing here replaces it. Add a proof of cash when the stakes or the risk justify the extra work: an audit where cash risk is real, a business where one person controls the cash cycle, a transaction where a buyer needs the earnings tied to cash, or an investigation. Run it monthly rather than annually when you do run it, because an annual proof can be defeated by errors that reverse inside the year and gives you no way to narrow where a variance came from.

One last practical note: if the books live in QuickBooks, you can skip the spreadsheet round trip for the routine monthly work and convert each statement straight into a QuickBooks ready file, keeping the spreadsheet approach for the periods where you actually need the four column proof.