Skip to main content
March 30, 2019
Question

Applying one payment to multiple customers & jobs

  • March 30, 2019
  • 5 replies
  • 0 views

I have two customers set up with multiple jobs under each.  The parent company (not set up as a customer) is now making one payment for both customers & jobs.  How do I apply this payment to multiple customers & jobs?  Is it best to merge the customers?  If I set up the parent company as a new customer and merge the two existing customers into the new customer do I lose any prior year transactions?  After the merge will I see the existing jobs under the new customer?  

 

Thanks for the help

5 replies

Kristine Mae
March 31, 2019

Hello there, Jw11.

 

You're unable to merge 2 customers to one parent account (customer). You can only merge 2 customers to each other and all transactions will transfer to the customer you will retain. 

 

I have a suggestion so you apply one payment to multiple customers. You can use our bank feeds feature. Once you set it up, you can match/apply the downloaded transaction (payment) to multiple invoices. Here's how:

  1. Click Banking.
  2. Go to Bank Feeds, then choose Bank Feeds Center.
  3. Choose the bank account, then click Transaction List.
  4. Choose the payment.
  5. Click the Select drop-down arrow, then choose Add More Details
  6. Choose the payments in the Undeposited Funds tab, or choose the invoices in the Open Invoices tab.
  7. Click Add to QuickBooks.

I've got you an article for more information: Add and match Bank Feed transactions.

 

Let us know if you have more questions. We'd be happy to answer them. 

March 3, 2021

What is the effective and fastest way to apply deposits from bank feed transactions if I don't have a quickbook Invoice supporting the Check Amount Deposited? I lost my Quickbook Files from the last 3 years and I am just trying to input Year 2020, I have setup Rules for the Downloaded Banking Transactions and know I am trying to find the streamline way of balancing those Transactions out.

Any Information is GREATLY APPRECIATED!

TIA

March 3, 2021

I appreciate you for joining this conversation, TIA. I'm here to help.

 

In QuickBooks Desktop, there are three Bank modes available. Each of them handles bank transactions differently. You'll want to add those transactions and, make sure to categorize them so you can easily trace them. 

 

To learn more information on how to add bank feed transactions in QBDT, please click here.

 

I also recommend seeking expert advice from an accountant to ensure your books will be accurate. You can use this link to find one: https://quickbooks.intuit.com/find-an-accountant/.

 

I'll be right here if you have any other banking concerns.

Rustler
March 31, 2019

@jw11 wrote:

I have two customers set up with multiple jobs under each.  The parent company (not set up as a customer) is now making one payment for both customers & jobs.  How do I apply this payment to multiple customers & jobs?  Is it best to merge the customers?  If I set up the parent company as a new customer and merge the two existing customers into the new customer do I lose any prior year transactions?  After the merge will I see the existing jobs under the new customer?  

 

Thanks for the help


QB does not care who makes the payment

 

Use receive payments, select the customer, select the invoices being paid and enter the amount paid for that invoice.  Do it again for a new customer if needed

the total in undeposited funds should equal the amount received

use make deposits to move the total to the bank account

 

download banking if you use it and match

 

the work flow is and has been, make entries, download banking, match

April 5, 2019

I just did this after following the directions in this link.  I created a parent company and just moved the other companies into it.  It worked great.  I didn't lose any information or transactions.  Hope it helps you.

 

http://www.accountingsoftwaresecrets.com/knowledge-base/using-quickbooks/customers-and-receivables/receiving-payments-and-discounts/receivi-1

October 16, 2020

I am having similar issues.

We use projects and create parent companies.  So when we have a parent company call with a job, we create a project for that specific location.  When we invoice out, we invoice under each project.  Problem is when the parent company pays, they send us authorization to process a single credit card transaction for multiple invoices.  I can not accept a credit card payment for more than one invoice at a time.  It should be set up so that, under a parent account, multiple invoices should be able to be processed in one transaction.  

I've yet to figure it out.

October 16, 2020

Hi there, @ Rebekah1972.

 

Setting up the parent company to funnel all the credit card payments is unavailable. All of the invoices will be sent to different sub-companies under the parent company.

 

You can do a Customer and job then job to sub customer. You can follow the steps on how.

 

  1. Go to the Customer Center.
  2. Check how every name handles then click, and drag a customer’s name down.
  3. On the Parent indent it to the right.

 

Once done, the payment can be received at the customer level. Then you can get a new column on the page. This way, you can apply all open invoices for all the jobs for that specific customer.

 

Just in case, I'll add this article for future reference: About bank or credit card subaccount setup.

 

Please let me know if you need further assistance. I'm always around to help. Have a good one.

 

October 28, 2020

I bought and used an APP called Transaction Pro, installed the program/app and in the Target in program properties I typed "C:\Program Files (x86)\Transaction Pro\Transaction Pro.exe" /RECPAY3.

When I setup the excel worksheet, I when I applied a check payment from the customers for instance and I used the same check number but added ".001" to the check. For Example if check # 1108 paid four invoices from  four different customers I would show on the  Excel Worksheet Ck # 1108.001 on the first Line (row), Ck # 1108.002, on the second row, etc. I then imported the Excel worksheet (csv) into Quick Books. For example the columns looked like this: 

DateTypeCheck NumberApply to Invoice     Amount     Deposit To      Discount Amount      Discount AcctMemoAR ACCT
November 9, 2020

I have the same situation and have figured out how to process the credit card payment.

Go to the parent company, click the down arrow on New Transaction and click on payment. It will bring up all open invoices for the company. I then clicked the invoices for each project that needed paid and processed the payment. I do hope this helps you as well.

 

 

February 15, 2021

Thanks, this doesn't work for me. Are you on QB Online?

 

When I enter a payment the way you describe I get the payment screen without any of the sub account invoices.

JoesemM
February 15, 2021

I appreciate you for following the steps above, @alcohol123.

 

The steps shared above is for QuickBooks Desktop. If you're using QuickBooks Online, you can receive the payment by following the steps below.

 

  1. Click the +New icon, then choose Receive Payment.
  2. Select the customer's name, then select an invoice.
  3. Click Save and send.

 

However, if you're using Merchant Service with us the transaction will automatically mark as paid. In this way, I'd suggest contacting our Merchant Support Team. They can check your account securely and provide other troubleshooting steps to get this resolved. You can see their contact information through this link: Contact Payments Support

 

I'm adding these articles that will guide in setting up a credit card subaccount and more details about card fees:

 

 

Please let me know if you have any other questions or concerns in the comment section below. I'm more than willing to help. Have a great day!