Incorrect Retained Earnings Balances on Custom Comparative Trial Balance

A Custom Comparative Trial Balance is generated for 2018 and 2019. However, the amount showing in Retained Earnings account is incorrect when compared to the amounts in Balance Sheets 2018 and 2019.

Verify the correct amount of Retained Earnings for FY 2018 via Balance Sheet

1. Navigate to Reports> Financial> Balance Sheet 
2. Filter: Select As of FY 2018
3. Click Refresh
4. See correct Retained Earnings Balance 

Verify the correct amount of Retained Earnings for FY 2019 via Balance Sheet

1. Navigate to Reports> Financial> Balance Sheet 
2. Filter: Select As of FY 2019
3. Click Refresh
4. See correct Retained Earnings Balance

Edit the Custom Comparative Trial Balance with incorrect Retained Earnings Balances

1. Navigate to Reports> Saved Reports> Custom Comparative Trial Balance
2. Click Customize 
3. On the Report Preview pane 
4. Remove Columns Trial Balance : Amount
5. Add Field Trial Balance : Amount (Gross)
6. Alternate Period Range Type: Select Relative to report date
7. Alternate Period Range: Select Last Fiscal Year
8. Add Field Trial Balance : Amount (Gross)
9. Click Save