Create a Statement of Change Report
If you want a single-period statement of change report that looks like this example, follow the steps listed below.
Report period mm/ccyy
Period ending mm/dd/ccyy
All amounts converted to U.S. Dollars
|
|
+---------Net change---------+ |
|
|
|
|
Period-to-date |
Year-to-date |
Current Balance |
|
Revenues |
|
|
|
|
Sales |
3,335,630.00 |
9,803,244.80 |
9.803,244.80 |
|
Discounts |
(44,484.67) |
(173,702.55) |
(173,702.55) |
|
Total |
3,291,145.33 |
9,629,542.25 |
9,629,542.25 |
|
|
|
|
|
|
Expenses |
|
|
|
|
Cost of Sales |
75,504.97 |
224,043.86 |
224,043.86 |
|
Overhead |
243,947.00 |
.00 |
810,294.00 |
|
Administration |
405,234.00 |
.00 |
1,539,558.00 |
|
Total |
724,685.97 |
224,043.86 |
2,573,895.86 |
|
|
|
|
|
|
Change in Net Assets |
2,566,459.36 |
9,405,498.39 |
7,055,646.39 |
-
Use the Financial Reports Format Maintenance (GFM) program to create a format like this:
|
Seq |
Pnt |
Accts |
Tot 1 |
Tot 2 |
Type |
Total to add |
Line desc |
Spaces to indent |
Lines to space |
Ul |
Fixed MTD amount |
Fixed YTD amount |
|
100 |
T |
|
|
|
|
|
Revenues |
|
0 |
|
|
|
|
200 |
Y |
400 |
|
|
R |
10 |
Sales |
3 |
0 |
|
|
|
|
300 |
Y |
405-406 |
|
|
R |
10 |
Discounts Given |
3 |
0 |
- |
|
|
|
400 |
Y |
|
10 |
|
R |
|
Total |
7 |
1 |
|
|
|
|
500 |
T |
|
|
|
|
|
Expense |
|
0 |
|
|
|
|
600 |
N |
542 |
|
|
E |
20 |
COGS |
|
|
|
|
|
|
700 |
N |
628 |
|
|
E |
20 |
Freight |
|
|
|
|
|
|
800 |
N |
810-855 |
|
|
E |
20 |
Taxes |
|
|
|
|
|
|
900 |
Y |
|
20 |
|
E |
30 |
Cost of Sales |
3 |
0 |
|
|
|
|
1000 |
Y |
626 |
|
|
E |
30 |
Overhead |
3 |
0 |
|
243947. |
810294. |
|
1100 |
Y |
530-532 |
|
|
E |
30 |
Administration |
3 |
0 |
- |
405234. |
1539558. |
|
1200 |
Y |
|
30 |
|
E |
|
Total |
7 |
1 |
= |
|
|
|
1300 |
Y |
|
10 |
30 |
R |
|
Change in Net Assets |
|
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 |
|
E |
1 |
Selected |
( |
-
Use the Financial Reports Print (GP) program to print the report, using these parameters:
|
Report type |
Exclude zero amounts? |
Beginning period |
|
E |
Cleared |
Same |