Create a P & L: Actual to Last Year
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 |
Last year |
Variance |
% |
Actual |
Last year |
Variance |
% |
|
Revenue |
|
|
|
|
|
|
|
|
|
Sales |
595,039 |
1,939,250 |
1,344,211- |
69.3- |
7,531,793 |
9,799,764 |
2,267,971- |
23.1- |
|
Discounts given |
11,706- |
0 |
11,706- |
.0 |
159,715- |
21,426- |
138,289- |
645.4 |
|
Total Revenue |
583,333 |
1,939,250 |
1,355,917- |
69.9- |
7,372,078 |
9,778,338 |
2,406,260- |
24.6- |
|
|
|
|
|
|
|
|
|
|
|
Expenses |
|
|
|
|
|
|
|
|
|
Cost of Goods |
40,413 |
22,407 |
18,006- |
80.4- |
601,896 |
470,591 |
131,305- |
27.9- |
|
Freight |
11,773- |
20,750- |
8,977- |
43.3 |
36,362- |
166,382- |
130,020- |
78.1 |
|
Taxes |
124- |
0 |
124 |
.0 |
20,445- |
0 |
20,445 |
.0 |
|
Total Expenses |
28,516 |
1,657 |
26,859- |
16.2- |
545,079 |
304,209 |
240,880- |
79.2- |
|
|
|
|
|
|
|
|
|
|
|
Gross Profit |
554,827 |
1,937,593 |
1,382,766- |
71.3- |
6,826,999 |
9,474,129 |
2,647,140- |
27.9- |
-
Use the Financial Reports Format Maintenance (GFM) program to create a format like this:
|
Seq |
|
Accts |
Total 1 |
Total 2 |
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 |
2 |
0 |
|
|
300 |
Y |
405- |
|
|
R |
10 |
Discounts Given |
2 |
0 |
- |
|
400 |
Y |
|
10 |
|
R |
|
Total Revenue |
|
0 |
|
|
500 |
T |
|
|
|
|
|
Expenses |
|
-1 |
|
|
600 |
Y |
501- |
|
|
E |
20 |
Overhead1 |
2 |
0 |
|
|
700 |
Y |
542 |
|
|
E |
20 |
Cost of Goods |
2 |
0 |
|
|
800 |
Y |
628 |
|
|
E |
20 |
Freight |
2 |
0 |
|
|
900 |
Y |
810- |
|
|
E |
20 |
Taxes |
2 |
0 |
- |
|
1000 |
Y |
|
20 |
|
E |
|
Total Expenses |
|
0 |
= |
|
1100 |
Y |
|
10 |
20 |
|
|
Gross Profit |
|
-1 |
|
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 |
|
B |
3 |
Selected |
- |
-
Use the Financial Reports Print (GP) program to print the report, using these parameters:
|
Report type |
Exclude zero amounts? |
Beginning period |
|
B |
Selected1 |
same |
1Overhead did not print because the overhead accounts had no postings during this period.