duplicated data

Good day to you, Mp196920160. I'll share some ways to remove the duplicate entries on your record.

First, you can go through your register to identify the possible duplicate transactions in your record. 

Here's how:

1. Sign in to your account.
2. Click on Accounting at the left pane, then Chart of Accounts.
3. Look for your bank, then tap on View Register under Action.

To remove possible duplicate records, select the transaction, then Delete.

Alternatively, you may exclude the downloaded bank entry from the Banking page. 

On the other hand, you can skip the process of manually deleting identical entries by matching them.

1. Locate the downloaded transaction to expand the view.
2. Tap on Find Match. 
3. Review the matching records found in QuickBooks. 
4. Follow the onscreen instructions to complete.

I'm also adding this article for more information: Categorise and match online bank transactions in QuickBooks Online. The same material will give you tips about adding and categorising banking entries and splitting them into multiple accounts.

Please let me know in the comment section below if you have follow-up questions while working with your banking data. I'm always here to help. Have a good one!

thanks again. going throughit but its doing what i want now. with the ones that are ok that have been added manually is there a way to make them show as cleared?

Hi Mp196920160,

Yes, there's a way to change the statuses of the ones you added to Cleared. I'll continue to guide you through updating them.

To do this, you'll want to go to your transactions in your bank register using the first set of steps that Angelyn_T shared above. Then, click each of them and the Reconcile field until the status becomes C (Cleared), save and confirm. Then, do the same thing to the rest of the transactions.

On the other hand, a cleared status can be achieved when you add or match transactions from the Banking page.

Speaking of duplicates, I also want to add this article about handling duplicate transactions in the For review section on Banking: How to remove duplicate bank transactions in QuickBooks Online. Though the flag says it's for an Australian version, the concept is just the same with the UK version. It's just for your additional reference.

Feel free to go back to this thread if you have any other questions about managing your bank transactions.

hI. THE SITUATION I HAVE IS THAT I HAVE DELETED A DEPOSIT IN ERROR FROM A SALE, INVOICE 1819.

I HAVE MANUALLY IMPORTED THIS NOW AGAIN NOW AND ITS UNDER THE REVIEW

tHE TRANSACTIONS IS AS BELOW

CENTRAL INS.SRVC 1819 CENTRAL INS RP46599[removed]0 201003 10 02MAY23 09:25

aS THE ORIGINAL INVOICE IS DELETED 1819, how do i have this as a cleared item

Thanks again

Hello MP196920160, Thanks for your reply. The solution would usually be, if it is under review to match it again which would change it to a c or to manually add the c as mentioned by the previous user. We do see that reconciles can be tricky to discuss here as we cannot see your screen and guide you. If you need us to go through it under a screen share, we have that option, just call us on 08082345337.