Difference between revisions of "How To Generate a Budget Report"

From FreekiWiki
Jump to navigation Jump to search
Line 16: Line 16:
  
 
==Step 4: Formatting Appearance of Budget Comparison Report==
 
==Step 4: Formatting Appearance of Budget Comparison Report==
 +
 +
Delete all columns containing information of months irrelevant to your specific report.  In this case, all but one month data should be deleted. In the cell on the right of the the cell labeled "Act" type "Difference".  Drag or move column A to the far left. 
  
 
==Step 5: Calculations in Budget Comparison Report==
 
==Step 5: Calculations in Budget Comparison Report==

Revision as of 14:03, 7 March 2007

A budget comparison report compares budgeted income and expenses, and actual income and expenses over a specific period of time. By comparing budgeted and actual, a more accurate budgeting system can be developed over time to meet Free Geek's specific needs. The goal is to minimize the gap between budgeted and actual, so net income can be more predictable.

The purpose of the instructions is to assist in creating a simple and uniform report for any time specific time period. The report was formatted with the intentions of being easy to understand and print. The process begins using GnuCash. The information obtained in GnuCash is then exported into a Gnumeric file. In Gnumeric the report will be formatted and completed.

Step 1: Inputting the Budget Into GnuCash

(will be added later)

Step 2: Creating a Budget Report in GnuCash

(will be added later)

Step 3: Exporting the Budget Report into Gnumeric

(will be added later)

Step 4: Formatting Appearance of Budget Comparison Report

Delete all columns containing information of months irrelevant to your specific report. In this case, all but one month data should be deleted. In the cell on the right of the the cell labeled "Act" type "Difference". Drag or move column A to the far left.

Step 5: Calculations in Budget Comparison Report