{"title":"Business Records","description":"\u003cp\u003eWorking records for the money side of a business: invoices, quotes, mileage and bookkeeping. Each is an Excel and Google Sheets workbook with a printable page or summary, a blank copy, a copy with fictional sample data and a PDF quick-start guide.\u003c\/p\u003e","products":[{"product_id":"freelancer-client-invoice-tracker","title":"Freelancer Client \u0026 Invoice Tracker","description":"\u003cp\u003eKeep a clean paper trail of who owes you what. This client and invoice tracker spreadsheet is built for freelancers, photographers, designers and small-business owners who want to see outstanding and overdue invoices at a glance without paying for invoicing software.\u003c\/p\u003e\u003cp\u003eAdd your clients once, log each invoice and its line items, and record payments as they arrive. Invoice status updates on its own from your dates and payments: Draft, Sent, Overdue or Paid, with days overdue. The Dashboard shows what's outstanding, what's overdue, what you've been paid this year, invoiced vs collected by month with a chart, an aging summary and your top five clients.\u003c\/p\u003e\u003cp\u003eWhen you need to send an invoice, pick its number on the Printable Invoice tab and print or save it as a PDF with your business details, line items, tax and balance due. Settings hold your business name, currency, sales tax rate and payment terms, so everything stays consistent.\u003c\/p\u003e\u003cp\u003eFormula cells are protected without a password, dropdowns keep entries tidy, and a blank copy plus a copy with fictional sample data are both included so you can explore before you start.\u003c\/p\u003e\u003ch3\u003eWhat's included\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eClient \u0026amp; Invoice Tracker workbook (.xlsx) with fictional sample data\u003c\/li\u003e\n\u003cli\u003eBlank copy (.xlsx) ready for your clients\u003c\/li\u003e\n\u003cli\u003eTabs: Start Here, Settings, Dashboard, Clients, Invoices, Invoice Items, Payments, Printable Invoice, Lists\u003c\/li\u003e\n\u003cli\u003eQuick-start guide (PDF, 3 pages)\u003c\/li\u003e\n\u003cli\u003eREADME\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eCompatibility\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2010 or newer (Windows and Mac) and Microsoft 365\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets (upload the .xlsx to Google Drive, then Open with \u0026gt; Google Sheets)\u003c\/li\u003e\n\u003cli\u003eNo macros or add-ons. Tested in LibreOffice Calc; uses functions available in both Excel and Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFile format\u003c\/h3\u003e\u003cul\u003e\u003cli\u003e.xlsx workbook (sample copy + blank copy) and a PDF quick-start guide, delivered as an instant download.\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eDigital download, no physical item shipped.\u003c\/strong\u003e\u003c\/p\u003e","brand":"Papertrails Print","offers":[{"title":"Default Title","offer_id":68147508773184,"sku":null,"price":17.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1010\/2643\/1296\/files\/papertrails-client-invoice-tracker-01_hero_2048.png?v=1794958537"},{"product_id":"freelance-rate-quote-calculator","title":"Freelance Rate \u0026 Quote Calculator","description":"\u003cp\u003eStop guessing what to charge. This freelance rate calculator works out the minimum hourly and day rate you need from your take-home income goal, yearly business expenses, an estimated tax set-aside, a buffer for slow months, your time off and the share of your hours that's actually billable.\u003c\/p\u003e\u003cp\u003eYou'll see revenue needed per year, month and week, where each dollar goes, rounded rates you can quote, and a what-if table for billable share from 40% to 80%. Set the rates you'll actually use, and you'll get a warning if they fall below your minimum.\u003c\/p\u003e\u003cp\u003eThen build a project quote: up to 15 line items as hourly, day-rate, fixed-price or expense lines, with optional markup, discount, rush fee, sales tax and deposit. A quote check compares the job's effective hourly rate with your minimum. The Printable Quote tab turns it into a clean one-page quote with your business details, ready to print or save as PDF; clients see final unit prices, not your markup.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eNew in version 1.1: Project Cancellation \/ Kill Fee section.\u003c\/strong\u003e Set editable cancellation terms (notice tiers and fee percentages, payment for work completed, a charge for reserved time you can't rebook, non-refundable expenses, an optional minimum fee and whether the deposit is non-refundable), calculate what's owed if a client cancels, and print a matching cancellation clause on the quote. The terms are customizable placeholders, not legal advice; whether a kill fee can be enforced depends on your contract and local law, so have them reviewed by a qualified lawyer.\u003c\/p\u003e\u003cp\u003eIncludes a copy with fictional example numbers and a blank copy. The tax rate is your own planning estimate, not tax advice.\u003c\/p\u003e\u003ch3\u003eWhat's included\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eRate \u0026amp; Quote Calculator workbook (.xlsx) with fictional example numbers\u003c\/li\u003e\n\u003cli\u003eBlank copy (.xlsx)\u003c\/li\u003e\n\u003cli\u003eTabs: Start Here, Settings, Rate Calculator, Quote Builder (with Project Cancellation \/ Kill Fee calculator), Printable Quote (with cancellation clause)\u003c\/li\u003e\n\u003cli\u003eQuick-start guide (PDF, 4 pages)\u003c\/li\u003e\n\u003cli\u003eREADME\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eCompatibility\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2010 or newer (Windows and Mac) and Microsoft 365\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets (upload the .xlsx to Google Drive, then Open with \u0026gt; Google Sheets)\u003c\/li\u003e\n\u003cli\u003eNo macros or add-ons. Tested in LibreOffice Calc; uses functions available in both Excel and Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFile format\u003c\/h3\u003e\u003cul\u003e\u003cli\u003e.xlsx workbook (sample copy + blank copy) and a PDF quick-start guide, delivered as an instant download.\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eDigital download, no physical item shipped.\u003c\/strong\u003e\u003c\/p\u003e","brand":"Papertrails Print","offers":[{"title":"Default Title","offer_id":68147508805952,"sku":null,"price":12.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1010\/2643\/1296\/files\/papertrails-rate-quote-calculator-01_hero_2048.png?v=1794958537"},{"product_id":"mileage-expense-log-2026-2027","title":"Mileage \u0026 Expense Log 2026–2027","description":"\u003cp\u003eLog business miles and work expenses for 2026 and 2027 in one tidy spreadsheet. Each trip is valued at the IRS standard mileage rate in effect on the trip date, including the mid-2026 change (72.5¢ per mile Jan 1 – Jun 30, 2026 and 76¢ from July 1, 2026, per IRS.gov as of November 17, 2026). Rates sit in an editable Settings table, so when the IRS publishes 2027 rates you update one row and every 2027 trip re-prices.\u003c\/p\u003e\u003cp\u003eEnter odometer readings or just the miles (with a round-trip option), choose Business, Medical, Charity or Personal, and add the business purpose. Log parking, tolls, meals, lodging and other expenses with reimbursable and receipt-saved flags.\u003c\/p\u003e\u003cp\u003eThe 2026 and 2027 Summary tabs total miles and mileage value by month and year for each trip type, expenses and reimbursable amounts, expenses by category, business-use percentage per vehicle and a monthly miles chart.\u003c\/p\u003e\u003cp\u003eIncludes a copy with fictional sample trips and a blank copy. Always confirm the current rate on IRS.gov; this is a record-keeping tool, not tax advice.\u003c\/p\u003e\u003ch3\u003eWhat's included\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eMileage \u0026amp; Expense Log workbook (.xlsx) with fictional sample trips\u003c\/li\u003e\n\u003cli\u003eBlank copy (.xlsx)\u003c\/li\u003e\n\u003cli\u003eTabs: Start Here, Settings (vehicles + IRS rate table), Trip Log, Expenses, 2026 Summary, 2027 Summary, Lists\u003c\/li\u003e\n\u003cli\u003eQuick-start guide (PDF, 3 pages)\u003c\/li\u003e\n\u003cli\u003eREADME\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eCompatibility\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2010 or newer (Windows and Mac) and Microsoft 365\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets (upload the .xlsx to Google Drive, then Open with \u0026gt; Google Sheets)\u003c\/li\u003e\n\u003cli\u003eNo macros or add-ons. Tested in LibreOffice Calc; uses functions available in both Excel and Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFile format\u003c\/h3\u003e\u003cul\u003e\u003cli\u003e.xlsx workbook (sample copy + blank copy) and a PDF quick-start guide, delivered as an instant download.\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eDigital download, no physical item shipped.\u003c\/strong\u003e\u003c\/p\u003e","brand":"Papertrails Print","offers":[{"title":"Default Title","offer_id":68147508838720,"sku":null,"price":9.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1010\/2643\/1296\/files\/papertrails-mileage-expense-log-01_hero_2048.png?v=1794958537"},{"product_id":"small-business-bookkeeping-spreadsheet","title":"Small-Business Bookkeeping Spreadsheet","description":"\u003cp\u003eA simple bookkeeping spreadsheet for US sole proprietors, freelancers and small businesses who want clear numbers without accounting software.\u003c\/p\u003e\u003cp\u003eType each sale on the Income tab and each purchase on the Expenses tab. Categories are aligned to common IRS Schedule C lines (advertising, contract labor, office expense, supplies, travel, meals and more), and you can rename or add your own. The Monthly P\u0026amp;L shows income, expenses and net profit for every month. Category Totals ranks your top expense categories with a chart and rolls everything up by Schedule C line, a handy starting point for your tax preparer. The Yearly Summary shows total income, expenses, net profit, profit margin, your best month, charts and a comparison with last year.\u003c\/p\u003e\u003cp\u003eAnything entered without a valid category shows as Uncategorized, so nothing slips through. Owner draws can be tracked but kept off the P\u0026amp;L, and a 'Receipt saved?' column helps you catch missing receipts before tax time.\u003c\/p\u003e\u003cp\u003eIncludes a copy with a fictional sample year and a blank copy. This is a record-keeping tool, not tax advice; check deductions with a tax professional.\u003c\/p\u003e\u003ch3\u003eWhat's included\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eBookkeeping workbook (.xlsx) with a fictional sample year\u003c\/li\u003e\n\u003cli\u003eBlank copy (.xlsx)\u003c\/li\u003e\n\u003cli\u003eTabs: Start Here, Settings, Income, Expenses, Monthly P\u0026amp;L, Category Totals (with Schedule C roll-up), Yearly Summary, Categories\u003c\/li\u003e\n\u003cli\u003eQuick-start guide (PDF, 4 pages)\u003c\/li\u003e\n\u003cli\u003eREADME\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eCompatibility\u003c\/h3\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2010 or newer (Windows and Mac) and Microsoft 365\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets (upload the .xlsx to Google Drive, then Open with \u0026gt; Google Sheets)\u003c\/li\u003e\n\u003cli\u003eNo macros or add-ons. Tested in LibreOffice Calc; uses functions available in both Excel and Google Sheets.\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch3\u003eFile format\u003c\/h3\u003e\u003cul\u003e\u003cli\u003e.xlsx workbook (sample copy + blank copy) and a PDF quick-start guide, delivered as an instant download.\u003c\/li\u003e\u003c\/ul\u003e\u003cp\u003e\u003cstrong\u003eDigital download, no physical item shipped.\u003c\/strong\u003e\u003c\/p\u003e","brand":"Papertrails Print","offers":[{"title":"Default Title","offer_id":68147508904256,"sku":null,"price":22.0,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1010\/2643\/1296\/files\/papertrails-bookkeeping-spreadsheet-01_hero_2048.png?v=1794958537"}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1010\/2643\/1296\/collections\/pt-card-client-invoice-tracker.jpg?v=1795112592","url":"https:\/\/www.papertrailsprint.com\/collections\/business-records.oembed","provider":"Papertrails Print","version":"1.0","type":"link"}