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

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
Adrian_A
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 3
Anonymous
Not applicable

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. 

 

 

cloudybeau
Level 2

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.

Adrian_A
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.

Need to get in touch?

Contact us