Why doesn't the Retained Earnings balance in the GL Summary (Trial Balance) report match my Balance Sheet?
The Retained Earnings balance in the GL Summary (Trial Balance) report reflects only entries actually made to the Retained Earnings Account. Typically, entries to Retained Earnings are systematically posted when the year is closed. Upon closing a fiscal year, the system will generate a closing General Ledger entry that posts the net income for the year to the retained earnings account. These entries can be viewed in the GL Details report if you select document type "FY - General Ledger Closing" from the DOCUMENT dropdown menu.
The Retained Earnings balance on the Balance Sheet reflects all prior year Net Income or Loss, whether those prior fiscal years have been closed or not. Once the prior fiscal years are closed, the Retained Earnings balance in the GL Summary (Trial Balance) report will be updated to reflect the posting of the prior year's net income/loss.
The following images show an example Equity section on the Balance Sheet Statement report, as an illustration of this concept:
Notice the Retained Earnings Balance and the Current Year Income balance (which ties to the Income Statement).
These values are for FY18-12, which has not yet been closed.
Now, notice the Balance Sheet Statement report values for FY19-01. The Retained Earnings balance is the sum of the Retained Earnings and Current Year Net Income above).
Even though the Balance Sheet Statement report rolls Retained Earnings automatically, the GL Summary (Trial Balance) report will only reflect the increase to Retained Earnings when the prior Fiscal Year is closed.