Type the formula = F13 – E13 in cell G13 to calculate this difference and drag the formula down the column to G18. The Diff column represents the difference between the Actual and the Budget columns. Repeat this process to create the total for the Actual column using the formula =SUM( F13:F17 ). In cell E18, type in the formula =SUM( E13:E17 ), which allows you to generate the total for the Budget column. Below each month, set up four columns representing Budget, Actual, Diff, and Utilization, respectively. The headers should read JAN, FEB, MAR, …, and DEC, with all the headings listed across row 11.
In the columns to the right of column C, create 12 categories for months across the year. Add a thick Bottom Border for the Total INCOME cell. Set the cell color for Total INCOME to Close to light green 13 (hex code #cdf3cd ).ĭ. For cell C12, the font color is white, and the cell color is Close to dark green 2 from the color options (hexadecimal code #1d7e1d ).Ĭ.
This will be the standard format throughout this sheet.ī. The font style for this particular template is Roboto, with the header set at font size 10 and all other cells at font size 8. You can see our examples in the screenshot below.Ī.
Below the header, type the income categories that apply to your situation. This section will contain your income categories. In cell C12, Type “INCOME I Earn” as the column header. Open a new blank spreadsheet where you wish to create the Budget and Expense Calculator. Now let’s see how to make our own from scratch. Once you have set up the folder, click Make a copy in the bottom right corner to save a copy of this sheet.Ĭreating the Income and Expense Categories Since we are working with Google Sheets, we recommend storing it on your GDrive so you can work on it online. Rename the file as needed and save it in an appropriate folder either on your Local Computer or your GDrive. This will open up the Copy document dialog box. To make a copy of the file, open it from the link provided, go to the File menu, and click the Make a copy option.
This also gives you a glimpse of important sources of income and key expense categories that you should keep an eye on.įinally, at the top of the sheet, create your own analysis of your Income and Expenses : how much you are saving, where to put your savings based on certain categories, and a visual representation of your savings.ĭownload a copy of this worksheet from “Please put the link of file from your shared path where you save all files for the articles. Review the difference between your Budget and Expenses through the Diff column, while the Utilization column provides a small pictorial infographic with the help of a custom formula to show how your Income and Expenses move across each category. With this tool, create Income and Expense categories and add rows to each to customize the list according to your personal lifestyle. Take a look at this Budget and Expense Calculator template you can create in Google Sheets: Does Google Sheets have a budget template?.How do I make a budget in Google Sheets?.Does Google Sheets have a budgeting tool?.Creating Budgets in Google Sheets: FAQs.Creating the Income and Expense Categories.