How to use the lowest balance date finder
- Enter the start date, the end date and your balance on the start date.
- Optionally set a warning level, a balance you want to stay above. The default is zero.
- List your income and bills. Each item has a name, a first date, an amount (positive for income, negative for bills) and how often it repeats.
- Read the lowest balance and the date it happens, the days below your level and the table of days with activity.
Formula
Balance on day d = balance on day d - 1 + sum of the amounts that fall on day d
Weekly: every 7 days from the first date. Every 2 weeks: every 14 days.
Monthly: same day of the month, or the last day in a shorter month
Lowest balance = the smallest end-of-day balance in the range
All items dated the same day are applied together. If two days tie for the lowest balance, the earlier day is shown.
Rent before payday
Start on 2026-11-01 with $1,500 and run through 2027-01-31. A $1,800 paycheck every two weeks from 11-05, rent of $1,400 on the 1st of each month, car insurance of $210 on the 18th and groceries of $160 every week from 11-03.
Rent on November 1 takes the balance to $100, and groceries on November 3 take it to ($60.00), the lowest point of the whole range. The balance stays below zero on 2 days, November 3 and 4, until the paycheck on November 5. Over the three months income totals $12,600, bills total ($6,910.00) and the balance on January 31 is $7,190.00.
Why the low point is not the end balance
An account that ends the month healthy can still dip below zero in the middle, when a large bill lands before the next paycheck. Month-end summaries hide that. This tool replays the days in order, so the date of the low point tells you exactly which bill needs to move or which buffer you need.
Once you know the date, the fix is often small: ask for a due date change, move savings in a few days earlier, or split a large payment. The Cash Flow Forecast Calculator looks at monthly balances for a business, and the Bill Calendar Planner helps you lay out when each bill is due.
Getting realistic dates
Use the dates when money actually leaves or arrives, not the dates on the statement. Card payments, checks and transfers can take a day or more to post, and pending items may reduce your available balance at once. Add a buffer in the warning level to allow for that.
For a plan for the whole month, try the Budget Planner or the Zero-Based Budget Calculator, and use this page to test the timing of a plan before you commit to it.
Assumptions and limits
- Only the end-of-day balance is checked. Items on the same day are applied together in no particular order.
- Repeating items continue until the end date, and items with a first date before the start date still repeat into the range.
- No interest, fees, overdraft charges or pending transactions are modeled.
- The range can be up to five years long and each item repeats weekly, every two weeks, monthly or once.
Frequently asked questions
How are monthly items on the 31st handled?
A monthly item keeps its day of the month. In a month with fewer days, such as February, it lands on the last day of that month, and it goes back to the 31st in the next month that has one.
Why is the low balance based on end-of-day amounts?
Banks post items in their own order, and the tool cannot know it. Applying all items on a day together gives a clear, repeatable answer. If two items on one day could dip your balance in the middle, build in a buffer.
Can I include a one-time expense?
Yes. Set Repeats to Once and give the date. Items dated outside the range are ignored.
What does the warning level do?
It counts how many days your balance is below a level you choose and shows the first such day. Set it to a safe cushion, such as the lowest amount you want in the account, rather than zero.