Trial Balance with Opening Balance and Transaction of Certain period only

SCENARIO

The client requires to get a Trial Balance report for a specific period range and its opening balance for the auditing purpose.

SOLUTION

We have to customise the Tril balance report in NetSuite

Navigation

Go to: Report>Finanacial>Trial Balance>Customise

The Report builder Opens

Click on the Filter subtab

Under choose filter, against Trial Balance Period:

• click on the pencil icon on Field
• Select Filter as Inclusive

Click on the Edit Column Subtab

Under Add fields in Trial Balance select Amount

In Column Label Provide opening Balance.

Check mark on Add Grand Total Column

In Alternative period range type choose; Relative to report date

In Alternative Period Range; Choose Balance Forward

Next we have to add another colum for Debit and credit values for the selected period for that do as following:

1. Under Add Filelds
2. Under Trial Blance
3. Choose Amount(Debit/Credit)

Click on the save button

Once the Report builder is saved a trial balance is shown with filter to select period range and also opening balance and Debit/Credit Columns.