For more information on the document file export, please see the linked article.
If you are planning to utilize the Document File Export to sync data between Corpay One and QuickBooks Desktop, follow these best practices for the smoothest experience.
Details added to Corpay One need to match EXACTLY with how they are entered into QuickBooks desktop. Any variations can result in duplicates.
Table of Contents
Vendor Bulk Upload
Currently, to access this feature, you will need to contact our support team to have them enable it for your account. Once enabled, the Bulk Import Tool will allow you to import vendor details AND payment details!
The support team will provide you with a CSV template which will enable you to easily map critical fields and import them into Corpay One.
To complete the upload:
Complete CSV file with vendor information
On the vendor page go to add vendor and a drop down appears to select by CSV file
Upload CSV file
The mapping screen will appear - make sure each field name is mapped to the correct CSV header name
Import vendors
Create Lists
You can use the Custom List feature to import lists with a CSV file. To ensure your data matches exactly to your QuickBooks desktop:
Export Lists from QuickBooks desktop
Verify the CSV format for import into Corpay One
Ensure that the name of the list MATCHES the table below Comment end
Upload the list using the instructions here
The IIF file format is a specific format for QuickBooks. In order for Corpay One to successfully create the file, Lists must be named in the following format:
Corpay One List Name | QuickBooks Field |
Payment Accounts | Bank Account |
Classes | Class |
Customer | Customer:Job |
Note: The QuickBooks IIF file will automatically check the “Is Billable” field when a customer is associated with a document.
* Supported Lists include: Categories, Payment Accounts, Class, and Customer/Project
Set Required Field Defaults with Workflows
There are some fields that QuickBooks desktop requires for every document. Without them, the import will result in an error.
QuickBooks requires a Category on every document
QuickBooks requires a Payment Account on every Bill
While these fields are not “required” in Corpay One, you will want to set up a workflow to ensure that default values are set for both category and payment account. See here on how to create new workflows.