Custom Summary Report

Thanks for visiting the Community today, @talk2khurram. I appreciate the screenshot you've shared.  

As an insight, the Custom Summary report will pull up data depends on the accounts, regardless of the dates you've entered or the accounting method used. 

For future reference, read through this article: Customize reports in QuickBooks Desktop. It helps you learn about generating personalized reports to only show details that matter to you and your business. 

Let me know if you have more questions. We're always here to help. 

Hi 

Thanks for your reply. Can you tell me the solution?

Thanks and regards,

Thanks for coming back to the Community, @talk2khurram.

I can share and guide you with the steps on how to resolve the incorrect data on your report. Let's go to your Lists settings to see it. 

Here's how:

1. Go to the Lists menu at the top, then select Chart of Accounts.
2. Scroll down to the Account drop-down, then choose Re-sort List.
3. Click OK when prompted.

Re-sorting your account list will help fix the odd behavior of your account. After re-sorting, run the Verify Data Utility tool. This tool will help check and fix data damage of your QuickBooks. Let me walk you through the steps.

1. Go to the File menu at the top, then choose Utilities.
2. Select Verify Data. If QuickBook detected no data problems, no further action needed. If you see a specific error message, this indicates data damage in the file. You'll need to continue by running the Rebuild Data to correct the error. 
3. To rebuild, go back to File, Utilities, and then Rebuild Data.

Once done, restart your computer and check your customer report again. For more details about the verify tools, check out this guide: Verify and Rebuild Data in QuickBooks Desktop.

In case you need help with fixing your file, check out this link for the step-by-step solutions.

Please let me know how it goes or if you still have questions. I'm more than willing to answer them for you. Have a great day ahead.

Hi

Thanks for your reply. I did the same what you suggested but i my problem not solved. Kindly find below pictures.  My custom summary report period is September 21- 23, 2020. But Repair and Maintenance Account Manual section 500 which I recorded 31/08/2020 showing in my custom summary report. I do not want to show Repair and Maintenance Account Manual section 500 which I recorded 31/08/2020 in this report.

Thanks and regards,

Thanks for the prompt reply, @talk2khurram.

I also appreciate the additional screenshots you shared. Let's perform some steps to isolate this unusual behavior. I recommend deleting and recreate the check. I’d be glad to guide you how.

1. From your Transactions by Account report, double click on the check to open the transaction.
2. Click Create a Copy from the top menu.
3. Then select Delete to delete the check. 
4. The copied check will be posted on the recent date. Locate and open the copied check and change the date to August 31, 2020.
5. Click Save and Close to save the changes.
6. Go back to your Custom Summary Report and click Refresh to load the recent changes made.

If the issue persists, I suggest downloading our QuickBooks Tool Hub. This tool fixes issues within your QuickBooks Desktop (QBDT) company file.

I’m also adding this article that you can utilize in case you need some guidance in exporting your reports to MS Excel: Export reports as Excel workbooks in QuickBooks Desktop.

I’ll be around if you have other concerns or questions in managing your reports in your QBDT software. Tag me in and I’ll swing back into action. Take care and stay safe!