How to Generate Net Income and Expense Budgets in a Spreadsheet

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. One thing you may want to change is One Time Income and One Time Expenses. By going to the Budget Report Options you can deselect One Time Income and One Time Expenses because they are not included in the budget.

• 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 any 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.
• Rows containing totals, such as Total Budgeted Income and Total Budgeted Expenses and Total Budgeted Net Income, should have bold text (including words and numbers in the row) 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.

Budgeted Expense Spreadsheets

• Create sheets labeled as the following:
  • Action
  • C7
  • HR and Kbees
  • Outreach and Propagation
  • Reuse and Technocrats

• Open GnuCash