{"product_id":"mileage-log-expense-tracker","title":"Mileage and Expense Log Spreadsheet","description":"\u003cp\u003eThis mileage log values every business trip at your own rate, in the same file as the rest of your books. It is for anyone self employed who claims mileage and would rather not reconcile a separate app at the end of the year.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eOne rate, every trip valued\u003c\/h2\u003e\u003cp\u003eSet your rate once on Setup. Each trip is logged with its date, purpose and distance, and its value is worked out on the line. The Mileage tab totals distance logged and what it is worth at your rate, and it sits beside the expense ledger rather than in a separate tool. Every figure on the dashboard is calculated from the tabs behind it, and nothing is typed into a summary, so the front page always agrees with the rows it came from.\u003c\/p\u003e\u003ch2\u003eEleven connected tabs\u003c\/h2\u003e\u003cp\u003eEvery tab reads the same source list, so nothing is entered twice. Alongside the 200-trip mileage tracker you get a full ledger of 1,000 rows:\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe ledger:\u003c\/strong\u003e Income and Expenses, 500 rows each, with the tax split out per line, your own categories and account balances\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe tax:\u003c\/strong\u003e sales tax by quarter and by rate, quarterly set-asides, and mileage valued at your rate\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe reporting:\u003c\/strong\u003e profit and loss, monthly and quarterly views, any date range, this year against last, and a live dashboard\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eThat makes it a complete expense tracker for business expenses as well: the profit and loss and the quarterly set-asides are ready when you need them, and the comparison view shows this year against last.\u003c\/p\u003e\u003cp\u003eYou get real spreadsheet files, not a PDF with a link in it: Excel and Google Sheets, each filled in and each blank and ready for yours. The filled copy is the file in the photos, so you can see how it behaves before you type anything.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice. No Microsoft 365 subscription required.\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. No Google account is needed for the Excel files.\u003c\/li\u003e\n\u003cli\u003eNo add-ins, no macros and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example, and the same workbook blank and ready for yours\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears. The Start Here tab walks you through setup in a few minutes. The files are for personal use on your own devices; please do not share or resell them. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDoes it work in Excel or Google Sheets?\u003c\/h3\u003e\u003cp\u003eBoth. You download Excel files for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make Google Sheets copies with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I set my own mileage rate?\u003c\/h3\u003e\u003cp\u003eYes. You enter one rate on Setup and every trip is valued at it. The file does not decide what rate you can claim.\u003c\/p\u003e\u003ch3\u003eHow many trips can I log?\u003c\/h3\u003e\u003cp\u003eThe mileage log holds 200 trips, and the income and expense ledger holds 1,000 rows.\u003c\/p\u003e\u003ch3\u003eDoes it track my other business costs too?\u003c\/h3\u003e\u003cp\u003eYes. Income and expenses each have 500 rows, with tax split out per line, and they feed the profit and loss, quarterly views and dashboard.\u003c\/p\u003e\u003ch3\u003eDoes it use GPS or connect to my phone?\u003c\/h3\u003e\u003cp\u003eNo. You type each trip yourself. There are no add-ins, no macros and no subscription.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597863616606,"sku":"OPX-058","price":20.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/mileage-log-expense-tracker-01.jpg?v=1790832258","url":"https:\/\/opxviashop.com\/products\/mileage-log-expense-tracker","provider":"OPXVIA","version":"1.0","type":"link"}