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.
- Click the gear icon
- Under Import/Export, click Import/Export
- Click Export for the record to export
- Click 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 cell Note: Using the name of an existing Export Profile will overwrite that Profile
- Click Default box to set Profile as the default
- Click Continue.
Things to know
- The default Profile will automatically be selected each time this Export is run until another default is chosen
- To select another Export Profile, click the drop-down menu and then run the export