QUIKBOOKS DESKTOP: Report for ITEMs with customer and Monthly sorted.

Certainly, Sajid. I can help you access the reports in QuickBooks Desktop (QBDT).

Creating monthly and yearly sales reports is a great way to gain insights into your income using QuickBooks. While there may not be a standard report that perfectly fits your needs, you can access the Sales by Customer Detail report and customize it to suit your requirements.

Here's how:

1. Go to the Reports menu at the top of your screen.
2. Select Sales and then choose Sales by Customer Detail.
3. Once the report is generated, click the Customize Report button to modify it according to your needs.
4. If you want to display specific customer names, select the Name options.
5. Choose the desired date range for the report. To see sales by month and year, select a date range that covers the period you want to analyze.
6. Click OK to complete the process.

To learn more about running reports in QBDT, you can check this article: Understand reports.

After customizing, you can export the report to Excel. From there, you can modify it to add columns for the months, listing customers on the left, with each product or line item displayed for each customer.

Following these steps will quickly produce a comprehensive report highlighting Items, Customers, and Months. If you have any questions or need further assistance, feel free to post here again. We’re available 24/7 to help with any queries you may have.

It's good to see you again on this thread, @sajidrasheed.

Currently, generating a detailed report you want isn't an option. However, you can tailor it to your needs with the information below.

As suggested by my colleague, LollyNino_C, you can pull up the Sales by Customer Detail or Sales by Item Detail report and customize it. Alternatively, exporting it to Excel will enable you to adjust the Items, Customers, and Months as desired.

Once the report is ready to be exported, here's how:

1. Navigate to Reports, then Reports Center.
2. Locate and double-click the report you want to export.
3. Select the Excel ▼dropdown, then choose Create New Worksheet or Update Existing Worksheet. 
   
    
4. If you encounter a message that says your report has too many columns, select Advanced, then uncheck the Space between columns checkbox. Select OK.
5. When you’re ready to export, select OK.

Furthermore, you can save customized report settings for future use by memorizing them. This way, you do not have to go through the customization process again. 

Feel free to click the Reply button below for queries about modifying your reports in QuickBooks Desktop. We'll circle back to help you.

Hello there, @sajidrasheed. I'm here to help you customize your Sales by item report and add customers to this report in QuickBooks Desktop to better align your preferences. I'll guide you through the steps and tailor the report to suit your specific needs.

Let's dive into these steps:

1. Open your QuickBooks Desktop.
2. Go to the Reports menu.
3. Select Report Center.
4. In the upper right corner, enter in the search bar Sales by item.
5. Under Sales by item Detail, Click on Run.
6. Click on Customize Report.
7. In the Columns section look for QTY, then uncheck it.
8. Hit Ok to save the changes.
   
   
    

Now, Let's add customer to this report. Here's how:

1. Go back to Report Menu.
2. Select Report Center.
3. In the upper right corner, enter in the search bar Sales by item.
4. Under Sales by item Detail, Click on Run.
5. Click on Customize Report.
6. In the Columns section look for Name. then check it.
7. Hit Ok to save the changes.
    

For your better experience, open this link: Customize customer, job, and sales reports in QuickBooks Desktop.
 

For your future reference on how to personalize company and monetary report, refer to this article: Customize company and financial reports.

Tailoring your QuickBooks Desktop settings to fit your preferences can be very useful. If you need any more help or have questions, feel free to comment below. I'm here to assist you.