If you are looking to make money blogging and want to get a handle over your blog business finances this is the tool for you. With the Excel Expense Tracker for Bloggers, you will always know what your profitability looks like at any point in time. You will also be able to view your profit growth on a daily, weekly and monthly time period with the click of a button. This tool is completely automated for your use!
Below is an in-depth explanation and review of each tab in the Expense Tracker. The tracker is meant to help you focus more on making money with your blog by saving you time when it comes to tracking your traffic, expenses and revenues.
Expense Tracker for Bloggers Instructions
Figure 1: Instructions tab.
This tab contains the instructions of how to use the tracker. It also contains the version number of the tracker for future tracking purposes.
There is a “Clear All Data” button that when clicked, will go into the “RevenueAndExpense”, “Affiliate_Revenue” and “Other_Expense” tab to clear out the data. This tool comes with initial simulated data which serves as an example of what inputs of the Expense tracker should look like.
Revenue and Expense Tracking for Bloggers
The Revenue and Expense tab contains a manual input section and a formula section:
Figure 2: Revenue and Expense tab that also allows the tracking of google analytic data.: Column B to column J above is data inputted manually. : Column L to column O contains formulas. Some are calculations like “Total Revenue” and others are formulas pulling data from other tabs such as “All Other Spend”. In order to make the formula copy down to the next filled row, all you need to do is to highlight from column L to O of the row with the formulas, then click on the lower right hand side of the selection and drag down to the desired row.  to : This box should not be deleted. Feel free to delete the actual numbers in “” but do not delete the values in the blue box. As you can see, this populates some of the column names in row 5. Instead of changing the names in row 5, you make the updates to the values inside the blue box. This was done to make sure that the user’s inputs are controlled in order to not mess up Power Query requests.
The Refresh Data button is to be clicked in order to update the values from the whole worksheet so that they can be viewed in the Dashboards. Without clicking this button, any new data added cannot be accessed in the Category and Dimension Dashboard.
Category and Dimension Dashboard
In both dashboards, you can choose how you want to view the reports. You can view the reports as daily, weekly or monthly numbers. You can choose what date period you want to view. So, if you wanted to know how your business blog did for the period between 11/24/18 and 12/2/18 as a daily report, you just make the following selections to the provided filters in the Category Dashboard:
Figure 3: Time Period, Categories and Date filters for automated graphical viewing.
Then your graph will look something like this (note that dummy values have been put into the Expense Tracker for illustration purposes only):
Figure 4: Graphical results from filter selection in Figure 3.
If you wanted a daily report instead, it is literally as easy as changing the “Time Period” filter above and clicking on “Daily” and you get the below graph instantly:
Figure 5: Graphical results from filter selection in Figure 3 and changing the Time Period to “Daily”.
Maybe you wanted to see how much in product sales your blog did for the same time period vs revenue made from affiliate sales. All you do is make the following selection to the Categories section:
Figure 6: Selecting affiliate sales and product sales from Categories filter to see how they compare when graphed.
And you will get the following graph instantly:
Figure 7: Results from Categories filter selection in Figure 6.
As you can already see, this makes it extremely easy to compare data over literally ANY period of time.
As mentioned, there is also the Dimension Dashboard. Here you have similar filters that allow you to look at your analytics. You can look at your page view, session, pages/session, CPM and eCPM. CPM and eCPM is reported as both session CPM (CPM_Session) and Pageview CPM (CPM). The same holds for eCPM (also known as RPM). If these acronyms confuse you, don’t worry… see below:
CPM is simply Cost per Mille or cost per thousand impressions. This number is what is used in the industry to tell you how much you are spending on 1000 sessions or pageviews to your blog. eCPM, for the purpose of this Expense Tracker stands for “earning CPM”. So, it is your revenue per 1000 sessions or pageviews. Feel free to change that to say RPM or something else if you like.
In the Dimension Dashboard, you can look at the analytics as a graph AND as a line chart. See below:
Figure 8: Dimensions Dashboard with filter selections for automated data viewing.
As you can see, the dashboard is very simple and straight forward. It is a huge time saver.
If you don’t like the graph colors that have been automatically chosen by Excel, feel free to change it on your own by going to where you want to have the color changed, right clicking on it and choosing your appropriate “Fill” color.
Affiliate Revenue Tracking for Bloggers
Note that the tool comes in two different colors (blueish and lavender). You can see the lavender screenshot below:
Figure 9: Affiliate Revenue tracking tab. This tab is for users to input all the revenues they receive from affiliate Networks such as Max Bounty, Impact Radius, Teachable etc.  This table allows you to see the revenue earned by each network. You input the index number starting from 1, you input the Network Name in Column K (feel free to change this title to your liking) and you highlight the cell with the formula under “Revenue”, right click on the little rectangular dot on the lower right hand side, and drag down to fill to the next line.
Other Expense Tracking for Bloggers
Here you will input your “other expenses”. For us, we place general expenses relating to stock photos, creative content, Tailwind and anything that we don’t need to specifically have a category for.
Profit Tracking for Bloggers
Figure 10: Profit/Financial Overview tab that tracks all the important stuff in a nutshell.
This is the Financial Overview tab. You can rename it to say “Financial Overview” if you like. It aggregates all the different expenses and revenues along with Google analytic data like sessions and pageviews (not pictured above). In this section, there is also a calculation of CPM and eCPM (both by session and pageview which is also not pictured above). These are important metrics to keep an eye on when it comes to making money online with your blog.
In order to add a date, all you have to do is click the “Click to Extend Dates” button and input the number of days to extend the date. After that, the excel sheet will take care of the rest and will inform you that the “date extension is complete” with a pop-up message. As we mentioned before, everything that can be automated is automated for you. The only thing that is needed is for you to input the data.
If you have bought this tool, please be sure to give us your feedback by sending us an email or by commenting below. If you would like to sell this tool yourself as an affiliate because you found it highly useful, feel free to reach out to us as well!
Click below to purchase the tool today for only $12!