cancel
Showing results for 
Search instead for 
Did you mean: 
sdaggs
Level 1

How do you match a lump sum deposit to multiple customers invoices? It is the same amount for each invoice. Monthly HOA dues collected by ACH.

The entity is a homeowner’s association and the invoices in question are recurring monthly invoices for dues. There are 32 owners and each currently pays $190.00 per month. These dues payments are collected by ACH debits to each owner's checking account on the same date each month. Then the bank credits our checking account with $6,080.00 in one lump sum.

1 Comment 1
RogelioL
QuickBooks Team

How do you match a lump sum deposit to multiple customers invoices? It is the same amount for each invoice. Monthly HOA dues collected by ACH.

Thank you for sharing the details of your concern regarding matching a lump-sum deposit to multiple customer invoices in QuickBooks Online (QBO). I can guide you through handling this to ensure your transactions align accurately.

 

To begin with, if those invoices are still open, we can directly match them to the downloaded lump sum bank deposit. This process will mark them as paid.

 

Here's how:

 

  1. Hover to the Transactions located in the left panel.
  2. Go to the Bank Transactions menu, then select For Review.
  3. Locate the lump sum bank deposit, then click it.
  4. Choose Match, then tick the 32 open invoices.
  5. Click Match.
    Invoice (1).gif

On the other hand, if you've manually received payments and created a bank deposit, we can proceed to match the bank deposit to the downloaded lump sum bank deposit.

Allow me to guide you through the process:

 

  1. With the same process, go to the Bank Transactions.
  2. Locate the lump sum bank deposit, then click it.
  3. Choose Match, then click the Bank Deposit you've manually created.
  4. Click Match.

 

Moreover, did you know that we offer a free session with our QuickBooks Live Expert Assisted? They specialize in transforming financial management into a seamless experience and provide personalized advice for your business-specific demands. Your brighter financial future starts with just one click.

 

Additionally, after matching these transactions, I recommend reconciling your account to ensure that the deposit matches the bank record and keeps your financial records accurate.

 

Feel free to reach out if you have any questions or need further assistance with this process. We’re here to help ensure your association’s financial management runs smoothly.

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Expert help for your business tax return

Susan, Business Tax Expert since 2010

File your business taxes with confidence thanks to our 100% accurate guarantee.

Explore QuickBooks Live Tax

QuickBooks Live Tax, powered by TurboTax

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up