Give every transaction a usable record
A receipt photo is useful, but a folder full of unnamed photos is difficult to review. Connect each purchase to a date, vendor, amount and business purpose while you still remember why it was made.
The IRS explains that supporting documents, including receipts and invoices, support entries in business records. Its recordkeeping guide describes the information those documents need to show.
For a practical expense log, start with date, vendor, category, job or purpose, amount paid, payment method and a receipt reference. Use notes for details that will not be obvious later, such as which customer a delivery charge belongs to.
Choose a consistent receipt name
Use a file name you can recognize from the expense log. A pattern such as 2026-10-05-vendor-job014.pdf connects the date, vendor and job without a long description.
Store the receipt in a private folder organized by year or month, and record the file name or a private link in the tracker. Check that the photo or PDF is readable before putting the paper copy away.
A bank transaction may show that money moved without explaining everything about the purchase. Keep the supporting information together rather than relying on a single line in a statement to tell the full story.
Avoid counting the same purchase twice
Record the purchase once. If it was paid by credit card, the later payment of the card balance is not a second purchase in this simple spending log. Treat a refund as a separate negative entry linked to the original purchase.
If one purchase serves several jobs, use a consistent allocation method and notes. Do not assign the full amount to every job. Keep the original receipt so the allocations can be traced back to one transaction.
A $120 materials purchase is split equally between two jobs. Each job receives $60 in your job-cost comparison, while the original purchase remains one $120 expense record.
The goal is a clear transaction history. This starter tracker does not decide tax deductions or replace an accounting system for more complex transactions.
Separate cash spending from a pricing comparison
Materials and delivery charges may be cash expenses. Your own time also matters when judging a quote, even when there is no separate payment receipt for each hour you worked.
Keep any assigned owner-labor value in a clearly labeled job-cost comparison. Do not create a fictional purchase in the expense log just to represent that time. This distinction keeps the spending record understandable while helping you evaluate whether the job was priced well.
For an illustrative $2,400 job with $1,950 of included costs, the difference is $450 and the margin on those included costs is 18.75%. Use the Profit Margin Calculator with a consistent cost scope. If a cost is missing, the result will not account for it.
Review a little at a time
Choose a short weekly review rather than waiting until every detail is unfamiliar. Match new entries with receipts, check unusual amounts and mark anything that needs clarification.
The free Excel Expense Tracker totals all 200 entry rows, even when filters hide some records. It includes category and payment-method dropdowns. The CSV version provides a plain starting table without formulas or formatting.
Save the working file and keep a backup of both the tracker and receipts. Review record-retention requirements for your own situation before deleting old records. An organized folder is easier to maintain when the process is small enough to repeat.
Start with a small expense log.
The free Expense Tracker includes a 200-entry Excel workbook, a CSV starter and a printable worksheet.