My P & L does not match my Sales Report. How can I get a total for the deposits per month so that I can figure out what is missing or duplicated?

Hello, Niecy. 

Thank you for your inquiry. I understand you are experiencing a discrepancy between your Profit and Loss (P&L) statement and your Sales Report in QuickBooks Online. I'm here to help you understand and resolve this issue.

There are a few reasons why your P&L may not match your Sales Report. Here are some common factors to consider:

• Timing of transactions: The P&L statement captures income based on the date of the invoice or sale, while the Sales Report reflects the date the payment was received. The two reports can create a discrepancy if you have outstanding invoices or payments that have not yet been recorded.
• Accrual vs. cash basis: The P&L statement can be generated on either an accrual basis or a cash basis. If your P&L is on an accrual basis, it will include income from sales made but not yet paid for. On the other hand, the Sales Report is typically generated on a cash basis and only includes payments received.
• Sales items point to incorrect sales accounts.
• The P&L report includes transactions that do not use items.

The following steps should help correct the discrepancy between the Profit and Loss and Sales report:

1. Confirm that the reports have the same date range and basis.
2. Make sure the items point to the correct accounts.
3. Check for transactions without items.
4. Compare the detail reports line by line to find differences.

To get a total for the deposits per month and identify any missing transactions, you can follow these steps:

1. Go to the "Reports" tab in QuickBooks Online.
2. Search for and select the "Transaction List by Date" report.
3. Set the report period to the specific month or date range you want to analyze.
4. Customize the report to include the necessary columns such as "Name of Customer," "Payment Method," and "Transaction Type."
5. Review the report to identify any missing deposits or discrepancies.

By analyzing the Transaction List by Date report, you can compare the deposit recorded in QuickBooks Online with your actual bank deposits. 

This will help you identify any missing or unrecorded transactions that may be causing the mismatch between your P&L and Sales Report. 

For additional reference, I'm adding some articles on how you can filter out the data from your reports and save its customization settings for future use:

• Customize reports in QuickBooks Online.
• Memorize reports in QuickBooks Online.

Please don't hesitate to reach out if you have any further inquiries or if there's anything else I can help with. I'm just a post away. Have a great day!