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
The Cash Application module needs to be enabled for your Tesorio account first. Please contact your CSM to request it.
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
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 “Group” permissions to users have access to the Cash App module. See details here
Begin applying and posting payments in Tesorio!
How Tesorio Connect Cash App Works
The bank transaction import, Auto-Matching and payment posting works the same regardless of what ERP the user is on. For more information on Recommended Matches & Auto-Match, please read this article.
Tesorio Connect Cash Application steps
In Tesorio:
Post your matched cash application transactions
You can make changed to payments in POSTED status until the file is exported
Export the Pending Payments file (currently only manual export is supported)
Once the file is exported, the payments status changes to POSTING and the payments are locked for edits
In you ERP:
Import the Tesorio Pending Payments file
customer payments and allocations will now be created in our ERP
The customer payments will then be picked up in your Payment Receipts file by your next scheduled run of outbound files to Tesorio
To link and close (switch status to Posted) the Unposted Payment in Tesorio, the Tesorio created customer payments need to have the Tesorio Payment ID in the Payment Receipts file
The invoice allocations will be picked up in the Receipts Applications file and reflected in Tesorio during your next file import
no changes required to this file
The round trip to Tesorio:
On your next Payment Receipts file import into Tesorio, the customer payments with the Tesorio Payment ID:
will be reflected in the Customer Payments workspace
The payments in Posting status in the Unposted Payments Workspace will be matched and changed to Posted - their terminal state
The Tesorio Pending Payments File
Once you have completed your cash application in Tesorio, navigate to Actions -> Export Pending Payments.
Import the csv file into your system.
The file format and fields is standard and cannot be modified before export.
Here is a sample csv file - tesorio_customer_payments_2024-04-12T233101.csv
You can use this file to test the mapping and import into your ERP.
Pending Payments File Field Mapping
See this document for the description of each field - tesorio_pending_payments_file_mapping.xlsx
If a payment was applied to more than one invoice, each invoice will be a separate line on the file
Partially applied payments - if you cannot apply the whole payment to invoices, we suggest you leave it in Incomplete or Ready status, so it is not picked up by the exported file. Another option is to split the payment post the amount you can allocate to invoices
💡Once a Posted payment is exported, it can no longer be edited to apply the remaining amount