cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
paulmoughtin
Level 1

I change the date range of the bank transactions I initially imported

* Can I... I've missed 12 months of transactions by entering the wrong year on the date range. Can I erase them and restart as I presume if I can reload I'll import lots of duplicates

1 REPLY 1
Jovychris_A
Moderator

I change the date range of the bank transactions I initially imported

Currently, we're unable to change the initially imported date range, Paul. However, we can prevent duplicating transactions by first filtering the date range and then excluding them.

 

You can follow the steps below:

 

  1. Navigate Transactions and then select Bank transactions.
  2. Click the Filter icon.
  3. (Optional) Fill in the following fields: Account, Transaction type, Category.
  4. Select Custom Date from the Date drop-down.
  5. Pick dates in the From and To fields.


     
  6. Hit Apply.

 

Once done, if this is your first time importing transactions, you can remove any incorrect entries by checking the box before the Date column and clicking Exclude to permanently delete them.

 

Moving forward, we recommend that you download your transactions from the bank using the appropriate date range. Once downloaded, kindly edit them using a designated application before re-importing them back into the system.

 

I'll provide this resource for additional insights, which will serve as your reference for deleting entries in the Bank transactions tab: Exclude bank transactions in QuickBooks Sole Trader.

 

Once all is set, this guide can assist you in quickly categorising the imported entries: Create a bank rule.

 

If you need further assistance with importing and removing bank transactions or other QuickBooks concerns, please don't hesitate to ask. We're here to help you always.

Need to get in touch?

Contact us