QuickBooks Desktop All-In-One For Dummies
QuickBooks Desktop All-In-One For Dummies book cover
Explore Book
Buy NowSubscribe on Perlego
QuickBooks Desktop All-In-One For Dummies
QuickBooks Desktop All-In-One For Dummies book coverExplore Book
Buy NowSubscribe on Perlego

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:

To Press
Open the Estimate page Ctrl+Alt+E
Open the Invoice page Ctrl+Alt+I
Open the Receive Payment page Ctrl+Alt+R
Open the Expense page Ctrl+Alt+X
Open the Check page Ctrl+Alt+W
Display the Lists page Ctrl+Alt+L
Display the Customers page Ctrl+Alt+C
Display the Chart of Accounts page Ctrl+Alt+A
Display the Vendors page Ctrl+Alt+V
Search QuickBooks Ctrl+Alt+F
Focus the sidebar menu Ctrl+Alt+D
Display keyboard shortcuts Ctrl+Alt+/
Display Help Ctrl+Alt+H

 Use the following keyboard shortcuts while working in a transaction window:

To Press
Save the transaction and start a new one Ctrl+Alt+S
Save the transaction and close the transaction window Ctrl+Alt+D
Save and send the transaction Ctrl+Alt+M
Print the transaction Ctrl+Alt+P
Close the transaction window. (If you’ve made changes, a message asks you to confirm that you want to close the window without saving your changes.) Ctrl+Alt+X or Ctrl+Alt+C or Esc

 

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.  

Accounting software conversions always entail some amount of manual effort. There’s also a learning curve during which you acclimate to the new software. Plan to give yourself three months for things to smooth out. The best practice is to run both the old software and the new software concurrently for about 90 days, a process referred to as running the programs in parallel. This ensures that you can easily continue with the old software if you discover an unexpected dealbreaker in the new program you’re trying out.

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.  

Review your recurring transactions after conversion. Transaction details may transfer, but their schedules don’t, so transactions won’t post until you establish new schedules.

  • 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.

QuickBooks Pro and Premier use average costing for inventory valuation, while QuickBooks Enterprise supports average costing or FIFO. If you’re converting from average costing to FIFO in the United States, consult your tax advisor about whether you need to file IRS Form 3115, Application for Change in Accounting Method. (https://irs.gov/forms-pubs/about-form-3115).

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 is from the book: 

About the book author:

David H. Ringstrom, CPA, is president of Accounting Advisors, Inc., a spreadsheet and database consulting firm. He is a sought-after speaker on the subject of Microsoft Excel, QuickBooks, and QuickBooks Online. He is also the co-author of the previous edition of QuickBooks Online For Dummies and two previous accounting reference books.

got more questions?

Frequently Asked Questions

No items found.