Skip to main content
G
GTygert
June 5, 2025
Question

Transaction Detail Report

  • June 5, 2025
  • 2 replies
  • 0 views

I have been trying for weeks to come up with a way (other than the Customer or Class fields) to add a unique customer ID to each payment and have it show up when I run the Transactions by Account report.

 

A little background, we pay one vendor for multiple "sub-vendors" so for example we may pay The Green Arm for The Green Arm - Cal Zeb, The Green Arm - Wheel of Fire and The Green Arm - Dyan Fre. All of these are paid to The Green Arm, however each "sub-vendor" has their own unique ID.

 

In addition, we don't enter these as invoices in QBDT, we enter them as checks, and since we use the Customer:Job and Class for other things those are not options for this. I have tried using items as a work around, but then my amounts change to zero on the report, because the "item" which is actually an ID # doesn't have a $ value associated with it.

 

I have also tried using Sales Rep, but that field doesn't pull to the report even though it's an option in the write checks window and as a column on the report! I don't understand if the options are there why they don't work!!! Something that bothers me A LOT about QB, but that's a rant for another day!

 

If anyone has any ideas no matter how far fetched please let me know! I am willing to try just about anything at this point!

 

Thank you in advance!

    2 replies

    BigRedConsulting
    BigRedConsulting
    June 5, 2025

    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.

    G
    GTygertAuthor
    June 6, 2025

    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! 

    BigRedConsulting
    BigRedConsulting
    June 6, 2025

    @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?

    J
    Jovelyn_M1
    June 6, 2025

    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.
      list-item-image-content
    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.

    G
    GTygertAuthor
    June 6, 2025

    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

    Terms & ConditionsAccessibility statement