Skip to main content
D
Dav
September 4, 2024
Question

How do I run a Quickbooks report that shows the vendor discounts we received?

  • September 4, 2024
  • 1 reply
  • 0 views

 

Hi  -

 

How do I run a QuickBooks report that shows the vendor discounts we’ve received?

 

For example:

 

Let’s say we have a $100 vendor invoice with terms 2% 10, Net 30.

 

So, if we pay within the first 10 days of the invoice, we’ll get a 2% discount. In this case, the discount is $2 (2%*$100).

 

Otherwise, if we pay the invoice in days 11 through day 30, we owe the full invoice amount of $100.

 

Let’s say we paid the invoice within the first 10 days and qualified for the $2 discount.  Therefore, we only paid the $98 due, ($100 invoice - $2 discount = $98 due).

 

How do I run one report that shows all the vendor discounts (including this $2) that we received for the year?

 

Thank you in advance for your feedback!

 

1 reply

I
Irene R
September 4, 2024

Let me discuss how we can show your vendor discounts in your reports, Dav.

 

In QuickBooks Desktop (QBDT), you can show this by pulling up and generating a Vendor Balance Detail report and then adding a Discount Available column.

 

Here's how:

 

1. Go to Reports, then choose Vendors & Payables.

2. Select Vendor Balance Detail.

 

 

3. When the report is generated, click on Customize Report.

 

 

4. On the Display tab, under the columns section, enter Discount Available.

5, Once finished, tap OK.

 

 

You will then see a column with your vendor discount information.

 

Moreover, in QuickBooks Online (QBO), you can generate a Vendor Balance Detail report. However, the Discount Available column feature is currently unavailable, and as a workaround, you can export the report and manually add the column outside QBO.

 

Additionally, you can reserve the exact settings of your customized report by memorizing them. You can utilize these articles:

 

If you need further assistance adding discount details to your QBO or QBDT account, kindly notify me by leaving a comment below. I’ll be happy to assist you at any time, Dav. Keep safe!

D
DavAuthor
September 4, 2024

Hi @Irene R and QuickBooks Team -

 

Regarding step #4, my QuickBooks Desktop Enterprise does not have the field "Discount Available".  How do I get the field "Discount Available"?  Is that field only available in certain versions of QuickBooks?

L
LeizylM
September 4, 2024

I'd gladly help you add a Discount Available field in QuickBooks Desktop (QBDT), Dav.

 

Let's ensure we are running the correct report to view a Discount Available field in QBDT.

 

If you're generating the correct report and the field is missing, we can run QuickBooks Tool Hub to fix common issues in the program. First, let's ensure you have updated QuickBooks Desktop to the latest release to keep your software up-to-date so you always have the latest features and fixes.

 

To download and install QuickBooks Tool Hub, follow the steps below:

 

  1. Close QuickBooks.
  2. Download the most recent version (1.6.0.5) of the QuickBooks Tool Hub. Save the file somewhere you can easily find it (like your Downloads folder or Windows desktop). Note: If you've installed Tool Hub before, you can find out which version you have. Select the Home tab. The version will be on the bottom.
  3. Open the file you downloaded (QuickBooksToolHub.exe).
  4. Follow the on-screen steps to install and agree to the terms and conditions.
  5. When the installation finishes, double-click the icon on your Windows desktop to open the tool hub.

 

To use the QuickBooks Desktop Tool Hub, select Program Problems if you notice performance issues when you open the program. Check out this article for more information: Fix issues when QuickBooks has stopped working.

 

For additional information on how to customize the data, add or delete columns, add or remove information on the header/footer, and even personalize the font and style of the report, you can click this article: Customize reports in QuickBooks Desktop.

 

I always have your back if you need additional questions about running reports in QBDT. I'm always here to help. Take care.

Terms & ConditionsAccessibility statement