Question

How to Show Transaction Numbers in Transaction Detail Report

Forum|Forum|5 years ago
July 13, 2020
4 replies
0 views

In QuickBooks Desktop, when you run a transaction detail report (Transaction Detail By Account), you can see the transaction number that is automatically assigned by QuickBooks. How do you display the same in QBO? I've looked for the transaction number column under "Customizations" for that report and could not find it.

QuickBooks Online

N

Nick_M

Hi there, frassers.

I'm happy to help show you how to turn on transaction numbers. Follow these steps below and you'll be on your way in no time.

Go to the Gear icon.
Under Your Company, select Accounts and Settings.
On the Sales page, click Sales form content.
Select the checkbox for Custom transactions numbers to turn it on.
Click on Save and then Done.

Once completed your transaction detail report will have transaction numbers.

If you have any other questions or concerns, feel free to post below, thank you for your time and have a nice afternoon.

P

ptownbroAuthor

Thank you for the reply, but you solution did not work. My apologies if my original post was not clear. I am not looking for CUSTOM transaction numbers. I'm looking for the SYSTEM GENERATED transaction numbers that QBO automatically assigns to each transaction. Again, this is available in QuickBooks Desktop. I'm looking for the same in QBO.

I've attached an screenshot image of the customization options available under the "Transaction Detail by Account" report in QBO. You'll see that transaction number is not available. BTW... neither the custom or system transaction number is available (I tried turning custom numbers on as you suggested, and even that doesn't show).

S

Steve_C

Hi frassers.In QuickBooks Online, you can enter a reference number in the Ref Num box on your transactions that do not display an automated transaction number to have them display on your reports.

The only transactions that an automated reference number will appear for are money in transactions, such as invoices or received payments. Make sure you follow the instructions Nick provided above to turn on the display of automated transaction numbers as well. Expenses and other transaction types won't display a transaction number. If you run into anything else, just leave a reply below and I'll get back with you as soon as possible. Have a great day.

M

Mwolf003

@ptownbro @wonderwoman : It appears you have some knowledge regarding the Trans # in QB desktop. I prefer running reports using this number as it is a true unique identifier and cannot be duplicated. Do you know how to search for transactions using this special number? I cannot find any useful information on how to leverage this field in QB desktop. The only way I've successfully used it is by adding it as a column to a report but I would like to be able to "query" QB desktop to make this number more meaningful.

M

mv32

Hi there, @Mwolf003.

There are lots of ways to search for transactions in QuickBooks Desktop. You can press Ctrl + F to find a specific entry type like invoice and bill to show their reference/transaction number. To use this feature, press T to filter for Transaction type and select it from the list. Then you can choose a specific transaction, then click Find to run a Report.

And yes, you're correct that you can customize a specific report to show them on a column.

In your case, you'll want to search for transactions using their reference ID or number, then clicking the Search icon tool is your choice. It may take a while to look for a specific transaction using the number, especially when there are lots of entries created in QuickBooks.

You can also use the drop-down button to find a specific transaction type, amount, and date.

Please let me know if you have additional questions. I'll get back to you soon. Take care and more power to your business!

M

Mwolf003

@mv32 Thank you but I don't believe this is answering my question. I am looking for a very specific field that is not showing up in what you've just demonstrated. It seems no one has really addressed this field or question and keeps showing the same thing and that thing is not what I'm referencing. If you look at the response from @wonderwoman regarding what this is it may help. I am hoping that someone from QB can provide guidance on this. This field is a "behind the scenes" system generated number that is truly unique, cannot be duplicated, and cannot be manipulated. That makes it far more useful than the "Num" field everyone from QB keeps referring to. I've included a picture of the field. The fact that this field exists should mean that there is some way to query it or if not already a way to query it a way that QB can make it searchable.

L

LisaAZ

I followed this whole feed and I'm trying to find out how to run a transaction detail report in QB desktop that gives me the column with the QB unique assigned identifier number. I see a lot about QB online but nothing that tells me how to get that in QB desktop. Can someone please tell me the steps to get that system generated number for each transaction on my transaction detail report please?

Thank you

K

Kurt_M

Thanks for joining the thread, @LisaAZ. Let's work this out so you can add a new column for identifiers in your QuickBooks Desktop (QBDT) transaction report.

Before anything, know that I want to ensure I can provide you with the best possible solution available. Can you tell me more about the identifier? May I know how you entered it in your QBDT company? This way, I can get more details and provide you with the suitable steps to add a new column on your reports specifically for the Identifier number.

Please don't hesitate to get back to me. I'll be more than happy to help you sort this out as soon as possible. Stay safe, and have a nice day!

D

Dan2601

When making a journal entry, QBO captures the Journal no. in the journal no. field on the header. That number is reported as a concatenation of the action and the journal no. in the audit report. Why can ALL transactions not have this id? It is just good/required accounting, makes audits easier, and tracking easier for all. Or add a proprietary QBO sql for users to query their data.

MiamiAccountant

You can indeed have the internal transaction number show up in the Transaction Detail Report. It is actually called the Transaction ID. The trick is to use the New Enhanced Experience (or Modern View) version of the report. This version is available in QuickBooks Online Advanced. It allows for a whole lot more customization of the report including adding many more columns than what are available in the Classic View Transaction Detail Report. See the image I have attached that shows how to add the Transaction ID column to the report.

If this has helped you and you do not already have QuickBooks Online Advanced, we are an Intuit Authorized Reseller and can provide you with a discounted upgrade to QuickBooks Online Advanced. Feel free to reach out to us for details.

R

rnolfe1

We just got the Dancing Numbers plugin and it shows a QuickbooksID that is unique for every line. This was $100 for 1 year.

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded