Receipt Template & Receipt Log, Auto Numbered Sales Receipt, Printable Receipt Book, Sales Tax, Refunds | Excel Google Sheets Template

Seller's description

Numbered receipts that fill themselves in, and a sales log that adds itself up. Log a sale once and this TeamTimeTools workbook gives it the next receipt number, works out the sales tax, prints a clean receipt and adds the sale to your monthly totals. For makers, market sellers, tutors, cleaners, salons and any small business that hands out receipts. Works in Excel and Google Sheets.

WHAT'S INCLUDED
1. Receipt Template + Receipt Log workbook (Excel + Google Sheets), 9 tabs:
- Start Here: setup steps in plain English.
- Setup: business details printed on every receipt, receipt prefix and first number, sales tax rate and label, tax on shipping yes/no, thank-you note, return policy, payment methods and categories.
- Receipts (1,000 sales): the receipt number is assigned for you. Optional per sale: its own tax rate (0% for tax-exempt), shipping, amount paid, refund, Void, cash received (change due worked out), a handwritten receipt number. Status shows Paid, Partly paid, Unpaid, Partly refunded, Refunded or Void.
- Receipt Lines (3,000 lines): items with qty, price (filled from Items), % discount and a taxable override.
- Customers (300) and Items (200): typed once, then picked by name. Customers show receipts, net received and balance due; Items show qty sold and sales.
- Receipt: pick a number and print or save as PDF: your header, customer, up to 12 lines, subtotal, shipping, tax, total, paid, balance due, change, notes, thank-you note and policy. Voided receipts print VOID.
- Summary: sales, shipping, sales tax collected, refunds and net received by month, by payment method and by category, plus a list of every receipt with a balance due.
- Blank Receipts: 6 numbered fill-in-by-hand receipts (3 per page) for markets and pop-ups, with their own prefix so they never clash with the log.
2. Start Here PDF with your Google copy link.

WHY IT'S DIFFERENT
- Numbers you never have to manage: no counter to bump after each sale, no duplicate numbers (a clash is flagged).
- Partial payments, deposits, refunds and voids handled, so the balance due and net received are always right.
- Sales tax worked out per receipt, rounded to the cent, with tax-exempt sales and non-taxed items.
- Every tab has a Check column that says exactly what's wrong (a misspelled item, a receipt number that doesn't exist), and the row stays out of the totals until it's fixed.
- Big fixed ranges: add rows without breaking formulas.
- Runs in Excel 2010 or newer, Google Sheets and LibreOffice. No Excel 365-only formulas, no macros, nothing locked.

TESTED
16 automated tests check every calculation against an independent model (64,221 cells), including a hand-worked receipt, unusual tax rates, bad input, voids, and a full file of 1,000 receipts and 3,000 lines. Google Sheets matched the Excel/LibreOffice values cell by cell (13,528 cells, 0 differences).

HOW TO GET IT
1. After you buy, go to your Etsy account > Purchases and download the zip. Etsy also emails you a link.
2. Open Receipt-START-HERE.pdf. Click the link and choose "Make a copy" for Google, or open the .xlsx in Excel.
3. Look at the sample, clear it, add your business details and log your first sale.

GOOD TO KNOW, PLEASE READ
- Record-keeping tool, not tax advice. It doesn't take payments, email receipts or file sales tax returns.
- One currency and one sales tax rate per receipt. The printable receipt shows 12 lines (a note says if there are more).
- Never delete a receipt row; set Void = Yes instead (receipt numbers follow the row order).
- Compatible with Google Sheets (free Google account), Excel 2010 or newer on Windows or Mac, and LibreOffice. Not designed for Apple Numbers.
- This is a digital download. Nothing physical will be shipped. Because it's a digital file, returns aren't accepted. If something isn't working, send me a message and I'll help.
- For your own use. Please don't resell or share the files or links.

HOW THIS WAS MADE
I designed this workbook with help from AI tools, which assisted with the formulas, layout and sample data. I chose the features after comparing the receipt templates already available and reading what sellers say goes wrong with them (numbers typed by hand, formulas that break when lines are added, no record of who still owes). I tested every calculation against an independent check (16 tests) before listing.