| A | B | C | D | |
|---|---|---|---|---|
1 | ||||
2 | ||||
3 | ||||
4 | ||||
5 | ||||
6 | ||||
7 | ||||
8 | ||||
9 | ||||
10 | ||||
11 | If you would like help creating a small business budget specifically tailored to your business needs, we can help. In addition to providing small business bookkeeping services, we are here to help you find ways to increase profitability! Contact us today for a free consult. consult@yourcloudbookkeeper.com | 678-915-1987 | |||
12 | ||||
13 | ||||
14 | ||||
15 | ||||
16 | ||||
17 | ||||
18 | Follow these steps as you use the budget templates on the corresponding tabs: | |||
19 | ||||
20 | Step | Action | ||
21 | 1 | To save this file in your Google Drive: Click "File" Click "Make a copy" To save this file on your computer: Click "File" Click "Download as" Click "Microsoft Excel" | ||
22 | 2 | Select the "COGS Budget" tab if you have Cost of Goods Sold Select the "Non-COGS Budget" tab if you do not have Cost of Good Sold | ||
23 | 3 | To add your logo: Add it to the top left where it says "[Logo Goes Here]" In the main navigation click "Insert" then "Image" and upload your logo | ||
24 | 4 | Replace "[Company Name Goes Here]" with the name of your company | ||
25 | 5 | Under the "Income" section, there are 3 rows labeled "[Add income category here if needed. Delete row if not needed.]" If you do not have additional income sources to add, delete these rows To add income categories, edit the names of the rows and replace them with the names of your income categories | ||
26 | 6 | Common expense categories have been listed for you You can edit, add or delete any as needed | ||
27 | 7 | The only numbers you are editing during the budgeting process are the ones in the Budget columns (e.g. "JAN Budget") | ||
28 | 8 | Do not edit the values in the following rows as they are formulas that will automatically calculate for you: -Total Income -Total Fixed Expenses -Total Variable Expenses -Total Expenses -Net Income Do not edit the values in the following columns as they are formulas that will automatically calculate for you: -2019 Budget -2019 Actual -YTD Variance | ||
29 | 9 | Do not edit the values in the variance columns These are formulas that will automatically calculate for you | ||
30 | 10 | As months close, enter actuals in each category and you'll be able to see the variance and totals on a monthly and yearly basis for each category and can also compare fixed vs. variable | ||
31 | ||||