Data Migration & Importing Data Flashcards

Which file formats can be uploaded manually to a bank or credit card account in QuickBooks Online?

Answer: CSV, QBO, QFX, OFX

Manual bank uploads accept CSV and Web Connect formats such as QBO, QFX and OFX.

Which column layouts does QuickBooks Online accept for a bank transaction CSV upload?

Answer: 3 columns (Date, Description, Amount) or 4 columns (Date, Description, Credit, Debit)

QBO accepts a 3-column layout with one amount column or a 4-column layout with separate credit and debit columns.

After a bank CSV file is uploaded to QuickBooks Online, where do the transactions show up?

Answer: In the For Review tab of the Banking page

Uploaded transactions go to For Review, where they are categorized, matched or excluded before they post.

A client connects a bank feed in QBO after the Desktop conversion has already brought in transactions through the conversion date. What is the best way to avoid duplicates?

Answer: Pick a download start date after the last converted transaction, then match or exclude any overlap

Starting the feed after the converted data and matching or excluding overlaps prevents double-counting.

In a single-amount-column bank CSV import into QuickBooks Online, how are money-out transactions usually shown?

Answer: As negative amounts

With one amount column, deposits are positive and withdrawals are negative; the mapping step can flip the signs if the bank uses the opposite convention.

While mapping a bank CSV file during import, which setting must match the file so QBO reads transaction dates correctly?

Answer: Date format (for example, MM/dd/yyyy)

Choosing the date format that matches the file stops QBO from misreading days and months.

Through a direct bank connection, how far back does QuickBooks Online usually download transactions by default?

Answer: Up to 90 days

Most direct connections pull about 90 days of history; older activity has to be uploaded manually from bank files.