Customize the Trial balance report to show the opening balance and closing balance for period amount

Scenario: User need to customize the Trial Balance Report that shows the accounts’ opening and closing balance for the period.

Solution

1. Navigate to Reports > Financial > Trial Balance > Customize
2. Name: Enter required title of the report
3. Go to Edit Columns tab:
4. Report Preview: Select Debit/Credit Column
5. Click Remove Column button

Note:Add the required columns and enter the following fields

To Create Opening Balance Column

1. Add Fields: Expand Trial Balance folder
2. Click Amount
3. Column Label: Enter Opening Balance
4. Alternate Period Range Type: Select Relative to report date
5. Cumulative Value: Enter Checkmark
6. Alternate Period Range: Select Last Period

To Create Debit Balance Column

1. Add Fields: Expand Trial Balance folder
2. Click Amount (Debit)
3. Alternate Period Range Type: Select Relative to report date
4. Cumulative Value: Clear Checkbox
5. Alternate Period Range: Select This Period

To Create Credit Balance Column

1. Add Fields: Expand Trial Balance folder
2. Click Amount (Credit)
3. Alternate Period Range Type: Select Relative to report date
4. Cumulative Value: Clear Checkbox
5. Alternate Period Range: Select This Period

To Create Closing Balance Column

1. Add Fields: Expand Trial Balance folder
2. Click Amount
3. Column Label: Enter Closing Balance
4. Alternate Period Range Type: Select None

6. Click Save