In Routable, you have the option to export either your payable history or your receivable history and download it as a .CSV file.

Exporting Payables to .CSV

To export a list of your payables to a .CSV file, first navigate to the Payables section of your dashboard by selecting the list of payables that you want to view:

  • All

  • Ready to send

  • Unpaid bills

  • Pending vendor action

  • Needs approval

  • Scheduled

When you are viewing a list of payables in your dashboard, there will be a button near the top of the page that says Export to CSV. Clicking this button will initiate your .CSV export.

Exporting Filtered, Sorted, and Selected Rows

When filters, sorting, and/or when rows have been selected in Routable, CSV Export will take that into account:

  • When rows are selected, only those rows are exported to CSV

  • When rows are sorted, Export to CSV will export the list of items with the sort applied

  • When filters are applied, Export to CSV will export the list of items with applied filters

  • CSV Export will include all pages if there are multiple pages

Exporting more than 1000 records

If you have 1000 items or fewer in the payable list, a .ZIP file will download in your browser as soon as you click the Export to CSV button.

However, if you have more than 1000 items in your payables list, you will be emailed a link to download the file as soon as it is ready, as this will take a bit more time to process.

Your CSV file downloads as a .ZIP file, and will include:

  • Payables-date.CSV - The CSV file itself

  • Export record and applied filters.txt - A text file that includes the user name, time, date, company name, and details on filters/sorting/checkboxes applied

About the Payables .CSV

Definitions

  • Payor - an entity who pays money to a payee

  • Amount Due - a sum of money necessary to pay a bill in full

  • Amount Paid - a sum of money already paid towards a bill

  • Balance - an amount still owed on an invoice after an amount has been paid

  • Currency - the type of money being used in the transaction

  • Due Date - date on which the payee expects to receive payment

  • Status - Showcases the current standing of each transaction

  • Status Date - date on which the status changed

  • Payee - entity who receives money from the payor

  • Invoice Date - date of the document's issue

  • Invoice Number - unique number generated by the business issuing an invoice

  • Payable Created Date - date the payable was created by a member of your team

  • Payment Initiated - date the payable was sent (whether scheduled or immediate)

  • Externally Paid - payables that were paid by another method, outside of Routable

  • ACH Returned - ACH transaction that is canceled or returned before completion

  • Funding Account Name - name of the Financial institution funding the transaction

  • Payment Delivery Method - the method of payment such as check or ACH

  • Payment Delivery Option - payment delivery type such as USPS First class check

  • ACH ID or Check Number - a unique 10-digit payment identifier

  • Message on Invoice - custom text included with the invoice

  • Last Updated - most recent date a change related to a payment was made

  • Tags - any tags associated with the entity

  • Unique ID - a unique string used to identify a transaction

  • Support ID - a unique identifier used for Support

  • Vendor ID - a unique string used to identify a Vendor

  • Funding Account ID - a unique string used to identify a Funding Account.

  • Export Type - the type of transaction, such as payable or receivable.

Rows with Multiple Payments

In situations where there are multiple payments initiated, the CSV Export will:

  • Include dates for each Payment Initiated separated by a / (slash)

  • Display info for each Payment Initiated date separated by a / (slash) for the following columns:

    • Funding Account Name

    • Funding Account ID

    • Payment Delivery Method

    • Payment Delivery Option

    • ACH ID or Check Number

🎗️ Note: multiple payments can be initiated, for example, when transactions fail, get canceled, re-attempted, or the payment method is changed.

Understanding the date stamps

Routable date stamps use the ISO 8601 format, an international standard covering the worldwide exchange and communication of date and time related data.

Example: 20220318T122112

  • year / month / day / T / hours / minutes / seconds

  • 2022 / 03 / 18 / Time (12:21:12 pm)

Exporting Receivables to .CSV

Similar to exporting your payables, for receivables you will need to navigate to the Receivables section of your dashboard by selecting the list of receivables that you want to view:

  • All

  • Ready to send

  • Received payments

  • Unpaid invoices

  • Needs approval

  • Scheduled

When you are viewing a list of receivables in your dashboard, there will be a button near the top of the page that says Export to CSV. Clicking this button will initiate your .CSV export.

Exporting Filtered, Sorted, and Selected Rows

When filters, sorting, or when rows have been selected in Routable, CSV Export will take that into account:

  • When rows are selected, only those rows are exported to CSV.

  • When rows are sorted, Export to CSV will export the list of items with the sort applied.

  • When filters are applied, Export to CSV will export the list of items with applied filters

  • CSV Export will include all pages if there are multiple pages

Exporting more than 1000 records.

If you have 1000 items or fewer in the payable list, a .ZIP file will download in your browser as soon as you click the Export to CSV button.

However, if you have more than 1000 items in your payables list, you will be emailed a link to download the file when it's ready, as this may take a bit longer to process.

Your CSV file downloads as a .ZIP file, and will include:

  • Receivables-date.CSV - The CSV file itself

  • Export record and applied filters.txt - A text file that includes the user name, time, date, and company name, and details on filters/sorting/checkboxes that were applied

Did this answer your question?