How to Use This Tool
- Upload your statements (CSV or PDF).
- Check and categorise the transactions. Many will be categorised automatically, by recognising earlier transactions or by rules set in Settings.
- If you use the Fawnly budget planner, copy the rows and paste them into the planner's Transactions tab. You can also export them to .xlsx for your own records.
- Visualise your spending.
- See your savings and net worth. Input your account balances if they are not on your statements, add any of your assets (and whether they appreciate or depreciate), add liabilities, and your savings, bonds, investments and pensions.
- Check your regular payments for price rises or forgotten subscriptions.
- Check for money coming into your account that is not income - e.g. insurance, refunds and friends or family paying you back for shared costs.
- To make sure your statements cover everything, check that every month you are analysing has a tick. A ✗ means no statement has been uploaded for that period yet.
You can set up categories and sub-categories in the "Your Categories & Sub-categories" dropdown, and add your accounts in the "Settings and Account Details" dropdown.
Your Categories & Sub-categories
If using the Fawnly budget planner these labels must match. Type over a name to rename it, ✕ to remove, or type in "+ add" and press Enter.
Settings and Account Details
Show
Changes steps 4 to 8 - spending, savings, regular payments, refunds and statements.
Names
If using other Fawnly products alongside this ensure that the names match. Children and Pets are optional tags (See FAQs). If more than one pet or child separate names with a comma.
Your Planner
Optional. Upload your budget planner .xlsx to automatically import categories and accounts and learn rules from prior categorised transactions.
Back Up & Restore
Everything is kept in this browser only. Save a back-up now and then.
Start Again
Reset keeps what you've imported; Delete removes everything this tool has saved in your browser.
Accounts
"Recognise by" = text that appears in that account's statements (account name or card number), so the account can be auto-selected.
| Colour | Account | Bank | Whose | Type | Business account? | Overdraft / credit limit | Recognise by (comma separated) |
|---|
Your Rules
Rules help automatically categorise transactions; you can also tick "Rule" in step 2 during import.
| If description contains | Money | Type | Sub-category | For | Bus. | Account from / to | Source |
|---|
1 Import Bank Statements
Use CSV for increased accuracy.
Cash
Alternatively log your cash income and expenditure in a CSV.
2 Categorise Transactions
Picking a sub-category for an expense or income automatically categorises payments from the same merchant. Tick "Rule" to auto-categorise future bank statements. Click × at the start of a row to delete it (it moves to Deleted - click + there to bring it back).
| Date | Account | Amount | Description | Type | Category | Sub-category | For | Child / pet | Bus. | Account from / to | Status | Rule |
|---|
3 Send to the Planner
Send to the Fawnly Family Budget Planner.
4 Your Spending Premium
Monthly Spending and Income
5 Savings and Net Worth
Balances update from your bank statements when visible. Add your home and vehicles under Assets, mortgages or loans under Liabilities, and savings, bonds and pensions under Savings, Bonds, Investments and Pensions.
Net Worth Month by Month
Account Balances Month by Month
Accounts
Assets
Liabilities
Savings, Bonds, Investments and Pensions
6 Regular Payments
Bills, subscriptions and other regular payments found from your statements. ▲ = the latest payment is more than usual.
Payments Calendar
7 Refunds and Paybacks
Money paid back to you that is not classified as income. Insurance payouts, refunds and friends/family.
8 Statements So Far
Frequently Asked Questions
Are my bank statements uploaded anywhere?
No. The file runs entirely in your web browser. Statements are read on your computer and nothing is sent to Fawnly or anyone else. Your settings and rules are saved in this browser only - use Settings › Back up to keep a copy.
Which banks and file types work?
CSV exports from most UK banks (Starling, Monzo, TSB, Santander, Barclays, HSBC, Lloyds, Nationwide, NatWest, first direct and more) and PDF statements. PDFs are read line by line, so check the amounts on anything that looks odd. CSV is the most reliable.
Why does it ask whose account it is?
So it knows who paid. A payment from a joint account is assumed to be for the household; one from your own account is assumed to be for you - you can change "For" on any row.
How do I track spending on each child or pet?
There are two ways, and you can mix them.
1. The Child / pet tag (recommended). Add their names in step 1 and keep normal sub-categories (Nursery, Vet bills, Dog food). Each payment then also says who it was for, in the Child / pet column. You can see both what the money went on and who it was for.
2. A sub-category named after them (for example "Biscuit"). Simpler, but everything for them sits in one sub-category, so you can't see what it went on.
Either way, if a sub-category has the same name as a child or pet in step 1, its payments are tagged to them automatically, so the Children & Pets section in step 4 and the totals on your planner's Setup tab count both. Using both is fine - each payment is only counted once.
How are refunds and insurance payouts shown?
Money coming back for something you bought - in step 2 set its Type to Refund or credit, Insurance payout or Paid back (a friend or family member paying you back) instead of Income, and give it the sub-category it was spent on (e.g. Vet bills). It's then taken off that spending rather than counted as income, and shows in step 7 under that type. In step 4, the Refunds buttons at the top choose where it counts: When paid back (the month the money arrived - matches your bank balance) or Against the payment (the month of what it refunds - each month's true cost). Refunds are matched automatically when it's clear (same shop and sub-category, within 4 months). For anything else - like an insurance payout covering several vet bills - click Refund for… in step 2, or click it in step 7 (Refunds and Paybacks), and tick the payments it pays back. Your planner always uses the month the money arrived.
How does it decide the category?
In this order: rules you set in Settings; what has been categorised before, including from any planner imports; then built-in rules for common UK shops, bills and services (supermarkets, fuel, energy and water companies, streaming, cafés, holidays). Payments abroad or with a foreign exchange fee are suggested as holiday spending, and council tax is spotted from the council's name and the band amounts. Anything that can't be categorised automatically goes into "To categorise" in step 2.
How do I add or change a rule?
Tick "Rule" on any row in step 2, or open Settings and Account Details › Your Rules.
Will the same transaction be imported twice?
If a transaction is uploaded twice in overlapping statements, it is flagged as a duplicate and not imported. Statements uploaded on a later day are checked too, as long as you clicked "Mark as imported" after sending the earlier ones (or loaded your planner in Settings).
How are transfers between our own accounts recognised?
When money leaves one of your accounts and the same amount arrives in another within 4 days, they're paired up automatically. The paying side is labelled "Transfer sent" and becomes one Transfer row (Joint top-up, Money to partner, Credit card repayment, Between own accounts or Savings); the other side is labelled "Transfer received" and left out, so it's only logged once. Transfers you've already sent - or that are already in your planner - are remembered, so the other side is still recognised when you import that account another day. Transfers never count as spending.
How do business costs work?
Tick Bus. on a row, or tick "Business account" for an account in Settings so everything from it counts. In step 4, Options › "Count business costs separately" keeps them out of your household and personal figures and shows them in their own pie chart and box instead.
What does a ✗ in "Statements So Far" mean?
No statement you've added covers those dates yet. Usually that's a missing statement, but it can also be an account with no payments that month - click the ✗ to mark it as a quiet month.
How are regular payments found?
Payments to the same place at a steady interval (weekly to yearly) are grouped together. If the amount changes and stays changed, it's shown as a price rise or drop. If a payment doesn't arrive when expected, it moves to "Stopped / cancelled / missed". Use ✓, ⊘ and ✕ to correct it - it learns from you.
Why is something I buy now and then listed as a regular payment?
If you buy from the same place on a fairly regular pattern (e.g. Kindle books), it can look like a subscription. Click ✕ and it moves to "Not regular payments", so it is no longer counted as a regular payment.
How is "Spent" worked out in step 4?
It adds up every expense. Transfers between your own accounts and into savings are not counted, and refunds are accounted for.
Where do the balances in Savings and Net Worth come from?
From your statements: every balance a statement shows is kept in that account's Balance Log, so the history builds up as you add more. If a statement doesn't show a balance (Monzo CSVs don't), add one by hand - it goes in the log too. Homes, vehicles and other things use their value and yearly change; mortgages and loans what is still owed.
What does "likely yearly" mean in Regular Payments?
A payment seen only once so far that looks like a yearly bill - insurance, a TV licence, a membership. Tick ✓ if it is one, ✕ if not. Once a second year of statements shows it again, the "likely" goes.
How do the filters at the top of step 4 work?
Tick any mix of accounts, people and categories - everything in step 4 follows them (the boxes, the graph, the pie charts, Full Breakdown and Spending Patterns). Nothing ticked means all. The category filter narrows spending only; money in still follows the account and person filters.
How are mortgages and loans worked out?
Repayment mortgage or loan: each payment covers that month's interest and pays off some of what you borrowed, so what you owe falls to £0 by the end of the term.
Interest-only mortgage: the payment is just the interest (borrowed × rate ÷ 12). What you borrowed stays the same and is all due at the end of the term.
Payment / month: leave it blank and it's worked out from Borrowed, Term and Interest %. Type your real payment if it's different (e.g. you overpay).
Still owed (statement): if your rate has changed, you've remortgaged or overpaid, type the balance from your latest statement and its date. It's used from that date on instead of the worked-out figure.
Paid from: the sub-category your payments are logged under (e.g. Mortgage). Paid this year adds up those payments from your statements so you can check them against what's expected.
Equity = what your home is worth now minus what's still owed on mortgages - the part of the home you own.
Do I need the Fawnly Family Budget Planner?
No - you can use the analyser on its own.
Private by design: your statements and all data stay in this browser on your device - nothing is ever uploaded to a server. Clear it any time with "Delete all my data" in Settings, or by clearing this site's data in your browser. This tool is for personal budgeting and is general information, not financial advice.