Guide

How to calculate true revenue from bank statements

Start with gross deposits and take out every credit that isn't a sale: transfers from the merchant's own accounts, owner and related-party money, loan and advance proceeds, reversals, returned items and bank interest. What's left is true revenue, the figure an advance should be sized on.

LendPipe team

Why gross deposits overstate revenue

A merchant cash advance is a purchase of future receivables, repaid with a set percentage of the business's daily sales receipts, as the Federal Reserve puts it. So the advance should be sized on sales. Gross deposits mix sales with money that only passed through: a transfer from savings, the owner topping up the account, last month's advance landing. Counting them makes a business look bigger than it is, and the advance too large for what it really earns.

What to take out of deposits

Deposits that are not revenue
DepositWhy it isn't revenueHow it often reads
Own-account transfersMoney the business already had, moved between its accountsONLINE TRANSFER FROM CHK 5520
Owner and related-party moneyCapital put in by the owner or people close to the businessZELLE FROM M COPPER
Loan and advance proceedsBorrowed money that has to be paid backA lump-sum credit from a funder or lender
Reversals and returned itemsA credit that undoes an earlier transactionRETURN, REVERSAL or a returned item
Bank interestEarned on the balance, not from customersINTEREST PAID

Everything else counts: card settlements, ACH payments from customers, cash and check deposits, and wires from customers.

How to calculate it, step by step

  1. Total every credit for each month. That's gross deposits.
  2. Mark transfers between the merchant's accounts. With both statements in hand, the amount leaving one account matches the amount arriving in the other on the same or next day.
  3. Mark money from the owner and related people: their names, personal accounts and P2P payments from them.
  4. Mark loan, advance, lease and factoring proceeds. A funding deposit usually arrives just before a funder's pulls begin.
  5. Mark reversals, returned deposits and bank interest.
  6. Subtract each group from gross deposits and keep one line per group, so anyone reviewing the file can check every dollar that didn't count.
Example: from gross deposits to true revenue for one month
LineAmount
Gross deposits$98,400
Own-account transfers−$12,000
Owner and related-party money−$5,000
Loan and advance proceeds−$25,000
Reversals and returned items−$1,350
Bank interest−$50
True revenue$55,000

Large one-off deposits

A single deposit far bigger than usual can be a real sale, a contract payment, or money that should have been excluded. Don't remove it silently and don't accept it silently: check it. Underly marks a deposit as unverified when it's 20% or more of an average month, measured without that deposit, and leaves it in true revenue for you to decide.

Working out the average month

Statements rarely start on the 1st, so a calendar-month average is dragged down by partial months. Divide total true revenue by the days the statements cover, then multiply by the length of an average month (365.25 ÷ 12, about 30.4 days). Days no statement covers are left out rather than counted as zero, and days covered by more than one account count once.

New York and California take a similar view in the disclosures they require for sales-based financing: estimated monthly sales are the merchant's historical average over a fixed period of four to twelve months.

How Underly does it

True revenueTransfers, owner deposits, loan proceeds and returns taken out of gross deposits.

Sources

FAQ

Common questions

Is true revenue the same as net income?

No. True revenue is what came in from customers, measured on the deposit side. It doesn't subtract expenses.

How do I handle several bank accounts?

Put every account in the same calculation and take out the transfers between them. Otherwise the same dollar is counted once in each account it passes through.

Should a previous MCA's funding deposit count?

No. It's an advance against future sales, not a sale, and it has to be paid back out of the same revenue you're measuring.

Can I change what counts in Underly?

Yes. Relabel a deposit and true revenue recalculates. Changing whether a transaction counts asks for a reason, so the change is on record.

Run your next file through Underly

The first 10 statements are free. No card.

Run a file free