Flat Rate Expenses Claim Excel - Free Template

1. Open the Claim Log sheet and add one claim per row. Enter the claim date, employee name, PPS number, department, work location, and expense type.
2. Fill in the flat rate amount and the quantity or days claimed. The claim total column is there to show the payable amount at a glance.
3. Update approval status and submitted-to details as the claim moves through checking. Use notes for anything unusual, such as a missing receipt or a split period.
4. Check the Rates & Rules sheet before you approve a claim. It is the place to keep your internal policy notes and any rate references you use often.
5. Review the Summary Dashboard before each payroll run or payment batch. That gives you a quick view of totals by status, department, or period.
6. Use the Instructions sheet to keep a standard process in the file. If more than one person handles claims, agree who enters, who approves, and who marks claims as paid.

This template suits the office manager in a trades firm, the payroll clerk in a small Ltd company, or the treasurer in a club who needs to record claims before money goes out. A carpenter with 4 employees might have 12 to 16 claims a month for travel, meals, or site allowances, and it is much easier to review them in one Claim Log than across email and paper slips.

Image 1 shows the Claim Log sheet, with columns for Claim ID, claim date, employee name, PPS number, department, work location, expense type, flat rate amount, quantity or days claimed, claim total, approval status, submitted to, paid date, notes, and payroll status. That structure works because you can sort by employee, filter by status, and see unpaid items before the payroll run.

Where this helps most

If you are running weekly payroll, claims often arrive at the same time as timesheets and holiday checks. A file with 30 claims at €24.50 each is only €735, but if three are missed you are already out €73.50 and the staff member will notice immediately.

Who should keep it

For a small team, one person can enter and track the file. In a larger office, I would keep the entry and approval steps separate, because that avoids the usual mix-up where a claim is paid before it is signed off.

Image 2 is the Rates & Rules sheet, which is the right place to keep the standard allowances, internal policy notes, and any reminders about what counts as a claimable flat rate. The Summary Dashboard on image 3 then gives you the quick totals you need before you release payment.

The Summary Dashboard on image 3 then gives you the quick totals you need before you release payment, and the same figures can feed into the grant income check when you need to confirm eligibility.

Flat rate claims are not the same as VAT invoices, but they still sit inside your payroll and bookkeeping records, so the paperwork needs to be tidy. Revenue expects you to keep business records for 6 years, and that is the minimum standard you should build into the workbook process.

If a claim is paid through payroll, the person processing it may also have to think about PAYE, PRSI, and USC. A claim that is genuinely an expense reimbursement is different from an allowance or benefit, so the wording in your Notes column matters more than people think.

Why the fields matter

The PPS number and employee name identify who the claim belongs to, while the claim date and paid date give you the timeline Revenue or an auditor may want to see. If you have 60 claims in a month and 8 of them are missing a paid date, you will waste time at year end trying to reconcile them back to bank payments.

A practical stance

Keep the log tight and factual rather than making it decorative. For most Irish employers, a plain record with dates, amounts, and approval status is better than a complicated file with extra tabs nobody updates, because the real risk is not lack of style — it is missing evidence when you need it.

Image 2 also lets you keep the rules sheet close to the working log, which is useful if you are updating internal policy after a payroll review. That is especially helpful where the same file covers several departments or sites and you need one consistent approach.

The most common mistake is paying claims without a proper status trail. If 25 claims at €18.00 are marked as submitted but never approved, you are looking at €450 of spend that can drift through the month with no clear owner.

Another problem is using the wrong amount or quantity. One employee claims 3 days, another enters 5, and the total is off by €49.00 or €98.00 before anybody notices, which is exactly the sort of error that creates awkward payroll corrections later.

Missing dates and poor notes

When the paid date is left blank, people assume the claim is still outstanding even when it has already been processed. That leads to duplicate payment requests, and a duplicate payment of €120.00 is easy to make if you do not have a simple check against the Paid Date and Payroll Status columns.

No backup for month-end review

What also goes wrong is losing the context. If a claim says only “site visit” or “travel” with no location, no department, and no note, the person reviewing it may have to chase the employee two weeks later, which costs more in time than the claim is worth.

My view is simple: if your file does not let you explain a payment in under 30 seconds, it is not ready. The whole point of the workbook is to stop the small errors becoming €500 headaches at month end.

Use the workbook at the same point every month, ideally just before payroll or just before the claims payment run. If claims are checked on the first working day and paid on the fifth, the file stops being an afterthought and becomes part of the routine.

Simple habits that keep it alive

• Copy the previous month’s tab or file structure so you do not rebuild the headings every time.
• Review the Claim Log once a week rather than waiting until 40 claims land at the end of the month.
• Use the Summary Dashboard to check the total approved versus paid claims before you close the period.
• Keep the Instructions sheet up to date so a colleague can step in if you are out sick.

When Excel is enough, and when it is not

Excel is fine when you have a modest number of claims, a clear approver, and a predictable payment cycle. If you move into hundreds of claims a month, multiple approvers, or live links to payroll and finance systems, you have outgrown a spreadsheet and should move to a proper expense system.

Image 4 shows the Instructions sheet, which is where you set the routine in writing. A file that is used every week for 12 months is far more valuable than a clever template that nobody opens after the first fortnight.