Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Questions about how to close your books for 2020? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Matching a bill payment to a bank transaction (with other posting date) it uses the bill payment date, affecting cash flow and reconciliation. How can I avoid this issue?

For example, if I enter a bill payment on 12/31 and the transaction posts 1/2, going to bank feed transaction matching will choose 12/31. The cash flow statement is affected and bank reconciliation is more difficult since the transactions don't match exactly. Is there any way to keep both dates? Alternatively, any way to have it choose the bank's date instead? I think that would be a lesser evil. Is there a better way of handling this?
4 Comments
QuickBooks Team

Matching a bill payment to a bank transaction (with other posting date) it uses the bill payment date, affecting cash flow and reconciliation. How can I avoid this issue?

I'll share some information about how QuickBooks matches the transactions, nar883.

 

When we match our QuickBooks transactions to the downloaded transactions from your bank, the program will follow the date of the QuickBooks transactions. The option to keep both dates in unavailable in QuickBooks Desktop. To make your reconciliation easier, we can locate those transactions in the Chart of Accounts then modify the date.

 

I'll be guiding you in doing the whole process:

 

  1. Select List from the top menu bar.
  2. Choose Chart of Accounts.
  3. Select then double-click the appropriate bank account to open it.
  4. Locate then double-click the appropriate transaction.
  5. Change the date based on the bank post date.
  6. Click Save & New, then hit Yes to confirm the changes.

I've included an article that will guide you in reconciling your accounts in QuickBooks to ensure that your QuickBooks accounts accurate.

 

You can always find me here if you need more help in managing your accounts. Assistance is just one post away.

Level 1

Matching a bill payment to a bank transaction (with other posting date) it uses the bill payment date, affecting cash flow and reconciliation. How can I avoid this issue?

Thanks, I had to do this already for some of the transactions so that things would reconcile, but it's not ideal.  I was hoping there was a better way to handle this [common?] scenario.

QuickBooks Team

Matching a bill payment to a bank transaction (with other posting date) it uses the bill payment date, affecting cash flow and reconciliation. How can I avoid this issue?

Good to hear from you again, @nar883.
 
You're most welcome. I also appreciate your taking the time to post this and letting me know that the issue got resolved.
 
As always, Community is full of experts possessing knowledge in all facets of QuickBooks, so please reach out to us here if there's anything you need. We're always happy to help you along your road to victory. Wishing you and your business continued success!

Level 1

Matching a bill payment to a bank transaction (with other posting date) it uses the bill payment date, affecting cash flow and reconciliation. How can I avoid this issue?

Well, it's not exactly resolved.  I was already doing what you suggested but it's not ideal, which is why I asked the question.  I'm guessing there isn't a better way of handling this, which is unfortunate.

Need to get in touch?

Contact us