The following table explains the fields that are used in Tesorio's Intacct Cash Application integration. Instructions on how to set fields as required are available here.
Tesorio Field | Required? | How it's populated | Intacct Field |
Customer Name | Mandatory | Suggested if Tesorio's matching algorithm finds a candidate. Recommended match must be accepted or a customer name manually set by the user. | Customer Name |
Payment # | Optional | If not set by the user it will be blank | Document or check no. |
Payment Amount | Mandatory | Populated automatically from the bank transaction record. Can be updated as needed. | Payment Amount |
Translated Amount | Mandatory | For multi-currency transactions, this is the amount in the CCY of the invoice. See more here | Txn Payment Amount |
Currency | Mandatory | Populated automatically from the bank transaction record | Payment CCY |
Applied Amount | Calculated | This field is calculated as the amount of the payment that is applied to an invoice.
| Amount Applied
Txn amount applied for multi-currency transactions |
Rate | Not applicable |
|
|
Unapplied Amount | Calculated | This field is calculated as the payment amount - applied amount | Not displayed |
Department | Not applicable | Not Applicable |
|
Location | Mandatory for partial payment applications and multicurrency transactions | List of entities from Intacct | Posts to the entity selected |
Invoices | Calculated | The invoices this payment was applied to on the 'Applied Invoices' tab | Applied To |
Status | Calculated | Payments in a 'Posted' status in Tesorio have been synced to Intacct. All other payments exist only in Tesorio. For more on statuses, read here. | N/A |
Account Type | Mandatory | Select between Bank account or Undeposited Funds | Account Type |
GL Account* | Mandatory | Similar to Intacct, you can select Undeposited or Bank account type. It is populated automatically according to your configurations for default GL Account. For FCC it is set-up for each subsidiary in Administration > Subsidiaries >Portal Settings>Payment Methods and Features > Sync FCC payments to ERP | Account ID |
Payment Date | Mandatory | Populated automatically from the bank transaction record. This is the date your bank recorded the transaction | Payment date |
Payment Method | Mandatory | Populated with Payment Method Mapping Rules. Can be updated as needed. Your list of payment methods from Intacct is available | Payment Method |
Memo | Optional | For bank transactions - it is the memo as received from your bank. For FCC payments Tesorio will insert a unique id for the payment + the default memo line if configured. | Memo |
Payment Tags | Optional |
| N/A - Tesorio only field |
Customer Tags | Optional |
| N/A - Tesorio only field |
Notes | Optional |
| N/A - Tesorio only field |
*GL Account Note: If the Undeposited GL account you selected is associated with a checking or a savings bank accounts, you cannot use it to record payments. This is a Sage Intacct rule. You will receive an error in the Tesorio sync status report when syncing payments to Sage Intacct. The error message from Sage Intacct in the error report will be something like this:
Tesorio sync status report:
Splitting Customer Payments
You can split a customer payment and apply it to invoices belonging to other customers.
First select the invoice and amount you need to apply a portion to
Next step will be to search for invoices belonging to other customers to apply that payment to.
Select All Customers from the dropdown on the Applied Invoices tab.
Once you select an invoice belonging to another customer, a new payment form will open. Complete the information and click Create
Post the payment
Select the invoice you would like to apply this payment to and it will open a new payment form with the customer populated. Check the details and Create.
The original payment balance will adjust.
New payment created
