freelance income tracker template

Professional Independent Contractor Revenue Ledger

This document serves as a centralized financial repository for tracking project-based earnings, tax liabilities, and payment timelines. It is designed to maintain fiscal oversight for sole proprietors and consultants. Update this ledger upon every invoice issuance and payment receipt to ensure accurate year-end reporting.

Column Definitions

• Date Issued: Date (YYYY-MM-DD). The calendar date the invoice was generated.
• Project Name: Text. Descriptive identifier for the scope of work.
• Client Entity: Text. The registered name of the business entity.
• Gross Amount: Currency. The total invoice value before expenses or taxes.
• Status: Dropdown. Options: Paid, Pending, Overdue, Cancelled.
• Payment Date: Date. The actual date funds were deposited.
• Tax Reserve (25%): Currency. Calculated field for estimated quarterly tax obligations.

Essential Formulas

Tax Reserve Calculation (Apply to Row 2):

=D2 * 0.25

Total Gross Revenue (Summary Cell):

=SUM(D2:D100)

Total Pending Receivables:

=SUMIF(E2:E100, "Pending", D2:D100)

Conditional Formatting & Data Validation

1. Status Validation: Select the "Status" column, go to Data Validation, and set the criteria to "List of items," entering: Paid, Pending, Overdue, Cancelled.
2. Overdue Highlighting: Apply conditional formatting to the "Status" column. If cell equals "Overdue," set the cell background to light red and the text to bold red.
3. Payment Date Alert: Apply conditional formatting to the "Payment Date" column. Use a custom formula =AND(E2="Paid", F2="") to highlight cells in yellow if a project is marked "Paid" but no payment date has been entered.