Business

Quarterly Expense Summaries for Freelancers (US Edition)

A simple quarterly expense summary template for US freelancers: categories, a worked dollar example and a routine that makes estimated payments easier.

Editorial illustration for Quarterly Expense Summaries for Freelancers (US Edition)

A quarterly expense summary is a one-page list of what you earned and what you spent in each three-month period, grouped into a few categories. It gives you and your accountant a clear picture when estimated payments come due. The tax rules, due dates and what counts as deductible are not covered here, so ask a qualified accountant or the official tax authority for the current position.

What goes on the page

SectionWhat to listSource
Income receivedPayments by date and clientBank deposits, invoices
Software and subscriptionsMonthly toolsCard statement
EquipmentGear bought this quarterReceipts
Travel and mealsTrips and client meetingsCard, receipts, calendar
Fees and otherBank, payment platform, insuranceStatements

Keep the categories few. Six to eight lines are enough, because a long list makes the habit hard to keep.

A worked example for one quarter

Say you received $4,200 in January, $3,100 in February and $5,300 in March. Your quarter income is $4,200 plus $3,100 plus $5,300, which is $12,600.

Your spending that quarter: software $180, equipment $640, travel and meals $410, fees $95, and other $75. Add them: $180 plus $640 is $820, plus $410 is $1,230, plus $95 is $1,325, plus $75 is $1,400. The quarter shows $12,600 in and $1,400 out, so $11,200 is the net figure before any adjustments your accountant applies.

These numbers are only for illustration. Your own pattern may be lumpy, and a month with no income is common for freelancers.

How do I build the summary each quarter?

  1. Download or export your business account statement for the three months.
  2. Mark each line as income or one of your expense categories.
  3. Total each category and total income.
  4. Compare against last quarter and note anything unusual, such as a one-off equipment purchase.
  5. Save the summary and attach it to the quarter's folder with receipts.

Do this within a week of the quarter ending while you still remember what the odd payments were.

What should I set aside?

Freelancers often move a share of every payment into a separate savings pot so the estimated payment is not a surprise. What share to use depends on your income and circumstances, so ask your accountant for a figure rather than guessing. As a pure arithmetic example, if you set aside one quarter of the $12,600 above, that pot would hold $3,150.

What if my income is uneven?

Uneven income is the normal case for freelancers, so build the summary to show it. Add a column that lists income by month, then look at which months were thin. If one client made up most of the quarter, note that too. It helps you plan cash and decide how much to keep aside. Do not smooth the numbers to look better; your accountant needs to see the real pattern, and so do you when deciding whether to take on more work.

When should I check with a professional?

  • When you are not sure how to treat a purchase that is partly personal.
  • When your income pattern changes sharply during the year.
  • Before each estimated payment is due, to confirm the amount and the date.
  • When you start working with clients in other countries.

A spreadsheet is enough to start. If you later want reports you can filter and group by category, then download as CSV, a tracker's report builder can do that; SpendixAI offers this, but it is built around India and INR, so for US dollar records it is not an obvious fit.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports