Create a Multi-Period P & L: Actual to Budget
If you want a multi-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 - mm/ccyy
Period ending mm/dd/ccyy
All amounts converted to U.S. Dollars
All amounts rounded to ONES
|
|
+----------------------- 4th Quarter -------------------+ |
+------------------------ Year-to-date -----------------+ |
||||||
|
|
Actual |
Budget |
Variance |
% |
Actual |
Budget |
Variance |
% |
|
Revenue |
|
|
|
|
|
|
|
|
|
Sales |
18,731,320 |
15,000,000 |
3,731,320 |
24.9 |
59,861,965 |
60,000,000 |
138,035- |
.2- |
|
Discounts Given |
143,476- |
175,000- |
31,524 |
18.0- |
687,736- |
700,000- |
12,264 |
1.8- |
|
Total Revenue |
18,587,844 |
14,825,000 |
3,762,844 |
25.4 |
59,174,229 |
59,300,000 |
125,771- |
.2- |
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
Cost of Goods |
2,260,948 |
1,200,000 |
1,060,948- |
88.4- |
4,814,470 |
4,800,000 |
14,470- |
.3- |
|
Freight |
131,505- |
150,000- |
18,495- |
12.3 |
620,380- |
600,000- |
20,380 |
3.4- |
|
Taxes |
13,911- |
7500- |
6,411 |
85.5- |
27,473- |
30,000- |
2,527- |
8.4 |
|
Total Expenses |
2,115,532 |
1,042,500 |
1,073,032- |
102.9- |
4,166,617 |
4,170,000 |
3,383 |
.1 |
-
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 |
|
R |
10 |
Sales |
3 |
0 |
|
|
300 |
Y |
405-406 |
|
R |
10 |
Discounts Given |
3 |
0 |
|
|
400 |
Y |
|
10 |
R |
|
Total Revenue |
|
1 |
|
|
500 |
T |
|
|
|
|
Expenses |
|
0 |
|
|
600 |
Y |
542 |
|
E |
20 |
Cost of Goods |
3 |
0 |
|
|
700 |
Y |
628 |
|
E |
20 |
Freight |
3 |
0 |
|
|
800 |
Y |
810-855 |
|
E |
20 |
Taxes |
3 |
0 |
|
|
900 |
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 |
|
L |
1 |
Selected |
- |
-
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 |
Heading for this date range |
|
L |
Selected |
First period |
4th Quarter |