Transaction Detail Report

If you mean that you want to include the payee's account number on a report, then...

Enter the ID in the Account No. field on the payee/vendor records, which is found on the Payment Settings tab, for the account number.

Then add the Name Account # column to your transaction report and you'll see the number there.

Unfortunately, that is only good for the main vendor, I need to be able to identify which sub-vendor each payment went to. Thank you though! 

To add a unique customer ID to each payment, we can use the Memo field, Gtyger.

To do so, we have to input it into the Memo field manually.

Here's how:

1. Go to the Banking menu.
2. Select Write checks.
3. From the Bank Account dropdown, choose Checking.
4. In the Pay To The Order Of field, type your sub-vendor name.
5. In the Memo field, manually type in your sub-vendor unique customer ID.
   
6. Enter the necessary details for the certain vendor.
7. Hit Save & Close.

To check for your created transactions, you can run and customize the Transaction Detail by Account. Make sure to enter the accurate date range and the transaction type.

You can check the attached screenshot below:

For future reference, I'm including this resource to help you export your reports to Excel from QuickBooks Desktop: Export reports as Excel workbooks in QuickBooks Desktop.

Keep us posted if you need further assistance.

@GTygert 

RE: I need to be able to identify which sub-vendor each payment went to. 

Do you mean the line item or the entire check/payment? I think the line item?

The sub-vendor is not entered on the check, right? So, how could it happen that you'll automatically see an ID on the report?

RE: ...and since we use the Customer:Job and Class for other things those are not options for this. 

Do you mean that you use the Customer:Job on these particular checks, or that you use the the field in general for customers?

That is what we are currently doing, however then once the report is run, we have to manually separate the ID into it's own column, we are looking to have it already in it's own column to avoid having to do it manually

Yes, the line item needs to have the sub-customer ID. And yes we currently use the Customer:Job field in general, not just for these checks.

If your goal is to enter the ID's and have them appear on a report in their own column, then this will work using the Expenses tab on the check:

1. Set up an Item based custom field (even though you're not going to use items for this option). Do this by editing an item, like a part of a service, and then click Custom Fields, and then Define Fields. Perhaps call the field "Vendor ID" or "Customer ID" or whatever you want to see on the report as a title.
2. One the Check's Expenses tab, right click and choose Customize Columns and then add the new field to the table.
3. For each row that needs an ID, enter the ID and save the check.
4. Add the column to your Transaction Detail report.

Or you can use the Items tab and then the custom ID field can be made to auto-fill:

1. Instead of using the Expenses tab, use the Items tab.
2. Add the custom Vendor ID column to it as on the Expenses tab.
3. Set up and use the an item for each Sub-Vendor. Perhaps an Other Charge type item.
4. As you set up the item for each sub-vendor, add their ID to the item in the custom field.
5. Then, when you use it on the check, the ID will auto-fill - so no need to add it manually.

That was a GREAT idea and I was so excited, but alas, it did not pull to the report :o(

It works for me or I wouldn't have suggested it. I tried Rep and it works fine as well.

I tried it with QuickBooks 2019. What version of QuickBooks are you using?

Here's my test check and transaction report with a the custom Vendor ID and the standard Rep fields:

It think it could be because the accounts I am pulling into the report are bank accounts? It could also be the report I'm pulling, your report says Custom Transaction Detail Report, mine says Transactions by Account?

I'm using QB Enterprise Solutions 24.0

That makes complete sense! 

I have to run the report from the other side of the entry, which I just did and it works!!!!

Thank you so much you have no idea how helpful you have been!!!