A household budget book without connecting your bank: importing statements and keeping fixed costs under control

A household budget book (in German Haushaltsbuch, a running record of what a household spends) has a bad reputation. It sounds like receipts in a shoebox, spreadsheets abandoned by March and evenings spent typing in amounts to the cent. Many modern finance apps therefore promise the opposite: connect your account, done, everything runs automatically. That works, but not everyone wants to give an app access to their bank account.

This article is for everyone who wants an overview of their money without setting up a bank connection. It shows why that is a sensible approach, which methods have proved themselves, how to separate fixed costs from variable spending and what a monthly routine looks like that fits into a quarter of an hour.

Why some people don't want a bank connection

A bank connection, often under the heading of open banking, works like this: you give a service permission to fetch your account transactions from the bank. That is regulated and in many cases implemented securely. Still, there are good reasons to do without it:

• Fewer parties involved. With a connection, there is often another service provider between the bank and the app. Every additional party is one more place where your transactions are stored.
• Joint accounts. With a joint account you don't decide alone. Not every partner wants their own spending to land in an app automatically.
• Control over timing. If you decide yourself when transactions go into your budget book, you look more consciously. For many people that look is the real benefit of keeping one.
• Constant renewal. Permission to access an account has to be confirmed regularly. If you forget, you get gaps, and often only notice weeks later.

Without a bank connection does not mean without bank data. It just means you fetch it yourself, when you want.

Three methods that work without account access

1. Recording by hand

The classic: every expense is entered, ideally straight after paying. That sounds like a lot of work, but it has an advantage no automation offers: you notice immediately what the money goes on. Someone who quickly types "chemist, €23.40" into their phone in the shop often decides differently next time.

Recording by hand works well for cash, for small households and for anyone who wants to change their spending habits consciously. It fails when everyday life gets busy and entries pile up.

2. Importing your bank statement as a file

Almost every bank offers an export of transactions in online banking, usually as a CSV file, often also as XML in CAMT format or as an Excel spreadsheet. You download this file and read it into your budget book. The advantage: you have all account movements in full without typing a single amount, and still nobody but you has access to your account.

An import should be able to do two things if it is really going to save work: recognise duplicates in case you read in the same period twice, and not count transfers between your own accounts as spending. Otherwise the overview is quickly distorted.

3. The mix

In practice most people end up with a combination: the current account comes in once a month as a file, and cash and spending from other accounts is added by hand. That way everything is complete and the manual work stays small.

Separating fixed costs and variable spending

The most important step towards a useful budget book is not a method but a distinction. There are two kinds of spending, and they need different attention.

Fixed costs are the amounts that go out regularly and usually automatically: rent, electricity, insurance, mobile phone contract, streaming, Kita fees (nursery or day care). Here you don't decide anew each month but once, when you sign the contract, and then again when a notice period approaches. The right question for fixed costs is therefore not "How much did I spend?" but "Which contracts are running, and when can I change them?".

Annual and quarterly payments are a stumbling block. Car insurance in January, home contents insurance in March: in those months the budget book looks dreadful, in the others too good. There are two ways to handle it:

• Smoothed: you convert every contract to a monthly amount. An annual bill of €600 counts as €50 a month. That shows what a month really costs you on average.
• By due date: you count the bill in the month it is due. That shows when money actually goes out, which matters for the question of whether there is enough in the account in January.

It is best to look at both. If you know your annual payments, you can set money aside for them each month and get no nasty surprise in January.

Variable spending is everything else: groceries, toiletries, clothes, outings, presents. Here you decide afresh each month, and this is where a budget pays off.

Budgets: few, but honest

A budget is a monthly limit for a category, for example €700 for groceries. It only works if it is realistic. So set your first budgets not by what you wish but by the figures of the last two or three months. If you spend €850 on groceries on average and aim for €600, you will give up after two months.

Three rules that have proved themselves:

• Few categories. Eight to twelve are enough for most families. Every extra category is one more decision when recording.
• Budgets only for variable spending. Fixed costs run through contracts, not monthly limits.
• Allow a carry-over. If you stay €50 under budget in October, you may use it in November, and the other way round. That way fluctuating months even out without every outlier looking like a failure.

The monthly routine in 15 minutes

A budget book rarely fails because of the method and almost always because of regularity. A fixed date helps, for example the first Sunday of the month. This is what it can look like:

1. Minutes 1–3: download and import the bank statement. For every account you track, the export for the previous month.
2. Minutes 4–7: check and assign. Are the categories right? Have transfers and duplicates been recognised correctly? New payees get a category once, which then fits automatically next time.
3. Minutes 8–9: add cash and anything missing. Whatever is not on the statement is added by hand.
4. Minutes 10–12: look at the budgets. Where were you over, where under? Was there a reason (a birthday, a school trip) or is the budget unrealistic?
5. Minutes 13–14: keep an eye on contracts. Does a notice period run out in the next few weeks? Is an annual bill coming?
6. Minute 15: one decision. Just one: cancel a subscription, adjust a budget, set aside an amount for the next annual bill.

The last step is the most important. A budget book that never leads to a decision is an archive. One that triggers a small decision every month changes something noticeably over a year.

A month in everyday life

A couple with two children have a joint account for the household and fixed costs and an account each of their own. On the first Sunday of the month, one of them spends ten minutes at the laptop, downloads the statement for the joint account and imports it. Most lines are assigned automatically because the payees are already known. Only their daughter's sports club is new; it gets the category "Leisure" once.

Looking at the budgets, they notice that groceries were over the limit for the third month running. Instead of getting annoyed, the couple raises the budget to an honest figure and takes a closer look at meals; the article on the meal plan fits well here. Among the contracts, a notice period for the mobile phone contract comes up in five weeks. That is the decision of the month: compare and switch. Their own accounts stay private and do not appear in the shared overview.

How patchio helps with your budget book

patchio has no bank connection and fetches nothing automatically from your bank. Instead, the import in the finances area reads your bank statements as CSV, XML (CAMT) or Excel files. The file is only read in your browser and not uploaded. patchio recognises Sparkasse, N26 and Revolut automatically; for other banks you map the columns once and patchio remembers this as a template. Before anything is taken over, you see every line in a review view: duplicates and transfers between your accounts are recognised, payments for stored contracts are assigned to the contract, and category corrections can be saved as a rule for future imports. An import can be undone completely.

Alongside that, you can record expenses by hand at any time. Contracts with notice periods remind you in good time before the last day to cancel, and the analysis shows fixed costs either smoothed or by due date. Budgets for variable categories show a traffic light at 80 and 100 per cent and can carry what is left over into the next month. With an opening balance per account you see the current balance, and savings goals with a monthly contribution help you put money aside for annual bills. Accounts are private by default.

Conclusion

A budget book does not need account access; it needs a routine. Download your bank statements once a month, separate fixed costs from variable spending, set a few honest budgets and make one single decision each month. That takes a quarter of an hour, and you stay in control of who sees your transactions.