Reports

Welcome to the Community space, @Dixymoma.

I am here to share a report that will show the sales for a specific period in QuickBooks Online (QBO).

If you want a report that will show your sales for a specific period, you can consider running a Sales by Customer Summary.

Here's how: 

1. In QuickBooks Online, go to Reports.
2. Enter Sales by Customer Summary on the Find report by name field and click on it.
3. Select a period from the Report period dropdown. You can use Custom to specify the date from the fields next to the dropdown.
4. Once done, click on Run report.

Moreover, I'm adding this helpful article as your reference in personalizing your report: Customize reports in QuickBooks Online.

Return to this post if you have other concerns about running reports in QBO. I'll be here to lend a hand.

Thank you for your response.  I guess I didn't ask the question properly.  You did answer part of it.  But, when I process the profit and loss statements, the income portion of the report includes payments made within the time period that I requested.  In other words, I selected the profit and loss for January 2024.  There were several deposits included in the number because they were deposited in January.  However, they were payments for December invoices.  I'm thinking there is a way to exclude these numbers?

Hello there, Dixymoma.

I appreciate you for clarifying your concern about the data that appears on your Profit and Loss report. I'll provide insights on how the statement works in QuickBooks and troubleshooting steps to ensure you can achieve your goal.

Before that, may I ask for additional information, such as screenshots of your invoices, payments, deposits, and the specific report you are running? This allows me to identify the root cause of the problem and provide accurate details.

For now, please note that if you run the Profit and Profit Detail report, the entries that are displayed on the statement are invoices and payments. The created deposits won't show up from there, and the data that comes up depends on the date the payments were made. With this, I recommend reviewing the payment dates and making sure that December is selected. This way, those entries will be excluded when you run the statements for January 2024.

If the issue persists, I recommend opening your QBO account in a private browser. Then, run and customize your report from there. This is to rule out the possibility of a webpage issue that might cause you to display incorrect data in your report.

Use these keyboard shortcuts based on the browser you're using:

• For Firefox or Microsoft Edge, press Ctrl + Shift + P.
• For Chrome, press Ctrl + Shift + N.
• For Safari, hold down Command + Shift + N.

If it works in incognito, you'll have to clear the cache of your regular browser. This removes the history or log of sites so you can start with a clean slate. If the steps above don't work, use another supported browser as an alternative.

In case you need steps on how to print, email, and export diffrent reports in QBO, you can read this article: Run reports in QuickBooks Online.

Please let me know if you have further concerns about your company snapshot or questions regarding your report in QBO. I'm always around to help, Dixymoma. Take care.

No, this has not been solved.  On a profit and loss report, it is supposed to show you invoices and expenses within the time period that you requested.  This is the same for any company.  I tried to customize the report to omit the deposits, but I wasn't sure how to do that.  If you can tell me how to do this, that is all I need.l

Thanks for your prompt reply, @Dixymoma.

I'll walk you through the process of how to customize a report in QuickBooks Online to see the information you need.

You can follow the steps below to pull up and run the report. Here's how:

1. Go to the Reports tab.
2. Enter and select Profit and Loss report.
3. Filter the Date Range.
4. From there, you can Customize the report then go to the Filter tab and choose the customer and vendor.
5. Then, tick Run report to save its customization.
   
   
   

Since you want to omit deposits, you can find them by clicking the amounts. From there, you can see transactions associated with it.

To learn more about it, please review this handy article: Customize reports in QuickBooks Online.

Moreover, I've added these handy articles that can help you with keeping track and handling reports as well as saving their current customization settings:

• Run reports in QuickBooks Online
• Memorize reports in QuickBooks Online

I'm still ready to back you up if you need more help with reports or other transactions in QBO. I'll keep the thread open so you can comment back.

OK You showed me how to locate deposits.  How do I omit them from the report?

Under filter, is there a way to add a field to the list?  I would like to add Transaction Type and Amount.  If this was available, I would be able to filter the report appropriately.

Thanks for keeping us posted, Dixymoma. Allow me to share details and provide guidance about customizing the Profit and Loss report in QuickBooks Online.

Yes, there's a way to add a Transaction Type and Amount filter to remove the deposits in the report. I'd be glad to show you how:

1. From the report, go to Customize.
2. Click Rows/Columns, then select Change columns.
3. Check the Transaction Type and Amount.
4. Under Filter, uncheck the Deposit in the Transaction Type.
5. Select Run report.

Additionally, I recommend memorizing a report to save its current customization settings.

I'd also like to add a couple more articles in case you need additional resources when customizing reports in QBO:

• Create enhanced custom reports in QuickBooks Online
• View and edit management reports in QuickBooks Online

If you have any other concerns about reports or anything with QuickBooks, please don't hesitate to ask. I'm always here to help.

@Dixymoma 

"But, when I process the profit and loss statements, the income portion of the report includes payments made within the time period that I requested. In other words, I selected the profit and loss for January 2024. There were several deposits included in the number because they were deposited in January. However, they were payments for December invoices. I'm thinking there is a way to exclude these numbers?"

Based on your question, it sounds like you're on accrual basis.  Is that correct?  I will assume it is.  I think what's happening is that you're not recording the payments received on the invoices properly.  You should not have both an invoice and a deposit for that invoice.  Seeing a deposit transaction under income is the red flag if that deposit is for payment on an invoice.  You should have an invoice and a payment.  Payments close out the invoice and record a reduction in A/R, not income.  It sounds like you may have duplicated income because the payments received on the invoices were recorded as deposits.  So, now you have the income from the invoice AND the income from the deposit.  Is that possible?  Are you using bank feeds to record the deposits or ???  Make sure that the payments received on the invoices are matched to the invoices through the bank feed.  Or, if you record the payments received in QB prior to bringing in the bank feed, match the deposit to the payment received.    

"On a profit and loss report, it is supposed to show you invoices and expenses within the time period that you requested."

Assuming you're on accrual basis, QB will only show the income from the invoice (and as of the invoice date) if you receive payment on the invoice.  If you create a separate deposit that is assigned to an income account, QB will duplicate income (the invoice and the deposit) and display the exact behavior you're seeing.