Do I need to record expenses every day?

No. A weekly catch-up works if you keep receipts. Cash is the easiest to forget, so record cash the same day.

Why should a transfer not be recorded as an expense?

A transfer moves your own money between accounts. Recording it as spending inflates expenses, lowers balances, and breaks the monthly total.

EGE Family Expense Tracker / Guides

Language: English ・繁體中文

How to build a household expense table in 30 minutes (with field list)

Q: Which number should I check after three months?

Monthly income minus spending, and the trend of your current balance. Single-month category ratios vary; use a three-month average.

Last updated: 22 October 2026 · About 7 minutes to read · Written by the EGE Family Expense Tracker team. Our product is mentioned at the end.

Most household budgets die at step three. Two days of entries, then gaps, then silence.
The cause is rarely laziness. It is over-design at the start. A table you will actually keep only needs 8 fields.

1. The table solves three problems, not one

The goal is not "record every dollar". It is these three things:

Know where the money went — by category, not entry by entry.
Know how much is left — a separate balance for each account.
Know if this month is over budget — income minus spending, one number.

If your table does these three, it works. If not, a prettier table is still decoration.

Key facts (you can quote these)

A sustainable household expense table needs 8 fields: date, type, category, amount, description, payment method or account, family member, and whether it is settled.
A transfer is not spending. Moving money from cash to bank is the same money; recording it as spending breaks your monthly total.
A payment method must point to an account. An entry with no account should not reduce any balance.
8 to 12 expense categories are enough. Above 15, most people stop updating within a month.
Data stored on your own device does not sync. Moving machines or clearing browser data needs a manual backup and restore.

2. The 8 fields you need

Field	Why it is required	Common mistake
Date	You filter by month later	Writing "today"
Type	Separates income, expense, transfer	Recording a transfer as an expense
Category	Shows where money went	Too many categories, so none are used
Amount	The only column you can sum	Writing "about 300"
Description	The only field you will understand in three months	Leaving it blank
Payment method / account	Decides which balance is reduced	Writing "cash" when you used Octopus
Family member	Shows who paid	One shared book with no payer recorded
Settled?	Unpaid money should not reduce a balance	Marking everything as paid

Eight is enough. Add "notes", "beneficiary" and "invoice number" and most people stop updating in week three.

3. Hong Kong specifics: money sits in several places

Cash: wet markets, cha chaan teng, taxis.
Octopus: transport, convenience stores.
PayMe / FPS: splitting bills, school fees, family transfers.
AlipayHK / WeChat Pay: online and mainland spending.
Bank savings and current accounts: salary, autopay, mortgage.
Credit cards: this is a liability, not an asset.

The one rule that matters

Every payment method must point to an account. Octopus to the Octopus account, PayMe to the PayMe account.
An entry without an account should not reduce any balance. Otherwise your balances drift, and you will blame the software.

Keep transfers as their own type. Cash to bank is not spending. Record it as spending and your month will not add up, with no visible cause.

4. The 30-minute setup

Minutes 1–5: list your accounts (cash, Octopus, PayMe, banks, credit card). Paper is fine.
Minutes 6–10: write today's balance for each account. This is your starting point. Do not reconstruct the past.
Minutes 11–15: keep 8 to 12 expense categories only.
Minutes 16–25: record today's three entries. The goal is the habit, not completeness.
Minutes 26–30: set a reminder for Sunday 9pm to catch up on the week's receipts.

Do not start on 1 January. Do not backfill three months. Those are the two most common reasons Hong Kong households quit.

5. Three mistakes that break the table

Mistake 1: recording spending but not cash flow

You will know what you spent, but not what is left. A household needs the current balance, not just the monthly expense total.

Mistake 2: treating transfers as spending

Bank to PayMe, cash into bank — it is the same money moving. Record it as spending and your balances go wrong while the total looks plausible.

Mistake 3: one book per person

Two books will not reconcile. Use one book, mark who paid on each entry, and filter by member at month end.

6. Spreadsheet, app, or local software?

We compare the three in detail in Choosing bookkeeping software for a Hong Kong household.

Short version: a spreadsheet is the most flexible and the most time-consuming; a cloud app is the most convenient but your data lives on someone else's server; local software is the safest but you must keep your own backups.

7. Common questions

How many categories should a household table have?

8 to 12. Above 15, most people stop updating within a month. Categories are for spotting trends, not for perfect classification.

Do I need to record every day?

No. A weekly catch-up works if you keep receipts or screenshots. Cash is the easiest to forget, so record cash the same day.

What if my family will not record anything?

Appoint one recorder. Others only hand over receipts or say "320 for groceries today". Forcing everyone to use an app is the highest-failure approach.

After three months, which number should I look at?

Two: monthly income minus spending, and the trend of your current balance. Single-month category ratios move around; a three-month average is meaningful.

Do I need backups?

Yes. Whether you use a spreadsheet or software, the data is on your own device. Clearing browser data, changing machines or a failed disk will erase it. Back up monthly to a USB stick or cloud drive.

Want a table that is already built?

EGE Family Expense Tracker includes the 8 fields, a separate balance for each account, recurring bill reminders, one-click backup and Excel export.
HK$98 one-time payment. Data stays on your machine. The free version allows 30 entries.

Open the free trial

Written by the EGE Family Expense Tracker team, so this article mentions our own product. The fields and steps work with any tool, including a free spreadsheet.