Home » QuickBooks Desktop to QuickBooks Online 50-point Checklist

QuickBooks Desktop to QuickBooks Online 50-point Checklist

We have a 50-point checklist designed to give you the BEST QuickBooks Desktop to QuickBooks Online conversion experience! In this video, Hector briefly explains the conversion process (AFTER determining that is a good idea to convert to Online and the QB Desktop file is prepped for conversion):

Items to Review in QuickBooks Desktop PRIOR to QBO conversion (in the spirit of making sure you do not upload any garbage into QBO):

Where is the database file currently located? is there a server? How many computers are accessing them at the moment? are there any remote access users? is there an external accountant working on the file? Is there an accountant’s copy out? does the Data Verify function work?
What is the File Size, Number of Targets? Is it necessary to do a condense?
Are there multiple users? What are their limited access restrictions?
How often are backups being done? Can you tell if a past scenario where you had to restore a backup file and what happened?
Is multi-currency turned on? Are there multiple accounts with balances with foreign currency? Any vendors or customers with foreign currency with balances?
Is payroll activated in the QuickBooks File? Is it Manual, Enhanced, or Assisted?
If there is outside payroll, how is it being entered, by hand? Or imported?
Is QB Payments enabled with this QuickBooks File? Are there any recurring payments setup in the Intuit merchant center? Is there CC data stored in the Customer:jobs?
Is there a 3^rd party app connected to QuickBooks via SDK or Web Connector? Are there IIF files being imported?
Are all banks, CC, and loan accounts reconciled? And up to when? Are there any transactions in the reconciliation discrepancy report?
Are there uncleared transactions older than 90 days from last reconciliation?
Does the Balance Sheet tie to the las tax return or audited financial statements?
Are books closed with a password? Are there any transactions in the Closed Exception Report?
Are there old transactions (90 days or more) in the Undeposited Funds Account?
Is there open A/R older than 1 year? Are there any unapplied Customer Payments or credit balances on transactions affecting A/R? Are they using multiple A/R Accounts?
Is there open A/P older than 1 year?Are there any unapplied Bill Payments or Debit balances on transactions affecting A/P? Are they using multiple A/{ Accounts?
Are sales orders being used? and how?
Are there open Partial Purchase Orders?
Are there any open Item receipts?
Are non-inventory items setup as “double-sided items”?
Is there Inventory? Do they use Inventory Assemblies? Is there any Inventory Items with a QOH inactive?
Are there any inventory parts with NEGATIVE balances?
Does the Inventory Valuation Report match the Inventory Asset in the Balance Sheet?
Do all Inventory Items map to the Inventory Asset Account?
Are there separate equity/distribution accounts per partner/owner?
Are the other Asset and Liability accounts correct?
Does the Sales Tax Liability tie to the consequent payment?
Does the Payroll Tax Liability tie to the consequent payments?
Are there redundant P&L Accounts?
Is there an opportunity to do mayor re-design of the P&L chart of accounts? (there is a 250 account limit in QuickBooks Online Simple Start, Essentials, and Plus – no limit on Advanced)
Does the COGS and Gross Margin % makes sense?
Are there multiple Sales Tax Items?
Are there any transactions without Payee’s?
Are they using Other Names? if so how many
Are Bank Feeds connected? Are they using Bill Payment Direct Deposit?
Are the Estimates/Sales Orders/Invoices/Purchase Order templates customized in a way that QBO won’t support? Are they using the Customer Message List? Ship Via List? Are they using the Delivery Date / Ship Date fields?
Are Sales Reps being used?
What custom fields are being used?
Are there customized/memorized reports needed by management?
Is Customer Type, Job Type, Job Status, and Vendor Type being used?
Are Price Levels being used?
Are Budgets setup?
Are multiple shipping addresses being used?
Are tasks and notes being used?
Are document attachments being used?
Is the Finance Charge feature being used?
Are grouped items being used? Grouped sales tax?
Is progress Invoicing and Estimates vs. Actual Reports being used?
Are there recurring/memorized transactions
Are fixed asset items being used?

We can offer a service that will include the following for $750:

Review the QuickBooks Desktop File using this checklist, and giving you a list of items/features you will lose in the process of conversion
Determining if QBO is right for you, and recommending QuickBooks Essentials or Plus
Creating new QBO Company File
Making Journal Entry to tie balance sheet post conversion at two periods: 1) for the last tax return and 2) for up to conversion date
15-minute overview on using QuickBooks Online post conversion to go over QBO settings and setup basic customization of forms, adding logo
Provide a price quote for training/customization* of QuickBooks Online beyond conversion
Provide a customized price quote for monthly bookkeeping services with QuickBooks Online to collaborate with you

*What is NOT included with the Review/Assessment, would need a separated bookkeeping/training session to show you how to do it:

Condensing the file: files with more than 350K targets will not convert to QuickBooks Online!
Data Entry
Journal Entries or Adjustments
Reconciling Bank Accounts
Cleaning up reconciliation discrepancies
Making Inventory Adjustments
Cleaning up item lists
Cleaning up chart of accounts
Cleaning up the Customer List
Cleaning up the Vendor/Other names List
Setting up budgets
Any training or answering, “how do I…” questions
Setting up multi-currency
Setting up items/groups
Customizing Reports
Setting up Bank Feeds, downloading transactions beyond 90 days, and/or excluding extra downloaded transactions