Create a P & L: Last Year to Actual to Budget
If you want a 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 shown in foreign currencies
All amounts rounded to ONES
|
|
+--------------- Period-to-date ---------------+ |
+--------------- Year-to-date ---------------+ |
+-- Annual --+ |
||||
|
|
Last year |
Actual |
Budget |
Last year |
Actual |
Budget |
Budget |
|
Revenue |
|
|
|
|
|
|
|
|
Sales |
799,340 |
10,045 |
800,000 |
799,340 |
10,045 |
800,000 |
12,700,000 |
|
Discounts given |
980 |
500 |
(10,500) |
980 |
500 |
(10,500) |
(145,600) |
|
|
798,360 |
9,545 |
810,500 |
798,360 |
9,545 |
810,500 |
12,845600 |
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
Cost of Goods |
48,545 |
1,626 |
87,000 |
48,545 |
1,626 |
87,000 |
1,110,000 |
|
Freight |
(35,469) |
(248) |
100 |
(35,469) |
(248) |
100 |
7,800 |
|
Taxes |
(64,591) |
(764) |
144,800 |
(64,591) |
(764) |
144,800 |
1,780,650 |
|
Total Expenses |
(51,515) |
614 |
232,010 |
(51,515) |
614 |
232,010 |
2,900,177 |
-
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 |
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 |
|
I |
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 |
|
I |
Cleared |
Same |