Skip to main content
S
Shawn Ronakov
December 19, 2024
Solved

The Big Bank Reconciliation Fail

  • December 19, 2024
  • 1 reply
  • 0 views

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!

Best answer by Jayson_E

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.

(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.

1 reply

J
Jayson_EAnswer
December 19, 2024

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.

(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.

Terms & ConditionsAccessibility statement