Synchronization with NetSuite
Select a category below to reveal information about synchronization between NetSuite and Zipalti.
- Payee payment terms sync bidirectionally (and payer payment terms sync from NetSuite to Zipalti).
- Inactive vendors in NetSuite are marked as suspended in Zipalti and vice versa.
- Vendors that are deleted in NetSuite are closed in Zipalti.
Zipalti to NetSuite
Bills in the following statuses are synchronized automatically from Zipalti to NetSuite:
- Scheduled for payment
- Submitted for payment
- Paid
- Partially paid
Payers can choose to sync bills from Zipalti 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 Zipalti'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 Zipalti
- Sync of approved bills. After sync further updates should be done in Zipalti.
- PO lines marked as "Closed" in the ERP are synced to Zipalti 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).
- Card transaction lines, including the VAT field, are synced to Zipalti.
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 Zipalti, 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 = $993Expense 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 Zipalti 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 Zipalti that were added, updated or deleted since the last synchronization are collected and synchronized to NetSuite.
Mapped fields
|
Zipalti |
NETSUITE |
|---|---|
| Zipalti 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 Zipalti.
Mapped fields
|
Zipalti |
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, Zipalti, or both systems.
Mapped fields
|
Zipalti |
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 Zipalti to NetSuite.
Mapped fields
|
Zipalti |
NETSUITE |
|---|---|
| Zipalti 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 |
All vendor credit records that were "added", "updated" or "deleted" since the last synchronization are collected and synchronized from Zipalti to NetSuite.
- When a vendor credit is applied in Zipalti, 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 Zipalti.
Mapped fields
|
Zipalti |
NETSUITE |
|---|---|
| Amount | TotalAmt |
| Currency | CurrencyRef |
| Invoice date | txnDate |
| Invoice number | docNumber |
| Bill line amount | line |
| Bill line description | line.description |
NetSuite and Zipalti Procurement
To set up NetSuite with Zipalti Procurement, go to Integrate Zipalti Procurement with NetSuite.
For details on sync directions and mapping fields between NetSuite and Zipalti Procurement, go to Mapping Zipalti Procurement with NetSuite.
Comments
0 comments
Please sign in to leave a comment.