Freelancer Income & Expense Tracker (Spreadsheet + Printable Logs)

A simple money tracker for freelancers and self-employed people whose income changes from month to month. Log invoices and expenses and see your monthly profit. Set aside a percentage for tax, and plan a steady 'salary' for yourself from uneven income.

★ WHAT YOU GET

• 1 spreadsheet (.xlsx) with 7 tabs: Start here, Monthly summary, Setup, Income, Expenses, Pay yourself, Clients

• Income log for 300 invoices: client drop-down, status (Paid / Sent / Overdue / Draft), date paid and automatic days-to-pay

• Expense log for 400 costs: category drop-down, business-use % for mixed costs, receipt kept Yes/No

• Monthly summary: income received, expenses, profit, your tax set-aside %, what's left, amount invoiced, outstanding and overdue totals, expenses by category and a chart

• Pay yourself tab: choose a fixed monthly amount and see a running buffer that shows if good months cover lean months

• Clients tab: invoiced, received, outstanding and average days to pay per client (up to 30 clients, 20 expense categories)

• 5-page printable PDF in US Letter and A4: year at a glance, income log, expense log, invoice tracker and a monthly money review

★ COMPATIBILITY

Made for Google Sheets (free Google account; upload the .xlsx to Google Drive, then open it with Google Sheets), Microsoft Excel 2010 or later, and LibreOffice Calc. Formulas were checked for Google Sheets and Excel compatibility (standard functions only, no macros, no add-ins) and tested in LibreOffice Calc. Unzip the download first (double-click on most computers). Best used on a computer or tablet. Enter dates as real dates (e.g. 3/15/2027 or 15/03/2027).

Printable PDFs in US Letter (8.5 × 11 in) and A4. Print at home or at a print shop (choose 'Actual size' or 'Fit'). The PDFs are for printing and writing by hand. They are not fillable forms.

★ GOOD TO KNOW

• The tax set-aside is a percentage YOU choose. It is not a tax calculation, doesn't know your country's rules and isn't tax, legal or financial advice.

• No currency symbol, so it works in USD, GBP, AUD, EUR or any single currency.

• Example rows are included so you can see how it works. Delete them before you start.

• Sheets are not locked, so you can rename categories and adjust anything.

★ For your own household or your own small business records. Please don't share, resell or redistribute the files.

★ Digital download: nothing physical is shipped. You get one .zip file; unzip it to get the files.

★ 14-day promise: if a file is faulty or not as described, contact me within 14 days and I'll fix it or refund you.

Made with the help of AI tools (drafting text, layouts and formulas); I chose the content and reviewed and edited every file.