Evidence-first money workflow · Personal Money
Bill Calendar and Paycheck Mapper
Map dated bills to paycheck windows, apply explicit priorities, carry cash forward, and identify the first uncovered obligation before it is due.
- 1Prepare
- 2Analyze
- 3Review and export
Prepare the evidence
Paste the documented CSV schema or choose a local CSV file. Nothing is sent to Nirmion.
Review the analysis
Summary metrics lead back to the rows that support them.
Method and interpretation
How to use Bill Calendar and Paycheck Mapper
Use this mapper when monthly totals look affordable but bill timing can still produce a negative balance. It assigns each obligation to the latest paycheck available on or before its due date, carries remaining cash forward, and identifies the first point where scheduled cash is insufficient.
Prepare the input
Add opening cash that is actually available, then list positive paycheck amounts and positive bill amounts. Mark each bill essential, important, or flexible. Multiple checks on the same date are combined. Bills before the first paycheck can use only opening cash, making early-period timing visible.
Check the worked example
The example begins with USD 300 and an insurance bill before the first October paycheck. Rent, utilities, groceries, gym, and a card payment are assigned across later pay dates. If a priority bill drives cash below zero, the exact due date and peak uncovered amount appear.
Read the evidence
Read paycheck windows first to see starting and ending cash. Then inspect bill funding decisions. Uncovered means the running amount went below zero at that bill; it does not recommend borrowing or delaying payment. Flexible rows remain visible for review even when funded because priority is an input assumption.
Calculation method
Bills are sorted into paycheck windows using due date. Inside each window, essential bills are applied before important and flexible bills, then by due date. Running cash equals prior carried cash plus paycheck income minus mapped bill amounts. The largest negative running value becomes peak uncovered amount.
See Quicken Simplifi projected cash-flow inputs and recurring reminders
Questions this workflow helps answer
Use these questions to confirm that this tool matches the task you need to complete.
- How can I build a bill-payment calendar around paycheck dates?
- Which paycheck should fund each bill before its due date?
- Where does a paycheck budget first become uncovered after priorities and opening cash are applied?
Limits and decision boundary
The model uses the dates and amounts entered. It does not account for bank processing time, holds, minimum-balance requirements, pending card transactions, overdraft rules, variable pay, or bills omitted from the file. A funded result is not a guarantee of account balance.
Common mistake
Do not enter credit-card purchases and the later card payment as separate bills in the same plan unless that double counting is intentional. Decide whether the calendar tracks cash obligations or category consumption.
Your pasted values and selected CSV files are processed in this browser tab. This workflow does not connect to a bank, save a budget, or provide financial, tax, legal, or investment advice.
Questions about this workflow
What if a bill is due on payday?
It belongs to that payday’s window. Real deposits and withdrawals can post in a different order, so keep an operating buffer when timing is uncertain.
Why are priorities processed before date inside a window?
The model protects user-marked essentials first. This is an explicit planning policy; change priority labels if strict due-date order better represents the household.
Can I add irregular income?
Add it as another dated paycheck only when the date and amount are sufficiently certain for this scenario. Use the irregular-income planner to compare uncertainty first.