Articles in this section

Synchronization with NetSuite

Select a category below to reveal information about synchronization between NetSuite and Tipalti.

Vendors
  • 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.
Bills

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 GL 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.

Bill refcode mapping

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 matching.
  • Card transaction lines, including the VAT field, are synced to Tipalti.
Vendor credits for fees

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:

  1. If the payment is a NetNow payment, the payee NetNow fee is added as a line on the fee vendor credit.
  2. 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.
  3. All vendor credit information is synchronized to NetSuite and a bill payment is created.
  4. If there is a payee foreign exchange (FX) fee, it is added to the bill payment.

Example

  • 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 reports

Expense transactions are synchronized as actual Expense Reports to employees, including sync of expense categories, employees, expense attachments, and expense reports (including Tax code and Tax amount information, and VAT for mileage).

Card transactions

Card Transaction attachments (such as receipts) are synchronized to NetSuite. This integration is automatically enabled for payers syncing Card transactions.

Payer fees

Payers can set a default value per payer entity 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.

Payments sync

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
GL account sync

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
Vendor sync

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
Email 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
Bill sync

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
VAT rate  Tax rate for UK and EU
Vendor credit sync

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

NetSuite and Tipalti Procurement

To set up NetSuite with Tipalti Procurement, go to Integrate Tipalti Procurement with NetSuite.

For details on sync directions and mapping fields between NetSuite and Tipalti Procurement, go to Mapping Tipalti Procurement with NetSuite.