Negative days and NSFs
Know if the account can take one more daily pull
Underly rebuilds the closing balance for every day the statements cover, then counts the days it went negative, the NSF returns and the days it closed below the existing daily debt.
First 10 statements free. No card.
How it works
How the daily balance is built
- Daily balance
- Each statement starts from its printed opening balance and closes every day on that day's credits and debits. Where the bank prints a running balance, each day is checked against it.
- Average and lowest
- The mean of the combined closing balances for each month and the whole file, and the lowest close with its date.
- Negative days
- Calendar days the combined account closed below zero. A dip during the day that recovers by close isn't counted.
- NSFs and returns
- NSF returns, returned payments, stop payments, chargebacks and bank fees, each with its transactions. A bounced funder pull counts as a returned payment, not an NSF.
- Balance calendar
- Every day with its close, credits, debits and funder pulls, and bank holidays named. Negative days and days that close below the existing daily debt are flagged.
FAQ
Common questions
How are several accounts combined?
Balances are added together on days every account has one. Accounts in a different currency from the analysis are left out of the combined figures.
Are bank holidays handled?
Yes, for US dollar and sterling accounts. Business days follow Federal Reserve holidays for dollars and England and Wales bank holidays for sterling, and the calendar names each one.
What does closing below the daily debt mean?
The day closed lower than the existing monthly debt divided by 21.7 business days, which is what current funders pull on an average day.
Do gaps between statements count?
No. Days no statement covers stay empty, so a missing month never shows as zero or negative.
Features
The rest of the read
- MCA stacking detectionEvery existing advance and loan by funder, with its payment, cadence and monthly total.
- True revenueTransfers, owner deposits, loan proceeds and returns taken out of gross deposits.
- Altered statement detectionPDF metadata and balance math checked on upload, so edited files are flagged before you fund.
- Line-item labelsEvery transaction labelled, from processor deposits to MCA debits and NSFs. Relabel in bulk and every figure recalculates.
- Debt-to-revenueExisting debt payments as a share of true revenue, so you see the room left before you fund.
Run your next file through Underly
The first 10 statements are free. No card.