Tracker FAQs

Enter your currency symbol in the currency box on the Setup tab.

Use the new Irregular Expense table on the Setup tab:

1. Enter the expense name
2. Select the expense category it falls under
3. Enter number of payments per year
4. Enter the next payment date
5. The expense will automatically appear in the appropriate monthly tabs!

1. Estimate the total annual amount
2. Divide by 12 to get monthly average
3. Add as a category in the Setup tab
4. When you receive the payment, either:

• Add the full amount to one monthly tab (creates a spike in income)
• Divide by number of months and spread across multiple tabs (smooths the income into your budget)

1. Select the goal column in the income table for months already completed
2. Copy the values and paste as values only (Ctrl+Shift+V)
3. Update the income amount in the Setup tab for future months

Use the new Net Worth tab to track all financial accounts including bank accounts, stocks, etc.:

• Enter assets starting in row 27
• Enter liabilities starting in row 69
• Enter beginning balances for each account
• Update ending balances monthly

For actively contributing accounts, also add them to the savings table in Setup with monthly contribution goals.

Yes! Copy date and amount columns one at a time into the transaction tracker. The cells may unmerge, but formulas will still work. Then select categories from the dropdown.

Use the transaction tracker to enter all transactions and categorize them. You can:

• Enter transactions daily, weekly, or monthly
• Use automatic aggregators by entering total amounts by category
• Update totals by changing the date and amount in existing entries

Yes! Instead of entering individual transactions, you can enter totals from your automatic aggregator. Simply enter the date and total expense amount, then select the appropriate category in the transaction tracker. This allows you to track your progress toward spending goals and see how much of the month remains in the Planned vs. Actual spending chart. When updating totals, just modify the date and amount in your existing entries rather than creating new ones.

You can start now, but the tracker works best if you backfill all your data for 2025 because the tracker tracks expenses on a January-December annual basis. Once it’s 1/1/2026, you can make a new copy of the blank version from your downloads and start fresh for the new year.

At the moment, we can’t add more rows for irregular expenses. A good workaround is to calculate the irregular expense's monthly amount and add it to the main expenses table to account for it that way.