(1) Calculate total income per month: In Cell B7 enter =SUM(B4:B6), then drag the Fill Handle to apply this formula to Range C7:M7. Step 2: Enter your budget data of income and expenses into the table, and calculate the total incomes of every month and every item: Step 1: Prepare a table, and enter its row headers and column headers as following screen shot shown: The following steps will walk you through customizing a monthly budget template in Excel.

You can typically select the date range.Although there are so many budget templates for downloading, you may still want to make a custom monthly budget template based on your needs. But you could do as many months as you’d like. I choose to do this monthly, so it isn’t so overwhelming. Log in to your online account and export your spending data. Export data from bank or credit card company

So without further ado, let’s look at how you can easily categorize and review actual spending. Plus, this gives you a great way to review each charge and know exactly what is going through your accounts. I’ve found instances where charges have been placed in the wrong bucket on several occasions. And some people use an online tool like Personal Capital to track and review spending. Some banks and credit card companies provide spending reports. This post will help with documenting your actual spending. It’s a tool you can use to regularly review spending habits + plan and budget several months out. This is a basic version of how I used to forecast as a finance analyst. This goes hand-in-hand with one of my very first posts on this blog: How to Develop a Personal Finance Forecast. I use this method for both personal and small business finances. You may have charges you’ve been meaning to cancel or inaccurate charges from companies. And before you doze off or close the page 😉 - this will save you some precious time + give you a way to review your spending in detail on a regular basis. Today I’m sharing a really easy way to categorize spending with the use of Microsoft Excel Pivot Tables. I used to be a financial analyst and I’m also an excel geek at heart. Welcome! Why I am posting personal finance on a food blog? I wrote this post before I decided to focus mainly on food blogging.

Daily expenses excel template