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

Banking - Bill payment batch

Hi, I am very new to QBO and need some help please.  I created a batch payment to pay our weekly creditors and have uploaded the aba file into the bank to pay - no problem.  The batch payment shows on the banking screen under the Review tab as per attached (Banking - Review) - how do I reconcile this?  Do I just need to allocate a category?  If so, what category do I choose?  

Also, when I look in the bank register, it shows the individual supplier payments that make up the batch payment.  This confuses me as these also look to be not reconciled.  What do I need to do here?

Are these two transactions going to double up on the bank reconciliation?  

Thank you in advance

7 Comments 7
JoesemM
Moderator

Banking - Bill payment batch

I'm here to help you with those transactions so you can reconcile them, @dkrbooks.

 

You'll have to Undo the transactions if you manually record the 1 bill payment for multiple bills since it will not be matched on the Banking page. These also to avoid duplicate in your bank register, so you can easily reconcile them.

 

Here's how:
 

  1. Click Banking, then go to the Banking tab.
  2. Go to the Review tab.
  3. Select the transactions you'll want to undo, then click Undo.

Then, exclude them by following the steps below:
 

  1. Go to the For Review tab.
  2. Select the transactions you'll want to exclude.
  3. Click Batch actions, then select Exclude Selected.

 

Once done, we can go to the account register and reconcile the transactions manually. For the correct category, I'd suggest reaching out to your accountant. This to ensure that your books are accurate.

 

Here's how:

 

  1. Click Accounting on the left menu and go to the Chart of Accounts tab.
  2. Look for the affected account and click View register.
  3. Look for the transaction and change the status from blank or Cleared (C) to Reconciled (R).
  4. Click Save and select Yes to confirm the action.

 

You can use this link for reference: Undo or remove transactions from reconciliations in QuickBooks Online.

 

I've also collected these articles that contain steps on how to properly reconcile your account and set up bank rules:

 

 

Should you have any additional questions or concerns, the Community and I will have you covered. Take good care!

dkrbooks
Level 1

Banking - Bill payment batch

Hi Joesem,

I think I understand your instructions.  Am I correct in saying I need to undo the individual bill payment transactions and then manually reconcile the batch payment to the invoices?  This is crazy!  Double the workload and more room for human error.  I don't understand why QBO has a batch payment function if it doesn't work correctly.  Is there no other way?

Alternatively, could I just remove the batch payment transaction? 

LeizylM
QuickBooks Team

Banking - Bill payment batch

Hi there, dkrbooks.

 

Allow me to share some information about deleting batch payments in QuickBooks Online.

 

In QuickBooks Online (QBO), you can delete multiple entries but payment transactions will have to be deleted one by one. This is to avoid the accidental removal of another transaction.

 

You can consider using a third-party application to save your business time. The App Center has all kinds of apps to choose from. Aside from that, you’ll get a better comparison of each one and check if it meets your needs.

 

When you're ready, you can start reconciling your accounts to keep your records correct.

 

In case you observe some discrepancies in your books, you can refer to this article for the fixes: Learn the reconciliation workflow in QuickBooks.

 

Keep me posted if you need help when working in QuickBooks. I’ll jump right back in to assist further. Have a great day ahead.

richard2393
Level 1

Banking - Bill payment batch

I agree with you 100% it becomes a real problem when reconciling. I have been excluding the batch amount in the bank feeds but this is very time consuming especially when you have many supplier payments in one batch.

IntuitSheila
Level 8

Banking - Bill payment batch

Hi richard2393,

 

It's not the experience we wanted you to have about matching batch payments in QuickBooks Online. I'll make sure to add this to our report and let our Product Development Team know. 

 

You can also send your feedback inside the QuickBooks Online account, then click on the Gear Icon and click on Feedback. This is the quickest and most direct way to send improvements or suggestions.

 

Also, you can check this link to learn more about Categorise and match online bank transactions in QuickBooks Online.

 

Feel free to drop a comment below if you have more concerns. I'll be around to help you!

AT  LBD
Level 1

Banking - Bill payment batch

Reading this feed as I too am new to Quickbooks.  This is absolutely madness!  In Xero and MYOB these will show as 1 lump sum item to match in bank feeds.  At no time do you have to unmatch, re-reconcile or any of the steps mentioned above!  I will soon be pushing for the company to move off of this software as it is very inefficient.

Surely everyone using QB must be hitting this problem on a constant basis?

AnthonySlab
Level 1

Banking - Bill payment batch

I totally agree that this is madness.  I literally have a calculator out each month guess at which transactions make a $20K $30K etc. batch payment on my register.  I miss QB Desktop so much!  With desktop they had the breakdown in the bill payment and the bill payment amount matched the bank statement.