How to track income and expenses without spreadsheets
Published:
You can track your money with a short log and a regular balance check. Record what comes in, what goes out and which account or cash wallet each entry belongs to. Then check whether your records explain the money you actually have. A notebook, a phone note or a money app can all hold that log; you can add up the figures with a calculator.
Start with a question you want answered: “Where did my money go?” or “What needs to be paid before I get paid again?” You do not need a detailed spreadsheet to answer either. You do need to distinguish a purchase from moving money between your own accounts.
Choose a method you can keep using
Before choosing software, try writing one transaction. Can you capture the date, amount, account and purpose without a long setup? Can you find it again when you check the totals?
| Method | Useful when | What to watch for |
|---|---|---|
| Paper notebook | You prefer writing and want no new account or service | You will need to total and check the figures yourself |
| Phone note | You want a quick place to capture purchases | Use the same format so the entries remain understandable |
| Bank transaction history | You need a starting record for that bank account | Add cash purchases and activity elsewhere; review category labels |
| Money app | You prefer keeping entries in a dedicated tool | Check that the available tools fit your routine and that entries are correct |
One bank account's history cannot explain how you spent cash after withdrawing it. Nor does it give a complete picture of money in other accounts. Treat it as a source for your log, rather than assuming every line is an expense.
Australia's ASIC Moneysmart explicitly includes cash purchases in its tracking guidance and suggests a phone, notebook or budgeting app as possible recording tools. The useful choice is one that lets you keep an understandable record.
Decide which money and dates you are tracking
Write down your starting money
Make a list of the accounts and cash you will include. For example: an everyday bank account, a savings account and the cash in your wallet. Record their balances at the same starting point.
This is your opening money, not income earned during the new period. If last week's pay is already in the bank, counting it again as new income would inflate your total.
The worked example below tracks your own money in one currency. A debit-card purchase is a payment from an included bank account. A credit limit is not part of your money; credit-card debt needs a separate record, explained later.
You can start today. Tracking a full calendar month makes some comparisons easier, but you do not need to wait for the first day of next month to begin.
Use actual payment dates
Record take-home pay when it arrives, rather than the gross salary stated in an employment agreement. Keep income you expect to receive in a separate planning note. A promised freelance payment is not money you can reconcile against today's bank balance.
A loan deposit is different again: it brings money in and creates an obligation to repay. Label it as borrowing rather than earnings. The distinction matters when you judge whether your regular income covers your costs.
Every two weeks is different from twice a month
Consider two hypothetical payment schedules, each paying USD 1,200 per payment:
| Assumed schedule | Payments in the example year | Annual total | Monthly average |
|---|---|---|---|
| Every two weeks | 26 | USD 31,200 | USD 2,600 |
| Twice a month | 24 | USD 28,800 | USD 2,400 |
The calculations are 1,200 × 26 ÷ 12 = 2,600 and 1,200 × 24 ÷ 12 = 2,400. The first row assumes a year with 26 payments; check the actual payroll calendar rather than treating that count as universal. In either case, an average month is a planning figure, not a deposit you have already received. Use actual dates in the log and the expected next payment date when looking ahead.
The amounts throughout this article are invented teaching examples, not typical pay or recommended spending levels. USD means US dollars. Readers using GBP, CAD, AUD, NZD, EUR or another currency can use their own figures in that currency. Do not treat currencies with the same $ symbol as interchangeable or add different currencies without an explicit conversion method. Keeping them separate is a simpler starting point.
Keep a small income and expense log
A practical entry has five fields: date, amount, type of movement, account or wallet, and category. Add a note when the purpose is not obvious. For a transfer, identify both the sending and receiving accounts.
For example:
Day 2 — USD 25 out — cash wallet — groceries — food for home.
Choose categories that help with decisions. Housing and bills, groceries, transport, health, leisure and other spending could be enough to start. You can separate eating out from groceries if knowing the difference would change your plan. There is no required number of categories.
Do not combine everything paid to another person into “transfers”. Paying a seller, sending money to someone outside the accounts you track, and moving money to your own savings are different events. Add a purpose that will make sense when you return to the record.
Keep the log of actual events separate from your budget. The Open University's introductory budgeting section describes a budget as looking forward to estimate and plan income and expenditure. Your log tells you what happened; a budget assigns money to what comes next.
Check your records with a worked example
Find the closing total
Suppose you start a period with USD 300: USD 250 in your everyday account and USD 50 in cash. You then receive USD 1,200 into that account.
Your actual expenses over the period are:
| Category | Amount |
|---|---|
| Housing and bills | USD 500 |
| Groceries | USD 220 |
| Transport | USD 80 |
| Health | USD 50 |
| Leisure and other purchases | USD 100 |
| Total | USD 950 |
With no borrowing, refunds or other external movements in this example:
Opening money + income − expenses = closing money.
USD 300 + USD 1,200 − USD 950 = USD 550.
The amount left is not just this period's income minus its expenses. It also includes the money you started with.
Make cash withdrawals balance in both places
During the same period, you withdraw USD 100 from the everyday account. Of your USD 950 expenses, USD 110 is paid in cash and USD 840 from the bank account. Assume no withdrawal fee.
- Bank account: 250 + 1,200 − 100 − 840 = USD 510.
- Cash wallet: 50 + 100 − 110 = USD 40.
- Total money: 510 + 40 = USD 550.
The withdrawal appears as a move between the two places, not as another USD 100 of spending. If you counted both the withdrawal and the cash purchases as expenses, your recorded spending would be USD 1,050 and your calculated closing money would be only USD 450. That is a recording error, not missing cash.
The same rule applies to moving money to an included savings account. Any fee paid to the bank is a separate expense; it is not part of the internal transfer.
Compare the result with your real balances
Check each included account and count your cash at the same moment. This comparison is called reconciliation: your records should explain the balances you have.
If you find USD 535 instead of USD 550, there is an unexplained USD 15 difference. Look for a missing purchase or fee, a duplicate entry, an incorrect opening balance or a date mismatch. Also check whether the balance you used already reflects a pending card hold that has not yet become a completed transaction in your log.
If a transfer has left one included account but has not reached the other, record the amount as money in transit and include it once in your combined total. A delay between the two sides appearing is not a purchase.
Do not invent “miscellaneous spending” just to force a match. Keep a dated note of the unresolved difference. You can start the next period from a verified total while preserving that note; the previous period's spending remains incomplete until the difference is explained.
Handle refunds and credit cards without double counting
A refund is money back, not new earnings
In a separate example, you pay USD 80 for an item and later receive a USD 20 partial refund. Keep both events and connect the refund to the purchase.
The net cost is 80 − 20 = USD 60. To check the money movement, you can record USD 80 out and USD 20 back in. Or, in a summary, show the net USD 60 cost. Do not both reduce spending to USD 60 and add the refund again when calculating the same closing total.
If the refund arrives in a later month, keep its actual receipt date. You might show current purchases and refunds of earlier purchases separately, so a refund does not look like this month's pay.
The general check for your money is:
Closing money = opening money + all external receipts − all external payments.
Internal transfers cancel out across included accounts. The types still matter: borrowing, earnings and refunds should remain distinguishable even though all can bring money in.
A credit-card purchase and its repayment answer different questions
Suppose you buy something for USD 80 on a credit card and later pay the card provider USD 80. This example assumes no interest or fees.
In the log of your own bank money and cash used here, the purchase creates USD 80 of debt but does not yet reduce those balances. Record it in a separate debt record. When you pay the provider, record USD 80 leaving your bank account as a debt repayment and reduce the debt by USD 80.
If you also want a report of purchases by purchase date, the item belongs in that report when bought. The repayment is not a second purchase. Do not add together that purchase report and the cash-payment log: doing so would count the same item twice.
If a payment includes interest or fees, identify those parts without adding them again on top of the total paid. This example explains a recording convention, not payment terms or a repayment recommendation. Keep debt and due dates visible even if you use a simple cash log.
Separate money you have from money you can allocate
Return to the main example's USD 550. Before your next payment arrives, you have USD 200 of bills still to pay and want to keep USD 50 set aside. The USD 50 is already included in the USD 550 total and is for a separate purpose from those bills.
550 − 200 − 50 = USD 300 remains to cover everything else before the next income payment.
If that payment is expected in 10 days, the average daily allowance would be 300 ÷ 10 = USD 30. This must cover all remaining costs not included in the bills or the reserved money, including any further groceries and transport. It is not USD 30 of extra leisure money on top of those costs. Spending can be uneven across the ten days.
Only subtract bills that are still unpaid. Expenses already included in the USD 950 have already reduced your money. Likewise, do not subtract an upcoming bill twice if money reserved for that bill is already deducted in your calculation.
The allowance depends on the amounts, dates and assumptions you entered. It is not a guarantee that spending that amount will be affordable in every situation.
Look beyond the next few days
A short log may miss annual or quarterly bills. Ireland's CCPC recommends including annual expenses and spreading preparation for large yearly costs over the year.
For an independent example in EUR, suppose a bill of EUR 360 is due in 12 months and nothing has been saved for it. Ignoring price changes and interest, setting aside 360 ÷ 12 = EUR 30 a month would build the required amount. With only three months remaining, the calculation becomes 360 ÷ 3 = EUR 120 a month. These are timing examples, not currency conversions from the USD case.
Putting money into an included savings account is a transfer. Paying the bill later is the external payment. Marking money as reserved in your plan does not make the transfer an additional expense.
What if the available amount is negative?
In another scenario, you have USD 550 but still owe USD 620 before the next receipt. Even without setting aside anything else, 550 − 620 = −USD 70. Dividing by the number of days does not create a positive allowance.
Check the figures and due dates, then consider which commitments can realistically be adjusted. If you cannot meet an essential payment, contact the provider or a local money-advice service early to discuss options. Rights, payment arrangements and consequences depend on the country and agreement; a tracking method cannot resolve those questions on its own.
Make the review small enough to repeat
Try a first week to test the method: note opening balances, capture actual transactions, and check the closing balances. A week is a practical trial, not a promise to form a habit in seven days or enough evidence to estimate every annual cost.
Once the figures make sense, pick one question to act on. Perhaps “other spending” needs a clearer label, a subscription is missing, or the next bill needs money set aside. You do not have to decide that every enjoyable purchase was a mistake.
For a longer review, Canada's FCAC recommends comparing actual spending with the budget at the end of each month and adjusting unrealistic figures. Use a complete period and check for occasional costs. A previous month can inform a plan, but cannot guarantee next month's spending or income.
If you miss entries, recover what you can from receipts and transaction histories. Mark gaps honestly. If necessary, restart from verified balances on a new date while retaining the unresolved difference. That lets you continue without pretending the missing period was fully tracked.
Considering Qavi Finance
You can learn about the product on the Qavi Finance income and expense tracking page and read its privacy policy. The method in this guide also works with another tool or with paper. Whichever you choose, keep the same distinction between income, purchases, internal transfers and money owed.
Frequently asked questions
Can I just use my bank's spending categories?
They can provide a starting point. Check what they include, add cash spending and activity in other accounts, and review transfers and refunds. A useful category is one you can explain when checking the totals.
Do I need to record every small purchase?
For a complete balance check, small purchases need to be represented too. You can group same-day purchases in the same category and from the same account if you retain enough detail to verify the combined amount. Do not add the individual purchases again after recording the group.
Should I count money moved to savings as spending?
If both accounts are included, it is an internal transfer. You can reserve it for a goal in your plan, but it still belongs in your total money. Count a later purchase once when money is paid outside those accounts.
How do I track irregular income?
Log actual receipts on their arrival dates. Keep expected payments separate and check the gap until the next one. An average based on past income is useful context, not a guarantee that money will arrive before a bill is due.
Can two people use the same household log?
First agree whose money and which accounts are included, who records purchases and how you avoid entering the same purchase twice. Moving money between included household accounts is internal. Sending money to someone outside that boundary is a payment leaving the log, with a purpose to record. This is a way to organise records, not a statement about shared-account features in any app.
Will tracking automatically save me money?
No. It can give you figures to work with; saving also depends on income, commitments and choices. A useful early outcome is simply knowing that the figures reconcile and that you have identified the bills due before your next payment.
Sources and scope
This is a guide to personal money records, not business bookkeeping, tax reporting or an individual financial plan. The examples and reconciliation steps are original teaching material. They are not study findings or a tested promise of savings.
- ASIC Moneysmart, Australia. Track your spending, updated 9 October 2026. The main article was read; it supports the choice of recording tools and inclusion of cash. Its guidance is not a test of Qavi or any particular method.
- The Open University, OpenLearn, UK. Managing my money: 3.1.1 Budgeting – the basics. This open course section was read, not the full course. It supports the distinction between a forward-looking budget and records of past activity; the section's publication date was not established.
- Competition and Consumer Protection Commission, Ireland. Building your personal budget plan. The main text was read, including guidance on annual expenses; its publication date was not stated. The calculator was not tested. Irish tax and benefit rules are not applied to other countries here.
- Financial Consumer Agency of Canada. Making a budget, dated 21 August 2025. The main text was read; it supports checking actual spending against a plan. Canadian spending benchmarks are not used as international targets.
Sources were checked for the research brief on 12 November 2026; accessible relevant sections were revisited for this draft on the same date. No claims rely on book blurbs, inaccessible chapters or unreviewed paid courses.