To make a budget from bank statements, collect the last three months of statements for every account and card you pay from, put all the transactions in one spreadsheet, and give each row a category. Then average each category across the three months. That average, adjusted for anything you know is changing, becomes next month's limit.
Which bank statements does a first budget need?
A first budget needs three full months of statements from every account that money leaves: checking, each credit card, and any savings account you spend from directly. Three months is long enough to catch bills that do not land every month and short enough to sort in one evening.
One month is too thin. A single statement can miss your car insurance, a quarterly water bill, or a month with no birthdays in it, and the budget built from it will be too low in exactly the places that hurt later. Twelve months is better data, but sorting a year of rows by hand is a weekend project, and most people quit before they finish. Three months is the compromise that gets a working budget on the table tonight. You can widen it later.
Pick full calendar months if you can. Most bank statements run on a cycle that does not match the calendar, so a statement dated the 18th covers half of one month and half of the next. That is fine for a budget, as long as you use three consecutive cycles and do not leave a gap between them. Write down the first and last date of each period so you can see the coverage at a glance.
If the current month matters, because you just changed jobs or moved, you do not have to wait for the statement to close. Many banks let you print the transactions so far, and what an interim bank statement is and how to request one explains how to get those rows mid-cycle.
Accounts people forget to include
Look for these before you start, because each one hides spending:
- A store card or buy-now-pay-later plan with its own statement.
- A second checking account used only for bills.
- A partner's card that pays for shared groceries.
- A PayPal or similar wallet balance that you spend from.
Leaving one out makes the budget look tidy and wrong at the same time.
Getting statement rows into one budget sheet
Statement rows reach a budget sheet in one of three ways: a CSV download from online banking, a PDF converted to a spreadsheet, or typing. Use the download where the bank offers it for the months you need. Use conversion for PDFs. Type only when the statement is very short.
Start with your bank's website or app. Many banks offer a transaction export in CSV or a spreadsheet format, though some limit how far back it goes. If the export covers all three months, take it, because it is the cleanest data you will get.
When all you have is the PDF statement, copying from the PDF viewer usually breaks columns apart, and typing a busy month takes longer than the rest of the evening combined. A converter does this step for you. CheapBankConvert, which is getting ready to open, turns a PDF statement into a CSV with date, description, amount and balance columns, or an .xlsx file with amounts stored as numbers. It shows the first 2 pages free before you pay, and at early pricing a statement of up to 10 pages costs $2.99, so three months is under $9. See the CheapBankConvert homepage for the current prices.
One layout for every account
However the rows arrive, paste them into a single sheet with the same five columns:
| Column | What goes in it | Example value |
|---|---|---|
| Date | The posting date from the statement | 2026-08-14 |
| Account | A short name for the account or card | Visa |
| Description | The merchant text as printed | TRADER JOES #552 |
| Amount | Money out as negative, money in as positive | -86.40 |
| Category | Left blank until the next step |
Credit card statements usually show purchases as positive numbers, which is the opposite of a checking account. Flip their sign when you paste, so that every outflow in the sheet is negative. If you skip this, card spending will be added to your income in the totals.
If you would rather not build the layout yourself, a free budget spreadsheet template that takes statement rows gives you these columns and the summary tab already set up.
Sorting statement transactions into budget categories
Sorting statement transactions means giving each row one budget category, such as groceries, rent or fuel. Start with ten to fifteen categories, sort the sheet by description so repeat merchants sit together, and fill a whole block of identical merchants at once. Most rows fall into a few large groups.
A short list beats a long one on a first budget. Twelve categories that you actually use tell you more than forty that each hold two rows. A sensible starting set looks like this: housing, utilities, groceries, eating out, transport, insurance, health, subscriptions, shopping, kids, gifts, and other. Add one only when "other" grows large enough to bother you.
Sorting by the description column is the trick that makes this fast. Every grocery run at the same store lines up in one block, so you type "Groceries" once and fill it down. A month with 120 rows often has only 30 or 40 distinct merchants. After the big blocks are done, sort by amount to find the large one-off items, which are the rows that matter most.
Some descriptions are cryptic. A string like "SQ *BLUE DOOR 0912" is a small business taking card payments through a processor. If you cannot place a row within a few seconds, put it in "other" and move on. One unknown $14 charge will not change your budget, and stopping to research it breaks the evening.
For the formulas that take the typing out of this, such as matching merchant names against a lookup list, categorizing bank transactions in Excel with rules walks through a reusable setup. You will want it next month, when the same merchants come back.
Income rows
Give income its own categories: salary, side work, refunds, interest. Keep them separate from spending so the totals on each side stay clean. A refund is the one income row that really belongs to spending, and it is better netted against the category it came from than counted as earnings.
How do you set budget limits from three months of spending?
Set each budget limit by adding up three months of spending in that category and dividing by three. Then adjust the result by hand: lower it where you want to cut, raise it where a known cost is coming, and round to a number you will remember. The average describes your past; the limit is a decision.
A pivot table or a simple total per category per month gives you the raw numbers. Here is a worked example for one household. The figures are made up for illustration.
| Category (example) | June | July | August | 3-month average | Limit set |
|---|---|---|---|---|---|
| Groceries | 612.30 | 588.10 | 655.45 | 618.62 | 620 |
| Eating out | 241.00 | 310.75 | 198.20 | 249.98 | 200 |
| Fuel | 162.40 | 171.90 | 149.30 | 161.20 | 165 |
| Subscriptions | 68.97 | 68.97 | 83.96 | 73.97 | 60 |
| Car insurance | 0.00 | 438.00 | 0.00 | 146.00 | 73 |
| Gifts | 35.00 | 0.00 | 120.00 | 51.67 | 50 |
Read the table row by row. Groceries are steady, so the limit stays close to the average. Eating out is the household's chosen cut, so the limit drops by fifty dollars. The subscriptions limit is lower than the average because one service is being cancelled. Car insurance shows why three months beats one: it landed once, in July, and a single June statement would have missed it. The premium covers six months, so the limit is $438 divided by six, $73 a month, set aside so the next bill is already covered.
Limits for bills that do not come monthly
Insurance, car registration and annual memberships are the lines that break budgets. Average them over the months they cover, not the months you happened to sort. A $438 premium paid every six months is $73 a month, not the $146 a three-month average suggests, so check the policy before you divide. Put that monthly amount aside, even in the months the bill does not arrive.
Statement budget mistake: counting card payments and transfers twice
The most common error in a budget built from statements is counting the same money twice. When you pay a credit card from checking, the checking statement shows the payment and the card statement shows every purchase it covered. Include both and your spending looks roughly double what it really is.
The fix is a category that the totals ignore. Call it "Transfer" and give it to every row that moves money between your own accounts:
- The credit card payment on the checking statement.
- The matching "payment received" line on the card statement.
- Moves from checking to savings and back.
- Top-ups to a wallet that you then spend from.
Keep the purchases on the card statement, because those are the real spending with real merchants. Then make sure your summary formula skips the Transfer category, so it never reaches a total.
A quick test tells you whether you caught them all. Add up every Transfer row across all accounts. If the transfers only move money between your own accounts, they should net to roughly zero, apart from timing at the edges of the three months. A large positive or negative remainder means a transfer is missing its other half, usually because one account's statement was left out.
When not to trust the averages
Averages mislead when one of the three months was unusual. A month with a holiday, a car repair or a medical bill will lift the average for that category. Do not throw the row out; mark it as one-off and set the limit from the other two months. Then add a separate line for repairs or irregular costs, because some unusual expense tends to turn up most months, even if it is a different one each time.
An evening timetable for a statement-based budget
A statement-based budget fits into one evening of about three hours if you keep each step to a time box and stop researching individual rows. Gathering and converting statements takes the first hour. Sorting takes the second. Totals, limits and a sanity check fill the third.
Here is the timetable, step by step:
- First 20 minutes: download or locate three months of statements for every account and card. List the accounts on a sticky note so none is skipped.
- Next 40 minutes: get the rows into one sheet with the five columns. Flip the sign on card purchases. Check that each account's first and last dates match its statement period.
- Next 60 minutes: sort by description and categorize in blocks. Mark transfers. Leave anything unclear in "other".
- Next 30 minutes: total each category for each month, then average the three months.
- Next 20 minutes: set a limit for every category, adjust the one-off months, and spread irregular bills.
- Last 10 minutes: compare the total of the limits with your monthly take-home pay. If the limits come to more, cut the categories you control first.
That last step is the moment the sheet becomes a budget. Until then it is a record of what happened. Once the limits fit inside your income, you have a plan for next month, and the same sheet will take its rows when the next statement arrives.