We have a complicated problem. A check date 12-31-2019 with a post date of 12-31-2019 needed to be reversed. When it was reversed, the post date is 12-31-2019 but! the transaction date was 01-10-2019. 

Now when we run the FULL aging report we have a difference to the balance sheet. If i print out the full aging report without that specific vendor and then print out the vendor alone using the "future applications" both amounts add to the balance sheet. 

But i cannot present this to the accountants. I was told by IT there is no fix for this. But now my again for 2020 also has a difference. How can we fix this?? The GL is correct, it is just the information that the report is pulling. 

2ND ISSUE: A MANUAL CHECK was created for a transaction date of 01-10-2020 which was correct! but, the posting date was 12-31-2019. Also causing a difference in the AGING and balance sheet. 

I have to exclude these vendors and run separately  in order to show that we reconcile. 

Is there really no way to adjust? do we really need to have it rolling forward to 2020? Any help is appreciated.