Income and expense tracker: a practical household template
Copy a simple income and expense tracker, work through a monthly example and learn how to handle transfers, refunds and credit cards without double-counting.
Your bank balance tells you how much is in one account. It does not tell you how much you earned this month, which purchases used it or how much is already reserved for next week's rent.
An income and expense tracker records money earned and money spent in one place. Start with a monthly transaction log, then total income and expenses separately. Keep transfers between your own accounts out of both totals so moving money does not look like earning or spending it.
This guide is for household budgeting. A business needs records suited to its bookkeeping and tax requirements. For that use, start with our
Decide what your tracker covers
Choose a month and list the accounts you will include: checking, cash, savings and any credit cards used for household purchases. You do not need to put account numbers in the file. Labels such as "checking" and "shared card" are enough.
For wages, use the take-home pay deposited into your account. Keep expected payments in a separate plan until they arrive. A promised payment is useful for forecasting, but it cannot cover a bill yet.
The consumer.gov budgeting guide recommends gathering bills and pay records, recording spending and comparing the result with your monthly plan. The template below adds transaction types so transfers and refunds do not distort that comparison.
Copy this transaction log
All amounts below are illustrative. Put each transaction on its own row. Use positive amounts and let the type determine how it contributes to the totals.
| Date | Description | Type | Category | Account | Amount |
|---|---|---|---|---|---|
| Sep 1 | Take-home pay | Income | Wages | Checking | $2,000 |
| Sep 2 | Rent | Expense | Housing | Checking | $1,000 |
| Sep 3 | Grocery shop | Expense | Groceries | Shared card | $72 |
| Sep 4 | Move money to savings | Transfer | Savings allocation | Checking to savings | $150 |
| Sep 5 | Returned grocery item | Refund | Groceries | Shared card | $12 |
| Sep 6 | Card payment | Transfer | Card payment | Checking to shared card | $60 |
For these rows, income is $2,000. Net expenses are $1,060: rent of $1,000 plus groceries of $72 minus the $12 refund. Income minus net expenses is $940.
The $150 savings transfer and $60 card payment do not change that spending total. They change account balances. The $940 result is also not a promise that you can spend $940 today: upcoming bills, other transactions and reserved money still matter.
Use a small set of categories
Begin with housing, utilities, groceries, transport, health, personal spending and entertainment. Add categories when a separate total will help you make a decision.
A supermarket receipt may include food, shampoo and a phone charger. Split those items if you want a food-only grocery total. Otherwise, label the category clearly enough that you remember it includes household supplies.
Our
Handle the transactions that cause double-counting
Credit card purchases and payments
If you record card purchases as expenses, the payment from checking to the card is a transfer. Counting both would record the same spending twice. Card interest and fees are separate expenses.
Payments toward debt from before your tracking period still use current cash. Show them in your payment plan even though the old purchases are not new expenses this month. A spending report and a bill-payment schedule answer different questions.
Cash withdrawals
When you track cash purchases, an ATM withdrawal is a transfer into your cash balance. Record the later purchases as expenses. Record an ATM fee separately if one applies.
For example, withdrawing $50 and later buying $18 of groceries leaves $32 in tracked cash. It creates $18 of spending, not $68.
Refunds
Link a refund to the original spending category. If a returned shirt produces a $30 refund, reduce clothing expenses by $30. Do not label it wages or new earnings.
A refund for an earlier month can make this month's category total negative. Add a note explaining the original purchase so you can understand the result later.
Shared expenses
Decide whether you are tracking the whole household or only your share. For a household tracker, include each household purchase once. Money passed between household members to settle it is an internal transfer when both sides are included.
For a personal tracker, record the reimbursement against the expense it repays. A $60 shared meal with a $30 reimbursement leaves a $30 personal cost. Use the same approach throughout the month.
Close the month with a short summary
Here is a separate full-month example:
| Measure | Amount |
|---|---|
| Income received | $3,200 |
| Expenses after refunds | $2,700 |
| Income minus expenses | $500 |
| Money allocated to savings | $300 |
| Unallocated part of this month's surplus | $200 |
The $300 savings allocation is part of the $500 surplus. It is not an additional expense in this spending view. A
Before closing the month, compare the log with your statements and receipts. Check for missing cash purchases, duplicate entries and refunds. Then check bills due before your next income arrives using a
Keep the daily work small
Save receipts when you buy something and choose a regular time to enter transactions.
Start with the current month. Enter your latest pay deposit and the purchases since then, check the totals and build your next budget from that record.