Tracking Expenditure in categories and sub categories

Panorama X
1

I’m trying to build a simple database that will track monthly expenditure that will come from a bank statement. I want to be able to categorise the expenditure with categories and sub categories possibly three sub categories deep so I can then see totals by month and by main or sub categories.

What would be the best way to achieve this?

2

Group by category, groupupwithin subcategories and voila!

3

I’m assuming that I’d need a field categories and a field subcategories?

4

Exactly correct.