Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Leslie at Pop Shop
Level 1

Massive QBO cleanup

I am going to start trying to clean up the books for an existing company.  They have used QBO since 2015, but were just manually entering transactions for years, until a year or so ago and then began importing transactions from a checking account and a credit card.  Until now, they were only using QBO to track their expenses of remodeling houses to flip.  No reconciliation has ever been done.  What would be the first steps to get the checking and credit card accounts to the correct place for a fresh start as of January 1 of this year?  I have only ever started from the beginning of a company or come into a company that was already up to date on reconciliation.

5 Comments 5
LeizylM
QuickBooks Team

Massive QBO cleanup

Hello, Leslie at Pop Shop. 

 

If your books are 60 days old or older, you need to cancel your account and start a new subscription.

 

To cancel your account:

 

  1. Go to the Gear icon.
  2. Click  Account and Settings under Your Company.
  3. Select the Billing and subscription tab.
  4. In the QuickBooks section, select Cancel.
  5. Follow the steps to cancel your account. 

 

To start a new account:

 

  1. Go to https://quickbooks.intuit.com/choose-country/.
  2. Fill up the User ID and password.
  3. You can use the same user ID and a password you previously had.


You can manually upload your checking account or credit card account to start January 1 for this year.

 

Also, I recommend reconciling your bank statements every month so your books are always 100% accurate. Here’s an article that provides detailed information on how to reconcile your account: Reconcile an account in QuickBooks Online

 

In addition, here are some resources that you can browse to help keep your accounts accurate and up-to-date:

 

 

Keep us posted if have any other concerns or further questions about this bank reconciliation. Wishing you all the best.

Fiat Lux - ASIA
Level 15

Massive QBO cleanup

@Leslie at Pop Shop 

You should open a new blank QBO account

https://quickbooks.grsm.io/US

https://quickbooks.grsm.io/us-promo

 

then consider having these apps to help

1. A migration tool

https://transactionpro.grsm.io/qbo

 

2. An importer or a converter for historical bank transactions

https://www.moneythumb.com/?ref=110

 

3. A backup restore app

https://rewindio.grsm.io/quickbooks

 

Hope they help.

Leslie at Pop Shop
Level 1

Massive QBO cleanup

What do I do about all the past expense numbers for each project so that the owner can look at reports to see what he has historically spent on projects in each category? It is common for projects to span more than one year.

Leslie at Pop Shop
Level 1

Massive QBO cleanup

What do I do about all the past expenses that were recorded so that the owner can still view reports showing what the expenses were for past projects by category? It is common for projects to span more than one year.

Fiat Lux - ASIA
Level 15

Massive QBO cleanup

You can utilize the migration tool to migrate any historical expense data from the old QBO account. i.e Bills + Bill Payments, Purchase Orders, and Purchase Cash

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

Need to get in touch?

Contact us