cancel
Showing results for 
Search instead for 
Did you mean: 
marc15
Level 1

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

 
9 Comments 9
Kristine Mae
Moderator

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

I'd like to know more about this, Marc15.

 

What report are you referring to? This way, I can provide an accurate answer.

 

In the meantime, you can try to customize the report. This will help you filter or format things that way you want them. 

 

You can get back to this thread with more information. We're right here to help you out. 

marc15
Level 1

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

Here you go.

BettyJaneB
QuickBooks Team

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

Hi there, @marc15.

 

You've got me here to provide some insights on why reference number column is not populating in the Transaction Report for Income Accounts.

 

The option to have the Reference number column to show up in the said report isn't available. It only displays the transaction number of the invoices, sales receipts, and credit memo that are included in the Income Account

 

To view the reference number of your deposits, you can run the Deposit Detail report. These figures will show up under the Num column. Please see the screenshot attached for reference: deposit ref.PNG

 

To give you more details the sales reports that you can pull up on your QuickBooks and on how to customize them, please see these links:

If there's anything else that I can assist you with, let me know. I'll make sure you're all set. Stay safe!

marc15
Level 1

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

The display customization does not seem to be the issue. The reference number is displayed with the COGS account . 

Pabz_L
QuickBooks Team

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

Thank you for your reply, @marc15.

 

The source of the NUM column in the report is the transaction number like invoice numbers. While the ref number on the deposits are assigned per line instead of the transaction itself. That is why when you pull up the report, the reference number for your deposits won’t show up.

 

For now, I advise following the steps above given by my colleague. to help you show the reference number when you run a report.

 

Also, you can refer to this article for additional information. Customize reports in QuickBooks Online.

 

Fill me in if you have any other questions. have a great day!

marc15
Level 1

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

The reference number box is flagged by default for the transaction report, as reflected in the attach image in the previous response to your colleague.

 

As per my attachment, in my prior response, the reference number per each transaction per deposit is entered in the provided QB field. I ran multiple QB reports where the ref number column is displayed but data field is empty. 

 

FYI- I am using Quickbooks online not Desktop version. Not sure if that makes a difference. 

katherinejoyceO
QuickBooks Team

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

 Thanks for actively responding, @marc15. I understand the need to display the reference number in the reports. However, this functionality will not display regardless if you've selected it. 

 

I will share your feedback to our engineers for further study. In the meantime, visit the QuickBooks Blog to get updates on the latest features and innovations.  

 

Feel free to message again if you have additional concerns. We're always delighted to help. 

marc15
Level 1

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

Thank you Katherine.

A lot of the automation processes that I build off of the QB reports are dependent on an identifier, which in this case is the reference number. I am at a stand still or looking for a work around, however I do believe that this is a bug in the report that QB should look into and resolve.

ReymondO
QuickBooks Team

Why is the reference number column not populating in the transaction report for Income accounts? It populates for COGS.

Hi there, @marc15.

 

I've read the entire thread and it seems that they have already provided the basic troubleshooting steps to fix this issue.

 

I recommend reaching out to our Customer Support Team. This way, they can perform an investigation to determine why the reference number is not populating in the transaction report. 

 

You can reach them out by following these steps:

 

  1. Click the Help icon.
  2. Hit the Contact Us button at the bottom. 
  3. Enter "Reference number is not populating in transaction report" in the description, then click Let's talk.
  4. Choose Get a callback.

 

Please check out our support hours to ensure that we address your concerns on time.

 

Let me know how it goes in the comment section. If you need additional assistance in doing your task with QBO, don't hesitate to visit us back. We'll be happy to help.

Need to get in touch?

Contact us