Expense report generator — totals by category, less any advance

How to use the expense report generator

1. Under Document, enter the Report no., Period from and Period to, the Purpose / trip and your Department, and choose the Currency.
2. Put the employer under Company and yourself under Employee.
3. In Expenses, add a line for each cost with Date, Category, Description and Amount.
4. Under Totals, enter the Advance received, if any.
5. List your receipts in Notes (receipts attached), then print the report for signature or download a PDF or CSV.

What it does and when to use it

After a work trip, a client visit or a month of small purchases, an expense report is how you get your money back. Finance teams want the same things every time: what was spent, on what, when, for which purpose, and how much is owed after any advance. This generator lays those out in a standard form with Employee and Approved by signature lines.

The summary is the useful part. Instead of a single total, it shows a subtotal for each category, largest first, so an approver can see at a glance that, for example, the hotel was the biggest cost. Then it subtracts the advance and states the balance in figures and words.

For a one-off cash payment from the office float, a petty cash voucher is simpler. If you also bill hours for the same trip, keep them on a timesheet. Freelancers passing costs to a client usually add them as lines on an invoice instead.

How it works

• Category subtotal = sum of amounts with the same category text
• Total expenses = sum of all lines
• Balance = total expenses − advance received

A positive balance is labelled “Reimbursement due to employee”; a negative one becomes “Amount owed back to company”. Amounts are added in whole pence or cents, so the total always matches the lines. Nothing leaves your browser.

Worked examples

A two-day client workshop. Train £112.40, hotel £238.00, team dinner £96.50 and taxi £18.20. The summary lists Lodging £238.00, Travel £130.60 and Meals £96.50; total expenses £465.10. Less the £200 advance, the report shows Reimbursement due: £265.10 — “Two hundred and sixty-five pounds and ten pence only”.

A bigger advance. Same expenses with a £500 advance: £465.10 − £500 = −£34.90, so the report says Owed back to company: £34.90.

Euro version. Switching the currency to EUR keeps every figure and changes the symbol: total €465.10.

Limits and tips

• The tool does not convert currencies or apply per-diem limits; it adds what you enter.
• Use the same spelling for each category (“Travel”, not “travel” on one line and “Transport” on another), or they will show as separate groups.
• Submit reports promptly; receipts are easier to find while the trip is fresh.