Create a Balance Sheet that Lists Accounts
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 - First Bank of State |
43,045.10 |
|
Discounts Taken |
2,976.82- |
|
Accounts Receivable |
11,338,102.49 |
|
Bad Debts |
271.35 |
|
Inventory - Returned |
1,147.59 |
|
Inventory Adjustments |
586.32 |
|
Inventory - Raw Material |
13,981,781.41 |
|
Inventory - WIP Material |
3,598,951.97- |
|
Inventory - Finished Goods |
1,444,413,749.46 |
|
WIP - Labor |
2,038,954.17 |
|
WIP - Adjustment |
202.63 |
|
Goods in Transit |
3,985.22 |
|
WIP - Outside Service |
924.90- |
|
WIP - Labor Adjustment |
229.92- |
|
WIP - Overhead |
256,512.04 |
|
WIP - Machine Overhead |
140.07- |
|
WIP - Rate Variance |
5,648.98 |
|
WIP - Efficiency Variance |
73.04- |
|
WIP - Overhead Adjustment |
13.21- |
|
WIP - Clearing |
3,651.90 |
|
Manufacturing Variance |
3,855.39- |
|
Floor Stock |
440.44- |
|
Depreciation |
27,895.02- |
|
Total Assets |
2,1885,416.96 |
|
|
|
|
Current Liability |
|
|
Accounts Payable |
-2,381,989.70 |
|
AP Accrual |
3,338,011.01 |
|
Sales Commissions Accrued |
5,339.60 |
|
Labor Payable |
564,249.45 |
|
Outside Labor Payable |
-608.10 |
|
Premium Pay Labor Payable |
384.00 |
|
Holiday Pay Labor Payable |
80.00 |
|
Advance Deposits Received |
109,297.62 |
|
Total Liabilities |
1,634,763.88 |
-
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 |
Lines to space |
Under-line |
|
100 |
T |
|
|
|
|
Current Assets |
0 |
0 |
|
|
200 |
R |
100-199 |
|
A |
10 |
Total Assets |
3 |
1 |
|
|
300 |
T |
|
|
|
|
Current Liabilities |
0 |
0 |
|
|
400 |
R |
200-299 |
|
L |
20 |
Total Liabilities |
3 |
|
|
-
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 |
|