Tesorio offers a file-based Cash Application designed for Tesorio Connect users, enabling automated matching and recording of customer payments.
The file exports can be seamlessly automated through SFTP, allowing scheduled posting into your ERP system.
Getting Started
We know that each ERP has different requirements. You will work with your CSM to review the Tesorio payments file and test it in your ERP.
Here is a sample csv file - tesorio_customer_payments_2024-04-12T233101.csv
Please use this file to test the field mapping and import into your ERP.
In this document you will find a description of each field - tesorio_pending_payments_file_mapping.xlsx
Some questions to review as you are testing the file:
The file format and headers are standard and cannot be modified before export
Does your system support mapping the file field names to the required field names?
Can your system import the file if it contains more fields than needed?
The payments file will include a unique Payment ID.
You will need to add a field on the Customer Payment record in your system to house the Tesorio Payment ID from the exported file.
Please create a data field on the customer payment record in your ERP and map it to Payment ID to record the id when importing the Tesorio payments file
Then add this id field to your Payment Receipts file (outbound to Tesorio).
this unique Payment ID is used to match the Unposted payment record in Tesorio and the payment it creates in your ERP
Let your CSM know if you require any of these data points to create a customer payment in Tesorio. Your CSM will make the templates available to you in Tesorio to populate and upload.
GL Account
Payment Method
Department
Locations
Class
Connect your bank accounts in Tesorio. See details here.
Update your Tesorio admin settings to identify payment-related fields
Settings and configuration in your ERP:
Complete the necessary configurations and mapping in your ERP to import the Tesorio Payment Application file and successfully record and allocate customer payments
Create and map a field on the customer payment that can store the Tesorio Payment ID from the imported file
Modify your Payment Receipts file (the file you generate from your ERP to Tesorio) to include the Tesorio Payment ID for the payments created via the Tesorio Cash Application process and imported into your ERP
the Payment ID is needed to identify that a payment was successfully created in your system and to close the Tesorio Cash Application payment - see this article on Cash Application statuses
The Tesorio Payment Application file can be configured to automatically load into your ERP (support for this is in the works)
Set-up and schedule your Payment Application file export in Tesorio
Configure your system to pickup and load the Tesorio files automatically
Update your team’s permission group to give users access to the Cash App module. See details here
Begin applying and posting payments in Tesorio!