Create a Trial Balance Report

If you want a trial balance 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

 

Debits

Credits

Assets

 

 

Cash

.00

335,450.86

Discounts taken

.00

29,994.29

Accounts Receivable

13,744,142.98

.00

Inventory

442,430,399.24

 

 

 

 

Liabilities

 

 

Accounts Payable

2,532,631.02

.00

 

 

 

Revenue

 

 

Sales

.00

51,462,250.42

Discounts given

527,110.55

.00

 

 

 

Expense

 

 

Cost of Goods Sold

3,547,492.30

.00

Freight out

.00

558,102.57

State taxes

.00

17,107.80

 

  1. Use the Financial Reports Format Maintenance (GFM) program to create a format like this:

Seq

Print

Accts

Total 1

Type

Total to add to

Line desc

Spaces to indent

Lines to space

100

T

 

 

 

 

Assets

 

 

200

Y

101

 

A

 

Cash

 

 

300

Y

106

 

A

 

Discounts taken

 

 

400

Y

110

 

A

 

Accounts Receivable

 

 

500

Y

122

 

A

 

Inventory

 

 

600

T

 

 

 

 

Liabilities

 

-1

700

Y

210

 

L

 

Accounts Payable

 

 

800

T

 

 

 

 

Revenue

 

-1

900

Y

400

 

R

 

Sales

 

 

1000

Y

405

 

R

 

Discounts given

 

 

1100

T

 

 

 

 

Expense

 

-1

1200

Y

542

 

E

 

Cost of goods sold

 

 

1300

Y

628

 

E

 

Freight

 

 

1400

Y

820

 

E

 

State taxes

 

 

Note
The accounts in this example are from a sample database; yours will be different. You may have additional revenue and expense accounts.

  1. Use the Financial Reports Header Maintenance (GHH) program to set these parameters:

Report type

Round option

Include commas?

Credit sign

G

1

Selected

-

  1. Use the Financial Reports Print (GP) program to print the report, using these parameters:

Report type

Exclude zero amounts?

Beginning period
Ending period

G

Selected

Same