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

. I have a problem with the intuit batch payments in my bank feed, not matching invoices created in QB. How do I correct this?

The individual invoices and batch payment both show up as sales. My bank balance and QB balance do not match.
3 Comments 3
Tori B
QuickBooks Team

. I have a problem with the intuit batch payments in my bank feed, not matching invoices created in QB. How do I correct this?

Good morning, @jensenautomotive.

 

Thanks for reaching out to us here in the Community.

 

To clarify, are these batch payments coming from merchant services? If you're using Intuit Payments/Merchant Services, several deposit transactions will come in batch, meaning that they're made up of multiple invoice payments that were processed and deposited together. When these transactions go through the Bank Feed, they can still be matched to their correlating invoices in QBO.

 

However, you'll need to know which invoices make up the batch deposit. If you're unsure, you can visit your Merchant Center and take a look at the individual payments that the batch deposit is made up of, as well as the name associated with the Credit Card used to pay the invoice.

 

Then, take a look at your Transaction History, locate the batched deposit, and take a peek. Once you've determined which invoices match the batch deposit, you can revisit your Bank Feed in QuickBooks.

 

From here, you can:

 

  1. Click to highlight the Batch Deposit in your Bank Feed.
  2. Select the Find Match option. Then, you'll be brought to a Match Transactions page, filled with Invoices and Sales Receipts.
  3. From this list, you'll check off each invoice that makes up the total batch deposit amount.
  4. Once all are selected, you can click Save at the bottom left.


Or, if you'd prefer not to have to locate each invoice that matches the batch deposit in you Bank Feed, you can Exclude this batch and deposit and Create your deposits manually.

 

I'll be sure to keep an eye out for your response. Please let me know if you have additional questions or concerns. You can always reach out to the Community anytime you need a helping hand. Take care!

 

 

jensenautomotive
Level 1

. I have a problem with the intuit batch payments in my bank feed, not matching invoices created in QB. How do I correct this?

Hi Tori B,

 

I open the batch payment to match it. It takes me to the match transactions screen. The individual transactions are not listed. I am not sure if when we are running the transaction , they are categorized wrong from the start. The invoice goes into A/R. It also shows a separate transaction for the payment in that account.  My A/R account has a $0 balance.   

MarsStephanieL
QuickBooks Team

. I have a problem with the intuit batch payments in my bank feed, not matching invoices created in QB. How do I correct this?

Thank you for providing additional details, @jensenautomotive.

 

It looks like the invoices aren't linked to the payment based on your scenario above. That may be the reason the individual transactions are not showing up in the Match transactions screen. Also, it causes the Accounts Receivable (A/R) account's balance to be zero.

 

I'd suggest applying the invoices to the payment. This way, the A/R balance won't be zero, and these will display on the Match transactions page. I'll guide you through the steps.

 

  1. Go to the + New button.
  2. Select Receive Payment.
  3. Enter the customer name and leave the Amount Received blank.
  4. For the Payment Date, enter the date you'd like to use for an invoice closing date for your reports.
  5. Under Outstanding Transactions, put a checkmark next to the invoice to be paid.
  6. In the Credits section, tick the box with the deposited amount.
  7. Verify the transaction and click Save and close. (I added a screenshot for your reference).

    receive payments.jpg

 

 The zero balances will disappear from the A/R Aging Summary report. Let's go back to the Match transactions page so you can view the transactions. For more information, please check this article to help you with the process: Categorize and match online bank transactions in QuickBooks Online.

 

Should you want to learn more about the reconciliation process, I recommend this article to you: Reconcile an account in QuickBooks Online. This includes methods on how to manage and fix reconciliation errors to ensure your accounts are balanced and accurate.

 

I'll be one post away if you need anything else in regards to QuickBooks. Stay safe and have a good one!

Need to get in touch?

Contact us