When I pull a general ledger report, it is pulling it by description instead of account #. How can I change this?
Thanks for reaching out to the Community, @Brmckay1011.
When you save it's pulling by Description, are you referring to the account name? If so, it's possible that the Use account numbers option in the Preferences is unchecked. To verify this, follow these steps below:
1. Go to the Edit menu at the upper left.
2. Pick Accounting on the left pane.
3. Go to the Company Preferences tab.
4. Put a checkmark on the Use account number.
5. Hit OK.
Once done, go back to the General Ledger report and you should see the account number.
I'm also adding this article future resources: Understand QuickBooks Chart of Accounts.
That should point you in the right direction. Keep me posted on how everything goes or if you're referring to something else in the comment section. I'll be happy to help. Have a great weekend.
Thank you. I have that set but instead of pulling the general ledger report in numerical order as it is in the chart of accounts its pulling it out of order. I understand that these are two different items altogether, but i'd like the general ledger report to look similar to the chart of accounts
For example: Two bank accounts:
I set up as one as Cash on Hand and other as Cash on Deposit
Cash on Hand is 500001 (using 500001 as the Account Name and Cash on Hand as the description)
Cash on Deposit is 500002 (using 500002 as the Account Name and Cash on Hand as the description)
In the chart of accounts - Cash on Hand is pulling up first (report pulls by NAME)
on the general ledger - Cash on Deposit is pulling up first (report pulls only by TYPE)
(I am using those numbers as examples as that is what we use for our Account names.)
Thanks for providing detailed information about your concern, @Brmckay1011.
The order of accounts should be the same as what is showing in the Chart of Accounts. Let’s try re-sorting the list to refresh the data on the General Ledger report.
Once done, go back to the Report menu and run the General Ledger report. You should find that Cash on Hand is listed before Cash on Deposit.
Here’s my screenshot for visual reference:
You can also check out this article about repairing damaged lists in QuickBooks Desktop: Re-sort Lists.
That should answer your concern for today.
Let me know how this goes and if you need further assistance. I’m always here ready to help. Take care!
I knew you could do it, @Brmckay1011.
It’s amazing that you were able to fix the issue on your own.
If you need assistance in the future, don’t hesitate to post in the Community again. I’m more than happy to help. Wishing you and your business continued success!