About this template
Work type: Admin
Location: United States
Client industry: Generic
Version: 2 (Latest)
This template includes
- 11 tasks
ABP - QBD to QBO Conversion
18 downloadsBefore we generate that file, please let us know more about you.
Sorry, but you can only download 5 Excel files per day.
Please come back tomorrow to download 5 more.
| Team Tasks | ||
|---|---|---|
| Pre-Conversion Evaluation | ||
| Run a recon report and make sure all is completed | ||
| Identify QBD version & year | ||
| Check file size limits for QBO | ||
| Verify if multi-currency is in use | ||
| Review inventory method and usage in QBD | ||
| Identify current payroll system (QBD or third-party) | ||
| Review open sales tax liabilities and filing status | ||
| Review use of custom fields (what needs to be rebuilt in QBO) | ||
| Note that attachments will not convert and plan for storage | ||
| Check number of customers, vendors, and items against QBO limits | ||
| Determine whether cleanup is needed before conversion | ||
| Create a New Fresh Company File for QBO | ||
| Create a full QBD backup file and store securely | ||
| Save PDF copies of P&L (YTD and prior year) | ||
| Save PDF copies of Balance Sheet (YTD and prior year) | ||
| Save PDF copy of Trial Balance | ||
| Save A/R Aging Summary and A/P Aging Summary reports | ||
| Save Inventory Valuation Summary (if applicable) | ||
| Export customer, vendor, and item lists to Excel | ||
| Save current-year payroll reports (if applicable) | ||
| Backup & Archive Historical Data | ||
| Create a full QBD backup file and store securely | ||
| Save PDF copies of P&L (YTD and prior year) | ||
| Save PDF copies of Balance Sheet (YTD and prior year) | ||
| Save PDF copy of Trial Balance | ||
| Save A/R Aging Summary and A/P Aging Summary reports | ||
| Save Inventory Valuation Summary (if applicable) | ||
| Export customer, vendor, and item lists to Excel | ||
| Save current-year payroll reports (if applicable) | ||
| Clean Up QBD File Before Conversion | ||
| Write off old or uncollectible A/R balances as needed | ||
| Write off old or incorrect A/P balances as needed | ||
| Clear undeposited funds and match to bank deposits | ||
| Fix negative inventory quantities and cost issues | ||
| Merge or deactivate duplicate customers and vendors | ||
| Verify bank and credit card reconciliations are current | ||
| Confirm loan balances agree to lender statements | ||
| Review and correct opening balances and prior adjustments | ||
| Choose Right Version | ||
| Migrate/Eport Data from Desktop | ||
| Update QuickBooks Desktop to a supported version if needed | ||
| Switch QBD file to single-user mode | ||
| Confirm you are logged in as the Admin user | ||
| Turn off multi-currency if required or document usage | ||
| Use the QBD export tool to export company file to QBO | ||
| Choose correct option for inventory on or off for QBO | ||
| Confirm receipt of Intuit’s email that conversion is complete | ||
| Verify Data After Conversion in QBO | ||
| Run P&L in QBD and QBO for same date range and compare | ||
| Run Balance Sheet in QBD and QBO for same date range and compare | ||
| Run Trial Balance in QBD and QBO and confirm account balances match | ||
| Review A/R Aging in both systems and match customer balances | ||
| Review A/P Aging in both systems and match vendor balances | ||
| Review Inventory Valuation Summary (if applicable) for differences | ||
| Review Sales Tax Liability report and match balances | ||
| Note and investigate any rounding or minor discrepancies | ||
| Configure QBO Settings and Features | ||
| Turn on and connect bank and credit card feeds in QBO | ||
| Set up bank rules for common vendors and transactions | ||
| Add users and set appropriate permission levels | ||
| Review and adjust Chart of Accounts structure as needed | ||
| Reconnect or set up payroll in QBO or connected app | ||
| Reconnect third-party apps and integrations previously used with QBD | ||
| Rebuild any necessary custom fields in QBO | ||
| Customize invoices, estimates, and sales receipt templates | ||
| Set up and verify sales tax settings in QBO | ||
| Review and Adjust Inventory in QBO (If Applicable) | ||
| Confirm item quantities in QBO match physical and QBD records | ||
| Confirm item valuations and note any significant differences | ||
| Identify and correct any items that did not convert properly | ||
| Rebuild or manually re-enter assembly items if needed | ||
| Post inventory adjustments in QBO as needed (FIFO basis going forward) | ||
| Finalize Reconciliations and Go-Live | ||
| Reconcile bank accounts in QBO through conversion date | ||
| Reconcile credit card accounts in QBO through conversion date | ||
| Validate all loan balances and other long-term liabilities in QBO | ||
| Confirm retained earnings and opening balances are accurate | ||
| Check for and remove any duplicate transactions from bank feeds | ||
| Update internal procedures and workflow documentation for QBO use | ||
| Client Training and Handoff | ||
| Provide overview training on QBO navigation and layout | ||
| Explain key differences between QBD and QBO workflows | ||
| Train client on using bank feeds and categorizing transactions | ||
| Train client on creating invoices, bills, and receiving payments | ||
| Provide written cheat sheets or quick reference guides | ||
| Schedule a 30-day follow-up to review questions and issues | ||