Expense and mileage log
Keep a simple list of expenses and business trips
Result
Add an expense or a trip to see totals.
How totals are worked out
Two expenses of 12.50 and 7.50 add to 20.00. Three trips of 18 km, 33.3 km and 12.5 km add to 63.8 km. A mileage amount appears only for a trip where you typed a rate.
Kilometres stay kilometres
A trip with no rate shows the kilometres only. No dollar figure is invented for it.
Using your own per-km rate
The tool multiplies distance by the rate you type. Canada Business Kit does not supply or check rates. Check the rate you use with the official source or a professional.
Rounding
Each trip is rounded to the cent, then those cents are added. 33.3 km at 0.75 is 24.98. 0.1 km at 0.05 is 0.01.
Common mistakes
- Do not add kilometres and dollars in the same column.
- A missing trip is left out of the distance total.
- A trip needs a purpose in your own words.
Using your CSV
Export CSV downloads one file you can open in a spreadsheet. A leading apostrophe on a text cell stops the spreadsheet from treating that cell as a formula. Numbers in the file use a dot.
A note for Canadian businesses
No tax categories and no per-km rates are built in. You type every figure.
Questions
What should I write in the purpose field?
The reason for the trip, in your words.
Do I need to keep receipts?
See the official source or a professional. This tool stores none.
What per-km rate should I use?
The tool cannot tell you. Look at the official source or ask a professional.
Does it track my location?
No. You type each entry.
Does it work in miles?
No. Distances stay in kilometres.
How do I export?
Export CSV. The summary you copy is the totals, not the words you typed.
Do I need an account?
Saving needs a free account. Without one, your entries stay on this page.
Why does the CSV show an apostrophe?
A leading apostrophe stops a spreadsheet from reading your text as a formula.