Daily Travel Spend Log

What this sheet is for

This sheet is for anyone travelling with a fixed pot of money — whether it is a personal holiday allowance or a work trip per diem — who wants to know at a glance how much is left. Reach for it on the first morning of your trip, fill in your starting funds, then log each transaction as it happens rather than reconstructing spending from memory at the end.

How to use it

Write your destination and travel dates in the Trip / Dates field at the top right, then enter your total available funds — cash plus card allowance combined — on the Cash & card funds at start line. Each time money moves, fill one row: the date, a short note in What / Where (for example 'Taxi to airport' or 'Hotel refund'), the amount in Money In or Money Out, and the updated Balance. The heavier rules every six rows help you see roughly how spending is pacing across the days. At the foot, set your Target remaining funds at trip end as a reference point so you can judge whether the running balance is on track.

What is printed on the page

“Daily Travel Spend Log” is laid out as running ledger: an opening-balance line, a 24-row ledger with date, description, in, out and running balance columns, and a goal box at the foot. Under the title it reads “Track every payment and receipt day by day while you are on the road.”, and the line at the foot of the page says “Keep receipts in a numbered envelope matching each row number — makes expense claims and refunds much faster.”.

The column headings slot holds three entries — “What / Where”, “Money In” and “Money Out” — so the sheet is already filled in for travel rather than left as blank rows to label yourself.

The remaining labels on the page are “Trip / Dates” for the period label, “Cash & card funds at start” for the opening label, “Balance” for the balance heading and “Target remaining funds at trip end” for the goal prompt.

Two things about this particular running ledger are settings rather than text, and “Daily Travel Spend Log” has them set like this. Goal box is on: include the goal box at the foot. Weekly dividers is on (the opposite of the layout's default): draw a heavier rule every six rows.

Tips

Convert foreign currency to your home currency at the actual rate you received, not the interbank rate, to keep the balance accurate.

Log ATM withdrawals as Money In and individual purchases as Money Out so cash spending stays fully visible in the ledger.

If a hotel pre-authorisation hold shows on your card, note it in the description and reverse it in Money In when it drops off.

The other layouts in this set

“Daily Travel Spend Log” is one of three sheets in this set, each a different fixed layout filled for the same topic. “Holiday Trip Budget” uses the income and expenses layout and “Trip Spending by Category” uses the category envelopes layout. Pick by how you work: the layout decides how much you write and where, not what the sheet is about.