Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Imported Very Old Transactions

After switching over to quickbooks online from desktop, there are hundreds of old transactions showing up (payments, invoices & journal entries) dating back to 2010. Any ideas how to clear these out without messing up the accounts?

Solved
Best answer January 08, 2020

Best Answers
Moderator

Imported Very Old Transactions

It's possible that the payment was unlinked, cloudybeau.

 

Let's verify this by going to each invoices and apply all available credits. This way, it will be recorded as paid. Let me guide you with these steps:

 

  1. Click the + New button, and then select Receive Payment.
  2. Select a customer.
  3. Tick the open invoice under Outstanding Transactions.
  4. Click Save and new.

 

Repeat the same steps for the other unpaid invoices.

 

Also, for the journal entries, I'd recommend reaching out to your accountant. They can you on what to do with those entries without messing your accountant.

 

On the other hand, here are the list on what data are not included when converting to QuickBooks Online: Limitations when you convert from QuickBooks Online to QuickBooks Desktop.

 

I'll be right here to help you if you have other concerns.

View solution in original post

3 Comments
Moderator

Imported Very Old Transactions

Hello cloudybeau.

 

We can manually clear these old transactions so they won't show up when reconciling. Let me show you the steps:

  1. Go to Accounting.
  2. Select Chart of Accounts.
  3. Click on the View register link for the bank account.
  4. Double-click on the blank space beside balance column for each transaction to show the letter "R."
  5. Click on Save

You may also refer to this article to help you with reconciling bank accounts: How to Reconcile an Account: Statements & Records, & More

 

We are happy to help you with any questions about reconciliations. Post go ahead and post them here. 

 

 

Level 1

Imported Very Old Transactions

Thank you, however they are not showing up in my bank account register to reconcile. They are showing up as unpaid invoices, undeposited payments.

Moderator

Imported Very Old Transactions

It's possible that the payment was unlinked, cloudybeau.

 

Let's verify this by going to each invoices and apply all available credits. This way, it will be recorded as paid. Let me guide you with these steps:

 

  1. Click the + New button, and then select Receive Payment.
  2. Select a customer.
  3. Tick the open invoice under Outstanding Transactions.
  4. Click Save and new.

 

Repeat the same steps for the other unpaid invoices.

 

Also, for the journal entries, I'd recommend reaching out to your accountant. They can you on what to do with those entries without messing your accountant.

 

On the other hand, here are the list on what data are not included when converting to QuickBooks Online: Limitations when you convert from QuickBooks Online to QuickBooks Desktop.

 

I'll be right here to help you if you have other concerns.

View solution in original post

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us