In QuickBooks,
  • go to Edit / preferences / Accounting (top left),
  • Company preferences (second tab, at the top),
  • You will have the option to "Use Account numbers",
  • If it was not checked already the bookkeeper have to assign numbers to the ones missing,
  • Save.
After that, the account listing report will have numbers or you may have to select them with the customize option and check the accnt# column. (top left)

Then you can export to excel and make sure you save is as a .xls, not .xlsx

Then you'll have to manually assign which one are banks in GEM-CAR
  • Goto : accounting / chart of accounts,
  • Activate the check box,
  • Save,