Entering the bank statement analysis

Until a statement analysis exists, lender matching runs on the revenue the merchant told you, which is usually optimistic. The analysis replaces it with the numbers the lender will see: true revenue, balances, NSFs, negative days and existing payments. Get it right and the match matrix, the offer calculator's holdback check and the submission all agree with the lender's underwriter.

1. 1Open the deal and the Bank statements tab.
2. 2Under Bank statements, fill Bank, Account and Last 4 for the first account. Click Prefill last 4 months to add four empty month rows, or Add month one at a time.
3. 3For each month, enter Total deposits, True revenue, Avg daily balance, Withdrawals, Starting balance, Ending balance, Number of deposits, Negative days, NSFs and MCA debits. Leave a cell empty when the statement does not show it.
4. 4If the merchant deposits into more than one account, click Add bank account (up to six). The preview combines them.
5. 5Add Notes on what you excluded: transfers, loan proceeds, a one-off deposit, seasonality.
6. 6Check the preview, then click Save analysis. Lender matches re-run on the new figures.

• True revenueTrue revenue is a merchant's real monthly sales on the bank statements: total deposits minus transfers, loan and MCA proceeds, refunds, reversals and owner money.
• Average daily balance (ADB)Average daily balance (ADB) is the mean of a bank account's end-of-day balances over a month. Funders use it to judge whether a merchant can carry daily payments.
• NSFNSF means non-sufficient funds: a payment bounced because the account was short. In MCA underwriting, NSF counts per month are a core risk signal.
• Negative daysNegative days are the days in a month when a merchant's bank account ends below zero. Funders cap them because each one risks a returned debit.

A bakery's four months of true revenue are $58,000, $61,000, $63,000 and $66,000. Statements show MCA debits of $6,200 a month from one existing advance. Your organization uses 21 business days a month and a 15% target holdback (the defaults).

Avg true revenue = (58,000 + 61,000 + 63,000 + 66,000) / 4 = $62,000
Holdback = 6,200 / 62,000 = 10.0%
Revenue trend = (66,000 - 58,000) / 58,000 = +13.8%
Room for new payment = (62,000 x 15% - 6,200) / 21 = 3,100 / 21 = about $148 per business day

The summary also flags risks automatically: three or more positions, more than 3 NSFs or more than 3 negative days last month, revenue down 15% or more, existing holdback at or above 25%, or an average daily balance under 5% of revenue.

• Edit figures corrects the current analysis.
• New analysis starts a fresh one (for example when a month rolls over). Once saved it replaces the current one for matching; the old one moves to Earlier analyses, where View months shows its figures.
• For card-heavy merchants, use Merchant processor statements (Add processor statements) to enter monthly card volume, Amex, chargebacks, transactions and batches. The card shows average volume, average ticket, chargeback ratio and Amex share.
• Upload the statement PDFs themselves on Documents & stips with the Statement month set, so the package and the analysis match.