Blog

YNAB Split Transactions: A Guide for Microsoft Money Users

← All posts

Key takeaways

YNAB split transactions let one payment cover several categories, so a single supermarket shop can be split between groceries, household goods and petrol without entering three transactions. This guide walks through creating, editing, unsplitting and refunding splits on desktop and mobile, and maps how YNAB's flow compares with the split categories you knew in Microsoft Money.

What Are YNAB Split Transactions and When Should You Use One?

A split transaction in YNAB is a single outflow from one account that you assign to two or more categories. The payment leaves the bank once; the budget impact lands in several places. This mirrors the split category feature in Microsoft Money, so the habit transfers directly.

The supermarket shop that spans two categories

One card payment at the supermarket might cover groceries, cleaning supplies, and cash withdrawn at the till. Entering it as one grocery figure would distort both categories. YNAB's own help documentation walks through creating, editing, and unsplitting these transactions on desktop and mobile (https://docs.ynab.com).

Splits and your 'left to spend' figures

Each part of a split reduces its own category, so what's left to budget updates correctly for every envelope you keep. That matters if you are creating and tracking to a budget across a whole household. If you are still weighing YNAB against tools closer to Money's ledger style, our comparison of a Quicken alternative covers that side by side.

How Do You Create a Split Transaction in YNAB on Desktop?

Entering the total first, then the category lines

Start as you would any transaction: type the payee and the full amount, say £84.60 for a supermarket trip. Do not assign a category yet. Instead, click the category field and choose "Split across multiple categories" from the list. YNAB then reveals a small table beneath the transaction with one row per category line.

Fill each row with a category and an amount. As you type, YNAB tracks the running total in the corner of the table and shows how much of the original £84.60 remains unassigned. You can add rows for groceries, household items and petrol in the same transaction, mirroring the split categories you built in Microsoft Money. When the lines sum exactly to the total, the split is saved with the transaction, and each category's budget column reflects its share immediately.

What happens if the split doesn't add up

YNAB will not save the transaction until the category lines balance to the penny against the total. If they fall short, the remainder sits as an unassigned amount, and YNAB flags it rather than guessing. This is stricter than Money, which let you park a difference without comment. If you would rather not chase pennies, either adjust one line or leave the remainder against a small rounding category you keep for the purpose. The same discipline applies when you later edit the split, which we cover in the mobile and editing sections. If you find the whole flow too rigid for your household records, it is worth reading our comparison at https://thriftyowl.money/white-papers/ynab-alternative before committing.

How Do You Enter YNAB Split Transactions on Mobile?

On the mobile app, enter the payee and amount first. Then tap Split (Non-Budgeted), or Split (Budgeted) if you want the categories drawn from your plan rather than left uncategorised. Add each line with its own category, amount and memo, and the app keeps a running total so you can see when the lines add up to the full transaction.

Adding a split before the receipt is to hand

You do not need the receipt in your hand. Enter the total now, tap split, and put a placeholder line against the category you expect. When the receipt turns up, edit the lines to match. This is the same habit as jotting a figure in Microsoft Money and reconciling against statements later, which is exactly what the YNAB documentation on reconciling accounts describes for keeping the app in line with your bank.

Why mobile splits are easier to fix on desktop

Editing several lines on a phone screen works, but it is fiddly. If a split needs restructuring, open the desktop app where you can see every line at once. The same applies at Thrifty Owl: we keep editing simple on small screens, but our Mint alternative white paper is easier to read on a laptop too.

How Do You Edit or Add a Category to an Existing Split?

Open the transaction and click the Edit button (or the pencil icon on mobile). The split appears as separate lines, each with its own category, payee note and amount. Change any figure, add a new line with the Add a split button, or correct a category the same way you would a plain transaction. YNAB updates the budget the moment you save, so a wrong category from last month will pull money from the wrong envelope until you fix it.

If the total of your split lines no longer matches the transaction amount, YNAB shows the difference as an unassigned remainder. Assign it to a category or adjust a line before saving.

Editing a split after you've reconciled

Reconciliation locks nothing in YNAB. You can still edit a reconciled split, but the cleared and reconciled flags stay as they were, so check the transaction again and re-reconcile to keep your balance honest. This is the same discipline as re-opening a reconciled entry in Microsoft Money, just with fewer prompts. If you are rebuilding years of Money history elsewhere, our guide to a Microsoft Money replacement covers what carries over.

How Do You Unsplit a Transaction in YNAB?

YNAB has no dedicated "unsplit" button. To collapse a split, open the transaction, delete the split lines one by one, and reassign the full amount to the single category you want. The transaction itself stays put; you are only editing its category breakdown, so nothing is lost if you keep the date, payee and amount untouched.

If you would rather not rebuild the entry, an alternative is to edit the split so one line carries the full amount and delete the rest, which achieves the same result with fewer clicks.

This differs from Microsoft Money, where split handling was similarly manual. For households still weighing whether a budgeting app can replace years of careful records, it is the same trade-off discussed in retiring a spreadsheet budget: more control, fewer shortcuts.

YNAB's own guidance on correcting entries, including refunds and returns, lives in its official documentation.

How Do You Handle a Refund Against a Split Transaction?

YNAB has no "refund against a split" button, so you record the refund as its own inflow transaction and assign it to the same category line as the original split portion. If a £60 supermarket shop was split £40 groceries / £20 household goods and the store refunds £10, enter an inflow of £10 with the category set to whichever line the refund belongs to. The refund reduces that category's spending without disturbing the other split lines.

Refund to the right category line

Match the refund to the split portion it corrects, not to the transaction as a whole. If the refund spans both categories, split the refund the same way: two inflow lines, £6.67 groceries and £3.33 household goods, for example. This keeps each category's activity accurate.

When a refund arrives weeks later

If the refund lands in a later month, assigning it to the original category still works: it reduces that month's spending in that category. If the category has no spending left that month, the refund frees the money for other purposes, which is usually what you want.

How Do Splits Affect Reconciling and Your Budget?

Reconciling a split against a bank statement

Reconciling treats a split as a single transaction, exactly as your statement does. The statement shows one debit from the shop; YNAB shows one transaction with a split icon, and you tick it off as a whole. You never reconcile the individual category lines, only the parent amount. If you import transactions rather than enter them by hand, YNAB matches an imported split against the split you already recorded, so you are not left with duplicates. The YNAB import documentation covers how imported transactions are matched to existing entries.

Overspending on one line of a split

Each line of a split hits its own category budget separately, which is where the discipline shows. If the £60 shop splits into £45 for groceries and £15 for household goods, each category is reduced by its own share. If groceries had only £40 left, that category shows £5 of overspending even though the transaction as a whole cleared. YNAB then asks you to cover it from another category, the same way it would for any single-category overspend.

Coming From Microsoft Money: How Do YNAB Splits Compare?

What Money did that YNAB doesn't

Money, like ThriftyOwl let you split a transaction into dozens of category lines, assign each line its own memo, and see the running split total as you typed. YNAB caps splits at the transaction amount, offers one memo per split line, and gives no running total while you enter them. Money also let a single split span transfers between accounts, which YNAB handles differently: transfers are their own transaction type and cannot be a category line within a split.

Where the habits carry over well: reconciling works the same way, and category lines in a split update your budget the moment you approve the transaction. Where it falls short: Money's split editing let you change one line without re-entering the rest, while YNAB's editing is closer to re-doing the split.

Running Thrifty Owl through the same test

Habit YNAB Thrifty Owl
Split a transaction by category Yes Yes
Per-line memos Yes Yes
Running total while entering No Yes
Budget rollover per category Yes Yes

Honest gap: Thrifty Owl has no mobile app today, and its bank importing is file-based rather than a live connection, so entering splits means importing a statement first. If you reconcile against statements weekly, that trade is manageable; if you want balances on your phone, it isn't.

FAQ

Why can't I see the split option in the YNAB mobile app?

The split control only appears after you have entered a payee and an amount. If either field is empty, YNAB hides the option. You should see Split (Non-Budgeted) or Split (Budgeted) once the total is in. If it still doesn't appear, check you are editing a transaction rather than viewing a reconciled one, and confirm the app is updated.

How do I delete one line of a split without deleting the whole transaction in YNAB?

Open the transaction and click Edit, or tap the pencil icon on mobile. Delete the individual split line you no longer want, then adjust the remaining lines so they add up to the transaction total. YNAB will not save while an unassigned remainder is left over. The parent transaction, with its date, payee and amount, stays intact throughout.

Does YNAB let you save a split as a recurring template, like a standing order split across bills?

Yes, indirectly. Create the split transaction once, then set it to repeat by choosing a recurrence pattern, and YNAB will generate the same split, with all its category lines and amounts, on schedule. This suits standing orders such as a combined council tax and water payment. Edit the original scheduled transaction and future occurrences update with the corrected lines.

Can I import split transactions from a QIF file into YNAB?

Not reliably. YNAB's importers work with OFX, QFX and CSV files, and imported transactions generally arrive as single entries without category breakdowns, so any split detail in a QIF export from Microsoft Money is lost. The practical route is importing the transaction totals, then re-entering the splits by hand. Budget time for that if you are migrating years of Money records.