Track Your Business Expenses with This Spreadsheet

2 min read

Tracking our business expenses is as important as tracking our incomes. Uncontrolled expenses can quickly ruin our earnings.

When I started being self-employed, I didn’t track my expenses. I didn’t know what my money was going. I was afraid of expending money and very insecure of investing money to grow my business.

After a while, I created a spreadsheet to track my business expenses, and I’ve been improving it since then.

Today I’m sharing this automated spreadsheet with you.

spreadsheet to track expenses

Why using a Spreadsheet to track your business expenses?

  • Be aware of how much your business expenses are
    Track your annually, monthly or one-time expenses.
  • Have a list of all your business expenses
    You can keep control of all your online subscriptions, studio rent, supplies, fees, promotion and any other expenses you might have.
  • Track how your business expenses evolve every year
    The spreadsheet contains a separate sheet for every year. It’s very easy to set a new sheet when a new year comes just duplicating the current sheet. Having different sheets makes it very easy to compare your business expenses between years.

What does the Expenses Spreadsheet include?

  • A list for the annually fixed expenses.
  • A list for the monthly fixed expenses.
  • A list for one-time expenses.
  • A list that sums all the totals.

How to use the Spreadsheet

You can create a copy of my Google Spreadsheet and use if for yourself. Just follow the link and go to File > Make a copy.

Create a copy of the Spreadsheet

Using this spreadsheet is very easy. Add the business expenses you pay once a year in the annually list, add those you pay once a month in the monthly list, and those that you pay them just once in the variable list.
That’s all. Everything is automated.

When a new year comes, duplicate the sheet and erase the variable expenses. If you cancel or modify any of your fixed expenses, just update the spreadsheet.

Conclusions

Accounting can be boring but is an essential part of business. The process becomes very easy using this spreadsheet. Just add the expenses immediately after you pay them.

Even if you work with an accountant or a bookkeeper, using this spreadsheet will help you to be in control of your expenses and know exactly where your money is going.