Create a Multi-Period P & L with Percentage Calculation
If you want a multi-period profit and loss report that looks like this example, follow the steps listed below.
Note
If the columns in this example do not line up, maximize your browser.
Report period mm/ccyy
Period ending mm/dd/ccyy
All amounts converted to U.S. Dollars
|
|
Fourth Quarter |
% |
Year-to-date |
% |
|
Revenue |
|
|
|
|
|
Net Sales |
18,587,844.33 |
100.0 |
59,174,229.11 |
100.0 |
|
Cost of Sales |
2,129,442.83 |
11.5 |
4,194,090.08 |
7.1 |
|
Gross Profit |
16,458,401.50 |
88.5 |
54,980,139.03 |
92.9 |
|
|
|
|
|
|
|
Expense |
|
|
|
|
|
Labor |
215,566.71- |
.8- |
620,434.77- |
1.0- |
|
Freight |
21,957.92- |
.1- |
52,984.52- |
.1- |
|
Total Expense |
237,524.63- |
.8- |
673,364.15- |
1.1- |
|
|
|
|
|
|
|
Income from Operations |
25,591,918.25 |
90.8 |
55,653,503.18 |
94.1 |
|
Taxes |
26,893.06- |
.1- |
27,473.06- |
.0 |
|
Net Income |
25,618,811.31 |
90.9 |
55,680,976.24 |
94.1 |
-
Use the Financial Reports Format Maintenance (GFM) program to create a format like this:
|
Seq |
|
Accts |
Total 1 |
Accum % of total |
Type |
Total to add to |
Line desc |
Spaces to indent |
Lines to space |
Under-line |
|
100 |
T |
|
|
|
|
|
Revenue |
|
0 |
|
|
200 |
N |
400 |
|
|
R |
10 |
Gross Sales |
|
|
|
|
300 |
N |
405-406 |
|
|
R |
10 |
Discounts Given |
|
|
|
|
400 |
Y |
|
10 |
10 |
R |
30 |
Net Sales |
3 |
0 |
|
|
500 |
N |
542 |
|
|
E |
20 |
Cost of Goods |
|
|
|
|
600 |
N |
628 |
|
|
E |
20 |
Freight |
|
|
|
|
700 |
Y |
|
20 |
10 |
E |
30 |
Cost of Sales |
3 |
0 |
- |
|
800 |
Y |
|
30 |
10 |
R |
50 |
Gross Profit |
6 |
0 |
|
|
900 |
T |
|
|
|
|
|
Expense |
|
-1 |
|
|
1000 |
Y |
628 |
|
10 |
E |
40 |
Labor |
3 |
0 |
|
|
1100 |
Y |
422 |
|
10 |
E |
40 |
Freight |
3 |
0 |
- |
|
1200 |
Y |
|
40 |
10 |
E |
50 |
Total Expense |
6 |
0 |
|
|
1300 |
Y |
|
50 |
10 |
R |
60 |
Income from Operations |
|
-1 |
|
|
1400 |
Y |
810-855 |
|
10 |
E |
60 |
Taxes |
3 |
0 |
- |
|
1500 |
Y |
|
60 |
10 |
R |
|
Net Income |
6 |
0 |
= |
Note
The accounts in this example are from a sample database; yours will be different. You probably 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 |
|
M |
1 |
Selected |
- |
-
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 |
|
M |
Cleared |
First period |
Fourth Quarter |