How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask Robert M. Your Own Question
Robert M.
Robert M., Consultant
Category: Financial Software
Satisfied Customers: 8947
Experience:  30 yrs. of computer experience in financial and marketing departments.
Type Your Financial Software Question Here...
Robert M. is online now
A new question is answered every 9 seconds

How do I get zero balance vendors from showing up on my

Customer Question

How do I get zero balance vendors from showing up on my Vendors and Payable reports
Submitted: 9 months ago.
Category: Financial Software
Expert:  Emilee Weaver replied 9 months ago.
Hi, Could you tell me what accounting or software system you are using to run the reports?
Expert:  Robert M. replied 9 months ago.
Customize report --> Filters ---> Paid Status ---> should be marked= OPEN
Customer: replied 9 months ago.
I was wanting only payables WITH a balance. I have my report set to what you have stated above and I still have zero balance Vendors, some which we haven't used in 3 years or more and yet they are on our payables list.
Customer: replied 9 months ago.
I am using QuickBooks Enterprise Solutions 14
Expert:  Robert M. replied 9 months ago.
which report are you using ? some you can do it and some you cant
Customer: replied 9 months ago.
Reports->> Vendors & Payables->> A/P Aging->> then under filter it says paid status OPEN
Expert:  Robert M. replied 9 months ago.
it may be because the payment was not linked to the bill that is you gave them a credit which wiped out their balance but it was never applied to a specific bill so qb sees an open bill even though it has zero owed on it. Go to vendors>pay bills>click on the bill and click "set credits" at the bottom of the screen. You will advance to the next screen where you can link the payment to the bill