Duplication of Sales Income on P&L

Hello, Jenvas.

Let's work hand in hand to figure out the cause of those duplicate sales and fix them. 

The invoices will always appear as sales in your P&L report. This is normal since the line items in the invoice are tied to your sales or income accounts. However, unpaid invoices won't appear if you use the Cash accounting method on the report. 

You also mentioned that your sales are duplicated. 

How are those payments recorded? I'd appreciate any clarifications on your process so I can pinpoint what causes the duplicate sales. 

While waiting for your clarifications, there's one common reason why those sales are duplicated on your report. 

Using the Receive payments function (deposited to Undeposited Funds as you've mentioned) and doing the Bank deposit process (using the income accounts for the line items) can cause duplicates. 

Ideally, we would want to use the Receive payments function and directly deposit those funds from the Undeposited Funds account to your bank account in QuickBooks. 

Before anything else, we'll want to delete those bank deposit entries. Simply go to your bank register in your Chart of Accounts, find the deposit and select it. Click the Delete button. 

Now, click the + New button then select Bank deposit. Check invoice payment under Select the payments included in this deposit. Add a memo and other information if needed, then click Save and close. 

This won't duplicate the sales. This will simply deposit the funds to the bank account. On your P&L report, the invoice is reflected on the income portion instead of the deposit. This counts as a paid and closed invoice. 

On your last question, the best way to correspond your cash deposits against multiple invoices is to simply use the Bank deposit function.

Ideally, we would want to use the Debtors account on each line item. Then, we would want to link those deposits with the invoices using the Receive payments function. This method assumes that the invoices have not been linked to any deposits or payments. 

Here are the complete steps: 

1. Click the + New button, then select Bank deposit.
2. Under Add funds to this deposit, add the customer profiles (where you received the cash deposits from).
3. Set the Account to Debtors. 
4. Add the amount under the Amount column. Avoid using lump sum, let's account the cash deposits one at a time. 
5. Add a memo and other transaction data. 
6. Once done, click Save and close.

Now, let's link the deposits to the open invoices. We can do this by clicking on the + New button, then selecting Receive payments. Check the open invoice and the deposits. Make sure to select your bank account under Deposit to.

Afterwards, click Save and new. We can do this process until all of the invoices and the cash deposits are accounted for. 

Just to add more details about this step, this won't duplicate your payment entries. This is just a way to close out the invoice and the deposit. QuickBooks creates a £0.00 payment entry as seen from this customer's profile: 

You might also find this article helpful if you want to review some steps in processing customer invoice payments: Record invoice payments in QuickBooks Online.

After taking care of the deposits, do you also need help reconciling your bank accounts? We do have an article to help you with the flow: Reconcile an account in QuickBooks Online.

I'm still up and available if you have more questions about your invoices or deposits. If you need a guide or two about running reports or managing other transactions, add them to your reply and I'll get back to you as soon as possible.