Net worth tracker
- Includes
- With chart
Before filling in a spreadsheet, choose the currency and the period you will record. Keep dates, categories and amounts in separate columns.
Currency
Currency
Currency
Currency
Currency
Currency
Currency
To understand a 50/30/20 split, apply the percentages to a sample amount. On 1000 units, the blocks are 500, 300 and 200, totaling 1000 again.
Enter one transaction per row with date, description, category and amount. Entries of 12 and 8 units total 20.
Record the description, stated date, amount and status. Use clear labels for pending, paid and unconfirmed.
Record an identifier, data date, noted balance and any movements you want to keep. In a simple subtraction, 1000 minus a movement of 100 gives 900 only when the example has no other charges or adjustments.
Separate values you classify as assets and liabilities, using one reference date. The arithmetic difference between 5000 and 2000 units is 3000.
Before filling in a spreadsheet, choose the currency and the period you will record. Keep dates, categories and amounts in separate columns. One row per transaction makes it easier to trace a total and correct mistakes.
Test the sheet with two or three simple amounts and check the total manually. Distinguish input cells from calculated cells. Do not add amounts from different currencies or periods as though they were equivalent; the template organizes the data you enter.