Tax and GST

How to total your business expenses at year end (US freelancers)

Add up a year of business expenses in dollars without guessing: tag every line, split shared costs, reconcile to statements and total with SUMIFS before you file.

Editorial illustration for How to total your business expenses at year end (US freelancers)

To total a year of business expenses, give every transaction one tag, split anything shared between work and personal use, and add each tag with a SUMIFS formula. Then check that the tagged lines plus everything untagged equal your statements. The result is a list of totals by type that your tax professional can review rather than a single number nobody can explain.

Step one: gather every source of spending

  • Business and personal bank accounts you used for work costs.
  • Every credit card, including old ones still billing a subscription.
  • Payment platforms where fees are taken before payout.
  • Cash receipts and reimbursements.

Your tax year may not match the calendar year, so check which dates your own situation uses before you start. Export or copy each source into one sheet with columns A to E: Date, Description, Type, Business share as a decimal, and Amount in dollars.

Step two: tag and split

  1. Give each line a type from a short list, such as Software, Travel, Home office, Phone, Fees, Training, Supplies, Other.
  2. For a fully business cost, set the share to 1.
  3. For a shared cost, put your documented share, such as 0.4 for a phone used 40 percent for work.
  4. Add a sixth column, Business amount, with =E2*D2, and fill it down.
  5. Mark transactions that were reimbursed by a client, so they are not counted twice.

Step three: total by type

With types in column C and business amounts in column F, this formula gives one type: =SUMIFS($F$2:$F$800,$C$2:$C$800,"Software"). To limit it to a date range, add =SUMIFS($F$2:$F$800,$C$2:$C$800,"Software",$A$2:$A$800,">="&DATE(2026,1,1),$A$2:$A$800,"<="&DATE(2026,12,31)). Put each type name in a cell and refer to it, so you can copy the formula down.

What does a small worked total look like?

TypeTotal spentWork shareBusiness amount
Software$1,2001.0$1,200
Phone$9600.4$384
Home office$3,1201.0$3,120
Travel$8501.0$850
Grand totaln/an/a$5,554

Check: 1,200 plus 384 plus 3,120 plus 850 is 5,554. The phone line is 960 times 0.4, which is 384. These are example numbers. Whether each type is allowed, and in what amount, is for your tax professional to confirm.

How do I know the total is complete?

Reconcile. Add up all debits in your statements for the period, then add up the business amounts and the private amounts you tagged. If the first number is higher than the second, you have untagged lines. Find them and tag them. Do this before you trust any total.

What if my statements are messy?

Messy statements are normal. Start with the biggest lines, because sorting by amount, largest first, usually covers most of the value in a few minutes. Tag those, then work down. Lines below a small threshold of your own choosing can be tagged in bulk by merchant, for example every charge from one software company at once. Keep a list of anything you were unsure about, and ask your tax professional at the end instead of stalling on each one.

How do I treat refunds and reimbursements?

A refund reduces the original cost, so enter it as a negative amount against the same type. A reimbursement from a client is more subtle: if a client repaid a travel cost, the cost and the repayment are linked, and your tax professional will tell you how to show them. Mark both lines with the client name so the pair is easy to find. Never delete the original line; the record should show what really happened.

Before you hand it over

  • Totals by type, with the share used on each shared line
  • Receipts or invoices in folders by month
  • A short note explaining how you worked out each share
  • A list of questions for your tax professional

If you have spending in other currencies, put the dollars that actually left your account in the amount column, and the original figure in a note. SpendixAI is built around India and rupees, so it will not suit a US filer; a sheet like this one does the job.

SPENDIXAI JOURNAL

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

Explore your reports