MoneyLifeCalcFor more than 30 years, I've tracked my income, expenses, and investments in an Excel workbook. One sheet is a monthly ledger of every bill, grouped by category. Another is a retirement planner that I compare with my end-of-year records. MoneyLifeCalc's Yearly ledger is built on that same idea. This guide explains the method so you can use it too, whether in our free ledger or your own spreadsheet.
A budget is a plan. A ledger is what really happened.
Most people start with a budget: a guess at what they will spend. That's useful, but a budget alone never tells you whether the guess was right. A ledger records what you actually paid, bill by bill, month by month. After a few months, the gap between the plan and reality becomes obvious, and that's where the useful decisions come from.
Step 1: Group your bills into a few categories
Keep the categories broad enough that every bill has an obvious home. The ledger on this site uses these groups:
- Credit cards: what you pay on each card each month
- Loans and rent: rent or mortgage, car loans, student loans
- Utilities: power, natural gas, water, phone, internet
- Car gas: fuel for each vehicle
- Taxes: any taxes you pay directly, such as estimated or property taxes
- Insurance: health, property, car
- Others: groceries, HOA fees, services, and anything not paid by card
If you pay most everyday spending by credit card, the card payment captures it, so list only what you pay some other way under "Others." That keeps you from counting the same dollar twice.
Step 2: Record actual payments once a month
Pick one time each month, such as the weekend after your last paycheck, and copy the amounts from your statements. It takes about fifteen minutes once the items are set up. Enter what you actually paid, not what you expected to pay.
Step 3: Read the totals, not just the entries
Every item gets a year total, every category gets a monthly subtotal, and the bottom row shows your total spending each month. Three things to look for:
- Bills that creep up. Insurance, phone, and subscription costs often rise a little each year without anyone noticing.
- Seasonal months. Summer power bills and winter heating make some months predictably expensive. Knowing that ahead of time prevents surprises.
- Your real monthly average. This is the number to use for an emergency fund or a retirement plan, because it comes from what you actually spend.
Step 4: Start each new year with last year's items
At the start of a new year, carry over the same items with empty months. After a few years, you can compare the same bill across years, which is where a ledger becomes truly valuable. It shows whether your plans are working over time, not just this month.
Step 5: Connect the ledger to your bigger plans
Your ledger feeds everything else. Your average monthly spending is the starting point for an emergency fund target and for a retirement plan that asks whether your savings will last. A net worth record once a month shows the other side: what you own and owe, growing over time.
Keep it private and keep a backup
Our ledger saves your numbers only in your own browser. Nothing is sent to us, and no bank login is needed. Because the data lives on your device, download a backup file now and then from Your data and backups, or export each year to Excel with the Download for Excel button.