Clean/tidy up QBO Account

yenngo · ‎July 31, 2022

Hi All,

Our company started to use Quickbooks online in April 22 and started to connect Bank account to Quickbooks in May 22. We are currently using Quickbooks for invoicing, entering expenses and payroll. Reconciliations have never been done.

Also, we have an accountant who does statements and BAS quarterly for us. We provide him with information of income and expenses in excel files together with bank statement.

Now I would like tidy/clean up the account so that I can keep track of all the transactions and get better view of the business. I'm thinking about restarting the account as of 01/07/2022, but I'm not sure what to do, where to start with as I'm new to Quickbooks and I was not the one who set up the QBO account at start.

So please help me point the way, it will be greatly appreciated.

JoesemM · ‎July 31, 2022

Thanks for the prompt reply, @yenngo.

You can export different transactions in QuickBooks Online. At this moment, exporting data is limited to reports and selected lists, and import data such as, Bank Data, Customers, Vendors, Chart of Accounts, Products and Services, and Invoices.

To export the transactions, make sure to select the data you'd like to export and save it to your local hard drive. This way, you can import them anytime.

Here are the steps to export the reports/lists:

Go to the Gear icon, then select Export data under Tools.
Set the reason for the export.
Under Lists select the list/s you want to export. Same with reports (under Reports).
Click on Export to Excel.
If you want to export your reports switch to the Reports tab.

Once they're available in Excel, here's how to import them to the second company:

From the Gear icon, select Import data.
Choose the data/lists you want to import.
Follow the on-screen instructions to complete the process.

For more guides about exporting out and importing data to QuickBooks Online, you can open these articles:

Also, we have a list of third-party apps that is QBO compatible to perform the data transfer for you. Doing so, all the data will be converted to the other company. Visit our applications website here: App Center.

Let me know you have follow-up questions. I'm always delighted to help. Have a great day, and take care!

View solution in original post

Fiat Lux - ASIA · ‎July 31, 2022

First of all, You cannot purge your QBO account after 90 days. This means you have to set up a new blank QBO account.

https://quickbooks.grsm.io/US

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

Next, export your data to XLS from your old account.

https://quickbooks.intuit.com/learn-support/en-us/help-article/list-management/export-reports-lists-...

You will import data starting from CoA, Lists, and Transactions. You may need to use a third-party migration tool if you have certain types of transactions to migrate (e.g receive payments, bill payments, journal entry)

https://transactionpro.grsm.io/qbo

As an additional option, utilize the backup restore app during your migration process.

https://rewindio.grsm.io/quickbooks

RoseJillB · ‎July 31, 2022

Welcome to the Community space, @yenngo.

Let me help you start over on your QuickBooks Online (QBO) account.

In QuickBooks, there are two options to start over depending on how long you’ve been using QuickBooks Online.

Accounts with less than 60 days can purge the company file to delete the data.
Accounts that are older than 60 days will have to cancel their QBO account. Then start a new one.

On the other hand, please take note that purging the account will let you start over by deleting all your data. Thus, there will be no option to keep the selected transaction that you want to remain in your company file nor a specific date.

For accounts less than 60 days:

Log in to your QuickBooks Online account as an admin.
Change the URL in your browser's address bar. For example:
• Before: https://...qbo.intuit.com/app/homepage
• After: https://...qbo.intuit.com/app/purgecompany
Type Yes to confirm the action.
Click Wipe Data.

For accounts 60 days older:

In your QBO account, click the Gear icon and select Account and Settings.
Go to the Billing and subscription tab.
Select Cancel subscription.
Follow the onscreen instruction to cancel your account
Then, sign up for a new QuickBooks Online account to start a new company.

Moreover, I added this article for detailed information: Delete your data and start over in QuickBooks Online

You may also want to check out this article if you need to learn more about QBO: Getting Started in QuickBooks Online

Should you have further queries about your data, please don’t hesitate to post them here. Have a good one!

yenngo · ‎July 31, 2022

Thanks so much for your information, RoseJillB

I'm wondering if there are any ways to transfer all the data of invoices, payments and payroll to the new company file?

Thank you!

yenngo · ‎July 31, 2022

Thanks so much for your reply. Really appreciate that!

Cheers,

yenngo · ‎July 31, 2022

Thanks so much for your reply. Really appreciate that

Cheers,

JoesemM · ‎July 31, 2022

Thanks for the prompt reply, @yenngo.

You can export different transactions in QuickBooks Online. At this moment, exporting data is limited to reports and selected lists, and import data such as, Bank Data, Customers, Vendors, Chart of Accounts, Products and Services, and Invoices.

To export the transactions, make sure to select the data you'd like to export and save it to your local hard drive. This way, you can import them anytime.

Here are the steps to export the reports/lists:

Go to the Gear icon, then select Export data under Tools.
Set the reason for the export.
Under Lists select the list/s you want to export. Same with reports (under Reports).
Click on Export to Excel.
If you want to export your reports switch to the Reports tab.

Once they're available in Excel, here's how to import them to the second company:

From the Gear icon, select Import data.
Choose the data/lists you want to import.
Follow the on-screen instructions to complete the process.

For more guides about exporting out and importing data to QuickBooks Online, you can open these articles:

Also, we have a list of third-party apps that is QBO compatible to perform the data transfer for you. Doing so, all the data will be converted to the other company. Visit our applications website here: App Center.

Let me know you have follow-up questions. I'm always delighted to help. Have a great day, and take care!

yenngo · ‎July 31, 2022

Thanks so much for your quick reply!

Have a good one!

Cheers,

LollyNino_C · ‎August 01, 2022

Thank you for the update, @yenngo.

I'm happy to hear my colleague was able to help you out with your QuickBooks account. If there's anything else you need help with, we're just a few clicks away, any day, any time.

Thanks again and I hope you have a wonderful day ahead.

Topics

Training

Community

Resources

Clean/tidy up QBO Account