Skip to main content
April 27, 2021
Solved

Bank Reconciliation/CC Payment Quickbooks Online

  • April 27, 2021
  • 1 reply
  • 0 views

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. 

Best answer by mv32

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!

1 reply

mv32Answer
April 28, 2021

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!

April 29, 2021

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.