Flowgrammer

Receipt Tracker

Receipt register with file naming and a review queue. Not tax software.

— Craig Major

Direct answer

A receipt tracker is a register of merchant receipts. Each row stores the merchant, purchase date, amounts as printed, a durable file name, status, owner, and whether a person reviewed the row. Tax-related fields are organizational capture only. This tracker does not give tax advice, prove deductibility, establish ITC eligibility, or make a receipt audit-ready. It does not extract fields from photos and it does not post or pay anything.

This page is a child of the Invoice Tracker cluster because it reuses intake, validation, and human review. Receipts are a different document job. The spreadsheet twin for supplier bills is the Google Sheets Invoice Tracker. What to automate first stays on Document Processing Automation.

Who this is for

Use this when people already collect receipts and the immediate problem is one register: what was bought, where the file lives, what failed validation, and what a person still has to review.

Prerequisites:

  • One buying entity for the first register. The worked example is fictional Cedar and Quay Fabrication Ltd.
  • A named reviewer who can set review_decision
  • A file-naming rule and a place to keep the source file
  • Agreement that destination_ref stays empty until a person records an entry in another system
  • Agreement that tax-related columns are labels copied from the receipt, not a determination of tax treatment

Stay out of the first tracker: tax filings, personal tax positions, OCR accuracy claims, refund execution, and supplier-invoice AP.

Canada Planner alternatives data dated 8 September 2026 put "receipt tracker" in the 100-1K band with a declining year-over-year signal. "Google Sheets receipt tracker" sat in the 10-100 band with a rising signal. This page keeps that honesty. It does not invent growth for the parent phrase.

Receipts are not supplier invoices

An invoice tracker records bills a supplier sent you. A receipt tracker records proofs of purchase from merchants. Do not clone invoice field names onto receipts. receipt_no may be blank. Duplicate keys are weaker because many receipts have no stable number.

If you need the supplier-bill register, stay on the invoice tracker. If you need extraction into an accounting draft, use Invoice Processing Automation.

Tax wall

This page and the paired workbook do not provide tax advice.

Capturing tax_amount, tax_label, or vendor_tax_id does not establish deductibility, input tax credit eligibility, compliance, or audit acceptance. Those fields exist so a reviewer can see what the receipt printed.

The Canada Revenue Agency publishes documentary requirements for claiming input tax credits (Documentary Requirements for Claiming Input Tax Credits). That publication explains why source documents carry certain information. It is not advice for your facts. Reconfirm the page on the day you rely on it. Use your own accountant or tax professional and the original files.

File naming

Suggested operational pattern:

YYYYMMDD_merchant-slug_total_currency_RCT-id.ext

Fictional example: 20260908_harbour-cafe_18-50_CAD_RCT-0001.pdf

Store that string in source_ref. Naming helps retrieval. It is not a statutory retention system and it is not a legal hold.

Field model

Required for a usable row: merchant_name, purchase_date, currency, total, source_ref, owner.

Tax-related capture, labeled as such: tax_amount, tax_label, vendor_tax_id. Copy them when they are printed. Do not validate a GST/HST registration here.

Other operating fields: receipt_no (optional), received_date, subtotal, payment_method, category, project_or_cost_center, source_url, status, reviewer, exception_code, review_decision, review_at, destination_ref, notes.

Statuses: received, validating, exception, pending_review, approved, recorded, rejected, duplicate.

Worked example

Cedar and Quay Fabrication Ltd is a fictional Toronto buyer. Sample as-of date is 10 September 2026.

  1. RCT-0001, Harbour Cafe, 8 September 2026, CAD 16.37 subtotal, CAD 2.13 tax, CAD 18.50 total, HST 13% as printed. File 20260908_harbour-cafe_18-50_CAD_RCT-0001.pdf. Status pending_review.
  2. RCT-0002, same merchant, date, and total on a second file name. Status duplicate. The first row is unchanged.
  3. RCT-0003, Union Station News, blank receipt number. Allowed if source_ref is present. Status pending_review with a note, not a missing-invoice-number clone.
  4. RCT-0004, King West Hardware. Subtotal 40.00 plus tax 5.20 does not equal printed total 52.00. Status exception / arithmetic_mismatch.
  5. RCT-0005, Harbour Cafe office supplies. Jordan Hale sets review_decision to approve. destination_ref stays empty.
  6. RCT-0008 has no owner. Assign one before review.
  7. RCT-0010 is approved and later given destination_ref EXP-FICTION-10 after a person recorded it elsewhere.

Validation checks arithmetic and required fields. It does not prove the merchant is genuine or that the tax printed is the correct treatment.

Workflow

  1. Photograph or save the receipt under the file-naming rule.
  2. Create a row. Fill required fields and any printed tax-related capture fields.
  3. Let formulas flag arithmetic and duplicate-key collisions.
  4. Open ReviewQueue. A person approves, rejects, or holds.
  5. Record destination_ref only after the person confirms an external entry.
  6. Append an AuditLog row for status and review changes.

Google Sheets documents in-cell dropdowns (Create an in-cell dropdown list), filters (Sort and filter your data), and QUERY (QUERY function). Protected ranges exist. Google states that protection should not be used as a security measure (Protect, hide, and edit sheets). Import the XLSX with File then Import (Use both Excel and Sheets).

Decision table

Signal Automatic Review Human-only
Required fields present, arithmetic matches Move toward pending_review Reviewer decides Do not auto-approve
Same merchant, date, total, currency Flag duplicate key Person confirms duplicate First row stays
Blank receipt number Allowed Person accepts or holds Do not invent a number
Arithmetic mismatch Flag Person compares the file Do not "fix" the printed total silently
Tax fields blank Allowed Person notes the source Do not infer tax treatment
External recording needed None None Person writes destination_ref later
Tax question None None Accountant or tax professional

Human gates

A person sets review_decision. A person judges a weak duplicate key. A person decides whether a missing receipt number is acceptable. A person records destination_ref. No formula decides deductibility.

Failure paths

  • Missing merchant, purchase date, total, source_ref, or owner: exception, no review approval
  • Arithmetic mismatch: exception, keep the printed total
  • Duplicate key: stop the new row
  • OCR accuracy claimed from this workbook: honesty fail
  • Deductibility, compliance, or audit-acceptance claim: remove it
  • Protected ranges treated as security: Google says they are not
  • Payment, refund, or auto-post added: out of scope
  • Live customer receipt images in the sample pack: forbidden

Retry means: fix the same record_id after the file or the amounts are corrected. Do not create a second row for the same purchase.

Test cases

Case Input Expected Acceptance
Clean RCT-0001 pending_review, empty destination_ref Required fields and matching arithmetic
Duplicate RCT-0002 status duplicate First row unchanged
Missing receipt number RCT-0003 Allowed with source_ref No invented number
Arithmetic mismatch RCT-0004 exception Printed total unchanged
Missing owner RCT-0008 exception missing_owner Cannot approve
Tax-advice wording Any sheet Fail the pack Forbidden-claims scan
Recorded after human confirm RCT-0010 destination_ref present review_decision already approve

Cost and measurement

Count open, exception, and pending-review rows. Those are planning counts. They are not savings and they are not a tax result.

Asset instructions

Download the Google Sheets Receipt Tracker. Open Instructions. Read the tax wall. Import the XLSX into Google Sheets or keep working in Excel. Fill Receipts. Use ReviewQueue. FileNaming is a convention sheet, not a legal retention policy.

Do not reuse the Google Sheets Invoice Tracker Workbook as a receipt register. The field names are different on purpose.

Next step

When receipts arrive from several people, need routing, or must create a controlled destination entry, the next paid step is a Document Intake and Approval System. Book a fit call when the register is no longer enough. If you still need the supplier-bill twin, stay on Invoice Tracker.

Sources

FAQ

Does this tracker prove a receipt is deductible?

No. It stores what was printed and whether a person reviewed the row. Deductibility is a tax question for your accountant.

Can I claim this workbook is CRA audit-ready?

No. File naming and labeled tax fields are operational. They are not a retention regime or an audit acceptance claim.

Does the workbook read receipt photos?

No. There is no OCR in this pack and no accuracy percentage.