Import vendors & chart of accounts from Thomson Reuters CBS

Key CashFlow℠ allows the option to import data from Thomson Reuters.

Chart of Accounts

  1. In the Thomson Reuters CBS file, select the Checkwriter tab
  2. Select Reports
  3. Select Chart of Accounts and select Options
  4. Include all accounts
  5. Mark for single spacing
  6. Select OK
  7. Select Print Preview
  8. Once the preview of the list of accounts appears, select the Export option, the small envelope with a red arrow
  9. Once the Export screen appears, choose comma-separated values (CSV) as the format and Disk File as the Destination
  10. Select OK
  11. Confirm the file name to save the file
  12. Open the file in Excel
  13. Delete all columns except for account number, account description, and account type

Vendors

  1. Begin with the same steps as above
  2. At Step 3, choose the Label option and preview
    • Vendors will be printed out like labels
  3. Use the export option for the labels
    • Again, there will be extra columns in the export file that will need to be deleted to narrow the information needed

Things to know

  • The phone number doesn't come over using this format, but we don't recommend using a different format for Vendor information, because too much information is sent and the output file is very convoluted and there's no easy way to clean it up.