Create a Balance Sheet
If you want a balance sheet 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
|
Current assets |
|
|
|
Cash |
43,045.10 |
|
|
Accounts Receivable |
11,338,102.49 |
|
|
Total Current Assets |
11,381,147.59 |
|
|
Fixed Assets |
586,867.32 |
|
|
Total Assets |
|
11,968,014.91 |
|
|
|
|
|
Liabilities |
|
|
|
Accounts Payable |
(2,532,602.80) |
|
|
Other Liabilities |
131,500.00 |
|
|
Total Liabilities |
|
(2,664,102.80) |
-
Use the Financial Reports Format Maintenance (GFM) program to create a format like this:
|
Seq |
|
Acct |
Total 1 |
Type |
Total to add |
Line desc |
Spaces to indent |
Col |
Lines to space |
Under-line |
|
100 |
T |
|
|
|
|
Current Assets |
0 |
|
0 |
|
|
200 |
Y |
100-102 |
|
A |
10 |
Cash |
3 |
|
0 |
|
|
300 |
Y |
110 |
|
A |
10 |
Accounts Receivable |
3 |
|
0 |
- |
|
400 |
Y |
|
10 |
A |
20 |
Total Current Assets |
3 |
|
0 |
|
|
500 |
N |
170-171 |
|
A |
20 |
Fixed Assets |
3 |
|
0 |
- |
|
600 |
Y |
|
20 |
A |
|
Total Assets |
0 |
2 |
1 |
|
|
700 |
T |
|
|
|
|
Liabilities |
0 |
|
0 |
|
|
800 |
Y |
210-212 |
|
L |
30 |
Accounts Payable |
3 |
|
0 |
|
|
900 |
Y |
220-231 |
|
L |
30 |
Other Liabilities |
3 |
|
0 |
- |
|
1000 |
Y |
|
30 |
L |
|
Total Liabilities |
0 |
2 |
0 |
|
Note
The accounts in this example are from a sample database; yours will be different. You may have additional asset and liability accounts.
Account type determines whether a line is considered to be a debit or credit and whether a credit sign is used.
-
Use the Financial Reports Header Maintenance (GHH) program to set these parameters:
|
Report type |
Round option |
Include commas? |
Credit sign |
|
A |
1 |
Selected |
( |
-
Use the Financial Reports Print (GP) program to print the report, using these parameters:
|
Report type |
Exclude zero amounts? |
Beginning period |
|
A |
Selected |
Same |