Scenario:
User want to move Net Income from previous periods (beginning of the year) to Retained Earnings in Balance Sheet.
Solution:
1. Navigate to Reports > Financial > Balance Sheet
2. Click Customize
3. Go to Edit Layout section
4. Edit Sections:
For the Retained Earnings:
A.) Expand Liabilities and Equity > Equity > Retained Earnings > Net Income (Balance Forward to Beginning of Year)
B.) Reference Row:
Relative Range: Balance Forward
To: Start Date
C.) Rename Row: Net Income (Balance Forward to Beginning of Period) - this is optional
Note: The Retained Earnings section of the report is composed of the Net Income Balance Forward (via Income Statement lookup) and Retained Earnings manual postings to this account.
For the Net Income:
A.) Go to Liabilities and Equity > Equity > Net Income
B.) Reference Row:
Relative Range: Start Date
To: End Date
C.) Rename row header to Net Income (Current Period) - Optional
5. Save and Run the Report
Here is an example:
In an Income Statement as of July 2021 the Net Income was USD $14,000.00:
Below is a comparison of the Customized Current Period Net Income Balance Sheet vs a Standard Balance Sheet as of July 2021:
The Equity for these two balances are the same, the only difference is between the Net Income and Retained Earnings:
Hope this helps!
Were you able to customize your Balance Sheet just like this one? Feel free to share your tips!