Create a Multi-Period P & L: Last Year to 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
|
|
+--------------- Quarter-to-date ---------------+ |
+----------------- Year-to-date -----------------+ |
+--- Annual ---+ |
||||
|
|
Last year |
Actual |
Budget |
Last Year |
Actual |
Budget |
Budget |
|
Revenue |
|
|
|
|
|
|
|
|
Sales |
6,1333,845 |
18,731,320 |
15,000,000 |
25,529,954 |
59,861,965 |
60,000,000 |
60,000,000 |
|
Discounts Given |
154,590- |
143,476- |
175,000 |
202,346- |
687,736- |
700,000- |
700,000- |
|
Total Revenue |
5,979,255 |
18,587,844 |
14,825,000 |
25,327,609 |
59,174,229 |
59,300,000 |
59,300,000 |
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
Cost of Goods |
140,785 |
2,260,948 |
1,200,000 |
897,380 |
4,814,470 |
4,800,000 |
4,800,000 |
|
Freight |
45,845- |
131,505- |
150,000- |
321,661- |
620,380- |
600,000- |
600,000- |
|
Taxes |
0 |
13,911- |
7,500- |
0 |
27,473- |
30,000- |
30,000- |
|
Total Expenses |
94,940 |
2,115,532 |
1,042,500 |
575,719 |
4,166,617 |
4,170,000 |
4,170,000 |
-
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 |
|
J |
3 |
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 |
|
J |
Cleared |
First period |
Quarter-to-date |