Scenario
Usually, Balance Sheet Reports are ran using Periods. But, it may also be ran to reflect the balance as of a specific date range. Note that the Report by Period Preference should be set to Never(Home> Set Preferences> Analytics tab).
Solution
Below are the steps to customize the Balance Sheet Report:
-
Navigate to Reports > Financial > Balance Sheet
-
Click Customize
-
Navigate to Available Filters tab
-
Set the following parameters:
-----Filter = Between
-----Date Range = null
-----From = 10/01/20x7
-----To = 12/31/20x7 -
Click Done
-
Mark Show in Filter Region
-
Rename the Custom Balance Sheet Report
-
Click Preview or Save