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?
A
Adalius
March 22, 2019
Solved

Recording Split ACH Payment Received

  • March 22, 2019
  • 2 replies
  • 0 views

I purchased a company's assets (thus forming a new company) but bought the old company's name as part of the transaction. So now I have a new entity with their name. 

As such, payments for their outstanding open invoices at time of sale are being collected on their behalf and I post them to a liability account (since I owe that money to them at some point). 

The problem I have is that a customer just sent me a single lump ACH payment which covers 3 of our invoices and the remainder goes to the liability account.

So I went into 'Receive Payment' and marked the 3 invoices as being paid by ACH, and then put them to undeposited funds. Then the ACH showed up in the banking feed but I can't figure out how to properly split it so that it puts part into the liability account and the other 3 against the invoices...

Do I just change the received payment from Undeposited funds to the bank account and then split the deposit between the liability account and the bank account and call it a day, or will that double up the amount in the bank since the receive payment *and* the deposit are both putting money towards it?

Best answer by MaryLandT

You're almost there, @Adalius.

 

The next thing to do is create a bank deposit for the three payments and deposit them to the right bank account.  

 

Once done, you can find match downloaded transactions, then resolve the difference in your banking feeds. This way, you'll be able to see the remainder and deposit it to your liability account. 

 

Let me show you the steps for additional guidance:

  1. Go to Banking from the left pane.
  2. Select the desired bank where the payment was deposited to. 
  3. Click the payment, then choose Find match to bring up the transaction. 
  4. Mark the deposit by putting a checkmark in the box.
  5. Enable the Resolve Difference feature.
  6. Click Save when ready. 

I've added this article for more details with find matching transactions : Add and match downloaded banking transactions.

 

Let me know hos this goes by leaving a comment below. I'm always around here in the Intuit Community whenever you need help.

2 replies

MaryLandT
MaryLandTAnswer
Level 10
March 22, 2019

You're almost there, @Adalius.

 

The next thing to do is create a bank deposit for the three payments and deposit them to the right bank account.  

 

Once done, you can find match downloaded transactions, then resolve the difference in your banking feeds. This way, you'll be able to see the remainder and deposit it to your liability account. 

 

Let me show you the steps for additional guidance:

  1. Go to Banking from the left pane.
  2. Select the desired bank where the payment was deposited to. 
  3. Click the payment, then choose Find match to bring up the transaction. 
  4. Mark the deposit by putting a checkmark in the box.
  5. Enable the Resolve Difference feature.
  6. Click Save when ready. 

I've added this article for more details with find matching transactions : Add and match downloaded banking transactions.

 

Let me know hos this goes by leaving a comment below. I'm always around here in the Intuit Community whenever you need help.

    L
    Lori H
    April 9, 2019

    I split my phone bill, but the original bill still shows, (so now there are 3 charges to Verizon for that day) so is it the original bill still going to be deducted?  Should I exclude the original bill?

    TIA!

    HoneyLynn_G
    HoneyLynn_G
    Level 6
    April 9, 2019

    Thanks for reaching to the Community space about your split bill concern, @Lori H.

     

    I want to make sure this gets taken care of for you. I just need some more details about the issue.

     

    How did you enter or record the split phone bill? Is this an online banking transaction or did you manually enter them in QuickBooks? If the original bill is just a duplicate from your split phone bill, then you can exclude it. 

     

    If that is not the case, please let me know by adding a comment below. I'm looking forward to your response.

    L
    Lori H
    April 10, 2019

    Hi,

    Thank you for responding. So far this program has a lot of limitations that are making it hard to work with, especially not being able to have custom categories. They don't match what my accountant wants i.e cell phone,  business expense, on personal no medical or dental etc...and I can't find a way to make it work. It's been very frustrating.

    After I posted the question on splitting my bill the duplicate went way.

    Is there a way that I could have a separate one for my personal to keep my business and personal completely separate. Is that possible to create another separate one without having to pay for another account?  Hopefully they will work on improving the customization capabilities of this program! 

    Thank you again for your response, Lori

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