This cheat sheet is here to make your life simpler. To make the most of your work in QuickBooks Online, use the handy and time-savings shortcuts and toolbar buttons offered here. Also, find a useful chart that covers QuickBooks Desktop conversions and details on uploading payroll history.
Keyboard shortcuts for QuickBooks Online
Keyboard shortcuts can save time by reducing how often you reach for your mouse. QuickBooks Online now includes more than 50 shortcuts organized around areas such as banking, lists, transaction forms, and reports.
To see the current shortcut list at any time, press Ctrl+Alt+? in Windows or Command+Option+? on a Mac. QuickBooks displays its regularly updated shortcut guide onscreen. Some of the most common shortcuts include:
Use the following keyboard shortcuts while working in a transaction window:
You can also use these shortcuts while entering transactions directly into a register:
- Press Ctrl+Alt+N to create the transaction type shown in the Add drop-down menu.
- Press Tab to move between fields and Ctrl+Alt+S to save the transaction.
- Press Alt+Down Arrow to display a drop-down list, such as Payee, Class, or Location.
Discovering what doesn’t import from QuickBooks Desktop
If you're happily using QuickBooks Online already, you can stop reading here. The remainder of this cheat sheet is for the brave souls still making the journey from QuickBooks Desktop to QuickBooks Online. QuickBooks Desktop may be riding off into the sunset, but plenty of businesses, bookkeepers, and accountants are still converting old company files. The following sections point out some of the more common conversion surprises and limitations to keep in mind during the move.
Most QuickBooks Desktop data can be imported into QuickBooks Online, but the two platforms aren’t identical. Some features work differently, some data requires special handling, and some information doesn’t transfer at all. The following sections highlight the differences most likely to affect your conversion. For additional guidance, see the free Data Conversion Guide created by Daniel DeLong, technical editor of QuickBooks Online For Dummies, at https://www.schoolofbookkeeping.com/quickbooks-conversion.
Most of your information from QuickBooks Desktop migrates seamlessly into QuickBooks Online, but the following table lists what doesn’t import. The article “Learn how features and data move from QuickBooks Desktop to QuickBooks Online” at https://intuit.me/3dUroMi provides additional details.
Most of your information from QuickBooks Desktop migrates to QuickBooks Online, but some information requires additional attention. Here are some differences worth knowing about before you convert:
- Users: You may need to invite QuickBooks Desktop users to the QuickBooks Online company and establish their access rights.
- Reconciliation reports: Reconciled transactions transfer, but previous reconciliation reports remain in QuickBooks Desktop.
- Recurring credit card charges: You may need to cancel existing automatic credit card charges and re-create them as recurring sales receipts.
- Memorized reports: You need to re-create memorized QuickBooks Desktop reports as customized reports in QuickBooks Online.
- Audit trail: Your previous audit trail remains in QuickBooks Desktop; QuickBooks Online begins recording a new audit trail after conversion.
Finding Desktop features that work differently
If you rely on specialized QuickBooks Desktop features, check their QuickBooks Online equivalents before converting:
- To Do notes: QuickBooks Online handles task management differently.
- Job costing: Make sure QuickBooks Online provides the level of job costing you need.
- Sales orders: Available with Plus and Advanced subscriptions.
- Fixed asset tracking: QuickBooks Online includes a fixed asset list but not all Desktop tracking capabilities.
- Estimate to Actual reporting: Available with an Advanced subscription.
You may also find third-party apps that provide functionality you need but can't find in QuickBooks Online.
Looking at list limitations
Most of your list information transfers from QuickBooks Desktop to QuickBooks Online, but some details may require cleanup after conversion. Here are some differences to watch for:
- Chart of accounts: QuickBooks Online adds detail types to accounts. QuickBooks assigns these during conversion, but you may need to review and change them afterward.
- Customers and jobs: Customers transfer, while QuickBooks Desktop jobs become subcustomers in QuickBooks Online.
- Customer details: Basic contact and billing information generally transfers, but information such as customer types, credit limits, job details, and custom fields may not.
- Shipping addresses: Ship-to addresses transfer, but address components may not land in the corresponding City, State, Zip Code, and Country fields.
- Inactive customers: Inactive status may change during conversion, particularly when customers have open balances or unbilled charges.
- Other names: Other Names entries become vendors in QuickBooks Online.
- Recurring transactions: Memorized transactions become recurring transactions, but availability depends on your QuickBooks Online subscription.
- Sales tax: QuickBooks Online creates its own sales tax accounts, and sales tax groups and codes may change or be discarded during conversion.
- Ship Via: Existing Ship Via information remains in transactions, but QuickBooks Online doesn’t maintain a corresponding list.
- Subtotals: Desktop subtotal items become descriptions rather than calculated subtotals.
- Customer, job, and vendor types: Types assigned in Desktop don’t transfer.
- Vendors: Basic vendor information generally transfers, but details such as vendor types, credit limits, custom fields, and inactive status may not.
Exploring payroll conversion
Most QuickBooks Desktop payroll information converts to QuickBooks Online Payroll, but payroll deserves extra attention during a conversion:
- Use the same Intuit login: For best results, use the same Intuit login when converting from QuickBooks Desktop and setting up QuickBooks Online. For specific details, visit https://www.schoolofbookkeeping.com/blog/PayrollPaymentsMigrations.
- Watch for unsupported information: Unsupported pay types, invalid identification numbers, and certain addresses may require manual attention.
- Review unmatched pay types carefully during payroll setup. If you skip a pay type that QuickBooks can't map, you may need to create it manually later.
- Verify year-to-date amounts: QuickBooks attempts to carry over year-to-date payroll amounts, but review the results carefully after conversion.
- Review payroll mappings: Make sure pay types and other payroll elements are mapped correctly before processing payroll.
- Complete payroll setup: Finish the QuickBooks Online Payroll setup process before creating new paychecks.
- Reconnect payroll services: You may need to re-enroll for electronic tax services and reestablish direct-deposit information.
- Time your conversion carefully: If possible, switch payroll at the beginning of a calendar year or quarter. A midyear conversion can require additional payroll history and tax information.
Setting Up Payroll
Keep these points in mind as you complete payroll setup after converting:
- Complete payroll setup: Finish payroll setup and verify your year-to-date payroll amounts before processing new paychecks.
- Use the Payroll Summary report: If you need to enter year-to-date amounts, use the QuickBooks Desktop Payroll Summary report as your source.
- Electronic tax services: Re-enroll for electronic tax payment and filing services in QuickBooks Online.
- Direct deposit: Reestablish your employer and employee bank information if you use direct deposit.
Examining inventory and the items list
Keep these differences in mind if you track inventory in QuickBooks Desktop:
- Inventory method: QuickBooks Online Plus and Advanced use the first in, first out (FIFO) method on an accrual basis. During conversion, you choose a date for QuickBooks to begin recalculating inventory using FIFO.
- Unit of measure: QuickBooks Online doesn’t support unit-of-measure tracking.
Regarding other special cases
Some QuickBooks Desktop information changes form or requires additional attention when you convert to QuickBooks Online. Keep these differences in mind:
- Bills and bill payments: Item receipts become bills, while discounts applied to bills become vendor credits.
- Closing date: Your closing date transfers, but your closing date password doesn’t. Previous closing-date exception history remains in QuickBooks Desktop.
- Custom fields: Custom fields may work differently or require a particular QuickBooks Online subscription, so review them after conversion.
- Discounts: Existing discounts may become customer or vendor credits. QuickBooks Online doesn’t calculate early-payment discounts from terms such as 2% 10, Net 30.
- Documents and attachments: QuickBooks Online can migrate Desktop attachments, but specific requirements apply to the conversion.
- Invoices: Some invoice information changes or doesn’t transfer, including subtotals, customized sales form templates, and certain custom fields.
- Journal entries: Journal entries transfer, but their billable status doesn’t. QuickBooks may also create journal entries for Desktop transactions that don’t have a direct QuickBooks Online equivalent.
- Multicurrency: Some multicurrency transactions may not transfer, and you may encounter rounding differences. Check that QuickBooks Online supports the currencies you use before converting.
- Purchase orders: Closed purchase orders don’t remain linked to their corresponding bills.
- Reimbursable expenses: Desktop reimbursable expenses and unbilled time become billable expenses in QuickBooks Online. Review unbilled charges carefully during conversion.
- Reports: You need to re-create memorized Desktop reports as customized QuickBooks Online reports. Accrual-basis results should generally be comparable after conversion, but cash-basis results can differ.
- Sales forms: Customized QuickBooks Desktop sales form templates need to be re-created in QuickBooks Online.
About This Article
This article can be found in the category:
got more questions?
















