Data Migration & Importing Data Flashcards

When importing journal entries into QuickBooks Online from a CSV file, what groups several lines into the same journal entry?

Answer: A shared Journal No. on each line

Lines with the same journal number and date are combined into one journal entry.

An imported journal entry fails validation in QuickBooks Online. What is the most likely cause?

Answer: Total debits don't equal total credits

Every journal entry must balance, so an entry whose debits and credits differ is rejected.

Which fields are needed to import a chart of accounts into QuickBooks Online?

Answer: Account name, account type and detail type

A chart of accounts import needs the account name and type, and the detail type sets each account's subcategory.

A client keeps customer contacts in Gmail. Besides CSV and Excel files, which other import option does QuickBooks Online offer for customers and vendors?

Answer: Importing contacts from Google (Gmail)

QBO can import customer and vendor contacts directly from Google Gmail as well as from spreadsheet files.

When importing a multi-sheet Excel workbook of products and services into QBO, which data is read?

Answer: Only the first sheet

QBO imports only the first worksheet, so the data has to be on that tab.

During a products and services import, what does QBO do if an imported item name already exists in the list?

Answer: It can update the existing item rather than add a duplicate

The products import flags existing names and lets you overwrite or update those items instead of creating duplicates.

Which QuickBooks Online Advanced feature lets a ProAdvisor build and post multiple transactions, such as journal entries, directly from Excel?

Answer: Spreadsheet Sync

Spreadsheet Sync in QBO Advanced connects Excel to QBO for reporting and bulk posting of records.