Trial Balance period-wise report

A Trial Balance report is needed, that can show the YTD balance per accounting period in individual columns for a given range of periods. The standard trial balance is not available for running the YTD balance per accounting period in individual columns. If the NetSuite account is not oneworld or there is no consolidation in reports, then period-wise Trial balance can be generated by customizing the standard Income statement. The steps to customize the standard Income statement layout is: 

1. Navigate to Reports > New Financial Report. 

2. Click any Standard Income statement Layout. 

3. Delete other sections in a particular order from the below row. 

4. Click the “Add Row/Section” drop-down field. 

5. Select “Add Financial Section”. 

6. Click OK in the New Section Row pop-up window. 

7. In the New Section Row, set the following: 

• Header Label: Enter preferred Name. 
• Display: (Default) Expanded 
• Group By: (Default) Account 

• Show Hierarchy: Uncheck 

8. In the section tab, select the filter “Account Type”. Select All Account Types in the box. 

9. Click the Format subtab. 

10. Scroll down to the Account Row Format segment. 

11. Check the Reverse Sign box. 

12. Click “Edit Columns”. 

13. Click on the Amount column. 

14. Check the “Add Grand Total” box. 

15. Select the “Accounting Period” in the “View columns by” field. 

16. Click Save. 

If the NetSuite account is oneworld or consolidation is using in reports, then the above solution will not work. Because consolidated trial balance has an additional row named “Cumulative Translation Adjustment” which shows the cumulative balance of the changes in converting the functional amount to the consolidated amount in reports. This row is available only in the trial balance and in the balance sheet consolidated report layouts. We cannot manually set up this row in the income statement layout. So we need to create separate trial balance reports for each financial year. 

1. Navigate to Reports > Financial > Trial Balance > Customize. 

2. In the “Edit Columns” subtab, add the below fields. 

1. Account 

2. Account Type (if needed) 

3. Subsidiary Name (if needed) 

4. Amount: Add twelve amount columns. 

5. Click on the first amount column and provide the below details. 

1. Alternate Period Range Type – Relative to today’s date. 

2. Alternate Period Range – Custom 

3. Periods – Select the first period in the financial year for which this report is customized. 

3. In the “Filters” subtab, hide the accounting period filter. 

4. In “More Options”, provide access to this report for all or specific users/roles. 

5. Provide a name to the report. The name should include the financial year for which the Trial balance is preparing. 

6. Click “Save”.