Solved

How do I split a transaction to multiple invoices.

Forum|Forum|8 years ago
March 28, 2018
11 replies
104 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

QuickBooks Online

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.

M

MichelleT

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

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

AlexV

Level 10

Thanks for joining us here, joslinjoice.

We can filter the transactions on the Match transactions page to see all available invoices and so you can match the correct ones. Please follow these steps:

From the Banking page, select the deposit transaction to expand it and click the Find match radio button.
Use the From and To date fields to set the correct dates and select Open invoices from the Show drop-down.
Select the two invoices and click Save.

Also, you'll want to open the invoices to verify the invoice date. You can also check this link for the detailed steps: Categorize and match online bank transactions in QuickBooks Online.

Another way is to record invoice payments and deposit them to the Undeposited Funds account. Then, you can make a bank deposit to deposit the payments to the bank. The bank deposit you've made can be matched to the downloaded one.

Need help in reconciling? Please check this link: Reconcile an account in QuickBooks Online.

Keep on posting here if you need anything else. I'm looking forward to assisting you again.

RustlerAnswer

Level 15

@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

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

Level 8

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.

Go to the +New icon.
Select the Receive payment.
Enter the details of the payment.
Select an appropriate payment method.
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.

Go to the +New icon.
Select Bank Deposit.
In the Payments section, put a check-mark next to the payments that you want to group.
From the Add funds to this deposit section, enter the amount of the total processing fees.
Make sure to enter the amount with a negative sign to denote an expense.
Review the details of the deposit to ensure that its total matches with the joint payments.
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.

Sign up

Login with SSO

Let's get you signed in

Login with SSO