Create a P & L: Actual to Budget
If you want a single-period profit and loss 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 U.S. Dollars
All amounts rounded to ONES
|
|
+---------------- Period-to-date --------------------+ |
+---------------- Year-to-date --------------------+ |
||||||
|
|
Actual |
Budget |
Variance |
% |
Actual |
Budget |
Variance |
% |
|
Revenue |
|
|
|
|
|
|
|
|
|
Sales |
595391 |
500000 |
95391 |
19.1 |
7566302 |
2000000 |
5566302 |
278.3 |
|
Discounts given |
11707- |
25000- |
13294 |
53.2- |
159715- |
100000- |
59715- |
59.7 |
|
Total Revenue |
583685 |
475000 |
108685 |
22.9 |
7406587 |
1900000 |
5506587 |
289.8 |
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
Overhead |
98- |
95- |
3 |
3.1- |
4787 |
95- |
4882- |
138.4 |
|
Cost of Goods |
40413 |
33333 |
7079- |
21.2- |
601896 |
1333333 |
468563- |
351.4- |
|
Freight |
11773- |
39583- |
27811- |
70.3 |
36362- |
158333- |
121972- |
77.0 |
|
Taxes |
124- |
1667- |
1542- |
92.5 |
20445- |
6667- |
13779 |
206.7- |
|
Total Expenses |
28418 |
8012- |
36429- |
454.7 |
549876 |
31762- |
581637- |
831.3 |
-
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 |
T |
|
|
|
|
Revenue |
|
0 |
|
|
200 |
Y |
400-401 |
|
R |
10 |
Sales |
2 |
0 |
|
|
300 |
Y |
405-406 |
|
R |
10 |
Discounts Given |
2 |
0 |
- |
|
400 |
Y |
|
10 |
R |
|
Total Revenue |
|
1 |
|
|
500 |
T |
|
|
|
|
Expenses |
|
0 |
|
|
600 |
Y |
530-532 |
|
E |
20 |
Overhead |
2 |
0 |
|
|
700 |
Y |
542 |
|
E |
20 |
Cost of Goods |
2 |
0 |
|
|
800 |
Y |
628 |
|
E |
20 |
Freight |
2 |
0 |
|
|
900 |
Y |
810-855 |
|
E |
20 |
Taxes |
2 |
0 |
- |
|
1000 |
Y |
|
20 |
E |
|
Total Expenses |
|
0 |
|
Note
The accounts in this example are from a sample database; yours will be different. You may have additional revenue and expense accounts.
-
Use the Financial Reports Header Maintenance (GHH) program to set these parameters:
|
Report type |
Round option |
Include commas? |
Credit sign |
|
C |
3 |
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 |
|
C |
Cleared |
Same |