Track Earnings and Time With One Simple Spreadsheet
A useful earnings tracker does not need dozens of tabs. One clean table can answer the questions that matter: what work was done, how long it took, how much it earned, what has been paid, and what still needs attention.
Use one row per piece of work
Useful columns include date, client or platform, work type, minutes spent, amount agreed, fees, amount received, payment status and notes.
Consistency matters more than adding every possible field. If a column is never used for a decision, consider removing it.
Calculate effective hourly return
Divide net earnings by hours spent, including meaningful unpaid setup time. This lets you compare a fixed-price task with an hourly job or a microtask platform.
Look at several weeks rather than one unusually good or bad session.
Add only a few summaries
Monthly net income, outstanding payments, hours worked and average effective hourly return are enough for many people. A simple pivot table can show income by source.
Back up the sheet and avoid storing unnecessary account credentials or sensitive identity documents alongside it.
A practical checklist
- Use one row per completed work item.
- Separate gross, fees and net.
- Track paid versus pending.
- Include meaningful unpaid work time.
- Review totals on a regular schedule.