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: 9017
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: 1 year ago.
Category: Financial Software
Expert:  Emilee Weaver replied 1 year ago.
Hi, Could you tell me what accounting or software system you are using to run the reports?
Expert:  Robert M. replied 1 year ago.
Customize report --> Filters ---> Paid Status ---> should be marked= OPEN
Customer: replied 1 year 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 1 year ago.
I am using QuickBooks Enterprise Solutions 14
Expert:  Robert M. replied 1 year ago.
which report are you using ? some you can do it and some you cant
Customer: replied 1 year ago.
Reports->> Vendors & Payables->> A/P Aging->> then under filter it says paid status OPEN
Expert:  Robert M. replied 1 year 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

Related Financial Software Questions