How to Track Freelance Income and Expenses for Taxes
USA FREELANCE CALCULATOR / RECORDKEEPING FIELD GUIDE
Build a clear picture of every dollar.
A client pays you $2,400, but your bank shows a $2,208 deposit. Another client still owes you for last month’s work. Your internet bill covers both project files and household use. If you build your books from bank deposits alone, you’ll miss part of that story.
This guide is for U.S. freelance service providers who generally report their business on Schedule C. The examples assume a sole proprietor and use the cash method unless stated otherwise.
Set up a system you can keep using
Start with three spreadsheet tabs and one document folder. Use Income for invoices and payments, Expenses for business costs, and Monthly Summary for reconciled totals and cash movements. A notebook and organized files can work for a handful of transactions. Bookkeeping software may save time if you handle multiple accounts or batch payouts. Make sure you can trace each total back to its transactions and documents.
Copyable starter columns. This is an example layout, not an IRS-mandated spreadsheet format:
- Income tab — invoices section (one row per invoice): Invoice ID · client · invoice date · due date · invoiced total · balance still unpaid · status · source-document ID.
- Income tab — payments section (one row per receipt or installment): Payment ID · invoice ID · date received/available · gross amount received · platform fee · net payout · bank deposit date · payout/receipt ID. Add a separate note for restrictions or held balances when relevant.
- Expenses tab (one row per purchase): Date paid · vendor · category · total charge · business-use percentage · potential business amount · payment source · receipt ID · business purpose · review flag.
- Monthly Summary tab (one row per month): Recognized gross income · eligible business costs · illustrative business profit · opening bank balance · deposits · bank payments · reserve transfers · owner draws · estimated tax payments · closing bank balance · unpaid invoices.
Keep invoice totals in the invoices section and sum amounts actually or constructively received in the payments section when preparing a cash-method income total. Don't count an invoice again each time a partial payment arrives. For the bank balance, use cleared deposits and withdrawals rather than invoice totals.
IRS requirement. Keep records that clearly show business income and expenses and support what you report on your federal tax return. The IRS generally lets you choose a system that suits your business. Some kinds of expenses require additional proof. IRS recordkeeping guidance
Practical setup. A dedicated business account or card can make transactions easier to sort. A separate savings account can help you keep tax money available. These are bookkeeping choices for a sole proprietor, subject to separate entity or bank obligations. If you use a shared account, label personal transactions and keep the evidence for business purchases you pay for personally.
Record invoices, payments, and income dates
Use your invoice to track what the client owes. Give it a unique ID, list the services and amount, and include the issue date, due date, and payment instructions. These fields are a practical template. If a client pays in installments, log each payment under the same invoice ID and update the remaining balance.
Your accounting method determines when you include an amount in income for federal tax purposes.
REFERENCE TABLE
| Method | When income generally counts | When expenses generally count |
|---|---|---|
| MethodCash | When income generally countsWhen you actually receive it or it becomes available to you without substantial restriction. | When expenses generally countWhen paid. Prepayments and assets can have separate timing rules. |
| MethodAccrual | When income generally countsWhen your right to receive it is fixed and the amount can be determined with reasonable accuracy. Special rules can apply. | When expenses generally countWhen the liability is fixed, its amount is reasonably determinable, and economic performance has occurred. For many purchases, that means when the goods or services are provided. |
Say you finish a $900 project in December, bill the client that month, and first receive the money in January. If the funds were unavailable to you until January and nobody received them as your agent in December, a calendar-year cash-method freelancer generally includes the $900 in the following tax year. Under accrual, the same $900 generally belongs to the earlier tax year if the right to payment was fixed then and the amount was known.
A bank deposit can come after the tax recognition date. If a processor makes funds available to you without substantial restriction in December and you wait until January to withdraw them, the cash method generally counts the income in December. That’s constructive receipt. Receipt by your authorized agent can also count as receipt by you. If a year-end platform payment is held, keep the transaction and release dates and check the terms and facts before choosing the tax year. Use your established accounting method consistently. Changing it generally requires IRS approval. IRS Publication 538
Sample freelance income log
Use one row per payment and link it to the invoice or order. Keep the invoice amount in your invoice list, with its due date and open balance, so partial payments don’t cause you to total the same invoice twice. These two views show the dates and dollars for the same two paid invoices.
REFERENCE TABLE
| Invoice and payer | Sent | Received or available | Bank deposit | Status and proof |
|---|---|---|---|---|
| Invoice and payerINV-104 · Alder Studio | SentMay 3 | Received or availableMay 10 | Bank depositMay 13 | Status and proofPaid · payout P-0513 |
| Invoice and payerINV-105 · River Edit Co. | SentMay 6 | Received or availableMay 17 | Bank depositMay 17 | Status and proofPaid · ACH confirmation A-0517 |
REFERENCE TABLE
| Invoice | Payment method | Gross billed | Gross paid | Fee withheld | Net deposit |
|---|---|---|---|---|---|
| InvoiceINV-104 | Payment methodMarketplace | Gross billed$2,400 | Gross paid$2,400 | Fee withheld$192 | Net deposit$2,208 |
| InvoiceINV-105 | Payment methodDirect bank transfer | Gross billed$1,350 | Gross paid$1,350 | Fee withheld$0 | Net deposit$1,350 |
Here, the marketplace funds first became available without restriction on May 10, and there was no earlier receipt by the freelancer or an agent. The tax recognition dates in this cash-method example are May 10 and May 17. If an invoice is paid in multiple installments, total the actual gross payments recognized in the period, not the invoice’s full billed amount on every payment row. Keep those dates in their own field if they differ from the dates you use to match deposits. For cash or checks, note who paid you and when, then link a receipt, remittance note, or deposit reference.
Reconcile gross payments, fees, and deposits
For INV-104, the client paid $2,400. The marketplace withheld $192 in fees, leaving $2,208 to deposit. The example assumes an 8% fee on this transaction, with no refunds, taxes collected for a government, or other adjustments. Use the actual fee shown on your report for each transaction.
Record the $2,400 gross receipt and record the $192 fee once as an eligible business cost. Use the $2,208 as the amount to match in your bank feed. If you import the platform transaction and then import the bank deposit, match the deposit to the payout already recorded. Counting the deposit as another sale inflates revenue. Subtracting the fee from the already-net $2,208 gives $2,016 and counts the fee twice.
For a batch payout, tie each underlying transaction to the same payout ID. Check fees, refunds, chargebacks, and other adjustments individually. If money remains on the platform at month-end, reconcile the opening balance, activity, transfers, and closing balance before treating a difference as missing income. Identify any sales tax collected for a government separately and check the applicable reporting rules. For examples specific to marketplaces, see the USAFC guide to platform fees and Form 1099-K.
Form 1099-K reports gross payments processed without adjustments such as fees or refunds. Compare each information return with the transactions it covers. Your books can also contain direct payments outside that form. Report all taxable business income, including income for which you receive no information return. If two forms appear to cover the same payment, compare the underlying records, report the income once, and contact the issuer if a form is incorrect. IRS guidance on using Form 1099-K
Track business expenses and document mixed use
In your expense log, capture the full charge, the part attributable to business, the payment source, and a reference to the supporting document. A useful business purpose is specific enough to recognize later, such as “color proofs for Alder Studio.” Flag equipment and costs with potential deduction limits for review.
Sample freelance expense log
REFERENCE TABLE
| Paid and vendor | Category | Full cost | Business use and amount | Paid from | Proof and purpose |
|---|---|---|---|---|---|
| Paid and vendorMay 7 · ProofDesk | CategorySoftware | Full cost$64 | Business use and amount100% · $64 | Paid fromBusiness debit | Proof and purposeE-051 · client proofing |
| Paid and vendorMay 15 · City Fiber | CategoryInternet | Full cost$90 | Business use and amount40% · $36 | Paid fromPersonal checking | Proof and purposeE-052 · bill and usage notes |
| Paid and vendorMay 21 · Paper & Ink | CategorySupplies | Full cost$28 | Business use and amount100% · $28 | Paid fromBusiness debit | Proof and purposeE-053 · project print proofs |
Log the $192 marketplace fee under INV-104, or link it into this expense log if you calculate your monthly expense total there. Set up the summary to pull that fee from one place.
Suppose your household pays $90 for internet and a representative usage log supports 40% business use. The business share is $90 × 40% = $36, leaving $54 personal. Keep the bill and the notes behind the percentage. For example, record business sessions across a representative period and compare them with overall household use, taking other users into account. For a shared mobile plan, itemized business calls or data usage may help support the allocation. Revisit your estimate when use changes. The 40% is specific to this example.
Eligible business expenses generally must be ordinary and necessary. Track the business share of mixed costs and check any category-specific limits or reporting rules before filing. See the USAFC freelance tax deductions checklist for eligibility questions and the treatment of items such as equipment, meals, and home offices. IRS Publication 583 · IRS Schedule C instructions
Close the month and check what you can transfer
Reconcile your books to your statements before planning a transfer or estimating taxes.
- Match income. Compare bank deposits with direct client payments and platform payouts. Explain timing differences and identify duplicate imports, owner contributions, or transfers between your own accounts.
- Match spending. Compare business bank and card activity with your expense entries, receipts, and refunds. Match a card payoff to the card balance. The underlying purchase belongs in your expense records once.
- Review unpaid invoices. Keep an open-invoice list with due date, balance, and next follow-up. An overdue $675 invoice goes on that list. It contributes $0 to collected cash until paid and stays outside cash-method income here, assuming no actual or constructive receipt.
- Summarize profit and cash separately. Calculate business profit from recognized income and eligible costs. Reconcile the operating balance from actual cash movements, then check upcoming bills and amounts already earmarked.
Worked monthly close
Assume both client payments and all listed expenses belong to May, both deposits clear in May, and the three operating costs and platform fee qualify as shown. There are no other operating transactions or timing differences.
01 / PROFIT VIEW
What the business earned
| Business profit for May | Amount |
|---|---|
| Business profit for MayGross receipts ($2,400 + $1,350) | Amount$3,750 |
| Business profit for MayMarketplace fee | Amount−$192 |
| Business profit for MaySoftware, business share of internet, and supplies ($64 + $36 + $28) | Amount−$128 |
| Business profit for MayIllustrative profit before personal taxes | Amount$3,430 |
02 / BANK BALANCE VIEW
What remained in checking
| Operating checking account for May | Amount |
|---|---|
| Operating checking account for MayOpening balance | Amount$720 |
| Operating checking account for MayDeposits ($2,208 + $1,350) | Amount+$3,558 |
| Operating checking account for MaySoftware and supplies paid from this account ($64 + $28) | Amount−$92 |
| Operating checking account for MayTransfer to a separate tax reserve | Amount−$550 |
| Operating checking account for MayOwner draw to personal checking | Amount−$1,250 |
| Operating checking account for MayFederal estimated tax payment from operating checking | Amount−$300 |
| Operating checking account for MayClosing operating balance | Amount$2,086 |
The fee is already reflected in the deposit. The $36 internet share reduces business profit because it was an eligible business cost paid by the owner. The $90 bill cleared personal checking, so no internet payment appears in the operating account. If $420 of upcoming bills is committed, $1,666 remains in operating checking before any additional buffer or planned spending.
Label a payment to yourself as an owner draw. Match the two sides of a tax reserve transfer so it shows up as cash moved between accounts. Record a federal estimated tax payment separately with its date, tax year, amount, and confirmation. All three stay outside ordinary Schedule C expenses for the sole proprietor. Here, $550 is earmarked for later and $300 is paid to the IRS. Your reserve can vary with projected tax, withholding, and prior payments. See the USAFC quarterly taxes guide for when estimated payments may apply. IRS estimated tax guidance · IRS Schedule C instructions
Use your reconciled income and expense records to plan next month’s budget in the Budget Planner. Start with expected gross receipts, list business and personal costs separately, and set aside money for taxes. Include platform fees once in business costs.
Keep receipts and records you can retrieve
Save invoices, payment confirmations, receipts, bank and card statements, and marketplace reports. For expenses, keep enough evidence to establish the date, vendor, amount, payment, and what made the purchase a business cost. A card statement and itemized receipt can work together when the statement alone gives you only the merchant and total. For vehicle use and some travel or meal expenses, additional substantiation can apply. IRS guidance on supporting records · IRS Publication 463
Digital filing routine. Create folders by tax year and then by type, such as invoices, receipts, statements, and tax forms. Use filenames you can search, such as 05-15_City-Fiber_90-00_E-052.pdf, and put that reference in the ledger. Check that scans include every page and remain legible. Back up the ledger and documents, test that you can open the copies, and export records before you lose access to a bank, marketplace, or bookkeeping account.
IRS rules for electronic storage. Records must remain complete, accurate, legible, and retrievable. A system that replaces paper records must index, preserve, and reproduce them, protect their integrity, and make them accessible to the IRS. Keep originals until you have tested the replacement system and have procedures to keep it compliant. Keep any other records or originals required under applicable rules. IRS Publication 583 · IRS Revenue Procedure 97-22
Mileage example for tax year 2026. Log the date, destination, business purpose, and miles for each trip, and keep the annual mileage records needed to support business use. If eligible for the standard mileage method, 120 qualifying miles in January–June at 72.5¢ and 120 in July–December at 76¢ produce $87.00 + $91.20 = $178.20. The trip dates determine the applicable period. Look up the rates for the year you are filing. IRS mileage rate table · IRS Announcement 2026-11
How long should you keep tax records?
REFERENCE TABLE
| Situation | General federal retention period |
|---|---|
| SituationRoutine income tax return | General federal retention periodGenerally 3 years after filing. For an early-filed return, generally count from the due date. |
| SituationRefund or credit claim after filing | General federal retention period3 years after the original return was filed or 2 years after the tax was paid, whichever is later. |
| SituationOmitted income greater than 25% of gross income shown on the return | General federal retention period6 years. |
| SituationLoss claim for worthless securities or a bad-debt deduction | General federal retention period7 years. |
| SituationNo return filed or a fraudulent return filed | General federal retention periodIndefinitely. |
| SituationBusiness property or equipment | General federal retention periodGenerally through the limitations period for the year you dispose of the property. |
| SituationEmployment tax records, if you have employees | General federal retention periodAt least 4 years after the tax is due or paid, whichever is later. |
Keep records as long as they remain relevant to your return. Review any state, contract, lender, or insurance requirements before discarding them. IRS retention guidance · IRS Publication 583
Build a routine you can repeat
- As transactions happen. Send invoices, save receipts, and note business purpose while you remember it.
- Weekly. Match payments to invoices, check automated categories, attach missing records, and follow up on past-due balances.
- Monthly. Reconcile bank, card, and platform statements. Review profit, upcoming bills, and the cash available before you transfer money.
- At year-end. Check payments and expenses around the tax-year cutoff. Compare information returns with the ledger as they arrive and resolve discrepancies. Export a year-end summary, account statements, payment confirmations, and supporting documents for filing or for your tax preparer.
Once the books are reconciled, you can use the USAFC Freelance Tax Estimator for planning. This guide covers general U.S. federal bookkeeping for Schedule C service businesses. State and local rules and the treatment of other business entities can differ.
Frequently asked questions
Can I track freelance income and expenses in a spreadsheet?
Yes. A spreadsheet can work if it clearly shows your income and expenses and you can retrieve the documents behind each entry. Add rows as transactions happen and check the totals against your statements. IRS recordkeeping guidance
Do I report freelance income if I never got a 1099?
Yes. Report taxable business income under your accounting method, including payments that arrived by cash, check, or direct transfer. Use your own payment records to account for them. IRS guidance on using Form 1099-K
Is a bank or credit card statement enough to prove an expense?
It can help establish payment. If the statement leaves the item or business purpose unclear, keep an itemized invoice or receipt and a short purpose note. If a receipt is missing, try requesting a replacement and retain other supporting evidence. Some expense categories have stricter proof rules. IRS guidance on supporting records · IRS Publication 463
How do I record an expense I paid with a personal card?
Enter the business portion, label the payment source as personal, and attach the receipt and proof of payment. Keep it out of the business checking reconciliation unless cash actually moved through that account. If you later transfer money to yourself to cover it, match that transfer to the original record so the purchase is counted once.
Copy this bookkeeping checklist
- Log each invoice, due date, payment, and open balance.
- Record gross payments and match fees and payouts once.
- Save receipts and note the business purpose and any mixed-use allocation.
- Reconcile bank, card, and platform records and follow up on overdue invoices.
- Track draws, tax-reserve transfers, and federal estimated payments separately.
- Back up records and confirm the applicable retention period before deleting anything.
Official IRS references
- Recordkeeping and types of supporting records
- Publication 538, Accounting Periods and Methods
- Publication 583, Starting a Business and Keeping Records and Revenue Procedure 97-22, Electronic Storage
- What to do with Form 1099-K
- Schedule C instructions
- Estimated taxes
- Publication 463, Travel, Gift, and Car Expenses
- Standard mileage rates and Announcement 2026-11
- How long to keep records