Project ending balance does not match project beginning balance on the Project activity report when they should be the same

Users may find that the Project ending balance does not match project beginning balance on the Project activity report filtered on specific dates that are not the end date for the fiscal year.
Click Chat with Support, reference this article, and provide the following information so we can assist you:   
  • A copy or your database may be needed
  • The exact steps to duplicate the issue (click by click).

Steps to Duplicate

In Configuration> Fiscal years notice that the fiscal year is set to start from 4/1/2018 to 3/31/2019

1. In Reports, Project Reports, create a new Project Activity Report
2. On the General Tab, select summary and for the dates select 07/31/2001 to 8/8/2018
3. Select all the desired filters and select the affected project
4. Click Preview,  Notice the ending balance is $14,644.05

1. In Reports, Project Reports, create a new Project Activity Report
2. On the General Tab, select summary and for the dates 08/01/2001 to 8/8/2018
3. Select all the desired filters and select the affected project
4. Click Preview,  Notice the beginning balance is $33,278.57- The ending balance at 7/31/01 should match the beginning balance at 8/1/01 but doesn't.

 

Was this article helpful?