Migrating to QuickBooks Online is a significant step toward streamlining your accounting processes. This guide is tailored for business owners, accountants, and bookkeepers who have recently switched from QuickBooks Desktop to QuickBooks Online. By following these steps, you can ensure a seamless transition and make the most of your new QuickBooks Online account.
Verifying your data and configuring your QuickBooks Online settings before entering new transactions is essential. This will help you avoid potential issues and ensure everything runs smoothly.
After migration, checking that your data is transferred correctly is crucial. Run these reports in both QuickBooks Online and QuickBooks Desktop:
Balance Sheet Report
Trial Balance – All Dates
Customer Balance Summary – All Dates
Supplier Balance Summary – All Dates
Sales Tax Summary Report for the most recent period
To verify your reports:
Set the date range to "All Dates."
Use the Accrual accounting method.
Potential Issues:
Discrepancies in Balances: If balances don’t match, recheck your data mapping and re-run the migration process if necessary.
Missing Transactions: Ensure all transactions are present. Missing data might indicate a need for manual entry.
Your company details like name, address, and email do not migrate automatically. Update these manually:
Go to Settings (gear icon) > Account and Settings.
On the Company tab, enter your company and contact information.
Set the email address for receiving monthly invoices from Intuit in the Company email box.
If different, specify an email address for customer contact in the Customer-facing email box.
Click Save.
Potential Issues:
Incorrect Information: Ensure the details entered are accurate to avoid communication issues and inaccurate billing.
Set up your sales tax information if your business is registered for it:
Go to Taxes and select Sales Tax.
Click Set up sales tax.
Choose your province or territory and select Save.
Fill in the required information and click Next, then OK.
Potential Issues:
Incorrect Tax Rates: Double-check the tax rates and registration details to ensure compliance with tax regulations.
For security reasons, bank and credit card details are not transferred. Connect these accounts manually:
Go to Bookkeeping > Transactions > Bank transactions.
Click Connect Account or Add Account.
Search for your bank and follow the prompts to link your accounts.
Select the appropriate account type from the dropdown menu and set the date range for the download.
Click Connect.
Potential Issues:
Connection Failures: Ensure you have the correct login credentials for your bank accounts.
Missing Transactions: Verify that all transactions are imported and none are missing.
Mark all pre-migration transactions as reconciled:
Go to Settings (gear icon) > Reconcile.
Select the relevant bank account, enter the Ending balance and Ending date, and click Reconcile Now.
Select all transactions up to the migration date. Ensure the Difference is zero before finishing.
Repeat for each connected account.
Potential Issues:
Discrepancies in Reconciliation: Double-check the ending balances and dates to ensure accurate reconciliation.
Enable the automatic application of credits:
Go to Settings (gear icon) > Account and Settings.
On the Advanced tab, enable Automatically Apply Credits and click Save.
Potential Issues:
Unlinked Transactions: Manually link payments and credits if automatic linking does not resolve all discrepancies.
QuickBooks Online uses an additional level of account typing called Detail Types. Review and update these as needed:
Go to Business Overview> Reports.
Run the Account Listing Report.
Review the accounts and edit their detail types if necessary.
Save any changes.
Potential Issues:
Incorrect Account Types: Ensure each account has the correct detail type to maintain accurate reporting.
Ensure your payroll data is correctly set up:
Go to Payroll > Employees.
Verify year-to-date payroll totals and employee details.
Map pay types from QuickBooks Desktop to QuickBooks Online if prompted.
Complete the payroll setup by following the on-screen instructions.
Potential Issues:
Incorrect Payroll Data: Double-check payroll information to avoid employee payments and tax filing errors.
Create a new Payments account in QuickBooks Online:
Go to Settings (gear icon) > Account and settings > Payments.
Click Learn More and then Set up Payments.
Complete the Business, Owner/Proprietor, and Bank sections.
Click Activate Payments.
Potential Issues:
Payment Setup Delays: Ensure all business and bank information is accurate for a smooth setup process.
Add users and assign appropriate access levels:
Go to Settings (gear icon) > Manage users.
Click Add User and follow the prompts to enter user details.
Save the changes. New users will receive an invitation via email.
Potential Issues:
Access Issues: Ensure users have the appropriate permissions to avoid access problems.
Invite your accountant to access your QuickBooks Online company:
Go to Bookkeeping > My accountant and enter their email address.
Alternatively, send an invitation to Settings (gear icon) > Manage users > Accounting firms>.
Potential Issues:
Invitation Errors: Confirm your accountant receives the invitation and can access your QuickBooks Online account.
After adding users, managing their permissions is essential to ensure they have the appropriate access levels.
Go to Settings (gear icon) > Manage users.
Select the user you want to manage and click Edit.
Assign a role (e.g., Standard User, Company Admin, etc.).
Customize permissions as needed and click Save.
Potential Issues:
Unauthorized Access: Ensure users have the correct permissions to prevent unauthorized access to sensitive information.
Enhance the functionality of QuickBooks Online by integrating it with third-party apps.
Payment Processors: Integrate with PayPal, Square, or Stripe.
E-commerce Platforms: Connect with Shopify, WooCommerce, or Amazon.
CRM Systems: Integrate with Salesforce or HubSpot.
Go to Apps in QuickBooks Online.
Search for the app you want to integrate.
Follow the on-screen instructions to connect to the app.
Potential Issues:
Integration Errors: Ensure the third-party app is compatible with QuickBooks Online to avoid integration issues.
Customizing your invoices and sales forms helps maintain your brand identity.
Go to Settings (gear icon) > Custom form styles.
Select New style and choose Invoice.
Customize the template, including logo, colors, and fields.
Click Save and close.
Potential Issues:
Brand Consistency: Ensure your forms are consistent with your brand guidelines.
Automate regular transactions by setting them up as recurring transactions.
Go to Settings (gear icon) > Recurring transactions.
Click New and select the type of transaction (e.g., Invoice, Expense, etc.).
Enter the transaction details and set the recurrence schedule.
Click Save template.
Potential Issues:
Incorrect Scheduling: Double-check the recurrence schedule to ensure transactions occur at the correct intervals.
Leverage the reporting capabilities of QuickBooks Online to gain insights into your business.
Go to Reports in QuickBooks Online.
Select the report you want to run (e.g., Profit and Loss, Balance Sheet, etc.).
Customize the report date range and filters.
Click Run report.
Potential Issues:
Data Accuracy: Ensure all transactions are entered correctly to maintain accurate reporting.
If your business deals with multiple currencies, set up multi-currency support in QuickBooks Online.
Go to Settings (gear icon) > Account and settings > Advanced.
In the Currency section, click Edit.
Turn on multi-currency and click Save.
Potential Issues:
Exchange Rate Fluctuations: Regularly update exchange rates to ensure accurate transaction records.
Manage projects and track profitability by setting up the Projects feature.
Go to Projects in QuickBooks Online.
Click New Project and enter the project name and details.
Assign transactions and time to the project to track expenses and revenue.
Potential Issues:
Tracking Accuracy: Ensure all related transactions are correctly assigned to the project for accurate tracking.
Although QuickBooks Online automatically backs up your data, it’s a good practice to export your reports periodically for added security.
QuickBooks Online offers a customizable dashboard. Tailor it to display the information most relevant to your business operations.
To streamline your workflow, use QuickBooks Online’s features, such as automation rules, integration with third-party apps, and advanced reporting capabilities.
If you encounter any issues or have questions, QuickBooks Online offers comprehensive support resources, including live chat, tutorials, and a user community.
Ensure you use the latest version of QuickBooks Online to benefit from new features and security updates.
If you notice any discrepancies in your data after migration, you may need to enter missing transactions or manually re-run the migration process. QuickBooks Online support can assist you if needed. SaasAnt offers migration assistance to help you through the migration process. You can learn more about our service on QuickBooks Migration—SaasAnt.
Use the import feature in Saasant Transactions to import data to QuickBooks Online. You can import almost all data types, such as Lists and Transactions.
Setting up a payments account in QuickBooks Online involves connecting your bank account and completing the business, owner/proprietor, and bank sections. Follow the steps outlined in the "Set Up Payments" section above.
Yes, you can move your QuickBooks Desktop company file to QuickBooks Online. Follow the steps in the migration process to ensure a smooth transition.
After migration, follow the initial steps in this guide to verify data integrity, update company information, and set up your QuickBooks Online account. This will prepare you for entering new transactions and managing your business data efficiently.