How do I take out deposits from the "sales by customer summary". I can do this with the detailed report, and now need to match the summary to this.

You can tailor your Sales by Customer Summary report to display only the transactions you wish to see by using the filter options, hello234. Let me provide the steps below. 

If you're using the modern view, follow these steps:
 

1. Go to the Reports menu.
2. Enter Sales by Customer Summary in the search field.
3. Click on Filter, then select Transaction type in the first field.
4. In the second field, choose equals and then Invoice.
   
   

If you're using the classic view, here's how to proceed:
 

1. Click on the Customize button.
2. Under the Filter section, choose Invoice from the Transaction type drop-down.
3. Hit Run report to view the filtered results.
   
   

For more information, you can check this article: Customise reports in QuickBooks Online.

Additionally, learn how to export reports to Excel so you can use them outside of QuickBooks. For complete guidelines, refer to this material: Export your reports to Excel from QuickBooks.

If you have follow-up questions about managing your reports in the system, feel free to click the Reply button below. I'm always here to assist you.

Hi Louise, thanks for your reply :)

The filter doesn't give me the option of "transaction type".

From modern view, I can click filter, and then I get 3 boxes.  The top one is "select one" - when I click the down arrow, I see "Customer" "Payment method" and "Product/Service". 

This is different to the detailed report, where I have lots of filter options, which have allowed me to select "invoice" and "credit note". 

If I try classic view, and click "customise", again the filters only include the 3 mentioned above

I appreciate you getting back to us with an update, hello234. Let me provide additional clarification about taking out deposits from the Sales by Customer Summary report in QuickBooks Online (QBO).

You're correct that the Sales by Customer Summary report doesn't allow you to filter by transaction types such as invoices or deposits. It's because the report is designed to provide a quick overview of total sales for each customer, without including the details of each transaction.

Since it adds up all sales, it can’t separate or exclude deposits or payments. If you want to see and filter specific transaction types, I recommend utilizing the Sales by Customer Detail report as it shows each transaction and lets you filter by type.

This helps clarify how the summary report works and guides you in choosing the right report for your needs. 

You can also refer to this article for guidance on how to efficiently tailor reports to get the most relevant insights from your financial data in QBO: Customise reports in QuickBooks Online.

Moreover, I'll provide this article to help you save all the customizations made on your reports in QBO: Save a customised report in Quickbooks Online.

Furthermore, if you need professional assistance from a bookkeeping expert, consider contacting our QuickBooks Live Expert Assisted team. Our knowledgeable team of experts stands ready to provide immediate support tailored to your business's unique needs, like managing products and adding them to your sales and expense transactions.

The Community always has your back if you need additional assistance managing reports or any QuickBooks-related concerns, hello234. We're always here to help.

Hi Jayson, thanks for your reply. 

How should one post a sales payment on account please, so that it doesn't duplicate itself into the "total sales" figure on the "sales by customer summary"?  It is not appropriate to create an invoice for these items, and they shouldn't effect the PL sales or VAT, only the debtor account.... I haven't seen another way to post it from the bank feed. 

Also, I can collapse the detailed report to provide something similar to the summary.  How can I add the comparative year to this report, so the client can easily see the total of "real sales" year on year, side by side.

It's a good idea to post a sales payment on account, @hello234. I'll provide some insights on this and how to include a comparative year in the report.

Currently, the feature to post a sales payment directly on account is unavailable. It's important to note that the accounts affected when creating sales transactions are those associated with the item. Therefore, we can't select a specific category when creating sales transactions, unlike with bills or expenses.

Regarding your second query, you can create a Profit and Loss Comparison report to add your comparative year, which allows your client to view the total real sales. Here’s how you can do it:

1. Go to the Reports section and enter Profit and Loss Comparison in the report search field.
2. Set the Report Period and the Date.
3. Click on the Compare option and select your desired time period.
4. Review the report, then click Save As.
5. Finally, click Save.

You can also check this guide to customise reports and focus on the details that matter the most to you: Customise reports in QBO.

If you want to save your customized report for easy access in the future without having to recreate it each time, you might find this article helpful: Save a customized report in QBO.

Please let me know if you have further questions about sales payment on account or the P&L report. I’ll be around to lend a helping hand.