Skip to main content

How do I export my payables or receivables?

Olivia Millard
Updated

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:

  • Unpaid
  • Paid
  • Failed and issue
  • All
  • Needs approval

When you are viewing a list of payables in your dashboard, click the download button at the upper-right of the page to export to CSV. 

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 in USD -  a sum of money Due or Paid converted to USD
  • 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
  • Scheduled Date - date the payable is scheduled to pay
  • Estimated arrival date - Date the payable is expected to arrive
  • Send Date - date the payable was sent by the user
  • Externally Paid Date -  date used by the user to indicate the payable was paid 
  • 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
  • ACH Returned - ACH transaction that is canceled or returned before completion
  • Externally Paid - payables that were paid by another method, outside of Routable
  • Payment Initiated - The date on which the payment process to the vendor was started, regardless of whether it was scheduled for a future time or sent immediately
  • 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
  • Current approval type - specifies whether all or any of the designated approvers must give their consent
  • Current approvers - this is the current list of individuals whose approval is required
  • Failure Category - high level category of current payment failure 
  • Failure Detail - description of failure status and recommended corrective action
  • Updated date - Date payable last updated

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)

Choosing what columns are visible

Payables

The column picker on the Payables tables gives you more control over the information you export.

  • Choose which columns to show or hide based on what’s most relevant to you
  • Your selections are remembered for each tab you visit during your session

 

 

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:

  • Unpaid
  • Paid
  • Failed and issue
  • All

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 receivables 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 receivables 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

Related articles