Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 3

Account Payalbe General Ledger

Hi 

I have two general ledger accounts for accounts payable. One is for our payables that being floored and the other for the rest. Most of the information is imported from our dealer management system and is going to the correct payable. I have noticed when I enter a bill directly into QBO sometimes it hits the correct payable and sometimes it doesn't and it is not being consistent. Is there a way to mark the vendor with the correct payable GL? 

Thanks,

CK18

Solved
Best answer September 18, 2020

Best Answers
QuickBooks Team

Account Payalbe General Ledger

Let me share some insights about having multiple Accounts Payable, @CK18.

 

Though QuickBooks Online allows you to create several A/P, it only uses one A/P account when entering a bill. However, it causes issues to your recordings having multiple A/P.

 

As a workaround, you can use the location tracking feature if you have to group or divide your payables. I'd be glad to show you how. First, you'll have to turn on this feature in your company settings.

 

Here's how:

  1. Go to the Gear icon and select Accounts and Settings under the Your Company column.
  2. Select the Advanced tab.
  3. Click the Edit icon in the Categories section.
  4. Enable Track Locations.
  5. Choose a location label.
  6. Click Save and Done.

The screenshot below shows the last three steps.
Capture.JPG

 

Then, go to the All Lists page from the Gear icon and select Location to set up different locations to use. For your reference, you can check out this article for more information: How to set up and use class and location tracking.

 

Once done, you can run a report to make sure that all transactions are assigned to a location associated with an A/P, and then customize it to show one location at a time. Here's how:

 

  1. Click the Reports menu.
  2. In the Find report by name field, type in "Vendor Balance Detail," then press Enter.
  3. Make sure that all transactions have locations indicated in the Locations column.
  4. Click on the Customize button.
  5. Expand the Filter section.
  6. Mark the locations you want to be included in the report.
  7. Click the Run Report button.

 

You can read through these articles for more guidance in managing your A/P and A/R accounts:

 

Please let me know if you have other questions or concerns. I'm always here to help. Have a great day, @CK18!

View solution in original post

1 Comment
QuickBooks Team

Account Payalbe General Ledger

Let me share some insights about having multiple Accounts Payable, @CK18.

 

Though QuickBooks Online allows you to create several A/P, it only uses one A/P account when entering a bill. However, it causes issues to your recordings having multiple A/P.

 

As a workaround, you can use the location tracking feature if you have to group or divide your payables. I'd be glad to show you how. First, you'll have to turn on this feature in your company settings.

 

Here's how:

  1. Go to the Gear icon and select Accounts and Settings under the Your Company column.
  2. Select the Advanced tab.
  3. Click the Edit icon in the Categories section.
  4. Enable Track Locations.
  5. Choose a location label.
  6. Click Save and Done.

The screenshot below shows the last three steps.
Capture.JPG

 

Then, go to the All Lists page from the Gear icon and select Location to set up different locations to use. For your reference, you can check out this article for more information: How to set up and use class and location tracking.

 

Once done, you can run a report to make sure that all transactions are assigned to a location associated with an A/P, and then customize it to show one location at a time. Here's how:

 

  1. Click the Reports menu.
  2. In the Find report by name field, type in "Vendor Balance Detail," then press Enter.
  3. Make sure that all transactions have locations indicated in the Locations column.
  4. Click on the Customize button.
  5. Expand the Filter section.
  6. Mark the locations you want to be included in the report.
  7. Click the Run Report button.

 

You can read through these articles for more guidance in managing your A/P and A/R accounts:

 

Please let me know if you have other questions or concerns. I'm always here to help. Have a great day, @CK18!

View solution in original post

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us