Finance Tracker

Maintain Categories

Version 23

Select a finance tracker workbook, maintain the category list, update budgets, choose whether a category appears in reports, and download the updated workbook. Processing is local in your browser.

Back to Importer

1. Select workbook

Tracker workbook .xlsx

Waiting for workbook.

2. Categories

Status	Category	Type	Annual Budget	Monthly Budget	Include in Summary	Used?	Order	Actions

How it works

Category is the name used by Transactions, Forecasts and Rules.
Type should normally be Income or Expense.
Annual Budget drives Dashboard and Monthly Spend Matrix reporting.
Monthly Budget is calculated automatically as annual budget divided by 12.
When you download, the Monthly Spend Matrix is rebuilt from active Expense categories marked Include in Summary = Yes.
Expense categories can be moved up/down to control their order in the Categories tab and Monthly Spend Matrix.
Include in Summary controls whether the category appears in summary reporting.
Renaming a category can also update matching Rules, Transactions and Forecast rows.