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