cancel
Showing results for 
Search instead for 
Did you mean: 
LINKConstruction
Level 2

Split Transactions duplicating in P&L

Alrighty here we go....

 

SO! I have two invoices due. I receive 2 checks from 2 different customers and I deposit them TOGETHER in my business checking account (MY BANK). Lets say I have a check for 1000 from customer A and 2000 from customer B. A grand total of 3000. 

 

When I go to record and SPLIT this transaction in QB, I link them to the 2 specific invoices (Invoice 001 for 1000 INV 002 for 2000) and everything seems to work just fine. However, when I go to my P&L report it is essentially doubling the credits showing up as an "Invoice" paid as well as a "Deposit" paid under TRANSACTION TYPE. What the heck?

 

I cannot seem to figure out how to record the split deposit transactions without this "duplicating" on my P&L report. Please help!

 

 

3 Comments 3
Charies_M
Moderator

Split Transactions duplicating in P&L

A pleasant day, LINKConstruction.

 

Let's go over and resolve your concern about duplicate split transactions from your Profit and Loss report.

 

There is a possibility that the invoice was manually received payment reason why it's showing as paid in the Profit and Loss report. In order to fix this, let's open the invoice and remove the Receive payment transaction associated with it.

 

Here's how:

  1. Go to Sales then All Sales.
  2. Locate the paid invoice and click it.
  3. From the invoice screen, click the link for payment made.
  4. Click the link under Date. This will route you to the Receive payment screen.
  5. Click More and choose Delete.
  6. Choose Yes to confirm.

This will now change the status of your invoice.

 

You might want to visit this article for tips about the correct way of linking your bank deposit to an invoice in QuickBooks Online (QBO): How to link a bank deposit to an invoice.

 

Feel free to check out our Help Articles to help you with the tasks when using QBO.

 

I'm looking forward to hearing this being resolved. Let me know if you have other concerns while working with your P&L report. I'm always here to help. Wishing you a good one.

LINKConstruction
Level 2

Split Transactions duplicating in P&L

I think you misinterpreted what I was saying. I know how to link deposits to invoices. But the SPLITING of ONE deposit into multiple invoices is what my issue is or was....

 

BUT NOW MY ISSUE IS WORSE...

 

I should have known when you suggested "delete" the invoice it would cause havoc on my books as I have linked transactions etc. 

 

This did not work. It only made things worse

GebelAlainaM
QuickBooks Team

Split Transactions duplicating in P&L

I understand the urgency of this matter, @LINKConstruction. Let's get this issue resolve.
 

To recover the deleted invoice transaction, you can recreate the transaction and apply payment if necessary. 
 

Meanwhile, for your first concern, you can create one deposit for multiple invoices. From there, you can pay the individual customer.

Here's how to create Bank deposit:
 

  1. Select + New.
  2. Select Bank Deposit.
  3. From the Account dropdown, choose the account you want to put the money into.
  4. Click the checkbox for each transaction you want to combine.
  5. Make sure the total of the selected transactions matches your deposit slip. Use your deposit slip as a reference.
  6. Then Save and Close.


For additional information, you can refer to this article: Record and make bank deposits in QuickBooks Online.

 

In case you want to run reports in the future you can check out this article: Run reports in QuickBooks Online.
 

If you need anything else feel free to come back. I'll be happy to assist you. Stay safe!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us