cancel
Showing results for 
Search instead for 
Did you mean: 
aaaccounting
Level 2

How do I fix negative vendor AP balance from previous period?

The previous bookkeeper wrote out a check to AP account, instead of to an expense account. The vendor now has a negative balance, as does the AP account. Transaction is dated Dec 2017. What is the best way to fix this?
 
I understand that JEs for AP and AR are not considered best practice. Could I
1) delete/void the Dec 2017 check written out to AP, then
2) create a bill dated Jan 2018, then
3) pay it with check dated Dec 2017, then
4) re-reconcile that check amount with a current month's reconciliation (2019 yr) so that everything is as it was before.
 
I'm thinking that would not change any figures for the 2017 tax year, is that correct?
Solved
Best answer April 04, 2019

Best Answers
PreciousB
Moderator

How do I fix negative vendor AP balance from previous period?

Welcome to the Community, aaaccounting.

 

First, I want to thank you for providing me with the complete details of your concern. I'm here to get you pointed in the right direction for fixing the negative balance of a vendor.

 

A check posted to Accounts Payable can be applied as credits to a bill. You can create a bill, then make a payment using the credits. Don't worry, this will not affect the reconciliation as long as the bank account and the amount stays the same.

 

I'm happy to show you how:

  1. Click the Plus sign icon, then select Bill.
  2. Choose the vendor's name.
  3. Enter the needed information.
  4. Click Save.
  5. Choose the Make Payment button at the top.
  6. Select the bill at the top and the check under Credits.
  7. Click Save.

Please refer to the screenshots below so you can easily follow the steps.

 

image.pngimage.png
 

That information should get you back in order. I'd like to make sure that you're able to resolve this concern, so please let me know how that works for you. Best regards. 

View solution in original post

10 Comments 10
PreciousB
Moderator

How do I fix negative vendor AP balance from previous period?

Welcome to the Community, aaaccounting.

 

First, I want to thank you for providing me with the complete details of your concern. I'm here to get you pointed in the right direction for fixing the negative balance of a vendor.

 

A check posted to Accounts Payable can be applied as credits to a bill. You can create a bill, then make a payment using the credits. Don't worry, this will not affect the reconciliation as long as the bank account and the amount stays the same.

 

I'm happy to show you how:

  1. Click the Plus sign icon, then select Bill.
  2. Choose the vendor's name.
  3. Enter the needed information.
  4. Click Save.
  5. Choose the Make Payment button at the top.
  6. Select the bill at the top and the check under Credits.
  7. Click Save.

Please refer to the screenshots below so you can easily follow the steps.

 

image.pngimage.png
 

That information should get you back in order. I'd like to make sure that you're able to resolve this concern, so please let me know how that works for you. Best regards. 

aaaccounting
Level 2

How do I fix negative vendor AP balance from previous period?

Thanks very much, that worked perfectly.

PreciousB
Moderator

How do I fix negative vendor AP balance from previous period?

You're most welcome, aaaccounting.

 

I'm happy that it worked for you. I'm including some helpful video tutorials that help navigate QuickBooks Online: QuickBooks Tutorials.

 

Please come back to the Community should you have any questions about QuickBooks. I'm wishing you all the best.

Sail-2020_
Level 1

How do I fix negative vendor AP balance from previous period?

What are the steps to this issue in QB's desktop version

MirriamM
Moderator

How do I fix negative vendor AP balance from previous period?

Welcome to the thread, @Sail-2020_.

 

I can convert the steps above for QuickBooks Desktop. Let me show you the step-by-step process.

  1. Go to the Vendors menu at the top and select Enter Bills
  2. Enter the Vendor's name.
  3. Fill out the needed information. 
  4. Hit Save.
  5. Select Pay Bill
  6. Click OK on the pop-up window.
  7. On the Pay Bills screen, select the Bills to be paid.
  8. Enter amount. 
  9. Choose Pay Selected Bills
  10. Pick Done

Here are some screenshots for your visual reference:

PB1.2.JPG

 

 

You can also check these articles for more information on the process above: 

For future tasks related to QBDT, visit our Community help articles

 

You're always welcome to get back to me if you need other help in managing your account. I'm more than happy to assist further. Have a great day!

 

 

 

**Say "Thanks" by clicking the thumb icon in a post.

**Mark the post that answers your question by clicking on "Accept as solution".

contadora23
Level 1

How do I fix negative vendor AP balance from previous period?

i have the same issue but in QuickBooks desktop? help please

 

MorganB
Content Leader

How do I fix negative vendor AP balance from previous period?

Hey there, contadora23.

 

Thanks for joining this thread. You've come to the right place for assistance and I'd be glad to provide some more info.

 

The steps to get this done in the Desktop version of the software were mentioned above by MirriamM (along with some handy screenshots). It can be easy to skip over when there are several comments in a thread. Here are the steps to get this done:

  1. Navigate to the Vendors menu at the top and select Enter Bills
  2. Enter the Vendor's name.
  3. Fill out the needed info. 
  4. Click Save.
  5. Select Pay Bill
  6. Click OK on the pop-up window.
  7. On the Pay Bills screen, select the Bills to be paid.
  8. Enter amount. 
  9. Choose Pay Selected Bills
  10. Click Done

The following articles provide even more info about this process:

That will do it. Please don't hesitate to reach back out if you have any other questions or concerns. Take care!

gsilvapo
Level 1

How do I fix negative vendor AP balance from previous period?

Hi there,

 

I have a negative AP balance in my vendor, but it shows that I have 0 credits.

 

Can you help me understand why?

 

Thanks,

gsilvapo
Level 1

How do I fix negative vendor AP balance from previous period?

Hi there,

 

I have a negative AP balance, but I don't see any credit available for me to create another bill and pay them with credits.

 

Can you help me understand why?

 

Thanks,

ShiellaGraceA
QuickBooks Team

How do I fix negative vendor AP balance from previous period?

Thanks for joining us here today, @gsilvapo.

 

It seems that this is a duplicate post. One of my colleagues has answered your other post. Feel free to check out her answer at this link: https://quickbooks.intuit.com/learn-support/en-us/payments/negative-ap-balance-but-no-credits-availa....

 

Additionally, you can run the Verify and Rebuild Data Utility tools. The Verify Data self-identifies the most commonly known data issues within a company file while Rebuild Data self-resolves most data integrity issues that the Verify Data finds. Refer to this article for the detailed steps: Verify and Rebuild Data in QuickBooks Desktop.

 

Please know that you're always welcome to reply anytime if you have follow-up questions or concerns. I'm always here to help. Take care and have a good one.

 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us