Your CSV template for bulk payments will vary depending on your configuration and the accounting software that you have integrated with Routable.
🎗 Note: This feature currently only works with Xero and QuickBooks Online integrations, or accounts with no integrations. Compatibility with our Oracle NetSuite integration is planned for a future release.
Downloading your template
To download your unique CSV template for your account, click New > Bulk upload in the top of the left navigation on your Routable dashboard.
On the next screen, there will be a button available to download your CSV template.
After downloading the template file, you may Cancel out of this screen if you need time to build your bulk upload CSV file before proceeding.
Preparing your CSV file for upload
We have a sample CSV file showing dummy data for the different accounting software integrations available for you to view here.
Your CSV template and the available fields will be different depending on the type of accounting software you have integrated with Routable. Use the links below to jump to the section that is relevant for your account:
No accounting software
For Routable accounts with no accounting software integrated, below is a sample of the fields that will be available in your CSV payables template.
📁 View Sample File With Dummy Data (No Integration)
(*denotes a required field)
Field | Type | Example |
ID* | Text | ACME20210721 |
Vendor name* | Text | Acme Corp. |
Vendor contacts* | Email address | |
Vendor read-only contacts | Email address | |
Message | Text | Custom message goes here. |
Unique ID | Text | |
Due date | Date (YYYY-MM-DD) | 2021-12-16 |
Issued date | Date (YYYY-MM-DD) | 2021-12-16 |
Bill No.* | Text | |
Reference* | Text | 1955 Hill Valley Rd. |
Line item description* | Text | |
Line item quantity* | Number | 2 |
Line item price* | Amount | 199.99 |
Line item amount* | Amount | 199.99 |
Line item type* | Text | |
Total amount* | Amount | 199.99 |
Payment from* | Routable bank account ID (Standard ACH, Expedited ACH) or Routable balance ID (NextDay, SameDay) | c87dc298-c61c-46e8-878f-11fa68496d64 |
Payment method* | Text | ACH, Check, or ACH,Check |
Delivery option* | Text | Expedited ACH, SameDay ACH, USPS First-Class Check |
Schedule send on date | Date (YYYY-MM-DD) | 2021-12-16 |
QuickBooks Online
For Routable accounts integrated with QuickBooks Online, below is a sample of the fields available in your CSV payables template.
🎗 Please note that the actual fields in your template will be based on the configuration in your QuickBooks Online account.
📁 View Sample File With Dummy Data (QBO Integration)
(*denotes a required field)
Field | Type | Example |
ID* | Text | ACME20210721 |
Vendor name* | Text | Acme Corp. |
Vendor contacts* | Email address | |
Vendor read-only contacts | Email address | |
Message | Text | Custom message goes here. |
Bill No.* | Text | INV-12345 |
Unique ID | Text | |
Memo | Text | 1955 Hill Valley Rd. |
Due date | Date (YYYY-MM-DD) | 2021-12-16 |
Issued date | Date (YYYY-MM-DD) | 2021-12-16 |
Line item type* | Text | |
Line item name* | Text | |
Line item price* | Amount | 199.99 |
Line item quantity* | Number | 2 |
Line item amount* | Text | |
Total amount* | Amount | 199.99 |
Payment from* | Routable bank account ID (Standard ACH, Expedited ACH) or Routable balance ID (NextDay, SameDay) | g87dc298-c61c-46e8-878f-11fa68496d33 |
Payment method* | Text | ACH, Check, or ACH&Check |
Delivery option* | Text | Expedited ACH, SameDay ACH, USPS First-Class Check |
Schedule send on date | Date (YYYY-MM-DD) | 2021-12-16 |
Xero
For Routable accounts integrated with Xero, below is a sample of the fields available in your CSV payables template.
🎗 Please note that the actual fields in your template will be based on the configuration in your Xero account.
📁 View Sample File With Dummy Data (Xero Integration)
(*denotes a required field)
Field | Type | Example |
ID* | Text | ACME20210721 |
Vendor name* | Text | Acme Corp. |
Vendor contacts* | Email address | |
Vendor read-only contacts | Email address | |
Message | Text | Custom message goes here. |
Unique ID | Text | INV-12345 |
Due date | Date (YYYY-MM-DD) | 2021-12-16 |
Issued date | Date (YYYY-MM-DD) | 2021-12-16 |
Bill No.* | Text | INV-12345 |
Reference* | Text | 1955 Hill Valley Rd. |
Amounts are* | exclusive, inclusive, none | inclusive |
Line item name* | Text | |
Line item description* | Text | |
Line item quantity* | Number | 2 |
Line item account* | Text | |
Line item tax* | ||
Line item amount* | Amount | 199.99 |
Memo | Text | Custom memo goes here. |
Total amount* | Amount | 199.99 |
Payment from* | Routable bank account ID (Standard ACH, Expedited ACH) or Routable balance ID (NextDay, SameDay) | g87dc298-c61c-46e8-878f-11fa68496d33 |
Payment method* | Text | ACH, Check, or ACH&Check |
Delivery option* | Text | Expedited ACH, SameDay ACH, USPS First-Class Check |
Schedule send on date | Date (YYYY-MM-DD) | 2021-12-16 |
How Multiple Line Items Work
When including multiple line items for your payables, you will need to duplicate all payable-level information for each line item. Meaning all of the fields that don’t have “Line item” in the name will contain the same information so that our system knows each of the line items are related to a single payable.
You will also need to ensure that all of the amounts for the payable (including Line item amount and Total amount) are calculated following the rules configured in your accounting software.
📁 View Sample File With Multiple Line Items (QBO Integration)
Using a QBO-integrated account as an example, multiple line items would look like:
Line item type* | Line item name* | Line item description | Line item price* | Line item quantity | Line item amount* | Total amount* |
Category | Advertising | Advertising expense | 500 | 500 | 450 | |
Category | Bank charges | Bank charges | -50 | -50 | 450 |
📚 Read more about: