How the category subtotals work
The category column uses a dropdown. The subtotal block uses SUMIF to add the amounts for each category, so the numbers update as you change a category or an amount. The total to reimburse adds the five subtotals.
What to put in each row
Date, a short description, the category and the amount. Put the receipt note in the last column if you need to track which receipts are attached. Keep the description specific enough that someone else could approve it.
Receipts and the $75 habit
Many businesses require receipts for anything over $75, and for all lodging and airfare. Attach them to the PDF export or keep them in the same folder as the report. A report without support is the one that gets sent back.
Print or save as PDF
The print area is US Letter, portrait, one page wide. Save as PDF and attach the receipts. If the client uses a different chart of accounts, change the category list in the dropdown and the subtotal labels together.