Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
S
shirley-soh
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

    F
    FateCandylaneTQuickBooks Team
    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!

    S
    shirley-sohAuthor
    September 9, 2024

    I'm am trying to produce a report of deposits, esp check deposits.  I enter the check number in the "Ref No." field but I cannot find a way to include that data in a report.  Can you tell me what kind of report, in QBO, I need to show this data?  As I said, I included the column but none of the data I've entered is showing up

     

    Dumping in excel and "customizing" by hand is not an acceptable solution.

     

    s

    Z
    ZackE_QuickBooks Team
    QuickBooks Team
    September 9, 2024

    Thanks for following up with the Community, shirley-so.

     

    You can run your Check Detail report and customize it with the available options in QuickBooks.

     

    Here's how:
     

    1. In your left navigation bar, go to Reports.
    2. Find and open the Check Detail report.
    3. If necessary, click Switch to classic view.
    4. Hit Customize.
    5. Make any customizations you need using your available options.
    6. Select Run report.

     

    You can also customize other reports, such as custom reports, using your available customization options. In the event you're unable to get check numbers to show up on a report while customizing it, you can use the steps available in FateCandylaneT's post to export and customize it further outside of QuickBooks.

     

    You also have the option of checking our QuickBooks App Store for apps which may be able to help you achieve what you're looking to do.

     

    I've additionally included a detailed resource about using QuickBooks which may come in handy moving forward: How do I submit feedback?

     

    Please feel welcome to send a reply if there's any additional questions. Have a lovely Monday!

    BigRedConsulting
    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.

    S
    shirley-sohAuthor
    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
      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.

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement