Unallocated Credits

Thanks for sharing your queries with us here, asid. I appreciate all the detailed information when running reports in a spreadsheet format with all the allocated and unallocated credits in your account. Let me provide insights to help you acquire the data you need.

Since extracting all unallocated vendor credits to a spreadsheet format is unavailable in the program, I recommend running a report and keeping track of the transactions with all the available credits. To help you do this:

1. Go to Reports and select Vendors & Payables. Then, click Vendor Balance Detail.
2. Select Customize Report.
3. Under the Display tab, enter Credits from the Columns section and click OK.

In addition to this, you can run the Check Detail report to show all the allocated vendor credits to bills. Here's how:

1. Go to Reports and select Banking. Then, click Check Detail report.
2. Select Customize Report.
3. Under the Filters tab, enable the following:

• Name
• Transaction Type: Select Bill.
• Detail Level: Choose All except the summary.

1. Review all the information and click OK.

Then, here's how to export the report to an Excel file:

1. Go to Reports, then Reports Center.
2. Find and double-click the report you want to export.
3. Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet. 
4. If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
5. Once ready, select OK.

Furthermore, you can refer to this guide to help save the customization settings made to your reports: Create, access, and modify memorized reports.

I'll keep this thread available if you have additional questions when running data reports in your accounts. Just let me know in the comments below, and I'll make sure to back you up. Keep safe and have a good one!

Thanks @FateCandylaneT 

Can I extract a report where I can see all the vendors allocated to any/all of the bills?

Yes, you can, asid.

You can extract the Transaction List by Vendor report. Then, filter it to show only the associated Bill transactions. Here's how:

1. From the Reports menu, hover to Vendors & Payables.
2. Select Transaction List by Vendor.
3. Click Customize Report.
4. Filter the Dates.
5. Go to the Filters tab.
6. Enter and select Transaction Type.
7. Under Transaction Type, select Bill. Click OK.
8. Click the Excel drop-down, then select Create New Worksheet.
9. On the Send Report to Excel page, select in new workbook.
10. Click Export.

Furthermore, you can check this article as your guide about managing bills: Manage bills.

Keep me posted whenever you have concerns about managing bills.

I guess my question was not clear initially 

Can I extract a report where I can see all the vendor "credits" allocated to any/all of the bills?

I would like to see the vendors credits that I have allocated to the bills.  Right now I go the bill, I either go to Reports > Transaction history or on the right hand panel Transactions > Related Transactions...this is where it shows me all the vendor credits associated to a specific bill. I want to extract this information in a report format. 

Thanks for the prompt response, asid.

Yes, you can pull up a report to see all your vendor credits and their associated bills. To do so, I recommend running the Transaction List by Vendor report and then customize it. Here's how:

1. Go to Reports, then select Vendors & Payables.
2. Click Transaction List by Vendor.
3. Select Customize Report.
4. Under Display, check the Paid.
5. In the Filter tab, select Transaction Type.
6. In the All drop-down arrow, click the Multiple Transaction Types.
7. Select the Bill Credit and OK.
8. Click OK.

You can also want to read this article to learn how to memorized reports: Create, Access and Modify Memorized Reports. It includes how to edit and delete a saved report. 

Let me know if you have other concerns regarding your vendors credit report. I'm always around to help. Keep safe!

Thanks for sharing the solution. The report provides me with a list of paid (allocated) and unpaid (unallocated) vendor credits. Which is a good start. What I want to see is, which bill exactly is a specific vendor credit allocated to. For eg.

Bill # 123 - Bill Status: Paid - Vendor Credit # abc

Bill # 456 - Bill Status: Paid - Vendor Credit # def & efg

Bill # 789 - Bill Status: Paid - Vendor Credit # efe, 38ns & aja

Hello there, @asid. Let me help you how to view the bill with a specific vendor credit allocated in QuickBooks Desktop (QBDT). 

In QBDT, you can see the bill with the vendor credit by pulling up a Vendor Balance Detail Report. This way, you can customize the report to show your goal. Here's how:

1. In your QBDT, go to Reports and select Vendors & Payables.
2. Choose the Vendor Balance Detail report.
3. Click the Customize report and go to the Filters tab. 
4. Select Multiple transactions type for the Transaction type.
5. Choose to click the Bill and Bill credit option, then hit OK.

On the other hand, visit this link as your reference in personalizing vendor reports in QBDT. This way, it will guide you on managing reports with vendors: Customize vendor reports. 

Feel free to reply again with more questions about handling vendor reports in QBDT. The community is here 24/7. Have a good one!