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
Once the file is exported, the payments status changes to POSTING and the payments are locked for edits
You can do a manual export
Or you can schedule an export (currently only an email destination is available, SFTP not available yet)
The exported file will have unique Tesorio Payment IDs for each payment. These IDs need to be saved in your ERP and included in the Outbound customer Payment file to Tesorio
In your 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 on 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 with the same Payment ID
that means that one payment may be recorded as multiple payments in your system. If this is not desired, you can use the Payment ID on the file to create one payment in your system (each system is different and this may not be possible)
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