Three Formats, One Record
Physical receipt photographed at the register. Email confirmation linked via URL. PDF from the online order stored as an attached file. Any given week of purchases will produce all three, and most tracking systems handle exactly one of them gracefully.
The Copy of Receipt field in this template flags which documentation type you have — Picture or Link to Online Receipt — and the three subsequent fields handle the actual storage: image upload for the physical scan, URL field for the email confirmation link, file attachment for the downloaded PDF. That is not redundancy. That is the documentation stack that matches how receipts actually arrive.
Where Cash Back Disappears
The most invisible leak in a household expense log is cash back. You pull $40 cash back at the grocery checkout on a $87 purchase. The receipt total says $127. Your budget system records $127 as a grocery expense. The $40 goes into your wallet, gets spent over the next four days, and appears nowhere. Your grocery category is now $40 overstated on the expense side and your cash spending is untracked.
The Cash Back Yes/No and Cash Back Amount fields resolve this in the entry itself. Record $127 as the receipt total, mark cash back Yes, record $40. Now you have the actual grocery spend of $87 and a clear notation that $40 cash entered circulation. What happens to that $40 is a separate tracking question, but at least it's identified as a known variable rather than a phantom discrepancy.
Most people discover this problem when their bank statement reconciliation is off by amounts that feel too irregular to be rounding errors and too small to trace easily.
The Itemized Receipt Checkbox
The boolean "Check here if you have a clear, itemized receipt" is doing more work than it looks like. At tax time, medical expense claims require itemized receipts — a receipt that says "pharmacy" for $67.40 is not the same document as one that shows ibuprofen, a blood pressure cuff, and a prescription co-pay. Home office deductions require itemized receipts. Warranty claims require them. Business expense reimbursements require them.
Logging entries without checking this field means you know you spent money but you may not know whether your documentation actually supports the claim you want to make with it. Filtering for all entries where the itemized checkbox is unchecked and the category is medical or business gives you an immediate list of weak documentation to chase down before the end of the year — while the purchase is recent enough that a replacement receipt is still obtainable.
The Payment Type field (Cash, Debit, Credit, Select Value) handles the reconciliation layer. When your credit card statement shows a charge you don't immediately recognize, searching by payment type and date range narrows the candidate records quickly.
Purchase date is logged as datetime, not just date. That matters when you're trying to match a record to a specific transaction on a bank statement that shows two charges at the same store in the same day.