cancel
Showing results for 
Search instead for 
Did you mean: 
Experienced Member

It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

 
11 Comments
QuickBooks Team

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

Good day, leftcoastinspect.

I can help you go over to your split deposits and have those invoices paid. Let's get started.

 

If you have a deposit to pay for the invoice, you'll need to make sure that the account used for the deposit is the Accounts Receivable then select a customer.

 

To change the account used for split deposit, you can go to the register and edit it. See the steps below.

 

  1. Go to the Chat of Accounts. Locate the bank and click View Register.
  2. Look for the Split Deposit and edit to change the account.
  3. Hit Save and close. I've attached sample screenshots below.

x.PNG c.PNG v.PNG

 

This way the deposit will show as available credit when you receive a payment for the invoice.

 

z.PNG

 

I'm leaving some articles that you might find helpful:

 

For personal account questions, feel free to reach us. Here's how:

 

  1. Sign into your QuickBooks Online Company.
  2. Click (?) Help at the upper right corner.
  3. Select Contact US on the pop-up.
  4. Enter a brief description of your concern then hit Continue.
  5. Click Get a callback.
  6. Enter your contact information.
  7. Select Call me.

Keep me posted if you need more help regarding split deposits and invoices in QuickBooks. I'll be around to help.

Experienced Member

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

I have done what you suggested but these items still show up in my overdue invoices

QuickBooks Team

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

Hello leftcoastinspect,

 

You'll want to make sure the deposit has the exact amount of your invoice. This process will change the invoice status to paid. I can help you verify the deposit.

  1. Go to Sales, then Customers.
  2. Click the customer's name, and then click the invoice under Transaction List.
  3. Click the payment made link at the top of the invoice. Then, click the Date link.
  4. In the Receive Payment window, scroll down to the Credits section and make sure that the deposit amount is the same as your invoice amount.
  5. Click Save and close.

If you're unable to view the deposit, you can go back to your bank register and change the account to A/R (Accounts Receivable).

 

You can pull up the Transaction Detail by Account report and filter it to view your split deposits.

  1. Click Reports, then enter "Transaction Detail by Account".
  2. Change the Report period.
  3. Click Customize at the top. 
  4. Click the Filter drop-down. Then, the Transaction Type box.
  5. Choose the Deposit box.
  6. Click Run report.

You might also want to check this article for future help: Income and expenses for QuickBooks Online.

 

Please know that we're always here if you have other questions. Feel free to reach out anytime.

Experienced Member

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

This doesn't work as these invoices have no payment. It seems that when the payment is part of a split deposit it doesn't match up to the invoice.

QuickBooks Team

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

Thank you for the response, @leftcoastinspect!

 

Let's review all the details of your unpaid invoice so you can mark it as paid in no time.

 

First off, the transaction fees or the amount of your invoice may be the reasons why you're unable to match it with a deposit.

 

In addition, you're only able to match a deposit with an invoice if they have the same exact amount or the invoice amount is lesser than the deposit.

 

Also, you'll have to create a Receive Payment transaction to match your invoice and deposit if your deposit is a downloaded bank transaction. And then match them from there. Please see the screenshot I've included below.

 

02.jpg

 

Thus said, you can follow the detailed steps outlined by my colleague, @RoseMarjorieA, so you can successfully match your invoice and deposit.

 

Lastly, you can also visit our Help Articles page for QuickBooks Online if in case you need to learn some tips and related articles in the future.

 

As always, you can leave a comment below or start a new thread if you have any other concerns. I'll be keeping an eye for your response.

Experienced Member

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

Thanks for the help.

So I am only having problems with split deposits, where 2 or more invoices are uploaded from my bank. They are all in A/R Accounts Receivable. 

There are no transaction fees and I have checked all the amounts several times and they all match.

If I create another "Receive Payment" transaction it will add the amount into my account a second time.

Moderator

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

Thanks for doing a follow up, leftcoastinspect,

 

Allow me to join the thread and share some additional information when matching transactions.

 

If you'd want to match the deposit with multiple transactions, here's what you'll need to do:

  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. and choose the transactions.
  7. Click Save.

However, if you'd create Receive Payment transaction, then all you need to do is to find match the Receive Payment transaction to the deposit.

 

To learn more about matching bank transactions, you can refer to this article: Match and categorize your downloaded bank transactions.

 

For future reference, you may find below articles helpful:

If you need further assistance while working in QuickBooks, please let me know. You can always count on me.

Experienced Member

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

there are no items in the For Review Tab

QuickBooks Team

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

Thanks for providing additional information about the split deposit, @leftcoastinspect.


There are no items showing under the For Review tab because they were already added to QuickBooks. Let’s move them back so you can match it to the invoices. 

  1. Go to the Reviewed tab on the Banking page.
  2. Mark the transactions you want to move.
  3. Click the Undo button to remove the added record from your accounts in QuickBooks.

Undo.PNG

Check out the Undo an added bank transaction section on this article to learn more: Unmatch or move bank transactions after reviewing them.


Before matching, create a bank deposit and apply it to the invoices to close out the sales transactions. Here’s how:

  1. Go to the Plus icon and select Bank Deposit.
  2. Choose an account.
  3. From the Add funds to this deposit section, select the name of the customer in the Received From column.
  4. Pick Accounts Receivable in the Account column.
  5. Enter payment method and amount.
  6. Hit Save and close.

After that, proceed with receiving payments. Follow the steps below:

  1. From the Plus icon, click Receive Payment.
  2. Choose the Customer from the drop-down.
  3. Go to the Outstanding Transactions section and mark the box next to the invoice.
  4. Select the Deposit from the Credits section.
  5. Hit Save and close.

For more information and screenshots, check out these articles: 

Once done, go back to the For Review tab and select the split deposit. Move the radio button to Find match and you’ll see the manually entered deposit under Records found. You can match the two transactions together.


Refer to the article shared by my colleague MirriamM for reference.


Let me know if you have any other questions or need more assistance. I’m always here ready to help. Have a good one!

Experienced Member

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

I did all that you said, but it added everything back twice.

Is there a way someone can help me live. Like remotely?

Highlighted
QuickBooks Team

Re: It seams whenever I get a split deposit it still shows those invoices attributed to it as unpaid

Hello @leftcoastinspect,

 

Let me route you to the best help available so someone can privately review your account and get your concern on your invoices and split deposits addressed.

 

Here in the Community, we don't have a direct view of your account for security reasons. Thus said, I'd recommend contacting our Customer Care Support.

 

From there, some can pull up and look into your account in a secure environment and explain the components of the split deposits. Also, with the screen sharing tool that they have, someone can help mark your invoice as paid and matching it to your split deposit.

 

With this, here's how you can contact our dedicated team:

  1. Go to Help.
  2. Select Contact us.
  3. Enter Invoices and Split Deposits in the What can we help you with? field.
  4. Choose Start messaging or Get a callback

As always, you can visit our Help Articles page for QuickBooks Online if in case you need some tips and related articles in the future.

 

If there's anything else that I can help you with, please let me know in the comment section down below. I'll be always around ready to help.