Question

Vendor or Customer Open Credits

Forum|Forum|7 years ago
April 8, 2019
7 replies
99 views

Good day, I was hoping to run a report that would display what credits are open for Vendors and or Customers. I found an article on QB in the link below. However, this appears to be how much was paid, not what is available. We are running Enterprise 2019 Manufacturing and Wholesale. Any assistance is appreciated.

Perhaps I am over thinking this but I am not seeing anything in the stock reports.

https://community.intuit.com/questions/1198961-a-report-of-open-credits-for-customers-and-vendors-with-a-total-2014-and-older-versions

QuickBooks Enterprise Suite

MaryLandT

Level 10

You're looking at the exact article, @CSMG.

All that's left to do is to make sure we did not miss any of the steps outlined in the article.

Let me guide you through the steps on how to accomplish this:

Go to Reports, select Custom Reports, then Transaction Detail.
The Modify Report: custom Transaction Detail Report opens automatically.
On the Display tab, add the Open Balance column, then remove other columns when necessary.
On the Filter tab:
a. Select Accounts Payable and Receivable for Account.
b. Select All Names for Names.
c. Select Payment, Credit Memo, Bill Credit, Bill Payment for the Transaction Type.
d. Select Open for the Paid Status.
Don't forget to click OK after performing each letter above.

The Open Balance column is where you can see the unapplied or remaining credit of your clients. Just make sure not to missed any steps and filter the report correctly.

After following the steps outlined in this article, you're able to see the available credit of your vendors and customers.

Keep me posted if you have follow-up questions and I'd be glad to help.

B

Blondon1

I applied these steps hoping to find out where a credit is originating from but it didn't help. How do I find out where a credit is stemming from? I've taken over some books that many people have worked on in the past and there is a credit of $1,249.94 on one of our vendors and I can't tell when it happened. I would appreciate any help!

B

Blondon1

I got you covered, Blondon1.

Let's work together to ensure you're able to track what and when your available credit transactions came from. You can run the Vendor Balance Detail report to view detailed information on the credits created and know their balances for every transaction. To do that:

In your QuickBooks Desktop company file, go to Reports from the menu bar.
Select Vendors & Payables and choose Vendor Balance Detail report.
Edit the desired date.
Click the Customize Report button.
Under Columns, search and select Credit and Open Balance in the search field.
Click OK.

You'll now see all the credits created and to which transaction it is applied. To view them, you can click the transaction itself.

If you also want to view the credits applied to the invoices and your customer's opening balances, you can run the Customer Balance Detail report. This report can be found from the steps provided above, you can select the Customers & Receivables dropdown from the Reports menu.

Additionally, I've attached this reference to help you add specific data to your reports: Customize reports in QuickBooks Desktop.

Let us know in this forum if you have additional questions or other QuickBooks concerns. We're always here to help. Keep safe!

Thank you for your help. Maybe I shouldn't call it a credit per se. This vendor has a negative balance and I can't find when or how this happened. I ran the report per your instructions but I'm still not finding anything.

Sign up

Login with SSO

Let's get you signed in

Login with SSO