For report customization:  I don't know of anything that will do this, but perhaps someone else does.

For tidying up/moving things around in your existing chart of accounts:  This function is turned off in the 'end-user' version of the software, but is turned on in the 'accountant' version of the software.  So, if your business works with an accounting office, perhaps to prepare your year-end financial statements and business tax returns, you may want to touch base with them about getting the changes done.

There is a report writer called XLGL published by Logicimtech https://www.logicimtech.com  This is an EXCEL add on which when connected to the Sage 50 dataset can produce reports on almost anything. If the data is in Sage 50 it can be reported. XLGL uses all the Excel power and reports can be written or modified as you wish without downloading to Excel. If necessary Pierre can even arrange to write a customized report for you at a reasonable cost. Follow the link and connect with them.

On your second point, there is no way to transfer accounts from one class (Assets) to another (Liabilities) within the Sage 50 program.

Thank you!

This is very helpful. Thank you!