FAQ - How Do I Add Net Income/Loss to the Fund Balance Sheet?

First, the Fund Balance Sheet report must be a company report (not a global report) in order to configure it properly. This is because of 2 reasons.

1. This report requires that the Liability and Equity Report Category be surrounded by a larger Report Category group, in order for the report to produce a "Total Liability and Equity" line. (Since Report Categories are defined at the association level, then these changes don't work at a Global Report Level) We'll show you how later in this article. Example of going from this:
    
   To this:
2. The report requires that you specify where the Net Operating Income / (Loss) goes, which can only be seen on the report if it is a management-level report as opposed to a global report So, this is only visible if it is a management report:
   
   Here is what the end result should look like:

Step-By-Step How To Setup:

This article describes how to set up a Fund Balance Sheet

1. Confirm you are using the correct data source "Fund Data".
2. Setup the proper Report Category Structure, including the surrounding Liabilities & Equity Group
3. Navigate to Report Categories: Accounting > Settings > GL Funds & Categories > Report Categories
4. Add "Liabilities & Equity Group"
5. This is what it should look like:
6. Drag the new Report Category up above Liabilities then click Save Order
7. Open up the "Liabilities" Category and change the Parent to "Liabilities & Equity Group" and click Save
8. Open up the "Equity" Category and change the Parent to "Liabilities & Equity Group" and click Save
9. Set Net Income Location
10. Open the Fund Balance Sheet Report
11. Click "More Options"
12. Set Net Income Title, Net Income Location, including "Include in Equity" and set it to Equity, click Save (Note: if you cannot see this section then make sure the report is a management report by clicking on the Config and click "Copy to Management", the close everything and reopen the report)
13. Pin the column so that the "Net Income / (Loss)" row ends up at the bottom of the Equity section: (NOTE: some of these steps are to get around a few bugs that should be fixed soon)
14. Go into the Config area
15. Click the Gear
16. Click to edit the Account Name. Change the Field so something other than Account Name then click save then open it back up and change it back to Account Name (Note: This is to get around an issue with older reports' data structure). Click Apply and Save
17. Click on More Option from within the Config section, select under Pinned Rows "Account Name" in the dropdown.
18. Click New Bottom Row and type in the exact name used in the Net Income Title. In our case, this is "Net Income / (Loss)". Exact spelling and case are required. Click Save (NOTE: you will not see the pinned row after it is saved due to a bug in the UI, but it will still work.)

There you go! The report should now look like this:

Other Items that may need fixed or Settings that need confirmed: Make sure the config group by columns only has one Column in and points to Report Category:

1. 1. Make sure on the main report page, be sure to select "Display subtotals for every level of Report Categories" checkbox:
       
   2. If you see a Total at the bottom, this needs to be removed: