Create a Multi-Period P & L: Actual to Last Year
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 |
Last Year |
Variance |
% |
Actual |
Last year |
Variance |
% |
|
Revenue |
|
|
|
|
|
|
|
|
|
Sales |
20,914,787 |
6,133,845 |
14,780,942 |
241.0 |
62,045,432 |
25,529,954 |
36,515,478 |
143.0 |
|
Discounts Taken |
57,217- |
25,693- |
31,524 |
122.7- |
131,107- |
700,002- |
568,895 |
81.3- |
|
Total Revenue |
20,907,570 |
6,108,152 |
14,799,418 |
242.3 |
61,914,325 |
24,829,952 |
3,7084,373 |
149.3 |
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
Cost of Goods |
2,250,948 |
1,140,784 |
1,110,164 |
97.3 |
4,814,470 |
1,897,380 |
2,917,090 |
153.7 |
|
Freight |
131,505- |
45,845- |
85,660- |
186.8 |
620,380- |
321,661- |
298,719- |
92.8 |
|
Taxes |
13,911- |
6,456- |
7,455- |
115.4 |
27,473- |
15,311- |
12,162- |
79.4 |
|
Total Expenses |
2,105,532 |
1,088,483 |
1,017,049 |
93.4 |
4,166,617 |
1,560,408 |
2,606,209 |
167.0 |
-
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 |
|
0 |
|
|
500 |
T |
|
|
|
|
Expenses |
|
-1 |
|
|
600 |
Y |
530-532 |
|
E |
20 |
Overhead |
3 |
0 |
|
|
700 |
Y |
542 |
|
E |
20 |
Cost of Goods |
3 |
0 |
|
|
800 |
Y |
628 |
|
E |
20 |
Freight |
3 |
0 |
|
|
900 |
Y |
810-855 |
|
E |
20 |
Taxes |
3 |
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 |
|
K |
1 |
Selected |
- |
-
Use the Financial Reports Print (GP) program to print the report, using these parameters:
|
Report type |
Exclude zero amounts? |
Beginning period |
|
K |
Cleared |
First period |