My Trial balance is currently showing accounts as follows:

10200 · A/R PATIENTS:10200.1 · adjustment

10200 · A/R PATIENTS:10200.2 · Co Pay Insurance Charges (HMO)

10226 · Loan Receivable

Where 10200 is the parent account and 10200.2 is the sub account.

How do I make it print the trial balance sorted by the final lowest account?

    10200.1 · adjustment
    10200.2 · Co Pay Insurance Charges (HMO)

    10226 · Loan Receivable

I want to be able to import into a large excel schedule using vlookup, but, autofilter doesn't work when there are multiple accounts that appear to have the same account number.