Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
September 9, 2024
Question

Ref # Data in Reports

  • September 9, 2024
  • 2 replies
  • 1 view

I created a custom report of contributed income and am able to add the "Ref#" column, but the data I've entered (specifically Check #) doesn't show up in the report. I really need this data. How can I get it to show up? (I tried to take a screenshot with your camera icon, but that feature still doesn't work). 😞

2 replies

QuickBooks Team
September 9, 2024

It's great to have your query shared on this forum, Shirley. Let me provide inputs when managing customized data reports in QuickBooks Online.

 

Beforehand, may I know what custom report you're trying to assess? You can also share screenshots so I can have a clearer reference of your end. Any additional details would be much appreciated.

 

In QuickBooks, several reports can help you track specific Check# data under a Ref# column. With that, you can run a Check Detail or Transaction List by Customer report to enable check detail numbers are accurately recorded in your transactions. To do this:

 

  1. In your QuickBooks Online account, go to Reports and enter Check Detail or Transaction List by Customer report from the Search panel.
  2. If necessary, click on the Switch to Classic View option. Then, click on the Customize icon.
  3. Under the Rows/Column section, click Change Columns and enable the Num or Ref# checkbox.
  4. Review all details and select Run Report.

 

In addition to this, you may consider exporting your report to an Excel file and adding further detailed customizations from there. Doing so will allow you to manually modify each check entry number and enter them on your file.

 

  1. At the right panel, choose Reports.
  2. Look for and select the report you want to export.
  3. At the top of the report, select the Export icon, then click Export to Excel.
  4. Save the file to where you can easily find it, such as your Downloads folder or your desktop.

 

Moreover, here's a guide you can utilize to help you review your account to ensure they always match your bank and other financial statements: Reconcile an account in QuickBooks Online.

 

If there's anything else you need additional assistance with when managing data reports in your company file, feel free to let me know in the comments below. Keep safe!

BigRedConsulting
Level 15
September 9, 2024

@FateCandylaneT 

The issue, as stated, is: "I created a custom report of contributed income and am able to add the "Ref#" column, but the data I've entered (specifically Check #) doesn't show up in the report."

 

The Ref# is not found on a check or a bill, nor would a report of contributed income include checks or bills on it. Obviously.

 

The Ref# is found on a sales receipt (and perhaps other sales transactions as well - not sure).

 

Did you address the issue? No, you did not.

 

Did you read and understand the OP's question? No, you did not.

BigRedConsulting
Level 15
September 9, 2024

@shirley-soh  RE: I created a custom report of contributed income and am able to add the "Ref#" column, but the data I've entered (specifically Check #) doesn't show up in the report. I really need this data. 

 

There is at least one report that will populate the field, the Deposit Detail report.  The Ref# field data will appear there in the Num column on the classic view of the report.

September 9, 2024

Yes, I do see that the "Deposit Detail" report reveals the check number I enter in the "Ref No" field when entering deposits.  Is this the only report that will provide check # info? I was hoping to create a custom report where I could include the check#s.

BigRedConsulting
Level 15
September 9, 2024

RE: Is this the only report that will provide check # info? I was hoping to create a custom report where I could include the check#s.

 

I'm not sure if it's the only report. It's the only one I've found. QuickBooks Online reporting is quite weak, buggy, and seems like a partial (half as*ed) implementation most of the time.