Check the labels and fix the rules

You will be able to find transactions with the wrong category quickly and keep your labels the same from month to month.

Priya's labelled month came back from the assistant with 87 rows, eleven of them marked CHECK (these are example figures). She sorted out the CHECK rows herself in a few minutes and thought she was finished.

CHECK is the marker the assistant puts on rows it was unsure how to label. Sorting those out does not mean the rest are correct. The assistant's other labels can be reasonable guesses and still be wrong. In a budget, a wrong label does more harm than a missing one, because it moves money into a category where it looks normal and goes unnoticed.

When Priya looked down her food column, she found her monthly payment to her mother labelled as food. The PayNow description contained the word "makan", which she had typed as a joke when she set up the transfer.

Sorting by category to find the odd row

Don't review the labelled rows in date order. Errors hide there, because each row sits among unrelated ones and nothing looks out of place. Sort the sheet by the category column instead, so similar rows are grouped together, then scan each group from top to bottom looking for the row that does not fit.

Within a group, similar things look similar, so an odd row stands out: a S$400 line among S$8 coffees and S$15 lunches, a hospital name in subscriptions, a hardware shop in groceries. Fix each wrong label as you go, directly in the category column. Once the sheet is sorted, scanning a month of rows is quick.

Four mix-ups to check every month

Some errors come up often enough that you should look for them on purpose, even if nothing jumps out during the scan.

The first is groceries and eating out. Supermarket runs get labelled as dining, and dining gets labelled as supermarket. Some supermarkets have cafes, some food courts have shop-like names, and a short merchant code does not show which counter you paid at. If you split food into groceries and eating out, check the boundary between the two.

The second is PayNow transfers labelled as other, or as any category at all. A transfer to a person shows on the statement as a PayNow transfer with the other person's name and any reference the sender typed. Since PayNow nicknames ended on 6 June 2026, the person receiving the money sees the sender's full account name, while the sender sees only selected letters of an individual recipient's registered name.

Either way, the line says who the money went to or came from, not what it was for, so the assistant has nothing to go on. Money to family, your share of a dinner bill with friends and paying back a colleague all look alike, and only you know which is which.

The third is rides labelled as food delivery, or the reverse. Some apps do both, Grab among them. Grab's own pages do not say how its card charges are labelled, and the description on your statement can be just the company name, the company name followed by a reference code, or sometimes a label that names the food service. So it does not always tell you which service you used. Amount and time of day help: a S$14 charge at 8.40am on a weekday is more likely a ride than breakfast.

The fourth is refunds treated as spending. A refund often shows the same merchant name as the purchase. If you record spending as positive, the refund should be negative, and it belongs in the same category as the purchase so the two cancel out.

Keeping transfers out of your spending

Money moving between your own accounts is not spending. If you pay your credit card bill from savings and both accounts are in your budget, the same spending is counted twice: once as the card purchases and again as the bill payment. Moving money into your own investment account or your own fixed deposit is not spending either. It is still your money, held in a different place.

Tag these rows as transfer, and leave the transfer category out of your spending totals. Lesson 2.4, "Build a month's budget from your own data", builds the budget summary so the transfer category is listed but not counted in spending.

Priya found three transfer rows labelled as other: two credit card bill payments and one top-up to her brokerage account. Together they would have added more than a thousand dollars of spending that never happened. Mislabelled transfers like these can make a first budget show someone spending more than they earn when they clearly are not.

Writing merchant rules for next month

Every correction you don't write down is one you will have to make again next month. Keep your merchant rules in a separate tab of the sheet: a short list where each rule is one plain sentence the assistant can follow. Next month, paste the rules into your request above the category list, with a line telling the assistant to apply these rules first. An assistant given explicit rules has less to guess, so your CHECK pile shrinks.

Rules need to be factual and specific to your own statement, using the wording or codes that actually appear in your export. A rule that is too broad fails. Telling the assistant that Grab is transport is wrong if you also order food through the same app, so write the code or wording that separates the two. Rules like these work:

PayNow transfers containing MAKAN or MUM are family. Ride-app lines marked as trips are transport, and that app's food orders are eating out. TOWN COUNCIL is bills. The pharmacy chain is health, not shopping.

Repeat the check each month. After two or three months, you will probably be adding few new rules.

Have your labelled sheet open with an empty tab ready for rules. You're done when every label in the month matches what the money was actually for, and the rules list is short enough to paste above next month's category list.

Sort your labelled month by category and fix every wrong label, keeping a note of each pattern you fix. Then write a short list of merchant rules to use in next month's prompt.

Course

Junxiong-WFG Organisation is an authorised representative of AIA Financial Advisers Private Limited (Reg. No. 201715016G).