Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
jimmybigfoot
March 28, 2018
Solved

How do I split a transaction to multiple invoices.

  • March 28, 2018
  • 11 replies
  • 127 views

Hi, I am new to quick books so bare with me.

I have two invoices for two different jobs and happened to get paid by cheque on the same day, so I went and banked them but the bank I use always puts the cheque amounts together.

 

Consequently, I need to split one transaction but match it to the two invoices.

 

Can anyone help me? I know the basics but I read somewhere about deposits but they sounded complicated.

 

Many thanks

Jim

Best answer by Rustler

@jimmybigfoot

 

You received checks to pay for invoices, do not worry about banking downloads


Use receive payments, check each invoice for that customer and receive the amounts. Make sure the account to be deposited to is undeposited funds.


then use make deposits when you get back from the bank. check off the two payments, select the bank account you deposited to, and insure the amount in QB matches the actual deposit, save.


THEN, when you download banking it just match the bank deposit to the QB deposit, if you use download banking.

11 replies

M
MichelleT
March 28, 2018

Hi there, @jimmybigfoot,


Thanks for joining QuickBooks. I’m happy you reached out to us to help you match the check with multiple invoices.


QuickBooks Online only allows us to split a downloaded transaction into multiple categories. Based on the information you provided, you’ll need to match the check with the two invoices you created for the two jobs.


This is to prevent duplicate transactions and doubling your income. Here’s how:


1.    Click Banking on the left panel.
2.    Select the bank from the Bank and Credit Cards drop-down menu.
3.    In the For Review tab, locate the check.
4.    Click the check and click the Find match radio button.
5.    Select Open invoices from the Show drop-down menu.
6.    Set the dates.
7.    Select the two invoices.
8.    Click Save.


Once done, you can click the Sales tab on the left, click Invoices on the top, then make sure the status of the invoices has been updated from Open to Deposited. You can also run the Profit and Loss report (Reports> Business Overview) to confirm the amount in the income account has not been doubled..


To learn more about matching bank transactions to existing entries in QuickBooks, you can refer to this article: https://community.intuit.com/articles/1164872


Please reach out to me if you need assistance while working in QuickBooks.

 

J
joslinjoice
January 4, 2021

How can I match a single bank deposit to multiple invoice when the particular invoice is not being displayed when I click find match.

JasroV
JasroV
Level 8
April 4, 2022

Hello - 

 

I'm trying to figure out how to solve this issue - 

 

I have a deposit that has come in through the Banking Feed.  Its contains 2 checks.  One is paying an open invoice.  One is not.  I need to "Find Match" so that I can match the check to the invoice and then "Split" it so that I can categorize the other check.  But I don't seem to be able to blend these 2 items.  I have to do one or the other.


How do I accomplish this?

 

Note:  I do not want to split the check and deposit the one that pays the invoice to A/R because every time I do this, a 3rd transaction is created and I get a balanced in Unapplied Cash Payment Income.


Good day to you, @CNajTuk.

 

Thanks for sharing the details of your concern with us.

 

You'll want to manually upload the deposit and split it before uploading it to your bank feeds. I'll show you how.

 

  1. Go to the Banking or Transactions menu in your QuickBooks Online (QBO) account.
  2. Select the Banking tab.
  3. Click the tile of your preferred bank and go to the For review tab.
  4. Locate and double-click the deposit and select Exclude to delete it.

 

Once done, log in to your bank's website and download the deposit. Open it in an MS Excel file and split them from there. Ensure you're using the correct format to import it seamlessly.

 

You can refer to these articles for the detailed steps: 
 

 

Additionally, I'm adding these resources that can guide in flawlessly matching your accounts:

 

 

Do have you have any other questions about managing your deposits and bank feeds? Please let me know in your reply. I'll be more than happy to assist you. Have a dazzling day ahead!

Rustler
RustlerAnswer
Level 15
March 29, 2018

@jimmybigfoot

 

You received checks to pay for invoices, do not worry about banking downloads


Use receive payments, check each invoice for that customer and receive the amounts. Make sure the account to be deposited to is undeposited funds.


then use make deposits when you get back from the bank. check off the two payments, select the bank account you deposited to, and insure the amount in QB matches the actual deposit, save.


THEN, when you download banking it just match the bank deposit to the QB deposit, if you use download banking.

    A
    accounts212
    June 2, 2020

    Thanks! very clear.

     

    I wonder if you can help me with the following:

    I received 1 payment for multiple invoices, on items sold on a platform, but they reduced a % for fees.

    How do I enter this?

     

    Many thanks

    IamjuViel
    IamjuViel
    Level 8
    June 2, 2020

    Hello, @accounts212.

     

    You can receive the payments for each invoice. Just make sure to choose Undeposited Funds from the Deposit To drop-down. Let me guide you on how to do it.

    1. Go to the +New icon.
    2. Select the Receive payment.
    3. Enter the details of the payment.
    4. Select an appropriate payment method.
    5. To complete the transaction, click the Save or Save and new button.

    Once completed, you'll need to group the payments so that they'll show as one deposit on the register. Make sure to indicate in the deposit the fees that were deducted from it.

    1. Go to the +New icon.
    2. Select Bank Deposit.
    3. In the Payments section, put a check-mark next to the payments that you want to group.
    4. From the Add funds to this deposit section, enter the amount of the total processing fees.
    5. Make sure to enter the amount with a negative sign to denote an expense.
    6. Review the details of the deposit to ensure that its total matches with the joint payments.
    7. Click Save and Close or Save and New.

    You can refer to this article for detailed steps:  How to link a deposit to an invoice.

     

    Also, I've got these to help you tracking, categorizing, and splitting invoice payments in QuickBooks:

    Let me know if you have other questions about managing your invoice payments in QuickBooks. I'm always here to help.

      Need QuickBooks guidance?
      Log in to access expert advice and community support instantly.
      Terms & ConditionsAccessibility statement