Skip to main content

Set Up Cash Application for Tesorio Connect

Settings and mapping for Tesorio Connect/file based customers

Updated yesterday

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

Optional

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

N

Customer Name

N

Customer ID

this is the unique ID you send in your Customers file

N

Payment Amount

payment amount from the posted payment

N

Currency

Payment currency

Y

Rate

rate, if used

Y

Applied Amount

the amount applied to invoices

N

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)

N

Check #

Optional field that you can populate

Y

Status

Optional field that you can populate

Y

Payment Date

The date your bank reports the transaction as posted

N

Memo

Bank transaction memo as received from the bank. Can be modified before posting

N

Invoice Number

If the payment was allocated to more than one invoice, there will be multiple lines - one for each invoice

Y

Invoice ID

this is the unique ID you send in your invoice file

N

Amount Applied to Invoice

Amount applied to this invoice

N

Payment Method

Your set payment method on the payment, or the default for this bank account

Y

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

Y

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:

  1. The file format and headers are standard and cannot be modified before export

  2. Does your system support mapping the file field names to the required field names?

  3. Can your system import the file if it contains more fields than needed?

  4. 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!

Did this answer your question?