Skip to main content
M
maags1950-gmail-
November 25, 2021
Question

Bank transfer duplication.

  • November 25, 2021
  • 1 reply
  • 0 views
I am still struggling with bank transfer duplication ,how do you categorise a bank transfer ,just to explain in my quickbooks when I get a transfer from bank account X to bank account Y,so you categorise, where funds are going to account Y ,so books are ok there is payment transaction ,from account X and a deposit in Y ,BUT ,it becomes a problem when you review bank account Y ,so again you categorise from where funds came ,this atomically causes duplication .as you have to review the 2 bank accounts ,my question how do I treat a bank transfer one one bank to another, do I use transfer or deposit option.

1 reply

M
Maybelle_S
November 26, 2021

Glad to see you in the Community, @maags1950-gmail-.

 

Let me share some insights about your situation.

 

When you download the transactions, it first goes into the For review page. Then, you'll need to check the categories before adding or matching them. 

 

In cases of duplicate transactions showing up in your bank register, please make sure to check if there's a bank rule with an auto-add feature set up. This automatically accepts your transactions into your books. That might be the reason why you see some duplicate figures.

 

Here's how:

 

1. Go to Transactions or Banking > Rules.

2. On the Rules page, if you see one, click the Edit link.

3. Review the setup and check if the Automatically confirm transactions this rule applies to option is enabled. 

4. Click the toggle icon to disable the feature.

 

If there are no rules set up for the duplicate transactions, you'll want to run the Audit log report to see who added these transactions.

 

Here are the steps:

 

1. Click the Gear icon located in the upper right-hand corner.

2. Under Tools, select Audit log.

3. Choose All from the User and Events drop-down and set the Date range.

4. In the History column section, click the View link to see more details.

 

To remove the duplicate transactions, you can exclude them by following these steps:

 

1. Go to Transactions > Banking.

2. In the For review tab, put a checkmark on the duplicate transactions.

3. Click the Exclude button.

 

After excluding these transactions, you can delete them in the Excluded section.

 

To help with matching and categorizing your downloaded transactions, please check out this article: Categorise and match online bank transactions in QuickBooks Online.

 

Please keep in touch with me here if there's anything else you need. I'd be happy to help you out again. Have a good day ahead.

Terms & ConditionsAccessibility statement