Create a Budget Planner Report
If you want a budget planner report that looks like this example, follow the steps listed below.
Note
Maximize your browser to display this example.
Report period mm/ccyy
Period ending mm/dd/ccyy
All amounts converted to US currency
All amounts rounded to ONES
|
GL acct |
Description |
|
|
|
|
|
|
|
|
|
|
05/yy |
06/yy |
07/yy |
08/yy |
09/yy |
10/yy |
11/yy |
12/yy |
01/yy |
|
542 |
COGS |
|
|
|
|
|
|
|
|
|
BUDG: |
170,000 |
370,000 |
500,000 |
500,000 |
800,000 |
900,000 |
730,000 |
120,000 |
50,000 |
|
ACT: |
160,878 |
363,888 |
513,104 |
493,574 |
792,141 |
861,963 |
727,835 |
104,173 |
20,732 |
|
VAR: |
9,122 |
6112 |
13,104- |
6426 |
7859 |
38037 |
2165 |
15827 |
29268 |
|
|
|
|
|
|
|
|
|
|
|
|
820 |
State taxes |
|
|
|
|
|
|
|
|
|
BUDG: |
15,000 |
15,000 |
15,000 |
15,000 |
15,000 |
15,000 |
15,000 |
15,000 |
15,000 |
|
ACT: |
12,987 |
13,203 |
11,202 |
15,099 |
16,132 |
15,656 |
14,876 |
14,132 |
14,323 |
|
VAR: |
2013 |
1797 |
3798 |
99 |
132- |
656- |
124 |
868 |
677 |
-
Use the Financial Reports Format Maintenance (GFM) program to create a format like this:
|
Seq |
|
Accounts |
Total 1 |
Type |
Total to add to |
Line desc |
Spaces to indent |
Lines to space |
Under-line |
|
100 |
Y |
542 |
|
E |
|
COGS |
|
0 |
|
|
200 |
Y |
820 |
|
E |
|
State taxes |
|
0 |
|
Note
The accounts in this example are from a sample database; yours will be different.
-
Use the Financial Reports Header Maintenance (GHH) program to set these parameters:
|
Report type |
Round option |
Include commas? |
Credit sign |
|
H |
1 |
Cleared |
- |
-
Use the GL Budget Maintenance (GBM) program to enter budget data for all accounts in the report.
-
Use the Financial Reports Print (GP) program to print the report, using these parameters:
|
Report type |
Exclude zero amounts? |
Beginning period |
|
H |
Cleared |
First period in the year |