Expense Sheet Generator screenshot

Expense Sheet Generator

Collect expenses into one sheet: dated receipts, categories, suppliers and amounts, with a claim total you can print.

Privacy First
0 Runs
Updated 2026-11-07
Runs in your browser
No upload
No account needed
Nothing is stored

Every receipt on one sheet

An expense sheet is a list of what was spent, with enough detail to approve it. This page gives you one row per expense: the date, the category, the supplier, a description and the amount.

The totals

The subtotal is the sum of the amounts. Tax uses the rate you enter, and the claim total is the subtotal plus that tax. If the amounts you enter are already tax-inclusive, leave the tax rate at zero so the claim total is not counted twice.

Header fields

The person submitting the sheet and the expense sheet number sit in the header, with the report date and the expense period as the two dates. The department and the approver are optional fields, and there is a signature line at the foot.

Layout and printing

The sheet uses the denser layout: the table leads and the details follow. Printing, or saving as PDF, emits A4 with the editor and site navigation removed.

What it does not do

It does not read receipts, convert currencies, or reimburse anyone. It does not store the sheet or send it for approval; the printed page is what you hand over.

An expense sheet is a list of what was spent with enough detail to approve it. Each row carries a date, a category, a supplier, a description and an amount, and the subtotal, tax and claim total are derived from those rows.

The tax rate is an input rather than a lookup. If the amounts you enter already include tax, leave the rate at zero; otherwise the claim total counts the tax twice, which is the most common way this sheet goes wrong.

It does not read receipts, convert currencies, reimburse anyone or send the sheet for approval. The printed page is what you hand to a person, and the decision to approve it stays with them.

The table and its totals

The sheet uses the denser layout, so the expense table leads and the party block follows. The subtotal is the sum of the amount column, the tax is that subtotal multiplied by the rate you typed, and the claim total adds the two.

The header names the submitter, the sheet number, the report date and the expense period. Department and approver are optional extras, and the signature line is where the claim is signed.

  • Date, category, supplier, description and amount
  • Subtotal, tax at your rate and claim total
  • A signature line for the claimant

What it cannot check

A receipt is evidence the page never sees. It cannot match an amount to a photographed invoice, flag a duplicate claim or apply a per-diem policy, so those checks remain manual.

Currency is not converted either. A sheet mixing two currencies adds the numbers as if they were one, which is arithmetically true and financially wrong; convert before typing.

How to use the expense rows

Name the submitter, the sheet number, the report date and the expense period in the header, then add one row per expense with its date, category, supplier, description and amount. Set the tax rate to the rate that applies, or to zero when the typed amounts already include tax, and watch the subtotal, tax and claim total follow the rows.

Press Print document and hand the sheet to whoever approves it; the signature line is where the claim is signed. Attach the receipts separately, since the page never sees them.

What to Expect

Best for

  • A small claim with a handful of receipts
  • A trip expense summary for approval
  • A printable record of what was spent

Not ideal for

  • Matching receipts or enforcing a policy
  • A claim mixing currencies
  • A payroll or accounting system that must post the figures

What this tool keeps

  • Every row exactly as typed
  • A subtotal from the amount column
  • A tax line only at the rate you supply

What may need cleanup

  • Tax that is already inside the amounts, which needs the rate at zero
  • A currency conversion, which the page does not perform
  • Receipt evidence, which must be attached outside the sheet

Common errors

  • Leaving a non-zero tax rate on tax-inclusive amounts
  • Expecting the page to read a photographed receipt
  • Mixing two currencies in one column

Example use cases

  • A monthly travel claim
  • A team offsite's shared costs
  • A volunteer's out-of-pocket expenses

Sample input

A sheet submitted by Sam Lee, number EXP-19, covering October, with four expense rows and a 20 per cent tax rate.

Sample output

An A4 expense sheet with four rows, a subtotal, a tax line at 20 per cent and a claim total, plus a signature line.

Who this is for

  • Employees claiming expenses
  • Freelancers documenting costs
  • Treasurers of small organisations

Frequently asked questions

What does each expense row carry?

A date, a category, a supplier, a description and an amount, with a subtotal, tax at your rate and a claim total derived from the rows.

Does it match receipts or enforce a policy?

No. Receipt evidence must be attached outside the sheet, and policy is not checked.

Can it mix currencies?

No. A claim mixing currencies is not converted; use one currency or convert first.

Developer program

Build custom tools for your store

Join the SDK program to create useful ecommerce utilities for your store.