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

Related Financial Software Questions