Limited time. 50% OFF QuickBooks for 3 months.

Buy now & save
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
AnnMc
Level 1

I imported several CC transactions that came over with 12--31-1969 as the date then accidentally bulk added them to the register. Any hope of a way to fix it?

Any way to prevent this date in the future?

1 Comment 1
ThomasJosephD
QuickBooks Team

I imported several CC transactions that came over with 12--31-1969 as the date then accidentally bulk added them to the register. Any hope of a way to fix it?

You can manually filter and delete the transaction in the register, AnnMc. Allow me to guide you through the process to correct your register.

 

Before proceeding with any changes, please ensure you have a recent backup of your financial data to avoid any loss of important information.

 

Regarding the transaction dated 12-31-1969, you can filter for these specific entries in your register and manually delete them, as there is currently no option available for bulk deletion in the register.

 

Here's how:

  1. Go to Setting and select Chart of Account.
  2. Select the bank account where the transactions accidentally added.
  3. Click View Register.
  4. Hit the Funnel icon to filter the transaction.
  5. Enter the specific date of the transaction and click Apply.
  6. Click the transaction and hit Delete.

 

You can reupload the data again after this and to avoid encountering similar issues in the future, it is highly recommended to double-check the date settings before importing any file.

 

Additionally, you can manually add transaction to account register in QuickBooks. Utilizing this technique can expedite the process when you're analyzing your chart of accounts and decide to include a new entry.

 

I've included an article that provides guidance on how to handle discrepancies between QuickBooks Online and bank statements during a reconciliation process in the future: Fix issues at the end of a reconciliation in QuickBooks Online.
 

To safeguards your financial information and ensures a smooth correction process is our priority. If you require additional assistance or have any questions, please do not hesitate to reach out. We are committed to providing prompt and effective support.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us