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

The Big Bank Reconciliation Fail

I've made a mess.

 

My bank pw changed at the start of the year and I never updated QB with the new one, so I never pulled in any transactions. That's bad enough, but now I'm at the point that my bank won't send them more than about 10-12 weeks worth. This leaves me to have to upload all 9 months of CSV files. I'm worried about invoices paid directly through QB (cc & EFT). They were always in QB of course and I'll be pulling them in as deposits for the 2nd time with my manual upload. Is there any way QB will flag the duplicate deposits for deletion or will I have to do so manually? I also need to delete only the new uploaded version correct? Leaving the QB version alone I would think. This is already a mess and I'd prefer to not make it too much worse.

 

Thanks!

Solved
Best answer Wednesday

Best Answers
Jayson_E
QuickBooks Team

The Big Bank Reconciliation Fail

I’m excited to assist you with updating your bank transactions in QuickBooks Online(QBO), Shawn. Let’s collaborate to streamline the uploads and handle any duplicates effortlessly.

 

Currently, QBO does not automatically flag duplicate deposits for deletion. When you upload transactions manually, it treats them as new entries, which can lead to duplicates if the same transactions were previously recorded in QBO.

 

However, you can Exclude duplicate transactions from your bank feeds to avoid discrepancies in your QBO records.

 

Here's how you can do it:

  1. Navigate to the Transactions menu.
  2. Click the Bank Transactions.
  3. Under the For review tab, tick the checkboxes next to the duplicate transactions.
  4. Click on the Exclude option that appears at the top of the list to remove these duplicates from your bank feed.
    image (50).png

(Note: The image attached is for reference only.)

 

You can view all excluded transactions in the Exclude tab later if needed, ensuring you have a complete picture of your financial activity.

 

To maintain a solid financial foundation for your business, enabling better decision-making and long-term success, I'm sharing these two helpful articles for you to use:

 

 

I appreciate the opportunity to assist you today! By effectively managing your bank transactions and duplicates, you're positioning your business for success. If you have any further questions, feel free to Reply below. Remember, We're always here to support you whenever you need help.

View solution in original post

1 Comment 1
Jayson_E
QuickBooks Team

The Big Bank Reconciliation Fail

I’m excited to assist you with updating your bank transactions in QuickBooks Online(QBO), Shawn. Let’s collaborate to streamline the uploads and handle any duplicates effortlessly.

 

Currently, QBO does not automatically flag duplicate deposits for deletion. When you upload transactions manually, it treats them as new entries, which can lead to duplicates if the same transactions were previously recorded in QBO.

 

However, you can Exclude duplicate transactions from your bank feeds to avoid discrepancies in your QBO records.

 

Here's how you can do it:

  1. Navigate to the Transactions menu.
  2. Click the Bank Transactions.
  3. Under the For review tab, tick the checkboxes next to the duplicate transactions.
  4. Click on the Exclude option that appears at the top of the list to remove these duplicates from your bank feed.
    image (50).png

(Note: The image attached is for reference only.)

 

You can view all excluded transactions in the Exclude tab later if needed, ensuring you have a complete picture of your financial activity.

 

To maintain a solid financial foundation for your business, enabling better decision-making and long-term success, I'm sharing these two helpful articles for you to use:

 

 

I appreciate the opportunity to assist you today! By effectively managing your bank transactions and duplicates, you're positioning your business for success. If you have any further questions, feel free to Reply below. Remember, We're always here to support you whenever you need help.

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

Need to get in touch?

Contact us