A cash-flow worksheet answers a specific question: how much usable money will be available on each date? A monthly budget can show that income exceeds expenses while still missing a shortage before payday. A running balance makes the timing visible before a loan payment is added.
Define the starting money carefully
Choose a start date and record money actually available in the account used for bills. Subtract amounts already committed to transactions that have not posted, or list those pending transactions as upcoming outflows. Do one or the other consistently so they are not counted twice.
Identify reserves within the balance. If $800 is set aside for annual insurance, it is not entirely free to fund another purchase merely because it shares a checking account. You can track the bank balance and uncommitted balance separately.
Do not include a credit limit as cash. It is potential borrowing subject to account terms and availability, and using it would create another repayment obligation. The worksheet should reveal the cash shortage rather than conceal it with assumed new credit.
The CFPB's Your Money, Your Goals toolkit includes cash-flow planning resources. The following layout is an original way to apply that timing principle to a household considering a loan.
Give every row a date and a source
Useful columns are date, description, money in, money out, running balance and confidence or status. A final column can identify the statement, bill or estimate behind the number. This makes revisions easier when a quote or payday changes.
Enter net pay, reliable benefits and other confirmed household receipts. Keep uncertain refunds, gifts and invoices in a separate scenario. A payment marked “expected” should not become indistinguishable from cleared money.
For outflows, include housing, utilities, food, transport, insurance, care costs, taxes paid separately and existing loan payments. List variable spending on realistic dates or weekly allowances. Putting all grocery spending on the last day of the month can hide an earlier shortage.
Handle transfers and cards consistently
A transfer between your own accounts is not new household income. If the worksheet tracks only the bill-paying account, it can appear as money in there, but the source account must still retain enough for its commitments. Label the transfer so it is not mistaken for earnings.
Credit cards require a clear method. If you record purchases as spending when made, the later payment needs to be treated consistently to avoid counting the same expense twice. Existing carried debt, interest and additional principal repayment still need separate attention.
Alternatively, a cash-only account forecast can list the actual card payment as an outflow while maintaining a separate spending record for purchases. The important point is that the method reveals both future bills and current cash without duplication.
Calculate a running example
Suppose a hypothetical account begins with $600 available. A $1,500 paycheck arrives on the 2nd, bringing it to $2,100. Rent of $1,100 on the 3rd leaves $1,000. Utilities of $160 and a weekly spending allowance of $180 leave $660. An existing $140 loan payment leaves $520.
If the proposed new installment is $250 on the 10th, the balance falls to $270. Another $180 of everyday spending before the next payday leaves $90. That low point matters even if the next paycheck makes the month-end balance look comfortable.
Now test a $150 irregular bill before that payday. The forecast falls to minus $60. This does not mean the household is necessarily short for the whole month; it identifies a timing gap that needs a real funding or date solution before borrowing.
Add known changes and uncertainty
Record annual bills on their due dates and show the reserve that funds them. Include a first loan payment that differs from the normal cycle. If a rate or promotional period may change, create a clearly labeled later-payment scenario.
For irregular income, shift a major receipt to a later date and observe the lowest balance. Then reduce its amount in a separate scenario. These tests distinguish timing risk from insufficient income, which may require different responses.
Avoid “fixing” a negative row by deleting essential spending without a credible plan. A due-date change should be entered only after it is approved; an unconfirmed request remains a possibility rather than the baseline.
Reconcile the plan with the bank
At least once during the cycle, compare expected and posted transactions. Update dates and amounts, noting why the difference occurred. Keep the original forecast long enough to learn from the error instead of overwriting every assumption immediately.
Use the lowest uncommitted balance as one input to the borrowing decision, along with total cost and longer-term affordability. The worksheet is most useful when it makes a weak point visible early enough to choose a smaller amount, save longer or change the purchase plan.
