General Ledger Q&A: Alternate Account Order

September 2022    Tags: Chart of Accounts, General Ledger, Reports

I need to be able to subtotal my GL accounts in a different order to report on income for the firm. However, the current order is what the firm usually needs. I would only need this alternate order for reporting purposes. What can I do?

GL has the ability to set an additional account order in your Chart of Accounts, specifically for this purpose. This can be particularly useful when you need to subtotal accounts in more than one way.

To print reports using an alternate account order, you must enable the use of an alternate account order, and then specify the order in the Chart of Accounts.

To enable the use of an alternate account order

1. From the Quick Launch, search for and select “Edit GLS Client.”
2. Select the desired Client Number.
3. In the Options section, select the Allow an alternate account order to be defined in the Chart of Accounts check box.
4. Press Ctrl+S.

To set up an alternate account order

1. From the Quick Launch, search for and select “Chart of Accounts.”
2. Right-click and select View Alternate Account Order.
3. Drag and drop accounts to their desired position.

Once defined, reports can be run using the alternate account order by selecting the Use Alternate Account Order check box on the Account tab of many GL reports.