Excel → QBO

Select File:

Account ID:

ⓘThe bank account number or unique ID used in your QBO mapping.

Last 5 of CC:

ⓘUsed by QuickBooks to identify which credit card this statement belongs to. Amex doesnt always use just this number.

Balance:

ⓘThe ledger balance to show in qb bank feeds.

Randomize Blank FITID:

ⓘGenerates a unique ID for transactions missing one to prevent duplicates in QBO.