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.

(*denotes a required field)

Field

Type

Example

ID*

Text

ACME20210721

Vendor name*

Text

Acme Corp.

Vendor contacts*

Email address

chuck@acme.com

Vendor read-only contacts

Email address

chuck@acme.com

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

Schedule send on date

Date (YYYY-MM-DD)

2021-12-16

πŸ“ View Sample File With Dummy Data (No Integration)

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.

(*denotes a required field)

Field

Type

Example

ID*

Text

ACME20210721

Vendor name*

Text

Acme Corp.

Vendor contacts*

Email address

chuck@acme.com

Vendor read-only contacts

Email address

chuck@acme.com

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

Schedule send on date

Date (YYYY-MM-DD)

2021-12-16

πŸ“ View Sample File With Dummy Data (QBO Integration)

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.

(*denotes a required field)

Field

Type

Example

ID*

Text

ACME20210721

Vendor name*

Text

Acme Corp.

Vendor contacts*

Email address

chuck@acme.com

Vendor read-only contacts

Email address

chuck@acme.com

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

Schedule send on date

Date (YYYY-MM-DD)

2021-12-16

πŸ“ View Sample File With Dummy Data (Xero Integration)

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.

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

πŸ“ View Sample File With Multiple Line Items (QBO Integration)

Did this answer your question?