How to Create a Solopreneur Business Tracking Expenses Sheet

When starting your business, you may start racking up business expenses. So, to avoid forgetting them, developing a business tracking expenses sheet works nicely.  It can be created at the beginning of the year for the entire year and will help you keep on top of when things are due.

This especially works well when there are bills that are issued quarterly or yearly.  I found that this worked well for all my admin bookkeeping clients (Affiliate Link) and helped me make sure all the bills were paid and accounted for. Some of my clients (Affiliate Link) had bills that I needed to write a check for, so if it wasn’t checked off on the list, I would follow up with the client to make sure she got a copy of the current bill. But why do you have to do this? I listed three of the main benefits of doing this.

Benefits of doing this business tracking expenses sheet.

1. To reduce any issues with unpaid bills.
2. It helps you remind yourself of what bills still need paying.
3. It gives you a glimpse of what needs to be paid each month and how much you will need for that month.  Quarterly months will probably be higher, so allocating money to those months works great, and you can really see those months stand out on this tracking sheet.

Now that you are committed to staying on top of your business tracking expenses, here’s how to make a business tracking expenses sheet.

Important areas to be included in the business tracking expenses sheet.

1. Name of Payee.
2. Due Date of Bill.
3. Months are indicated at the top.
4. How frequently do you get the bill? I like to use Q for Quarterly, W for weekly, and Y for Yearly. For Quarterly and Yearly expenses, I add Xs on the months that the bill is not due.
5. Total month expenses (optional). If you want to make this more like a budget as well as a tracking sheet, you can add a “total expenses” row for each column.
6. Column for the amount paid (optional). However, if you want to add the total monthly expenses row, you will need to add an amount paid column.

Examples of What the Business Expense Tracking Sheet Looks Like.

Below is an image of what this should look like. You can use Microsoft Excel or any other spreadsheet app to create it yourself and add different columns and rows you may need.

How to make the Expense Sheet more detailed

As I mentioned above, you can add the total expenses and extra columns to make it more comprehensive.

Here’s an image of what that would look like. The first column for the month shows the amount you paid, and the second column shows the date you paid it.

There is a total amount at the bottom of all the amount columns below so you can see actually how much you spent that month.

I hope this helps you start tracking your expenses and when they are due. It will keep you on track and in good standing with all your vendors.

If you want more bookkeeping tips, please visit our other bookkeeping tips posts. If you want help creating these useful spreadsheets, please contact me. I love making these tracking sheets for clients (Affiliate Link).

Here are some additional posts I found on the subject of tracking your business expenses:

How to Make a Track Spending Spreadsheet for Home Business

After writing about money for half a decade, here’s the spreadsheet I built to keep track of my spending