Create a Multi-Period Operating Report
If you want a multi-period operating 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
|
Org |
GL acct |
Title |
No of trans |
Amount |
Current |
Balance |
Current open |
|
|
|
|
|
|
|
|
|
|
*0 |
400 |
Sales |
160 |
8,322,606.00 |
110,779,255.05 |
.00 |
110,779,255.05 |
|
|
|
Total Cash In |
|
8,322,606.00 |
221,558,510.10 |
.00 |
221,558,510.10 |
|
|
|
|
|
|
|
|
|
|
*0 |
542 |
COGS |
160 |
861,962.61 |
6,964,039.28 |
.00 |
6,964,039.28 |
|
*0 |
628 |
Freight out |
75 |
64,394.89- |
1,437.931.47- |
.00 |
1,437,931.47- |
|
*0 |
820 |
Sales taxes |
3 |
3,764.00- |
1,750,613.37- |
.00 |
1,750,613.37- |
|
|
|
Total Cash Out |
|
793,803.72 |
2,024,881.07 |
.00 |
2,024,881.07 |
|
|
|
|
|
|
|
|
|
|
|
|
Net Cash |
|
9,116,409.72 |
111,579,630.56 |
.00 |
116,579,630.00 |
The number of accounts listed is 4
-
Use the Financial Reports Format Maintenance (GFM) program to create a format like this:
|
Seq |
|
Accounts |
Total 1 |
Total 2 |
Type |
Total to add to |
Line desc |
Spaces to indent |
Lines to space |
Under-line |
|
100 |
Y |
400 |
|
|
R |
10 |
Sales |
|
0 |
- |
|
200 |
Y |
|
10 |
|
R |
30 |
Total Cash In |
|
1 |
= |
|
300 |
Y |
542 |
|
|
E |
20 |
COGS |
|
0 |
|
|
400 |
Y |
628 |
|
|
E |
20 |
Freight out |
|
0 |
|
|
500 |
Y |
820 |
|
|
E |
20 |
State taxes |
|
0 |
|
|
600 |
Y |
|
20 |
|
E |
30 |
Total Cash Out |
|
1 |
- |
|
700 |
Y |
|
30 |
|
R |
|
Net Cash |
|
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 |
|
P |
1 |
Selected |
- |
-
Use the Financial Reports Print (GP) program to print the report, using these parameters:
|
Report type |
Exclude zero amounts? |
Beginning period |
|
P |
Selected |
First period |