Question

Unallocated Credits

Forum|Forum|2 years ago
January 3, 2024
1 reply
0 views

I have QB Desktop 2016

I have 2 questions

1. I am trying to extract in a spreadsheet format all my unallocated vendor credits. When I go to Vendors > Pay Bills > Select a bill > Set Credits...the pop-up window that opens here, can I get this in an spreadsheet format?

2. Secondly, I want to extract a report in spreadsheet format where I can see all the allocated vendor credits against the bill. Right now I go the bill, I either go to Reports > Transaction history or on the right hand panel Transactions > Related Transactions. This list now shows me all the vendor credits allocated to this bill and any payment for this specific bill. I want a report where I can see in a single sheet all the bills where I have previously allocated a transaction. Or all the transactions which have been allocated to bills?

Thanks

QuickBooks Desktop

F

FateCandylaneT

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:

Go to Reports and select Vendors & Payables. Then, click Vendor Balance Detail.
Select Customize Report.
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:

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

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

Review all the information and click OK.

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

Go to Reports, then Reports Center.
Find and double-click the report you want to export.
Select the Excel ▼dropdown, then Create New Worksheet or Update Existing Worksheet.
If you see a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
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!