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

QuickBooks Desktop - Adjust report date range

Hello, I am trying to find a way to run a rent roll report for my company. The method we currently use is by utilizing the Customer Contact List report to show the start/end date of the customer, along with other important information. 

The issue arises with the balance. The customers' recurring charges are set up on automatic memorized entries that post 20 days into the month. Say I go to run the Contact List report in the middle of January, charges from February will appear in the customer's balance. I don't want that. 

Is there a way to change the date range of the report to only show the current customer charges? If not, is there a similar report I could be using that would show the customer's balance along with their start/end date? 
Thank you!

10 Comments 10
BigRedConsulting
Community Champion

QuickBooks Desktop - Adjust report date range

No, List reports like the Customer Contact list report don't have a concept like that. They just report on current information.

JonpriL
Moderator

QuickBooks Desktop - Adjust report date range

Hi @Trey_A, I'll help customize your report.

 

You have the option to choose a date range to limit the customer charges showing on your report. I'll show you how.

 

  1. Access the Customer Contact List report.
  2. Go to Customize Report.
  3. Select Filters.
  4. Under CHOOSE FILTER, enter Date.
  5. Choose Start Date and End Date.
  6. Type in your desired report date range.
  7. Click OK.

 

I'm adding these articles to learn more about how you can customize a report: Customize Reports in QuickBooks Desktop.

 

Below are references you can use to keep up with your report and understand your current financial status:

 

 

Don't hesitate to post again here if you have other questions or concerns with QuickBooks generating reports. I'm always around happy to help. Stay safe and have a good one!

kcludlow
Level 2

QuickBooks Desktop - Adjust report date range

The report date range does not have an "OK" button for the customer contact list report. It's the only report that does not allow you to click "OK". QB needs to fix this. I can't run this report without it.

LollyNino_C
QuickBooks Team

QuickBooks Desktop - Adjust report date range

Nice to see you here in the Community, @kcludlow. This behavior with the missing OK button might caused by damaged data.

 

Before we begin the troubleshooting, open a sample file to determine if the behavior is the same as your company file and find out if the issue is with your QuickBooks Desktop (QBDT) software. Once opened, change the report date range in the sample company file. You may follow the steps provided above.

 

If the error persists, follow the steps outlined in the following article on how to manually repair your company file: Fix data damage in your QuickBooks Desktop company file. I do have steps here that we can follow. Here's how:

  1. Download QuickBooks Tool hub.
  2. Open and install the downloaded file.
  3. On the QuickBooks Tool app, select Program Problems.
  4. Click Quick Fix my Program.

Once done and nothing happens, follow the second steps. I'll guide you how:

  1. Go to the Start menu.
  2. Select Control Panel.
  3. Under Program and Features, select Uninstall a Program.
  4. From the list of applications, select QuickBooks.
  5. Select Uninstall/Change.
  6. Click Repair.

 

If you can edit the date range in the sample company, go back to your original file, update QuickBooks Desktop to the latest release, and perform the Verifying and rebuilding data. It's a built-in tool that auto-detects and self-resolves minor company file data issues.

 

In case you want to fix common errors right away and set up timesheets, print them, and run a timesheet report. Just check out these articles:

 

 

Stay in touch with me if you need additional information about your reports. I'm always around to help you.

kcludlow
Level 2

QuickBooks Desktop - Adjust report date range

Thanks for your reply. I do not have QB Desktop but QB Online so your advice doesn't apply. I have no clue why the subject this forum gave me was Desktop. I never chose that option.

Carneil_C
QuickBooks Team

QuickBooks Desktop - Adjust report date range

I appreciate you getting back on this thread and clarifying the QuickBooks product you're using, @kcludlow.

 

QuickBooks Desktop and QuickBooks Online are two separate, though similar, products. They're both accounting software with totally different database structures.

 

In QBO, we can click the Run report option after modifying the date range from the filter customization. This way, it will save the information you've changed or customized. Here's how:

 

  1. Go to Reports from the left pane and type in Customer Contact List report in the search field.
  2. Click on Customize.
  3. Personalize the details according to your needs.
  4. Click on Run report.

 

You can also check out this article for more details about this process: Customize reports in QuickBooks Online.

 

On top of that, I’ve added this great resource that helps you save its current customization settings for future use: Memorize Reports in QuickBooks Online.

 

If you have any trouble with your reports or other transactions in QBO, please let me know, and I'll do everything I can to help here in the Community.

kcludlow
Level 2

QuickBooks Desktop - Adjust report date range

Thanks for the response, but that's why I'm on here. The "Run Report" button is missing. I've used QBO for many years and am an accountant myself. The button is missing.Screenshot 2023-09-07 at 7.18.46 AM.png

Mark_R
Moderator

QuickBooks Desktop - Adjust report date range

Hi there, @kcludlow.

 

Thank you for sharing a screenshot of your concern. I'm here to help ensure you can run a report according to your needs.

 

The Run Report button is only available in the old report interface. With the new interface, you'll just need to select the Customize button and add the details you want to show on the report. This will automatically update the report. I'll attach a screenshot below.

I'm adding this article to learn more about customizing reports in QuickBooks Online (QBO): Customize reports.

 

Just in case you want to save its current customization settings for future use, you can check out this article for more guidance: Memorize Reports in QuickBooks Online.

 

Come back to this post if you have other concerns or follow-up questions about this. I'll be around to provide further assistance.

kcludlow
Level 2

QuickBooks Desktop - Adjust report date range

I appreciate the response but that is the very first thing I tried. When I enter my custom dates, the report doesn't change. As you can see from my screenshot, I have custom dates entered but the report is still only showing the current year.Screenshot 2023-09-07 at 2.36.11 PM.png

SarahannC
Moderator

QuickBooks Desktop - Adjust report date range

Thank you for returning to this discussion and including a screenshot to provide further clarification, kcludlow. 

 

Changing the dates in the Customer Contact List report won't affect the information displayed because this feature is designed for transactions, not customer details.

 

The custom dates feature works in other reports, like Transaction List by Customer and Transaction List by Vendor. I understand that this might be confusing, so let's offer feedback directly to our product engineers regarding the modern report.

 

  1. Log in to your QBO account.
  2. In the search field, enter Customer Contact List.
  3. Click the Give feedback.

 

Still, I would like to ask about the specific information you would like to get through the report. By knowing your specific needs, it allows me to give you more precise assistance with the right information.

 

If you have a specific question about QuickBooks reports or need general guidance, please feel free to ask me. I'm here to lend a hand! Take care always.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us