Trial Balance Report in Microsoft Dynamics GP

Want a Trial Balance (TB) report from GP where the balances of all ledgers are summaries into debit and credit column totals that are equal? You can get it in GP easily.

Path: Reports > Financial > Trial Balance

1.   Select “Summary” from Reports options.

2.   To create new report, click [New]. Or to print existing report option, just select the report which available in the Options, then click [Modify].

3.   Type a name for the report option that you want to use in [Option:].

4.   In the Include section, select the "Posting Accounts" check box.

5.   Select the target fiscal year to generate in Year section. Please take note that if you are printing historical year, you need to select "History".

6.   Select the settings and restrictions that you want to use with the new report option. In the sample below, the TB that going to generate is March in 2017. You can also filter a group of the account code that need to generate using this filtering option.

7.   Select [Destination]

8.   Click to select the Destination to “Screen” check box and the to “File” check box if you need to export to Excel.

                Refer to this link to know further on exporting report to Excel.

9.   Go back to the Trial Balance Report Options window, click the Print button to generate the report.