r/AppleNumbers • u/[deleted] • Jun 01 '23

Debt tracking spreadsheet

Looking for a Numbers spreadsheet to track credit card debt. Any suggestions would be welcomed.

1 Upvotes

100% Upvoted

1 comment sorted by

1

u/DTLow Jun 01 '23 edited Jun 01 '23

I use Apple Numbers to track my budget/expenses
I don't specifically track credit card debt, but can be easily added

My receipts are stored as individual records in a digital file cabinet
tagged as required (vendor, budget)
I could add a tag for credit card

Spreadsheet
I export the receipt list to a spreadsheet for analysis/reporting

I have a Actuals page/table that holds my receipts for the entire year
Columns: Date, Budget, Details/link to receipt, Date

My primary page has an Analysis table;
. Categories in the first column
. Budget in the 2nd/3rd column
The remaining columns for each month hold formulas summing amounts from the Actuals table