Importing: Vendors & Chart of Accounts from Thomson Reuters CBS

Bill.com allows the option to import data from Thomson Reuters.

Chart of Accounts

  1. In the Thomson Reuters CBS file, click the Checkwriter tab
  2. Click Reports
  3. Mark the Chart of Accounts and click Options
  4. Include all accounts
  5. Mark for single spacing
  6. Click OK
  7. Click Print Preview
  8. Once the preview of the list of accounts appears, click 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. Click OK
  11. Confirm the file name to save the file
  12. Open the file in Excel
  13. Retain the columns for account number, account description, and account type
    • Delete the other columns

Vendors

  1. Begin with the same steps as above
  2. At Step 3, choose the Label option and preview
    • Vendors will 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 does not come over using this format, but when using a different format of the Vendor information, too much information is sent and the output file is very convoluted and there is no easy way to clean it up.