Payment Calendar Template
A payment calendar lists every expected receipt and payment on the date it actually lands, then carries the balance forward day by day. It answers the one question a monthly budget cannot: on which specific date does the account run dry?
A month can close in surplus and still contain a Tuesday that breaks you. Payroll clears on the 10th, the quarterly VAT payment on the 20th, and the client who covers both pays on the 28th. Totalled over the month everything balances; lived day by day there are eighteen days with a hole in them. The running balance column is the entire point of this sheet — it is the only thing in your reporting that shows that hole in advance.
Each line takes a date, a counterparty, an amount and a confidence level. Keep confirmed payments separate from expected ones: a signed invoice with agreed terms and a verbal promise are not the same input, and mixing them is how a calendar quietly becomes fiction. The template totals both separately, so you can read the worst case (confirmed only) and the planned case side by side.
Used properly this is a weekly ritual, not a document. Fifteen minutes every Monday: move what actually happened into the actual column, extend the horizon by a week, and look at the first day the balance turns red. If there is one, you have a choice of levers while they are still cheap — move a supplier payment three days, pull a prepayment forward, draw on the credit line deliberately rather than by accident.
The maintenance is what kills most payment calendars: re-typing bank movements every Monday is tedious, and a calendar nobody updates is worse than none. Finmap builds the same view from the bank data it already pulls in, so the plan sits next to the facts without anyone re-keying them.
