cancel
Showing results for 
Search instead for 
Did you mean: 
LieraMarie_A
QuickBooks Team

Applying one payment to multiple customers & jobs

Hi there, @csacs100.

Can you send some screenshots of your report? This way, I can review why deposits are showing as "Non-specified" in your sales report.
 

You can also reach out to our Customer Care Support team. They can take a look at your reports securely and check your transactions thoroughly.

 

  1. Click the (?) Help icon in the upper right-hand corner of the Dashboard.
  2. Select Talk to a Human.
  3. Enter a short description of your concern and press Enter.
  4. Click I still need a human.
  5. Select Contact Us to connect with our live support.
  6. Choose Get a callback.
    help.JPG

 

To ensure we address your concern, our representatives are available from 6:00 AM to 6:00 PM on weekdays and 6:00 AM - 3:00 PM on Saturdays, PST. For more information, check out our support hours and types.  

 

Keep in touch with us on your progress with this sales report issue. I'm determined to help you succeed.

SvetlanaZ
Level 2

Applying one payment to multiple customers & jobs

You obviously didn't read his post.  He clearly said "a customer with multiple jobs", "parent company". Your answer has nothing to do what he is talking about.  Everybody keeps posting answers that have nothing to do with his problem, and seems like more people have it, including me. I have a customer with 8 locations as "job". I can see invoices in the parent company for each location/job in Customer Center, but I can't apply a payment by going to the parent company and simply click - Receive Payment. Instead I get a message telling me go to each account and post individually. I have another check from a corporate account that paid for 50 different location/jobs!!! I have to open 50 invoices in order to apply the payment. And sure I can't create a normal receipt for one check. QB Premier post multiple invoices payment problem.png

Mich_S
QuickBooks Team

Applying one payment to multiple customers & jobs

I'm here to walk you through applying invoice payments, @SvetlanaZ.

 

To apply the payment for a specific job, you'll have to select the job manually on the Receive Payment page. Here's how:

 

  1. Go to the Customers menu.
  2. Locate and select the customer you want to receive the payment from.
  3. From the Manage Transactions drop-down, click on Receive Payments.
  4. Review and put a checkmark on the job you want to apply the payment to.
  5. Once done, click on Save & Close.

 

 

 

For more information about handling customer payments, see this: Receive and process payments in QuickBooks Desktop.

 

Don't hesitate to reply back to this thread if you need further help with this matter or QuickBooks. We're here to back you up. Take care.

SvetlanaZ
Level 2

Applying one payment to multiple customers & jobs

Did you read my post and looked at the picture of the message I get? I've been working with QB for over 15 years, so telling this basic steps actually sound insulting. I specifically said that I cannot do it for some reason and what message I get.

The steps you are giving me work for QB Enterprise. I worked on QBE and it does exactly what you are saying. Right now I'm using QB Premier 2019 and it doesn't do it. Please people, before giving a "help" read people's post a few times so you don't look like you have a problem with reading comprehension.

So now, anyone has a solution?

Jen_D
Moderator

Applying one payment to multiple customers & jobs

Thanks for posting here, @SvetlanaZ.

 

I want to help you out with applying payments. I can help you further with applying multiple payments for a customer. If you have multiple Accounts Receivable, you can receive multiple payments through the QuickBooks Receive Payments window.

 

All you need to do is switch the Accounts Receivable account to the ones you will apply payment for. Here's how:

 

  1. Go to the Customers menu then Receive Payments.
  2. Update the A/R account dropdown.
  3. Mark the invoices you need to receive the payment to. See this Premier 2019 screenshot:

This is the only way you will get rid of the error when applying the payment directly from the customer's profile.

 

Post again if you have other invoicing concerns in QuickBooks. I'll be right here to help anytime. Have a wonderful day!

SvetlanaZ
Level 2

Applying one payment to multiple customers & jobs

I have only one A/R account. There is nothing to switch to. That's why it's so frustrating. So it didn't sold the problem.

DivinaMercy_N
Moderator

Applying one payment to multiple customers & jobs

Thanks for getting back here, @SvetlanaZ. I'm here to further help you fix the message you've encountered.

 

I can see you've already performed all the recommended steps to get this issue resolved. For additional troubleshooting steps, you can try to reorganize your customers in your QuickBooks Desktop (QBDT) account. For instance, if you have customer Name 1 and want to group a number of those jobs under another name (Name 2) this will show as Name 1:Name 2:(Job) Name. If you did this, the reporting and payment data showed nothing for those jobs. To fix it, you'll have to go to the Edit/Add Multiple Customers:Jobs and then create a new customer as Name 2 then add it under the existing job (Name).

 

You may also consider visiting this article to further help you in managing your A/R account in QBDT: AR balance on the Chart of Accounts does not match AR balance on reports.

 

You'll want to browse our QuickBooks Help articles page for guides and links to help you in performing your accounting tasks. You can also bookmark or print the articles to serve as your handy guide.

 

Please touch base with me here if you need anything else. Thanks for dropping in. Have a good one.

alcohol123
Level 3

Applying one payment to multiple customers & jobs

I still don't have a way to do this.  Other than waiting for the bank deposit to come in, and then matching the multi-customer invoices to the incoming bank deposit.

 

Instead of waiting for the bank deposit to be downloaded and then matching the invoices to the incoming deposit, is there a way to enter a deposit manually and then match all the invoices to it?

 

Such that when the deposit comes into my bank account it would match to the manually entered undeposited funds deposit.  And the undeposited funds deposit has already been matched up with the invoices from multiple customers.

Adrian_A
Moderator

Applying one payment to multiple customers & jobs

I appreciate you for posting on this thread, alcohol123.

 

I'm here to share some information about matching multi-customer invoices.

 

When you enter a deposit manually, it will create a duplicate of the downloaded one. That said, you may want to wait for the deposit to be brought up by the system.

 

Once downloaded, you're good to match it to the invoices. Here's an article as your guide: Add and match bank deposits.

 

I'll be around whenever you need help in matching transactions.

alcohol123
Level 3

Applying one payment to multiple customers & jobs

Thanks, but you added nothing to the discussion except another post.

alcohol123
Level 3

Applying one payment to multiple customers & jobs

Well, my awesome bookkeeper solved the problem for us.

 

When I set up the sub-customer accounts I did not check "Bill parent customer" because I actually send the bill out to each sub customer.  The sub-customers approve the charges and let's the parent customer know that they should pay the invoices.  

 

I had to have "Bill parent customer" checked on the sub-customer account for the invoices to show up in the Parent account.  Hope this helps someone.

afoa21
Level 1

Applying one payment to multiple customers & jobs

AlexV,

What you described is correct, but only works when you are applying the payment to multiple invoices under one customer.

 

Many QB users need a method to apply a payment to multiple invoices that are under multiple customers. An example for us would be: A hunting club is leasing land from multiple landowners. Landowners are customers in our QB. The hunting club sends in one check to pay for his leases under multiple landowners (customers). There needs to be a way to apply his one payment to multiple invoices under multiple customers. We need the same for credit card payments.

JonpriL
Moderator

Applying one payment to multiple customers & jobs

I hear you, @afoa21.

 

I'm here to help share insights about applying customer payments for multiple invoices in QuickBooks Desktop.

 

As of the moment, there isn't an integrated way to apply a credit card payment to invoices with different names of a customer. I'm also unable to provide the exact turnaround time as to when such a feature like this is added to the program.

 

While the said option is not yet available, I suggest getting in touch and letting our product developers know about your request by sending feedback. I'll show you how.

 

  1. Go to Help.
  2. Select Send Feedback Online.
  3. Click Product Suggestion.
  4. Under Product Area, choose Customers & Sales.
  5. Enter a few words describing how you wanted to apply credit card payment to multiple invoices under multiple customers in QuickBooks Desktop.
  6. Select Send Feedback.
  7. Click Close Window.

 

For now, I'm including this reference so you're able to use all the features and functions of QuickBooks: Help Articles in QuickBooks Desktop. Also, you're able to read subtopics that will describe how a feature is used and how to accomplish tasks related to its functions.

 

I've got you covered if you have other questions aside from working with customer payments in QuickBooks. Use the Reply option below and don't forget to include my name, @JonpriL, so that I can get back here and assist you. Take care always and stay safe!

Alacrity Bookkeeping
Level 1

Applying one payment to multiple customers & jobs

Have you tried turning on projects. 

In Construction you can have one contractor with multiple jobs. If you create "Projects" under one client than it allows you under the customer to apply payment to all "projects".

Each different civi address is considered a "project". You can "cash out" multiple invoices for that address/project. Or go in to the actual customer, hit the +, sleet receive payment. A list of all outstanding invoices for each project aka address, aka restaurant should come up.  

Shelby W
Level 2

Applying one payment to multiple customers & jobs

This was a very long thread for a pretty short answer.  Thank you @alcohol123 !

MarioMP
Level 2

Applying one payment to multiple customers & jobs

This does NOT help at all. Read the original problem statement. 

Harish0412
Level 1

Applying one payment to multiple customers & jobs

I'm trying to import customer payment through excel import, We have received a check from parent customer for two different sub customer. If I import this, I'm getting an error that customer's invoice can't be found. But on changing the Ref No in the first column I'm able to import. But each row is considered as different payments. Please provide the right format of excel file to import payments received from single parent customer to different sub customer invoices.

Ref NoPayment DateCustomer Payment methodDeposit To Account NameInvoice NoJournal NoAmountReference NoMemoCurrency CodeExchange Rate
100110-9-2024Partnership Healthplan of CA:Aya AngelesCheckPayments to deposit1001 12TY37465   
100110-9-2024Partnership Healthplan of CA:Cristy JamesCheckPayments to deposit1003 35TY37465   
100310-9-2024UBH Claims Dept:Gabriel NavarroCheckPayments to deposit1002 25AR25441   
Tori B
QuickBooks Team

Applying one payment to multiple customers & jobs

Thanks for following along with the thread, @Harish0412.

 

When importing from Excel, we have a tool kit available that you can use. The toolkit contains:

 

  • Import from Excel and CSV Manual – a PDF document with instructions, best practices, and notes.
  • CSV Examples Folder – 4 sample CSV files, one for each type of list.
  • XLS Example Folder – a sample Excel file containing 4 worksheets, one for each list type.
  • Allowed fields – a reference guide explaining what fields are available for Excel and CSV import.

 

If you're interested in using the tool kit, please use the steps I'm including below to download it. 

 

  1. Open the file download window for the toolkit, then select Save.
  2. Go to your Windows Desktop, then tap on Save.
  3. Double-click QuickBooks_Import_Excel_and_CSV.exe on your Windows desktop to open the WinZip Self-Extractor window.
  4. Hit Browse, choose the folder where you want to install the toolkit (such as your Desktop), then OK.
  5. Select Unzip to extract the contents, and then select Close to close the WinZip Self-Extractor window.
  6. Open the QuickBooks Import Excel and CSV folder from the location you selected in step 4.

 

For more information about the import process, check out these help guides below:

 

 

That should do the trick. Please don't hesitate to let me know if you have any additional questions or concerns. Have a good one! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us