Synchronization
Select a category below to reveal information about synchronization between NetSuite and Tipalti.
- Payee payment terms sync bidirectionally (and payer payment terms sync from NetSuite to Tipalti).
- Inactive vendors in NetSuite are marked as suspended in Tipalti and vice versa.
- Vendors that are deleted in NetSuite are closed in Tipalti.
Tipalti to NetSuite
Bills in the following statuses are synchronized automatically from Tipalti to NetSuite:
- Scheduled for payment
- Submitted for payment
- Paid
- Partially paid
Payers can choose to sync bills from Tipalti to NetSuite before or after bill approval. Syncing before approval syncs bills in "Pending approval" status, which allows payers to see their bills earlier in the ERP.
Currently, syncing bills before approval is not available for payers using the PO Matching feature.
When a synchronized bill is "deleted" or "disputed", it is removed from NetSuite. If the bill is "un-deleted" or "undisputed", it is re-created in NetSuite.
Bills paid manually
The GLA general ledger (GL) is used for recording transactions related to business assets, liabilities, equity, revenue and expenses. account type (Bank/ Credit card) and transaction date for bills marked as paid manually are synced to the payer's ERP under the relevant bill payment.
Bills marked as prepayment
You can mark a bill for prepayment using Tipalti's prepayment feature, which represents a superior alternative to NetSuite's prepayment module (this feature replaces the need to use NetSuite's prepayment module). Refer to Prepayments for PO-backed bills for details.
Bill refcode
You can map the bill refCode to a Free Text custom field in NetSuite. this value is useful for tracking and reconciliation purposes in NetSuite.
NetSuite to Tipalti
- Sync of approved bills. After sync further updates should be done in Tipalti.
- PO lines marked as "Closed" in the ERP are synced to Tipalti and will not be available for PO matchingThe process of matching goods and services from purchase orders to invoices (2-way matching), and receipts (3-way matching).
A vendor credit is created for a payee's transaction fee and is linked to the payee's bill. When the payment is submitted to Tipalti, both vendor credit and bill are synced to NetSuite.
When the payment is paid:
- If the payment is a NetNow payment, the payee NetNow fee is added as a line on the fee vendor credit.
- If the payee's payment is subject to withholding, a different vendor credit is created for the withholding amount and is linked to the bill.
- All vendor credit information is synchronized to NetSuite and a bill payment is created.
- If there is a payee foreign exchange (FXForeign exchange) fee, it is added to the bill payment.
Bill = $1000
Vendor credit 1:
Payee transaction fee = $3
Payee NetNow fee = $2
Vendor credit 2: Withholding amount = $4
Payee FX fee = $1
Net amount (received by payee) = $990
Bill payment = Net amount + Payee NetNow fee + Payee FX fee = $993
Expense transactions are synchronized as actual Expense Reports to employees, including sync of expense categories, employees, expense attachments, and expense reports (including Tax codeA code for the type of tax applied to a bill line (e.g., VAT-UK) and Tax amount information, and VAT for mileage).
Card Transaction attachments (such as receipts) are synchronized to NetSuite. This integration is automatically enabled for payers syncing Card transactions.
Payers can set a default value per payer entityAn entity can be a subsidiary, division, business unit, brand, etc. of your organization. Entities can have similar or different AP processes and workflows. via Swagger (phase 1- configured by Tipalti engineering support team) instead of setting these values at a payer level.
Standard integration
Several fields are mapped automatically in the standard integration and are not available for custom mapping. Select a category below to reveal the mapped fields.
All payments in Tipalti that were added, updated or deleted since the last synchronization are collected and synchronized to NetSuite.
Mapped fields
Tipalti |
NETSUITE |
---|---|
Tipalti payee ID (idap) | VendorRef by Payee ID |
Total amount | TotalAmt |
Submitted date | TxnDate |
RefCode | External ID (custom field) |
Txn refcode | Doc. No.* |
Currency | CurrencyRef |
PaymentAmount (displays under Related Bills) | Line |
RefCode (displays under Related Bills) | Line |
Account (Virtual Account ID) | BankAccountRef |
* Labeled "Ref. No." in the NetSuite user interface |
All GL accounts in NetSuite that were added, updated or deleted since the last synchronization are collected and synchronized to Tipalti.
Mapped fields
Tipalti |
NETSUITE |
---|---|
Number | AcctNum |
Name | Name |
Description | Description |
External ID | ID |
All vendors that were "added", "updated" or "deleted" since the last synchronization are collected and synchronized to NetSuite, Tipalti, or both systems.
Mapped fields
Tipalti |
NETSUITE |
---|---|
PrimaryEmailAddr.Address | |
Company name | CompanyName |
First name | Givenname |
Middle name | Middlename |
Last name | FamilyName |
Street 1 | BillAddr.Line1 |
Street 2 | BillAddr.Line2 |
City | BillAddr.City |
State | BillAddr.CountrySubDivisionCode |
Zip | BillAddr.PostalCode |
All bills that were "added", "updated" or "deleted" since the last synchronization are collected and synchronized from Tipalti to NetSuite.
Mapped fields
Tipalti |
NETSUITE |
---|---|
Tipalti payee ID (idap) | VendorRef by Payee ID |
Due date | DueDate (if it exists) |
Invoice date | TxnDate |
Invoice number | DocNumber |
Refcode | ExternalID (custom field) |
Bill line amount | Line [0..n].TaxInclusiveAmt (only Billable / HasBeenBill lines) |
Bill line description | Line [0..n].Description (only Billable / HasBeenBill lines) |
Bill line account | Line [0..n].AccountRef |
All vendor credit records that were "added", "updated" or "deleted" since the last synchronization are collected and synchronized from Tipalti to NetSuite.
- When a vendor credit is applied in Tipalti, a bill payment is created automatically in NetSuite and the vendor credit is linked to it.
- When a vendor credit is applied in NetSuite, it is applied automatically in Tipalti.
Mapped fields
Tipalti |
NETSUITE |
---|---|
Amount | TotalAmt |
Currency | CurrencyRef |
Invoice date | txnDate |
Invoice number | docNumber |
Bill line amount | line |
Bill line description | line.description |