cancel
Showing results for 
Search instead for 
Did you mean: 
Linda Pi
Level 2

Prior period bank transactions

I have a duplicate bank transaction on my bank feed from a prior period. I can no longer exclude it as financial statements have already been issued. How do I remove the duplicate transaction? Thanks!

4 Comments 4
Fiat Lux - ASIA
Level 15

Prior period bank transactions

Utilize a deleter tool

https://transactionpro.grsm.io/qbo

 

LeizylM
QuickBooks Team

Prior period bank transactions

Good day, Linda Pi.

 

I'll lend you a hand with removing duplicate transactions in QuickBooks Online (QBO).

 

You'll need to undo the duplicate transactions for them to be excluded from the For Review tab. Just a heads up that this may affect the prior period on your financial statements.

 

To undo, here's how:

 

  1. In the left navigation tab, click on Banking.
  2. Select the Categorized tab, select the duplicate transactions. 
  3. Click on Undo.
  4. In the For Review tab, select the duplicate transactions. 
  5. Click Exclude.

 

However, if you're unable to delete duplicate transactions you can create a journal entry. Before doing so, I suggest consulting your accountant to ensure your books are accurate.

 

For your reference, please read this article so you'll be guided when categorizing transactions: Categorize and match online bank transactions in QuickBooks Online.

 

If there's anything else that you need with your bank transactions, let us know so we can get back to you. Have a great day!

Linda Pi
Level 2

Prior period bank transactions

The transaction is not categorized or matched. I cannot exclude it as it is from a prior period and FS have been issued already. How can I remove it from the banking feed in this period?

RoseJillB
QuickBooks Team

Prior period bank transactions

Thank you for your prompt reply, @Linda Pi. I’ll help you with removing duplicate transactions in QuickBooks Online (QBO).

 

To make amendments from your prior period transactions, we can edit your closed books by changing their closing date.

 

Take note that only those with admin access can make these changes. Otherwise, you can request access from the primary or company admin to grant you access and enable you to have the option.

 

Here’s how you can edit the closing date:

 

  1. Go to the Gear icon, and select Account and Settings.
  2. Select the Advanced tab.
  3. Click Edit in the Accounting section.
  4. Change the closing date. To change your password, simply type in a new one and confirm it.
  5. Select Save and then Done.

 

Once done, you can go back to the banking feed and follow the steps provided by my colleague @LeizylM above.

 

I also highly recommend you consult your accountant for expert advice and to avoid having problems with your prior period financial statements.

 

Also, you can track any changes you make after you close your books by clicking this link.

 

Furthermore, you can check out the following articles to learn more about categorizing transactions and reconciling your account in QuickBooks Online.

 

 

If you need further assistance with your transactions, you can always hit the Reply button. I’ll make sure to get back to you as soon as possible. Have a great day!

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

Need to get in touch?

Contact us