bank statement → OFX

Proof of Cash Analysis Software for Quality of Earnings Reviews

A proof of cash is only as good as the bank data under it. Upload the target's statements, digital or scanned, and get every transaction and balance in one Excel table you can foot, pivot and tie to the ledger.

Reads scanned statements with OCR
Test 15 pages, no credit card
256-bit encryption

PDF, JPG, PNG, BMP, HEIC, TIFF

Upload your bank statement

Extract:
|
|
<OFX> for MS Money & accounting software, <CSV> for spreadsheets

What does proof of cash analysis software do?

It extracts the bank side of a proof of cash so you can reconcile it. OFXStatement reads every transaction and balance from PDF or scanned bank statements into Excel or CSV, so the analyst totals receipts and disbursements by month and ties them to the general ledger instead of keying statements. It does not perform the reconciliation or write the report.

The reconciliation is quick. The statements are not.

A QoE proof of cash needs every account for every month, and targets send PDFs from several banks, many of them scanned. Keying thousands of lines eats the engagement budget and adds errors you then have to reconcile away.

From a folder of statements to a reconciliation table

Upload the statements and download clean rows with the balances printed on each statement.

Excel and CSV Output

One row per transaction with date, description, amount and balance.

Scanned Statements Read With OCR

Paper and photographed statements extract like digital PDFs.

Bulk Upload on Plus

Up to 50 statements per upload, with an option to merge files.

Balances for Footing

Running balances, plus the summary box in All data mode.

Card Statements Too

Credit card statements for the disbursement side of the proof.

Encrypted Handling

Files are encrypted in transit and at rest.

How to get statements ready for a proof of cash in 4 steps

The same routine for a QoE engagement, a lender file or a buyer's own cash proof.

1

Collect every account

List every bank and card account and every month in the period.

2

Extract the statements

Upload them above and download Excel or CSV.

3

Foot each month

Opening balance plus deposits minus withdrawals must equal the printed close.

4

Tie to the ledger

Total receipts and disbursements by month and reconcile to the GL.

Who uses proof of cash analysis software

Anyone who has to tie a target's reported numbers to its bank accounts.

QoE and Transaction Advisory Teams

Cutting the statement keying out of fixed-fee engagements.

Search Fund and ETA Buyers

Running a first cash proof before paying for a full QoE.

Acquisition Lenders

Tying deposits to tax returns and financial statements before funding.

Common Search Terms

proof of cash analysis software proof of cash analysis proof of cash proof of cash software quality of earnings proof of cash proof of cash audit proof of cash due diligence quality of earnings software bank statements for quality of earnings four column proof of cash sba quality of earnings

What is proof of cash analysis software?

Proof of cash analysis software gets the bank side of a proof of cash into a spreadsheet so you can reconcile it. A proof of cash ties the cash that actually moved through the bank to what the books say happened, month by month, split into receipts and disbursements. The reconciling is analyst work. The slow part, in almost every deal, is getting two or three years of statements for every account out of PDFs and into rows. That is the part OFXStatement does.

Forvis Mazars describes the procedure in M&A work as a reconciliation of cash basis revenue and EBITDA to the bank statements. The bank statement is the third-party document in the file, which is why buyers, lenders and QoE providers insist on it. It is also why the work gets expensive: statements arrive as PDFs, often scanned, often from several banks, and nobody wants to key thirty thousand lines.

For scale, QoEAgent, a firm that sells proof of cash as a service, publishes one trailing-twelve-month engagement on its site: 431 bank statements across 36 accounts, manually scanned PDFs rather than spreadsheet exports, and 29,823 transactions. Most lower middle market targets are smaller than that. Few are small enough to type.

How is a proof of cash laid out?

The classic layout is the four-column proof of cash auditors learn early: beginning balance, receipts, disbursements and ending balance across the top, with the bank figures reconciled down to the book figures. The top row comes straight off the bank statements.

LineBeginning balanceReceiptsDisbursementsEnding balance
Per bank statementOpening balance printed on the first statementTotal deposits and credits for the periodTotal withdrawals, checks and debitsClosing balance printed on the last statement
Deposits in transitAt the start of the periodAdd this period, remove last periodAt the end of the period
Outstanding checksAt the start of the periodAdd this period, remove last periodAt the end of the period
Other reconciling itemsBank errors, unrecorded fees or interestUnrecorded receiptsUnrecorded chargesCarried forward
Per books (general ledger)Opening cash per GLCash debits per GLCash credits per GLClosing cash per GL

In due diligence the same idea runs over a longer period, often the last two fiscal years plus the trailing twelve months, and the receipts column gets compared with reported revenue rather than just the ledger cash account. Either way, every figure on the "per bank" line is a sum of statement transactions. If those transactions are wrong or missing, nothing below them reconciles.

What the software does and what stays with you

We are specific about this because the difference matters when you are pricing an engagement. OFXStatement is an extraction tool. It reads the statements; it does not read the general ledger, form an opinion or produce a report.

Step in the proof of cashWhere the data comes fromWhat OFXStatement does
Collect statements for every account and monthThe seller or the bank, usually as PDFs, sometimes scannedNothing yet. You still need the complete set
Get every transaction into a spreadsheetThe statement transaction tablesExtracts date, description, amount and balance from each page, digital or scanned, to Excel, CSV or OFX
Confirm opening and closing balancesStatement summary boxesKeeps the running balance column where the bank prints one; All data mode also pulls the summary box with opening and closing balances
Total receipts and disbursements by monthThe extracted rowsGives you clean rows; the SUMIFS or pivot table is yours
Remove transfers between the target's own accountsDescriptions across several accountsKeeps the bank description text so you can filter and match transfers
Tie cash to revenue and expenses in the GLGeneral ledger exportNot in scope. That is the analyst's judgment
Explain variances and write the reportYour workpapersNot in scope

How to prepare bank statements for a proof of cash

Collect every account and every month, extract the transactions, foot each month to the printed balances, then tie the totals to the ledger. This is the routine we would follow with the converter on this page:

  1. Build a request list of every operating, payroll, merchant, savings and credit card account, and every month in the review period. Missing months are the most common reason a proof of cash will not roll forward.
  2. Upload the statements with the box at the top of this page. On Plus you can drop up to 50 files at once and, if you like, merge one account's months into a single file before extraction.
  3. Choose Transactions only so each export holds just the transaction table under one header row, then download Excel or CSV.
  4. Add two columns: Account and Statement month. Stack every account into one table.
  5. Check each month: opening balance plus deposits minus withdrawals should equal the closing balance printed on the statement. A month that does not foot is a missing page or a misread line, and you want to find it now, not after you tie to the ledger.
  6. Tag transfers between the target's own accounts, owner draws and loan proceeds, then build the receipts and disbursements totals by month with a pivot table.
  7. Tie those totals to the cash activity in the general ledger and to reported revenue, and work the variances.

The footing check in step 5 is the one people skip and regret. A statement that does not roll forward on its own will never tie to the ledger, and you cannot tell a missing deposit from an extraction error until you have checked the month in isolation. The converter keeps the running balance column where the bank prints one, which makes the check a one-line formula.

Proof of cash for quality of earnings, SBA and search fund deals

Three kinds of buyers run into this work most. Transaction advisory and QoE teams at small CPA firms do proof of cash on most lower middle market engagements and bill by the engagement, so hours spent keying statements come straight out of margin. Search fund and ETA buyers often run a quick cash proof themselves before they pay for a full QoE, to decide whether the deal is worth the fee. Lenders, including SBA lenders, ask for cash to be tied to the tax returns and financial statements before they fund an acquisition.

The data problem is the same in all three. The target sends a folder of PDFs, some downloaded, some scanned from paper, from two or three banks with different layouts. Credit card statements need the same treatment, because a proof of disbursements is incomplete without them. Everything on this page applies to card statements as well.

How do you handle transfers between accounts?

Transfers are the most common source of inflated receipts. When the operating account sweeps into savings and back, both sides show up as deposits and withdrawals on different statements, and a naive total counts them twice. Extract all accounts into one table, filter the descriptions for the bank's transfer wording (it usually names the other account or ends in its last four digits), and tag both legs. The same pass catches owner draws, loan proceeds and credit card payments, which belong in the proof but not in revenue.

Options for getting the bank data, compared

Prices below are the ones each vendor publishes on its own site as of September 2026. Where a vendor does not publish a price, we say so rather than guess.

OptionPublished priceWhat you getBest for
Keying statements by handStaff timeFull control, slow, typo risk on thousands of linesOne account, a few months
Generic PDF to Excel (Excel Get Data, Acrobat)Software you may already ownWorks on some digital PDFs; scanned pages and multi-line descriptions break itClean digital statements from one bank
OFXStatement$49 a month (2,500 pages) or $149 a month (10,000 pages)Transaction tables from digital and scanned statements to Excel, CSV or OFX; you run the reconciliationAnalysts who do the proof of cash themselves
DocuClipper$29 a month (60 pages) to $899 a month (5,000 pages), from its pricing pageBank statement extraction plus invoices and receiptsFirms that also process invoices and receipts
QoEAgent Proof-of-Cash Plus$10,000 flat, from its websiteThe reconciliation done for you, plus GAAP-formatted monthly income statements and balance sheetsBuyers who want the proof of cash delivered, not built
Full QoE engagement from a CPA firmQuoted per engagementProof of cash inside a full quality of earnings reportLenders and investors who need a signed report

These are not all the same product. QoEAgent and a CPA firm deliver the reconciliation; OFXStatement and DocuClipper deliver the data you reconcile. If your team is doing the proof of cash anyway, extraction is the cost you can cut. If you want someone else to own the conclusion, a service is the right purchase, and the statement data still has to be extracted by someone.

How much does it cost to extract a year of statements?

A typical small business checking statement runs 3 to 10 pages. A target with four accounts and 36 months of history is 144 statements, which at an average of 6 pages is about 860 pages. That fits inside one month of Starter at $49 (2,500 pages on the faster AI model, up to 25 pages per statement). A target the size of the QoEAgent example above, at 4 pages a statement, is roughly 1,700 pages and still fits, though long statements and bulk upload point to Plus at $149 a month (10,000 pages, unlimited pages per statement, up to 50 files per upload). You can test up to 15 pages with no credit card first. See current pricing.

If you already extract statements for lending files or forensic work, the same account covers this. Our pages on bank statement extraction software and the bulk bank statement converter go deeper into volume work, and what forensic teams pay for Valid8 covers the adjacent forensic market.

Proof of Cash FAQ

A proof of cash is a reconciliation that ties the cash moving through a company's bank accounts to its accounting records over a period, with receipts and disbursements reconciled separately, not just the ending balance. In M&A due diligence it ties cash basis revenue and EBITDA to the bank statements.

Usually, yes. Most QoE providers run a proof of cash to confirm that reported revenue and expenses are backed by real bank activity before they analyze adjustments. Forvis Mazars notes it is a supplement and not a substitute for full financial diligence, so it rarely stands alone in a large deal.

A bank reconciliation matches the ending balance per bank to the ending balance per books at one date. A proof of cash also reconciles the receipts and disbursements for the whole period, so it catches offsetting errors and unrecorded activity that a balance-only reconciliation can hide.

You need bank statements for every account for every month in the period, credit card statements, the general ledger or trial balance, and usually the tax returns and financial statements you are testing. Missing statement months are the most common reason a proof of cash cannot be completed.

Yes. OFXStatement reads scanned and photographed statements with OCR and extracts the same date, description, amount and balance columns as from a digital PDF. Foot each month against the balances printed on the statement to confirm nothing was misread before you tie to the ledger.

Firms quote proof of cash and QoE work per engagement. The one flat price we found published is QoEAgent's Proof-of-Cash Plus at $10,000. Doing it in house, the data extraction for a small target fits in one month of our Starter plan at $49.

No. It extracts the transactions and balances from the bank statements into Excel, CSV or OFX. You or your team reconcile them to the general ledger, explain the variances and write the conclusions. That split is why the tool costs a monthly subscription instead of an engagement fee.

Excel or CSV. Both keep the statement columns as printed, one row per transaction, so you can stack accounts, add Account and Month columns and pivot. OFX is meant for importing into accounting software and is the wrong format for a reconciliation workbook.

Related Resources

Other Bank Statement Converters

JPMorgan Chase Bank of America Citigroup Wells Fargo Goldman Sachs Morgan Stanley U.S. Bancorp PNC Financial Services Truist Financial Capital One TD Bank Charles Schwab Bank of New York Mellon State Street BMO USA Ally Financial Regions Financial Fifth Third Bank Huntington Bancshares KeyBank Citizens Financial Group First Citizens BancShares Synchrony Financial M&T Bank First Horizon Cathay Bank USAA Navy Federal Comerica Zions Bancorporation East West Bancorp First National of Nebraska Cullen Frost Bankers BOK Financial Fulton Financial Associated Banc-Corp Valley National Bancorp Wintrust Financial First Midwest Bancorp Commerce Bancshares UMB Financial Pinnacle Financial Partners Webster Financial Cadence Bank Old National Bancorp First Interstate BancSystem Umpqua Holdings First Hawaiian Bank Prosperity Bancshares SouthState Corporation First Merchants First Bank Holding Glacier Bancorp First Financial Bancorp Independent Bank Columbia Banking System Western Alliance Bancorporation Pacific Premier Bancorp Bank OZK United Community Banks Customers Bancorp Texas Capital Bancshares SVB Financial Group Signature Bank First Republic Bank New York Community Bancorp Sterling Bancorp First Bank Bank United First Commonwealth Financial ServisFirst Bancshares Renasant Corporation Simmons First National Trustmark Corporation First Busey Community Bank System First Mid Bancshares Ameris Bancorp Hancock Whitney First BanCorp Third Coast Bancshares Home Bancshares Byline Bancorp Simmons Bank United Bankshares Peoples United Financial American Express HSBC Bank USA Citizens Bank Santander Bank Flagstar Bank PNC Credit Card U.S. Bank Credit Card Apple Card

Payment Processor and Marketplace Statement Converters