An invoice tells you what you asked a client to pay. A payment record tells you what actually arrived. Keeping those facts in separate columns makes a side-income log easier to understand when you review your month.
Start with records you can trace
The IRS advises U.S. gig workers to retain income records and expense receipts, including income for which no Form 1099 arrives. That is a reason to build a reliable record habit. It is not a reason to guess your tax result from a spreadsheet total.
For a simple personal tracking sheet, create columns for client or project, invoice reference, invoice date, amount invoiced, payment date, amount received, and a link or reference to supporting records. Keep private client information in an appropriately protected location.
Try one small example
Suppose a fictional project has an invoice for $300. The client pays $150 this week and the remainder later. Your invoice column still describes the original request. Your payment entries show two separate receipts. A remaining-balance calculation can help you follow up without counting the invoice itself as another payment.
If a payment service deducts a fee, retain the statement that shows the transaction and fee. Avoid silently replacing one number with another and losing the explanation. Use separate notes or columns so you can reconcile your log with the underlying records. This is an organizing example, not a tax accounting method.
Make reconciliation a short appointment
Once a week, compare new entries with invoices, payment confirmations, and relevant account statements. Mark anything you cannot match as a question. If a client says they sent payment but it has not arrived, record that as a pending issue rather than received money.
Keep a consistent reference for refunds, adjustments, and duplicate entries. Correct an error in a way that leaves you able to explain the change. A complicated dashboard is less useful than a modest sheet you can trust and maintain.
Know what the sheet cannot decide
Tax reporting depends on your circumstances, location, and applicable rules. The IRS notes that self-employed gig workers may need estimated tax payments. Its current guidance and a qualified tax professional can help with your specific obligations; this article does not determine taxable income, deductions, or payment amounts.
Your immediate next step can be simple: open the last invoice and its matching payment record. If your sheet cannot show the relationship, improve the columns before adding another chart.
Sources and further reading
IRS: Manage taxes for your gig work
Sources checked November 2, 2026. Practical examples and checklists are original StayHomeHire editorial suggestions.