Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
August 10, 2021
Question

Massive QBO cleanup

  • August 10, 2021
  • 2 replies
  • 17 views

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.

2 replies

QuickBooks Team
August 11, 2021

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.

August 11, 2021

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.

Fiat Lux - ASIA
Level 14
August 11, 2021

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