excel spreadsheet for monthly business expenses

#Excel spreadsheet for monthly business expenses how to
#Excel spreadsheet for monthly business expenses software
#Excel spreadsheet for monthly business expenses free

So this is where you would add in any contractors or freelancers that you use under “Production (Fixed Rate)” And you can see in the example below, I add in around 3% for merchant fees (which is when you collect money through Stripe or PayPal for example).Business expense spreadsheet 10 (37.50 KB) Types of spreadsheets for business expenses On this page, you add in the cost of goods sold. The example I use in the spreadsheet is based on doing some project work with a little bit of recurring revenue. So this sheet will tell you your monthly revenue. The P&L is where you're basically going to break down what you earn, what you spend and what your margins are. You then know what your employees cost you per month.

#Excel spreadsheet for monthly business expenses software

For example, leasing for laptops or software such as Adobe Creative Cloud. On this sheet, you also enter your expenses for your employees. This is important because what this sheet also does is calculate things like your 401k matching (or superannuation if you're in Australia).

What this sheet then does is calculate your headcount based on the number of staff that you entered.

are actual employees – NOT contractors who invoice you for their services.

aren’t working on the client projects.

Underneath that, enter the salary of any staff members that you have that: The next sheet we want to look at is the labour expenses.įirst enter in the base salary that you want to give yourself and this spreadsheet will break that down to a monthly amount:

You don’t want to include any software on this page that you are using for what we call “production” which is any software that you're using to actually build projects for clients.įor example, if you are using an SEO tool such as Moz or Ahrefs, then you wouldn’t include that on this sheet. Remember, this is only software that you’re using to run your business. From there you can work out how much you are paying monthly in software expenses. On this tab, you’ll list out all the software that you use such as Calendly, GSuite, accounting software, Zoom etc. I've given you some examples to get you started: And this is where you basically just list out all of the software that you use to run your business. The first sheet that we're looking at is software expenses. Note: Once you receive your spreadsheet in your inbox, you need to make a copy and save it to your own Google account and then you can start editing.

#Excel spreadsheet for monthly business expenses how to

Then click the download button to receive the spreadsheet template and then watch this video training so you know exactly how to use it With the help of this spreadsheet and a by making a few tweaks in your business then you will be able to expand your revenue, pay yourself a salary and have profit leftover at the end of the year. Well, then this spreadsheet is going to be a game-changer for you.

At the end of the year is there little or no profit left over?.

Making somewhere between 70 and 100k a year in revenue?.

If you are a freelancer or small business owner offering services in the creative space (such as marketing, web design or business consulting) then this spreadsheet is for you.

#Excel spreadsheet for monthly business expenses free

I will also give you your own free copy and show you exactly how to fill it out. In this video, I reveal the only spreadsheet you need to run a successful business and grow your revenue.