
▶













▶Money arrives weekly. Bills arrive monthly. This works out what has to come out of this check.
If you are paid every week, your money arrives on a weekly rhythm and your bills arrive on a monthly one. That mismatch is not a budgeting mistake. It is a timing problem, and no monthly planner can see it.
If you are paid every week, your money arrives on a weekly rhythm and your bills arrive on a monthly one. That mismatch is not a budgeting mistake. It is a timing problem, and no monthly planner can see it.
Every weekly template on the shelf hands you a seven-day grid. This one does the subtraction instead: twelve months of your bills divided by the number of paydays in your year gives one figure to hold back out of every single check, the same every week whatever the month is doing. In the shipped sample that figure is $491 and $189 is left over. The Week Map then walks all fifty-three pay weeks of 2027, drops each bill into the week its due date actually falls in, and gives every week a verdict. Week one carries $1,239 of bills against one $680 check.
Twelve months of bills divided by the paydays in your year. It does not move when the month does and it does not move when your hours do, because it is a share of your bills rather than a share of your check. In the sample it is $491, and the $189 left over is genuinely yours: nothing on this file asks you to account for it.
A month can balance to the dollar and still have a week in it where the money is not there yet. The Week Map walks every pay week of the year, drops each bill into the week its due date actually falls in, handles the weeks that straddle two months, and marks each one Clear, Tight or Short.
The one number no monthly budget can give you. The map walks the reserve from zero and reports the deepest point it ever reaches: $1,429.89 in the sample. Start the year with that in the bills account and every one of the fifty-three weeks clears. Start with less and the Reserve Plan lists the weeks that fail, by date, with the amount to put aside each week between now and then.
Mark power, water or anything seasonal as varying and it plans at the highest of the last three months. An average is the number that makes a hot August fail. The extra sits in the reserve in the months the bill behaves, which is most of them.
Month by Month shows what five-payday months really do: in the sample each one puts $287 into the reserve while each four-payday month takes $204 out, and the whole year nets to $7. That last figure near zero is how you know the hold-back is sized right.
A whole tab writes out every formula in the file in plain English. No macros, no add-ons, no bank connection and no login. Nothing here reads your computer's clock unless you type =TODAY() into one cell, so the worked sample reads the same forever.
Open Setup and type the first payday of the year you are planning, what you take home in a normal check, and today's date. The file counts the paydays in that year for you.
One row per bill, with the day the money actually leaves your account and whether it moves around. Ten sample rows are already there to type over.
Back on Setup, two figures: what to hold back out of every check and what is left for you. That is the answer this file exists to give.
Anything listed there is a week the money does not reach in time. Each row carries the amount to set aside per week between now and then.
Optional, and worth doing. Type what actually landed and the file shows the drift against plan before it becomes a problem.
The shelf sells weekly budgets as seven-day grids and paycheck budgets as biweekly planners. Neither answers the question a weekly payday actually asks, which is what has to come out of this check for a monthly bill cycle to survive. This file answers it with one number, proves the number is right by walking all fifty-odd weeks of the year, and then names the weeks it does not cover yet.
As soon as your order is complete you get instant access to download the ZIP: the workbook in four color editions, the three-color bundle, a two-page Quick-Start PDF and a START-HERE file.
One ZIP, instant download. Portable formulas only — no macros, no add-ons, no account and nothing to cancel. Opens in Microsoft Excel (2016 or later, Mac or PC) and Google Sheets; to use Sheets, upload the .xlsx to Drive and open it with Sheets. Apple Numbers opens it too. The four colorways are the same workbook: pick one and stay in it.
Then this is the wrong file and the Paycheck Budget Spreadsheet is the right one. This workbook is built for a weekly payday and its whole method turns on the number of paydays in your year.
Yes. Every formula is portable. Upload the .xlsx to Google Drive and open it with Sheets; formulas and dropdowns carry over.
No. Nothing here reads an account, asks for a login or sends anything anywhere. You type the numbers.
Yes. It counts the paydays in whatever year you start it in, which is fifty-two most years and fifty-three whenever January 1 and December 31 fall on the same weekday.
For personal use. A budgeting and record-keeping tool that calculates from the numbers you enter; not financial, tax or accounting advice. The workbook ships with an invented worked sample so every tab has something in it; delete it and type your own. A reserve that clears every week on this file still needs the money to actually be in the account.