How to Create a Solopreneur Business Tracking Expenses Sheet

When starting your business, you may start racking up business expenses. So, to not forget 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 and helped me make sure all the bills were paid and accounted for. Some of my clients had bills that I needed to write a check for, so if it weren’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

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

Here’s the image of what that would look like. The first column for the month is for the amount you paid, the second column for the month is for 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.

Well, I hope this helps you start tracking your expenses and when they are due. As a result, it will keep you on track and in good standing with all your vendors.

If you want more bookkeeping tips, feel free to visit our other bookkeeping tips posts. If you want help creating these useful spreadsheets, feel free to contact me. I love making these tracking sheets for clients.

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