Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

A report of Open Credits for customers and vendors with a total

This report will show all credits available for a customer and vendors without having the amount affected by open invoices or open bills.

Detailed instructions

There is not a report in QuickBooks that will show you this information automatically. You must create a custom report will to to obtain this information.

  1. From the Reports menu, select Custom Reports > Transaction Detail
  2. The Customize Report window will automatically open to the Display tab.
  3. Choose the appropriate date range.
  4. Scroll through the Column list and select Type, Date, Num and Open Balance (These can be adjusted to your needs).

For Customers:

  1. For Total by, select Customer.
  2. From the Filters tab, select the filter for Account and choose your Accounts Receivable account(s).
  3. Select the filter for Name and choose All customers/jobs.
  4. Select the filter for Transaction Type and choose Multiple Transaction Types.
  5. Scroll through the list and select Payment, Credit Memo, and Journal (this will ensure credits will appear regardless of how they were entered into QuickBooks).
  6. Click OK.
  7. Select the filter for Paid Status and choose Open.
  8. Click OK.

For Vendors:

  1. For Total by, select Vendors.
  2. From the Filters tab, select the filter for Account and choose your Accounts Payable account(s).
  3. Select the filter for Name and choose All vendors. Transaction Type and choose Multiple Transaction Types.
  4. Scroll through the list and select Bill Payment, Bill Credit, and Journal (this will ensure credits will appear regardless of how they were entered into QuickBooks).
  5. Select the filter for Paid Status and choose Open.
  6. Click OK.

The report will now show all credits available, totaled by customer or vendor without having open invoices or open bills affect the viewable credit balance.

KB ID# HOW13138
12/8/2016 8:06:50 AM
QYPPRDQBKSWS07 9138 Pro 2017 89d2dc