Synchronization
Select a category below to see information about synchronization between Intacct and Tipalti.
- Payee payment terms sync bidirectionally (and payer payment terms sync from Intacct to Tipalti).
- Inactive vendors in Intacct are marked as suspended in Tipalti and vice versa.
- Vendors that are deleted in Intacct are closed in Tipalti.
Tipalti to Intacct
Bills in the following statuses are synced automatically from Tipalti to Intacct:
- Scheduled for payment
- Submitted for payment
- Paid
- Partially paid
Payers can choose to sync bills from Tipalti to Intacct 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 Intacct. If the bill is "un-deleted" or "undisputed", it is re-created in Intacct.
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.
Intacct to Tipalti
- GL accounts linked to multiple entities sync from Intacct to Tipalti.
- Units of measurement, which are used for PO matchingThe process of matching goods and services from purchase orders to invoices (2-way matching), and receipts (3-way matching), sync from Intacct to Tipalti. Unit values must be unique in Intacct for sync to be successful.
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 Intacct.
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 Intacct 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
GL accounts linked to multiple entities sync from Intacct to Tipalti.
- In Intacct, POs and receipts (PO receivers) can be defined in 3 ways:
- Leave Transaction Open - Partially matched transaction is kept open until completed.
- Close Original and Create Back Order - Once the transaction has been partially matched, it is closed, and a new transaction is created with the remaining quantity.
- Close transaction - Partially matched transaction is closed.
- POs and receipts (PO receivers) are synced to Tipalti and matched to the invoice.
- Once matching is complete, a "Vendor invoice" is synced back to Intacct and a linked bill is created automatically to represent the transaction.
In Intacct, Amortization class allows you to categorize and manage the amortization of expenses over a specific period.
-
Amortization class is synced to Tipalti as two fields:
Start Amortization date is synced as a custom field of type Date.
Amortization classes is synced as a custom field of type List.
Standard integration
Several fields are mapped automatically in the standard integration and are not available for custom mapping. Select a category below to see the mapped fields.
All payments in Tipalti that were added, updated or deleted since the last sync are collected and synced to Intacct.
Mapped fields
Tipalti |
Intacct |
---|---|
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 Intacct user interface |
All GL accounts in Intacct that were added, updated or deleted since the last sync are collected and synced to Tipalti.
Mapped fields
Tipalti |
Intacct |
---|---|
Number | AcctNum |
Name | Name |
Description | Description |
External ID | ID |
All vendors that were added, updated or deleted since the last sync are collected and synced to Intacct, Tipalti, or both systems.
Mapped fields
Tipalti |
Intacct |
---|---|
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 |
Phone | Mobile |
All bills that were added, updated or deleted since the last sync are collected and synced from Tipalti to Intacct.
Mapped fields
Tipalti |
Intacct |
---|---|
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 sync are collected and synced from Tipalti to Intacct.
- When a vendor credit is applied in Tipalti, a bill payment is created automatically in Intacct and the vendor credit is linked to it.
- When a vendor credit is applied in Intacct, it is applied automatically in Tipalti.
Mapped fields
Tipalti |
Intacct |
---|---|
Amount | TotalAmt |
Currency | CurrencyRef |
Invoice date | txnDate |
Invoice number | docNumber |
Bill line amount | line |
Bill line description | line.description |
All purchase orders in Intacct that were added, updated or deleted since the last sync are collected and synced to Tipalti.
Mapped fields
Tipalti |
common |
Intacct |
---|---|---|
ExternalId | Id | RECORDNO |
PurchaseOrderNumber | PurchaseOrderNumber | DOCID |
Status | Status* | STATE |
Memo | Memo | MESSAGE |
PurchaseOrderDate | CreatedDate | WHENCREATED |
Idap | VendorID | CUSTVENDID |
PurchaseOrderLines. PurchaseOrderLine[].Item |
PurchaseOrderLines[]. Item^ |
PODOCUMENTENTRIES. podocumententry[].ITEMID |
PurchaseOrderLines. PurchaseOrderLine[].Quantity |
PurchaseOrderLines[]. Quantity |
PODOCUMENTENTRIES. podocumententry[].UIQTY |
PurchaseOrderLines. PurchaseOrderLine[].Units |
PurchaseOrderLines[]. Units |
PODOCUMENTENTRIES. podocumententry[].UNIT |
PurchaseOrderLines.Line Description |
PurchaseOrderLines[]. Description |
PODOCUMENTENTRIES. podocumententry[].MEMO |
PurchaseOrderLines. PurchaseOrderLine[].Rate |
PurchaseOrderLines[]. Rate |
PODOCUMENTENTRIES. podocumententry[].UIPRICE |
PurchaseOrderLines. PurchaseOrderLine[].Item |
PurchaseOrderLines[]. TRX_VALUE |
PODOCUMENTENTRIES. podocumententry[].TRX_VALUE |
PurchaseOrderLines.PurchaseOrderLine[]. CustomFields.Warehouse |
PurchaseOrderLines[]. CustomFields.Warehouse |
PODOCUMENTENTRIES. podocumententry[].WAREHOUSE. LOCATION_NO |
PurchaseOrderLines.PurchaseOrderLine[]. CustomFields.Department |
PurchaseOrderLines[]. CustomFields.Department |
PODOCUMENTENTRIES. podocumententry[].DEPARTMENT |
PurchaseOrderLines.PurchaseOrderLine[]. CustomFields.Class |
PurchaseOrderLines[]. CustomFields.Classǂ |
PODOCUMENTENTRIES. podocumententry[].CLASSID |
PurchaseOrderLines.PurchaseOrderLine[]. CustomFields.Location |
PurchaseOrderLines[]. CustomFields.Location |
PODOCUMENTENTRIES. podocumententry[].LOCATIONID |
PurchaseOrderLines. PurchaseOrderLine[].PoLineId |
PurchaseOrderLines[]. ExternalID |
PODOCUMENTENTRIES. |
PurchaseOrderLines. PurchaseOrderLine[].BilledQuantity |
PurchaseOrderLines[]. BilledQuantity |
PODOCUMENTENTRIES. |
PurchaseOrderLines. PurchaseOrderLine[].LineType |
PurchaseOrderLines[]. LineType = 'Item' |
N/A |
N/A | PurchaseOrderLines[]. BilledAmount |
PODOCUMENTENTRIES. podocumententry[]. TOTAL_AMOUNT_CONVERTED |
PayerEntity | PayerEntity+ | PODOCUMENTENTRIES. podocumententry[].LOCATIONID |
Currency | Currency+ | PODOCUMENTENTRIES. podocumententry[].CURRENCY |
PurchaseOrderLines. PurchaseOrderLine[].CustomFields.<Dimension1> |
PurchaseOrderLines[]. CustomFields.<Dimension1> |
PODOCUMENTENTRIES. podocumententry[].GLDIM<Dimension2> |
* The Intacctstatus is mapped to a Tipalti status according to the status map | ||
^ Extracted from the ITEMID by taking the value before '--' | ||
ǂ Extracted from the CLASSID by taking the value before '--' | ||
+ Same for all the podocumententry lines | ||
Dimension1: The name of the dimension as saved in Tipalti, e.g., Better. | ||
Dimension2: The name of the dimension as saved in the ERP in an uppercase format, e.g., BETTERPROMOTION. |
Mapped purchase order statuses
Tipalti |
Intacct |
---|---|
PendingApproval |
|
Closed |
|
Active |
|
Deleted | Declined |
PartiallyBilled | Partially converted (in 2-way matching) |
All PO receivers (GRNsA goods received note (GRN) is an internal document that acts as proof of goods received to match against invoices and purchase orders. GRN, receipt, and receiving report are synonymous.) in Intacct that were added, updated or deleted since the last sync are collected and synced to Tipalti.
Mapped fields
Tipalti |
common |
Intacct |
---|---|---|
ReceiptNumber | ReceiptNumber | DOCID |
Status | Status* | STATE |
Memo | Notes | MESSAGE |
ReceiptDate | ReceiptDate | WHENCREATED |
Supplier | VendorID | CUSTVENDID |
ShipmentDate | ShipmentDate | WHENCREATED |
PurchaseOrderNumber | PurchaseOrderNumber | CREATEDFROM |
GrnLines.GoodsReceived NotificationLine[].InvoiceNumber |
ItemReceiptLines[]. InvoiceNumber |
PODOCUMENTENTRIES. podocumententry[].SOURCE_DOCID |
GrnLines.GoodsReceived NotificationLine[].ItemCode |
ItemReceiptLines[]. ItemCode |
PODOCUMENTENTRIES. podocumententry[].ITEMID |
GrnLines.GoodsReceived NotificationLine[].ItemDescription |
ItemReceiptLines[]. ItemDescription |
PODOCUMENTENTRIES. podocumententry[].MEMO |
GrnLines.GoodsReceived NotificationLine[].ItemUnits |
ItemReceiptLines[]. ItemUnits |
PODOCUMENTENTRIES. podocumententry[].UNIT |
GrnLines.GoodsReceived NotificationLine[].LineNotes |
ItemReceiptLines[]. LineNotes |
PODOCUMENTENTRIES. podocumententry[].MEMO |
GrnLines.GoodsReceived NotificationLine[].Quantity |
ItemReceiptLines[]. QuantityShipped |
PODOCUMENTENTRIES. podocumententry[].UIQTY |
GrnLines.GoodsReceived NotificationLine[].PoLineId |
ItemReceiptLines[]. ExternalID |
PODOCUMENTENTRIES. podocumententry[].LINE_NO |
PayerEntity | PayerEntity^ | PODOCUMENTENTRIES. podocumententry[].LOCATIONID |
* The Intacctstatus is mapped to a Tipalti status according to the status map | ||
^ Same for all the podocumententry lines |
Mapped PO receiver statuses
Tipalti |
Intacct |
---|---|
Active |
|
Closed |
|
Deleted | Declined |
All Vendor invoices (matched bills) that were added, updated or deleted since the last sync are collected and synced to Intacct.
Mapped fields
Tipalti |
common |
Intacct |
---|---|---|
InvoiceDate* | InvoiceDate | datecreated.day |
InvoiceDate | InvoiceDate | datecreated.month |
InvoiceDate | InvoiceDate | datecreated.year |
InvoiceDueDate* | InvoiceDueDate | datedue.day |
InvoiceDueDate | InvoiceDueDate | datedue.month |
InvoiceDueDate | InvoiceDueDate | datedue.year |
N/A | N/A | potransitems.potransitem[]. billable = 'false' |
InvoiceLines.InvoiceLine[]. RelatedPurchaseOrders. TipaltiRelatedPurchaseOrder[]. ItemNumber |
invoiceLine.PurchaseOrders[]. Item |
potransitems.potransitem[]. itemid |
N/A | N/A | potransitems.potransitem[]. line_num = index of line |
PayerEntityName | PayerEntity | potransitems.potransitem[]. locationid |
InvoiceLines.InvoiceLine[]. InvoiceLines.InvoiceLine[]. |
InvoiceLine.PurchaseOrders[]. NetAmount/ invoiceLine. PurchaseOrders[].NetAmount.Quantity |
potransitems.potransitem[]. price |
InvoiceLines.InvoiceLine[]. RelatedPurchaseOrders. TipaltiRelatedPurchaseOrder[]. Quantity |
invoiceLine.PurchaseOrders[]. Quantity |
potransitems.potransitem[]. quantity |
N/A | N/A |
potransitems.potransitem[]. taxable = false |
N/A | N/A |
potransitems.potransitem[]. unit |
Idap | VendorID^ | potransitems.potransitem[]. vendorid |
N/A | N/A | State (Pending/Draft - according to approval status) |
InvoiceNumber | InvoiceNumber | vendordocno |
InvoiceRefCode | Id | documentnoǂ |
N/A | N/A | transactiontypeǂ = 'Vendor Invoice' |
Idap | VendorID | vendoridǂ |
InvoiceLines.InvoiceLine[]. RelatedPurchaseOrders. TipaltiRelatedPurchaseOrder[]. PurchaseOrderNumber |
PurchaseOrderNumber | createdfromǂ |
Description | Description | MESSAGE <<< Header |
InvoiceLines[].Description | InvoiceLines[].Description | ITEMDESC <<< Line |
* Day/ month/ year are extracted from a single string | ||
^ Same VendorId for all items | ||
ǂ Only relevant for non-update scenarios |