If you use an accounting system that doesn't sync with Bill.com, use the Import/Export function to transfer information from Bill.com to your accounting system and vice versa.
Your accounting system may require import files to have specific column headers and to have columns in a specific order. Create a Profile to match the requirements of your accounting system. Once created, each time you run an export, the CSV file will be titled and ordered in the format to match the requirements of your accounting system.
- Select Settings
- Select Import/Export under Import/Export
- Select Export for the record to export
- Select Modify next to the Export Profile drop-down menu
- Edit the format of the headers by updating the names and the order of the columns using the sliders to the right of each header
- Enter the file name in the Save As field
- Note: Using the name of an existing Export Profile will overwrite that Profile
- Select Default box to set the Profile as the default
- Select Continue
Things to know
- The default Profile will be selected each time this Export is run until another default is chosen
- To select another Export Profile, select the profile in the drop-down menu and then run the export