Template library › Spending and budgets
Monthly budget
A Google Sheets template by TrackerHacker LLC, version 1.
A budget for each spending category, with what's spent and left this month. Change the amounts in the Budget tab.
Transactionsv1
Use this templateGoogle asks you to choose the template once, then TrackerHacker copies it into your own Google Drive, charts and all, and you pick the emails that fill it, like your bank's or PayPal's. New here? You sign in with Google on the way.
Columns
- Date (always filled): The day it happened, in your timezone.
- Merchant / Description (always filled): Who was paid or paid you, e.g. Trader Joe's
- Amount (always filled): -12.50 for money out, 12.50 for money in
- Currency: ISO code such as USD; blank means your usual currency.
- Account: Which card or account it was, e.g. "Visa 1234".
- Category: A spending category. Open text: each sheet template sets its own list of categories.
- Type: debit: money out; credit: money in; transfer: between your own accounts.
- Transaction status: planned: money you mean to spend, added ahead; pending: the bank hasn't settled it yet; posted: settled. Blank means posted.
- Bank reference: The bank's id for the transaction, when the message has one. The same on its pending and posted alerts, so a later alert updates the row.
- Balance after: The account's balance right after this transaction, as the message states it (often the available balance, which counts pending holds). What you owe on a card is a minus. Blank when the message doesn't say.
Copied it and connected your copy? TrackerHacker asks how it's going on your sheet's page after two weeks, and your stars show up here.
More spending and budgets templates · Template library · What is TrackerHacker?