Tesorio offers a file-based Cash Application designed for Tesorio Connect users, enabling automated matching and recording of customer payments.
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. We have a test file for you to upload into your ERP, but before you do, you'll need to do a couple things first.
Before You Upload the Test File
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
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
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
Test the Payment File in your ERP
Use this sample csv file to test the field mapping and import into your ERP: tesorio_customer_payments_2024-04-12T233101.csv
Field Descriptions in the Payment File
Name | Description | Required? |
Payment ID | this is the Tesorio drafted payment id that you will need to add in your ERP to be recorded during the file import and included in your Payment Receipts outbound file to Tesorio | Y |
Customer Name | The business name of your customer | Y |
Customer ID | this is the unique ID you send in your Customers file | Y |
Payment Amount | payment amount from the posted payment | Y |
Currency | Payment currency | N |
Rate | rate, if used | N |
Applied Amount | the amount applied to invoices | Y |
Unapplied Amount | Amount left unapplied on the payment (You cannot further edit this payment in Tesorio. We recommend you split this payment and apply in full, or do not post until the whole payment can be applied) | Y |
Check # | Optional field that you can populate | N |
Status | Optional field that you can populate | N |
Payment Date | The date your bank reports the transaction as posted | Y |
Memo | Bank transaction memo as received from the bank. Can be modified before posting | Y |
Invoice Number | If the payment was allocated to more than one invoice, there will be multiple lines - one for each invoice | N |
Invoice ID | this is the unique ID you send in your invoice file | Y |
Amount Applied to Invoice | Amount applied to this invoice | Y |
Payment Method | Your set payment method on the payment, or the default for this bank account | N |
Department
Location
Transaction Class
GL Account
Payment Method ID
Department ID
Location ID
Transaction Class ID
GL Account ID | These are optional fields that you can populate depending on whether they are required in your ERP. You will work with your CSM on the required set-up | N |
You can also find this information in this sample CSV file: tesorio_pending_payments_file_mapping.xlsx
Things to Know During Testing
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?
Currently, the Tesorio Payment Application file cannot be configured to automatically load into 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
Final Setup Steps
Connect your bank accounts in Tesorio. See details here.
Update your Tesorio admin settings to identify payment-related fields
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!