cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Contributor *

GENERAL LEDGER

When I pull a general ledger report, it is pulling it by description instead of account #.  How can I change this?

 

Many thanks!

 

Brooke

5 Comments
Moderator

Re: GENERAL LEDGER

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.

97.PNG

 

Once done, go back to the General Ledger report and you should see the account number.

98.PNG 99.PNG

 

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.

Community Contributor *

Re: GENERAL LEDGER

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.)

QuickBooks Team

Re: GENERAL LEDGER

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. 


Here’s how:

  1. From the Chart of Accounts window, click the Account drop-down.
  2. Click Re-sort List.
  3. Hit OK on the message prompt.

 

 

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!

Community Contributor *

Re: GENERAL LEDGER

I had to resort the list. I had figured it out before you wrote this but thank you guys very much!!!!

QuickBooks Team

Re: GENERAL LEDGER

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!