Difference between revisions of "How to Generate Net Income and Expense Budgets in a Spreadsheet"
Jump to navigation
Jump to search
Line 8: | Line 8: | ||
*After the last income account, insert 2 rows. | *After the last income account, insert 2 rows. | ||
*In the first row directly under last income account type “Total Budgeted Income” in column A. In the row under the last expense account type “Total Budgeted Expenses” in column A. After that skip a row and type “Total Net Income” in column A. Because these added rows are totals, you may want to make the text bold to make this information stand out. | *In the first row directly under last income account type “Total Budgeted Income” in column A. In the row under the last expense account type “Total Budgeted Expenses” in column A. After that skip a row and type “Total Net Income” in column A. Because these added rows are totals, you may want to make the text bold to make this information stand out. | ||
− | + | ===Calculations:=== | |
**Total Budgeted Income = sum of all income parent accounts. NOTE: do not include the subtotals for the parent accounts. Only use the total in each of the parent accounts. This will ensure that you do not add a number twice in the total. | **Total Budgeted Income = sum of all income parent accounts. NOTE: do not include the subtotals for the parent accounts. Only use the total in each of the parent accounts. This will ensure that you do not add a number twice in the total. | ||
**Total Budgeted Expenses = sum of all expense parent accounts. NOTE: do not include the subtotals for the parent accounts. Only use the total in each of the parent accounts. This will ensure that you do not add a number twice in the total. | **Total Budgeted Expenses = sum of all expense parent accounts. NOTE: do not include the subtotals for the parent accounts. Only use the total in each of the parent accounts. This will ensure that you do not add a number twice in the total. | ||
**Total Budgeted Net Income = Total Budgeted Income – Total Budgeted Expenses | **Total Budgeted Net Income = Total Budgeted Income – Total Budgeted Expenses | ||
*Name sheet "Net Income" or "Budgeted Net Income" and save. | *Name sheet "Net Income" or "Budgeted Net Income" and save. |
Revision as of 17:48, 7 April 2007
Budgeted Net Income Spreadsheet
To generate this report you should use the Budget Report in GnuCash that was used to produce the Budget Comparison Report.
- Copy budget report (copy function is located on the Edit menu located on the task bar) and paste on a different spreadsheet in the same workbook as the Budget Comparison Report.
- Change any colored text to the default black, and remove any underlining.
- Delete all columns containing actual information, leaving only budgeted numbers. You may also want to delete the columns pertaining to budgeted information that is already included in the Budget Comparison Report. This information is past data that has already occurred and not needed for the budget.
- If the report contains subtotals for parent accounts, make sure those subtotals are highlighted in some way to differentiate them from the totals. For example, if you chose to contain the subaccounts for Sales under Income, then you would highlight the subaccounts and the subtotals by either making the background gray (a light gray to make sure the numbers are readable once the report is printed), italicizing the font, making the font smaller, or all of the above.
- Delete numerical data in the rows pertaining to “Income” and “Expenses.” This is to help relieve confusion. The totals will be included in the end.
- After the last income account, insert 2 rows.
- In the first row directly under last income account type “Total Budgeted Income” in column A. In the row under the last expense account type “Total Budgeted Expenses” in column A. After that skip a row and type “Total Net Income” in column A. Because these added rows are totals, you may want to make the text bold to make this information stand out.
Calculations:
- Total Budgeted Income = sum of all income parent accounts. NOTE: do not include the subtotals for the parent accounts. Only use the total in each of the parent accounts. This will ensure that you do not add a number twice in the total.
- Total Budgeted Expenses = sum of all expense parent accounts. NOTE: do not include the subtotals for the parent accounts. Only use the total in each of the parent accounts. This will ensure that you do not add a number twice in the total.
- Total Budgeted Net Income = Total Budgeted Income – Total Budgeted Expenses
- Name sheet "Net Income" or "Budgeted Net Income" and save.