Expense claims
A Google Sheets template by TrackerHacker LLC, version 1.
Work expenses from your receipts, one row each, with a claims view of what's been submitted and what's still to claim. You add a hack for each sender the first time its email arrives.
Expensesv1
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 the money was spent.
- Merchant (always filled): Who was paid, as the receipt names them.
- Amount (always filled): What was spent, as a positive amount, in the receipt's currency.
- Currency: ISO code such as USD; blank means your usual currency.
- Category: An expense category. Open text: each sheet template sets its own list, often matching the accountant's chart of accounts.
- What for: Why it was spent, like Client lunch or Printer ink.
- Customer / job: The customer or job it's for, to bill it on or see what a job cost.
- Paid with: How it was paid, like Company card or Own money, so own-money claims can be paid back.
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 business templates · Template library · What is TrackerHacker?