Profit and Loss reports

It's good to have you here in the Community, @Badgers10.

Customizing the profit and loss report to show only the total income for invoices isn't available in QuickBooks Online (QBO). Please know that the report is designed to display all the total income of the business, and it includes bank deposits.

As an alternative, you can consider running and customizing the Transaction Details by Account. This will help you see the total sales of the invoices. Here's how:

1. Sign in to your QBO account.
2. Click Reports from the left menu.
3. Search for the Transaction Detail by Account report.
4. In the report, select the Customize button.
5. From the Report period drop-down, choose the date you want to show on the report.
6. Go to the Rows/Columns section, then select Transactions Type in the Group by drop-down.
7. Go to the Filter section and choose Invoice from the Transaction Type drop-down.
8. Click Run report.

After the steps, the report will display all the invoices and the total sales. I'm adding this article to learn more about customizing reports: Customize reports in QuickBooks Online.

You might also want to memorize the report. This allows you to save the current customization settings of the report.

It's nice working with you, @Badgers10. Should you need further assistance running reports in QBO, I'm available here to help any time!

Thanks for the response, Mark!

The issue is that the deposits are tied to invoices, so I am essentially showing twice the income for a single sale.

There must be some way to remedy this.  Long story short, I started a business last summer.  Some customers pay by ACH, or directly through Quickbooks.  However, the majority of my customers give me a check as a form of payment.  I "receive payment" in Quickbooks for these payments made by check.  Then, at the end of the week, or sometimes every other week, I will make a bulk deposit.  The bank records this transaction as one deposit.

Now, when I run a P&L, it shows all of my invoiced sales and those bank deposits as well.  So, most of my sales are showing up as income twice, inflating my sales.  

This can't be the correct and has to be fixable.

Best,

Nick

Thank you for sharing more details about your concern, @Badgers10.  I can share some insights about the duplicate amount showing in your report in QuickBooks Online (QBO).

The manually added payments made to the Undeposited funds will not create a duplicate transaction when you create a deposit to your bank.

However, if the payment is assigned to the same account when creating a Receive payment and Deposit transaction from the identical invoice, it will create a duplicate amount in the account.

In your case, removing the recorded checks in the Deposit transactions would take out the duplicate amount showing in the Profit and Loss report. 

Here's how:

1. Go to the Accounting menu, and then select the account associated with the bank deposit.
2. Click View register under the Action column.
3. Choose the transaction, and then tap the Edit button.
4. Make the necessary changes you want, and then click Save and Close once ready.

Once done, you can check the Profits and Loss report, and the Accounting method is set to Cash or Accrual and the date range to get the exact details.
 

Moreover, you can check out this article you can use in the future about matching multiple transactions to your downloaded transaction in the Banking page: Categorize and match online bank transactions in QuickBooks Online.

I'll be around if you need more help managing your deposits or any QuickBooks-related processes. Feel free to add a reply so I can help you further. You have a good one!

Thank you for the response, Stephanie.  I just tried to edit a deposit.  Here is what I did and what happened.

I located the deposits that registered as sales in the chart of accounts.

I clicked edit, and tried to change the "payee account" to payments to deposit. 

I clicked save and received an error message that said "Select a bank account for this deposit." 

I have no idea what to do next.

Thanks for your help.

Best!

Thank you for getting back to us and providing us with more details about the error you're having after doing the steps provided by my colleague, @Badgers10.

When trying to record a bank deposit, select an income or expense account rather that choosing the undeposited funds account. Refer to these articles for more information about putting payments into the Undeposited Funds account and managing them right after:

• Record and make bank deposits in QuickBooks Online
• Deposit payments into the Undeposited Funds account in QuickBooks Online

For more information about adjusting the amounts of your Undeposited Funds and Bank account, you'll want to create a Journal Entry. 

Let me know if you need further help with your deposits. I'm always glad to help in any way I can. Have a great rest of the day!

@Badgers10 

Are you receiving payment (New > Receive payment) on each invoice and selecting 'Undeposited Funds' under the 'Deposit to' dropdown? 

After receiving the payment to undeposited funds, create a bank deposit (New > Bank deposit).  You will see a list of all the payments (checks) you have received.  Check off all of the payments you're depositing and select the bank account you're depositing into.