Sort pasted expenses into categories
Sorts a pasted list of work expenses into the categories you give, flags unclear lines and totals each category without inventing amounts.
Task:
Sort the expense lines below into my categories and total each category.
Context:
The expenses are from [period] for [business or project]. My categories are [list your categories]. I will check the totals against my receipts, so the sums must be exact.
Rules:
- Put each line under exactly one category and keep its original wording and amount.
- A line that could fit two categories or has no clear category goes under "unclear" with a one-line question.
- Show the arithmetic for each total so I can verify it. If an amount or currency is missing, list the line under "missing amount" and leave it out of the totals.
- Tax treatment is not part of this task. For tax or deductions, I will ask my accountant.
Result:
A table per category with the columns date, description and amount, a total under each table, then a grand total and the "unclear" and "missing amount" lists.
Material:
[paste your expense lines here]