Skip to content

Travel Expenses: Receipt Ledger and Reimbursement

Record USD travel receipts and refunds by payer and category, then separately reconcile an approved reimbursement with advances and payments received.

Use this result well

Inputs that matter
Trip label, Expense rows, Approval reference, Approved traveler amount, and 3 more
Output to expect
Actual Travel Expense Ledger, Approved Reimbursement Settlement
  • Check the units and required inputs before comparing results.
  • Keep the assumptions with a copied result so you can reproduce the calculation later.
Was this tool helpful?

Reference & details

How it works

Actual expenses and received refunds

Each row has a unique ID, real date, category, payer, signed USD amount and receipt note. Positive amounts are charges; negative amounts are refunds actually received by the original payer. Advances, reimbursements and pending refunds do not belong in this ledger.

Net recorded expense = charges − received refunds = traveler-paid net + employer-paid net

Approved settlement arithmetic

Enter the amount externally approved for payment to the traveler. Exclude employer-paid charges already settled directly. Compare that amount with advances and reimbursements actually received, less amounts already returned.

Outstanding balance = approved amount − advances − reimbursements received + payments returned

Eligibility comes from the applicable policy

GSA rules concern federal travel and depend on the applicable location, dates and conditions. A receipt total does not establish a per-diem allowance, reimbursement entitlement or tax deduction. Obtain the approved traveler amount from the responsible organization; this tool performs no policy or rate lookup.

Source: GSA: per diem questions and scope

USD and explicit local records

Amounts use integer cents, with up to two entered decimal places. Convert foreign-currency receipts separately and keep the rate/date with the receipt notes. Save explicitly to this browser or copy a Markdown report; the two modes have independent versioned history and do not transfer records automatically.

Updated: September 2026

Example Scenarios

Illustrative receipts; no claim approval is implied.

Employer airfare: $520Traveler hotel: $800Traveler meals: $65Traveler local transport: $120Received hotel refund to traveler: −$50

Charges $1,505.00; received refunds $50.00; net expense $1,455.00. Traveler-paid net $935.00 and employer-paid net $520.00.

Illustrative externally approved traveler amount; enter approval and payment records in settlement mode.

Approved traveler amount: $935Advances received: $400Reimbursements received: $300Payments returned: $0

$235.00 outstanding to traveler. If $1,000 had already been received, $65.00 would be excess retained; confirm any return with the organization.

FAQ

No. It totals the expense rows entered. Your employer, agency or other responsible organization determines eligible costs and allowances under its applicable policy. Only an externally approved amount belongs in settlement mode.

Use a negative amount for a refund actually received, identify the original payer as its recipient and reference the original charge in the note. Use employer for company-paid bookings and traveler for your own payments. Do not put reimbursement transfers or cash advances into the expense ledger.

A negative category or ledger total means recorded refunds exceed recorded charges in that scope, which can happen when earlier charges are outside the period. Check completeness. In settlement mode, a negative signed balance means retained payments exceed the entered approved amount.

Use ID | YYYY-MM-DD | category | payer | signed USD amount | receipt note, one row per charge or received refund. Categories are transport, lodging, meals, local and other; payer is traveler or employer. Use plain numbers without dollar signs or commas. Up to 100 rows and 30,000 characters are supported.

No receipts are uploaded and there is no bank connection. Save expense record stores current inputs and results in this browser. Copy a Markdown report for a separate record, and retain original receipts elsewhere. Clearing browser storage removes local history; older aggregate-calculator history remains under its older key.

About Travel Expenses: Receipt Ledger and Reimbursement

Keep actual travel spending separate from reimbursement decisions. Enter dated USD receipt rows to total charges and received refunds by category and payer; use the separate settlement mode only after the traveler-payable amount has been approved.