Guide

Expense audit trails: what to capture, what to freeze, and how long to keep it

An expense audit trail is the record of what happened to a claim and who made it happen — not a log file, but the set of facts that lets someone reconstruct a decision without asking the people who made it.

The test is uncomfortable and simple. Pick an expense from fourteen months ago. Can you say who submitted it, what it was for, which policy rule applied, who approved it and on what basis, what changed between submission and approval, when it was paid, and where the receipt is? If any of those requires an email search or a conversation, the trail has a gap — and gaps are found at the worst possible time, by someone whose job is to find them.

This guide covers the fields an expense trail has to carry, which events have to be immutable and which can be corrected, how long to keep everything, and the five gaps that show up most often in otherwise well-run processes.

Written by

Clara Global Editorial Team

finance operations content

Updated

12 min read

Share
Summarize this article with:
Table of contents

What an audit trail is for

Three different readers use the same record, and designing for only one of them is how trails end up incomplete.

The auditor is testing whether the control operated as described. They do not usually care about a single expense; they care that the same rule produced the same outcome across a sample. That means the trail has to make the rule visible, not just the decision.

The tax authority is testing substantiation. Their question is about the individual item: what was it, when, where, for what business purpose, and is there a document. IRS Publication 463 puts this directly — records must prove the time, place and business purpose of travel, and an accountable plan additionally requires employees to account adequately to the employer and to return any excess reimbursement. HMRC's requirements for employers reporting expenses and benefits work on the same principle with different mechanics.

Your own finance team, twelve months later, is answering "why does this number look like that?" Their need is the reconstructable narrative: the sequence, with the reasons attached.

A trail built only for the auditor tends to have excellent approval metadata and no receipts. One built only for tax tends to have receipts and no record of who decided what. The field list below is the union.

The field-level record

What an expense audit trail should carry, when each fact is captured, and why it is asked for.
FieldCaptured whenWhy it is asked for
Submitter identitySubmissionEstablishes who incurred the cost
Original amount and ISO 4217 currencySubmissionThe claim before anyone's arithmetic
Transaction dateSubmissionDistinct from the submission date; drives rate and period
Business purposeSubmissionThe substantiation requirement most often left blank
Category, entity, cost centerSubmissionDetermines whose books carry it and under which policy
Attached evidence and its hash or versionSubmissionA receipt that can be silently replaced is not evidence
Exchange rate, source and date takenSubmissionAll three, or none of it is defensible
Policy rule evaluated and its outcomeSubmissionMakes the control testable across a sample, not just per item
Approver identity and timestampApprovalWho accepted it, and when
Approval route and the rule that produced itApprovalAnswers "why this approver?" — the question routing logs usually cannot
Delegation record, if anyApprovalDelegate, delegator, start, end
Any field changed after submission: old value, new value, actor, reasonAny editThe single highest-value entry in the trail
Rejection or send-back with reasonAnyA claim's history includes the times it did not pass
Payment date, amount, and destination account referencePaymentCloses the loop
Accounting export or sync referenceExportTies the operational record to the ledger

Two rows carry more weight than the rest. The policy rule evaluated and its outcome is what turns a pile of individual approvals into a testable control — without it, an auditor sampling twenty expenses can confirm twenty decisions and nothing about the rule. And the change record is the one that converts a trail from a set of final values into a history; a field that was edited without a trace is a field an auditor has to treat as unreliable, including on every other claim.

Immutable versus correctable

Not everything in a trail should be frozen, and freezing the wrong things creates its own problems.

Freeze the events. Submitted, approved, rejected, delegated, paid, exported. These are facts about what happened at a point in time. They are append-only: a mistake is corrected by a new event, not by editing the old one.

Allow correction, with a record, on the descriptive fields. Category, cost center, business purpose, entity. These are frequently wrong on first submission and correcting them is normal bookkeeping. What matters is that the correction is itself an event: old value, new value, who, when, why.

Never allow silent replacement of evidence. A receipt image swapped after approval, with no version history, undermines every claim in the system rather than just that one. Version the attachment or store a hash alongside it.

The design failure to avoid is a system where everything is editable and only the current state is stored. It looks tidy and it is worth very little: at audit, the answer to "was this always the category?" is "we don't know", and the auditor's next question is about your whole population rather than your sample.

How long to keep it

Retention is where most teams have a policy that does not match what they actually do.

The general shape: tax authorities set a minimum retention period for records supporting a return, and it varies by jurisdiction and by circumstance — with longer periods where a return was not filed or was materially understated. Corporate and employment law add their own periods, as do sector regulators. A group operating in several countries is subject to the longest applicable period for each record, not to an average.

Three practical rules save more trouble than a precise table would:

  1. Retain the trail and the evidence together. An approval history that outlives its receipts, or receipts whose approval context has been purged, are each half of an answer.
  2. Set retention by the entity that carries the cost, not by the employee's location. Entity ownership is what determines which jurisdiction's rules apply.
  3. Decide before you need to. Deletion is a decision either way — a team with no retention policy is keeping everything indefinitely, which is a data-protection position they have not consciously taken.

Because the specifics differ so much by jurisdiction, this is a case for confirming the applicable periods with an adviser rather than adopting a number from a guide.

The five gaps auditors find most often

Business purpose left blank or generic. "Client meeting" on eighty claims is not a business purpose; it is a default value. This is the most common substantiation gap and the easiest to fix, because it is a required-field decision.

No record of why this approver. The trail shows an approval and gives no way to tell whether it was the right person. Capturing the rule that produced the route is what turns approval metadata into control evidence.

Edits with no history. Fields that changed after submission, with only the final value stored. Once identified, this usually widens the scope of the audit rather than being a single finding.

Rate without provenance. A converted amount and a rate, but no source and no date the rate was taken. See foreign currency expenses for what the complete version looks like.

Approvals during absence with no delegation record. Approvals that appear under a name while that person was demonstrably away. Sometimes this is an undocumented delegation and sometimes it is a shared credential; the trail cannot distinguish them, which is precisely the problem. Segregation of duties in expenses covers the control.

None of these is exotic, and all five are visible in a sample of twenty expenses pulled at random. That makes a self-review cheap: pull the sample, check the five, and you know where you stand before anyone else does.

Making the trail a by-product, not a project

The reliable pattern is that the trail is produced by the workflow rather than assembled for the audit. Anything reconstructed after the fact is both expensive and weaker evidence, because it was compiled by someone with an interest in the answer.

That means capturing at the moment of the decision: the rule at evaluation time, the approver at approval time, the rate at submission time. Each of those is trivially available at the moment it happens and progressively harder to establish afterwards. A workflow that records them as it goes has an audit trail without anyone doing audit-trail work; one that stores only outcomes creates a research project every time a question is asked.

The corollary is that the trail should be readable by a person, not only queryable by an engineer. If answering an auditor’s question requires a database export and someone who knows the schema, the trail exists but is not usable, and in practice it will be reconstructed by hand anyway.

How Clara records the expense trail

Clara captures the trail as the expense moves rather than as a separate logging step. The original amount and currency are recorded as submitted; the exchange rate is locked at the moment the employee submits, so the rate on the record is the rate that governed the decision rather than one recalculated later; approvals are recorded with the approver and the routing that produced them.

At the finance end, the output is a payment-ready report — expenses grouped by currency and by the bank account each needs to be paid from, with the FX breakdown included — which means the payment record and the approval record describe the same set of expenses. Clara does not execute the transfers; the report is built for a finance team to act on through their existing banking platform.

The approval rules that decide this routing are configured per company and evaluated on the expense itself, so the same record is produced for an employee in any country submitting in any currency.

What a system cannot do is decide your retention periods, your policy, or what your auditor will accept. Those stay with your finance and legal teams. The contribution is that the facts they need are captured when they occur rather than reconstructed when they are asked for.

Methodology

The field-level table and the five-gap list are practitioner guidance informed by the standards referenced below, not quotations from them.

This page gives no retention periods in months or years. They vary by jurisdiction, entity, sector and circumstance, so a single figure in a general guide would be wrong for most readers — confirm the periods that apply to you before setting a policy.

Frequently asked questions

What should an expense audit trail contain?

An expense audit trail should contain the submitter, the original amount and its ISO 4217 currency code, the transaction date, the business purpose, the category, entity and cost center, the attached evidence, the exchange rate with its source and the date it was taken, the policy rule that was evaluated and its outcome, the approver and timestamp, the routing rule that selected that approver, any delegation, every field change with its old and new value and the actor and reason, any rejection with its reason, the payment date and destination account reference, and the accounting export reference.

Two of those are more valuable than the rest and are the ones most often missing. Recording the policy rule that was evaluated is what lets an auditor test the control across a sample rather than confirming individual decisions one at a time. Recording field changes with their previous values is what makes the trail a history rather than a snapshot — without it, an auditor has to treat every stored value as potentially edited, which widens the scope of their testing well beyond the items they sampled.

How long should expense records be retained?

Long enough to satisfy the longest applicable requirement across every jurisdiction the entity operates in, which is longer than most teams assume and is not a single number. Tax authorities set minimum periods for records supporting a return, and those periods extend in specific circumstances such as an unfiled return or a materially understated one. Corporate law, employment law and sector regulators add their own periods on top.

Two practical rules matter more than the precise figure. Retain the approval history and the underlying evidence together, because either one alone answers only half of any question. And set the period by the entity that carries the cost rather than by where the employee is based, since entity ownership determines which jurisdiction's rules apply. Given how much this varies, confirm the applicable periods with a qualified adviser rather than adopting a number from a guide — including this one.

Does an audit trail need to be immutable?

The events do; the descriptive fields should not be. Submission, approval, rejection, delegation, payment and export are facts about what happened at a point in time, and they should be append-only — a mistake is corrected by recording a new event, never by editing the original. Freezing them is what makes the sequence trustworthy.

Descriptive fields such as category, cost center, business purpose and entity are a different case. They are often wrong on first submission and correcting them is ordinary bookkeeping, so the requirement is not immutability but traceability: the correction itself becomes an event carrying the old value, the new value, who made it and why. The one thing that should never be silently replaceable is attached evidence — a receipt image swapped after approval with no version history casts doubt on every claim in the system, not just that one.

What is the difference between an audit trail and an audit log?

An audit log is a technical record of system events — who logged in, which endpoint was called, what row changed. An audit trail is a business record of a transaction’s history, expressed in terms a finance person or an auditor can read: who submitted this expense, which rule applied, who approved it and why they were the right approver.

The distinction matters because a system can have thorough logging and a poor audit trail. If answering "why was this approved by that person?" requires a database export and someone who knows the schema, the information exists but is not usable as evidence, and in practice it will be reconstructed by hand under time pressure. A usable trail is readable in the same place the expense lives, by the people who need to answer for it.

How do you audit expenses across multiple entities?

Start from entity ownership on each claim, because it determines which policy, which functional currency and which retention rules apply. An expense assigned to the wrong entity is difficult to spot after the fact — every individual number looks reasonable, and the error only surfaces when the entity's own reporting is reviewed.

The trail therefore needs entity as a first-class field decided at submission, plus a record of any reassignment between entities with the reason for it. Where a cost is genuinely shared or recharged, the trail should link the original expense to the recharge rather than restating it, so an auditor reviewing either side reaches the same set of facts. See intercompany expenses for the recharge mechanics and multi-entity expense management for the surrounding structure.

Can spreadsheets provide an adequate audit trail?

For a small volume with disciplined habits, a spreadsheet plus a document folder can satisfy substantiation, and plenty of small entities operate this way legitimately. What it cannot do well is evidence a control. A spreadsheet has no reliable history of who changed a cell and when, so the record shows the final state and nothing about how it got there.

The practical consequence appears when an auditor tests consistency rather than individual items. Questions such as "was the same threshold applied all year?" or "did this category change after approval?" cannot be answered from a current-state file, and being unable to answer them tends to expand the testing rather than settle it. If a spreadsheet is what you have, the highest-value additions are a dated change log maintained deliberately, evidence filed so it cannot be replaced without trace, and a written record of the rules in force during each period.

Sources

About this guide

This guide covers what an expense audit trail should capture and how long it needs to survive. It gives no specific retention periods, because those depend on jurisdiction, entity and sector — the sources below set out general requirements rather than the rules for any one company.

This page is operational guidance for finance teams. It is not legal, tax, audit, or accounting advice. Record-keeping and retention obligations depend on jurisdiction, entity structure, sector and circumstance — confirm the periods and requirements that apply to you with a qualified adviser before setting or changing a retention policy.

Capture the trail as it happens

Start free and see the trail captured as the expense moves, rather than reconstructed when someone asks.

Start free

Start now!