This document highlights the data needed from Payments and Payment Lines when integrating data in Tesorio via Tesorio Connect
Payments and Payment Lines are required data files in Tesorio, allowing you and your team to track cash received and clear invoices from payments.
Tesorio requires that these files are received in the following order
Payments: saves a payment receipt record
Payment Lines: the cash application record. This file associates payment receipt records to Invoice(s) in Tesorio
💲Payments
Use the Payments file for customer payment receipts to reflect your cash received in Tesorio.
Tesorio needs to receive this file FIRST to have a record of the payment receipt. Tesorio sets the values of the applied and unapplied customer payments as received on this file.
The file must include the total amount of the payment. Either the applied and/or the unapplied amounts can be included. If the file includes only one, Tesorio will calculate the other.
Example
You have received a payment from a customer.
You have the total amount and the applied amount, and these are provided to Tesorio. Tesorio will then calculate the unapplied amount.
Example payment file:
Payment ID | Customer ID | Total Amount | Applied Amount | Currency | Transaction Date | Status |
PAY00000371 | Company567ABCXYZ | 14.04 | 0 | GBP | 1/31/2022 | Pending |
Example payment reflected in Tesorio:
📍Payment Lines
Use the Payment Lines file to associate a payment with an invoice. This file is required to display payment receipts received in the Payment file under the invoice associated with the payment.
💡 Important: If this file is not received, the payment receipts received in the Payment file are NOT associated with an invoice
Tesorio needs to receive this file AFTER the Payment file.
Example of payment receipt reflected in Tesorio:
Key Considerations
The updated invoice balance after payments are received needs to be sent to Tesorio with the Invoice file, Tesorio does not deduct payments from the Invoice amount
Tesorio will reflect the status of the payment received in the Payments file. When the payment status changes, send an updated Payment file with updated amounts and statuses
Payment and Payment Line files do NOT close the payment receipts or invoices, Tesorio needs to receive updated Payment and Invoice files to reflect updated information that matches your ERP
Payment Drawer
Open the payment drawer by clicking on the three dots on the right hand side of the payment line. This allows you to add notes and send email, add payment info, match invoices, and attach supporting docs.
Attach Supporting Docs
Supporting documentation can be attached to a payment to aid with remittance and audit. Multiple file formats are supported:
Supported file formats: PDF, Excel, CSV, Doc, Txt
Multiple documents can be associated with a single payment
Unused documents can be deleted.
