cancel
Showing results for 
Search instead for 
Did you mean: 
wandellscottreal
Level 2

Bank Reconciliation/CC Payment Quickbooks Online

I am reconciling my bank Statement it is off by a 400.00 payment. I see the transaction in the Chart of Accounts and I have left the reconcile "blank" instead of C/R  to add it back to my bank statement to finish reconciling. The payment is not going back to my bank statement. I had this happen with another CC payment and the Charge went unreconciled on my bank statement and It corrected the difference amount. 

Solved
Best answer April 27, 2021

Best Answers
Jovychris_A
Moderator

Bank Reconciliation/CC Payment Quickbooks Online

I can help clear things up to you, @wandellscottreal.

 

The 400 payment can be a duplicate transaction. It happens when you add it to the bank register and also have an existing transaction in QuickBooks at the same time. When you have recorded a payment transaction in QuickBooks, you can match it with an online banking transaction to avoid duplicate. For more details, you can reference this article: Categorize and match online bank transactions in QuickBooks Online.

 

Also, there may be an edited payment transaction or sales receipt and this entry resolve the difference causing the 400 payment to create a difference when clearing/reconciling the amount. If that's the case, you can review the Audit log for edited transactions by following these steps:

 

  1. Go to Gear and then select Audit log.
  2. Click the Filter button and then set:
    User: All users
    Date: select a period or custom date
    Events: Show all events
  3. Then hit Apply.
  4. Then select View when you see a transaction that's the same with 400 payment amount.

You can also check the Profit and Loss by Detail report to see a duplicate transaction on a given report period.

 

In case it's proven that the transaction is a duplicate, you can go to the bank or CC register to remove it.

 

Here's how:

  1. Go to the Gear icon and then select Chart of accounts.
  2. Find the bank in question.
  3. Click View register on the Action column.
  4. Select the payment transaction and choose Delete.

 

For additional insights, you may check out these articles:

 

If you have other questions in mind about reconciling accounts and managing transactions, please let me know so I can assist you. Have a wonderful ahead!

View solution in original post

2 Comments 2
Jovychris_A
Moderator

Bank Reconciliation/CC Payment Quickbooks Online

I can help clear things up to you, @wandellscottreal.

 

The 400 payment can be a duplicate transaction. It happens when you add it to the bank register and also have an existing transaction in QuickBooks at the same time. When you have recorded a payment transaction in QuickBooks, you can match it with an online banking transaction to avoid duplicate. For more details, you can reference this article: Categorize and match online bank transactions in QuickBooks Online.

 

Also, there may be an edited payment transaction or sales receipt and this entry resolve the difference causing the 400 payment to create a difference when clearing/reconciling the amount. If that's the case, you can review the Audit log for edited transactions by following these steps:

 

  1. Go to Gear and then select Audit log.
  2. Click the Filter button and then set:
    User: All users
    Date: select a period or custom date
    Events: Show all events
  3. Then hit Apply.
  4. Then select View when you see a transaction that's the same with 400 payment amount.

You can also check the Profit and Loss by Detail report to see a duplicate transaction on a given report period.

 

In case it's proven that the transaction is a duplicate, you can go to the bank or CC register to remove it.

 

Here's how:

  1. Go to the Gear icon and then select Chart of accounts.
  2. Find the bank in question.
  3. Click View register on the Action column.
  4. Select the payment transaction and choose Delete.

 

For additional insights, you may check out these articles:

 

If you have other questions in mind about reconciling accounts and managing transactions, please let me know so I can assist you. Have a wonderful ahead!

wandellscottreal
Level 2

Bank Reconciliation/CC Payment Quickbooks Online

After many Hours Of trying to figure out the issue. It was operator error. When marking Credit card Payments to the correct credit card make sure your bank register is marked to that credit card and not a different one. Meaning Bank register paid Capital one and Credit card payment was to Amex. The Joys of being your own accountant.

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

Need to get in touch?

Contact us