Synchronization with Sage Intacct
Select a category below to see information about synchronization between Intacct and Zipalti.
- Payee payment terms sync bidirectionally (and payer payment terms sync from Intacct to Zipalti).
- Inactive vendors in Intacct are marked as suspended in Zipalti and vice versa.
- Vendors that are deleted in Intacct are closed in Zipalti.
Zipalti to Intacct
Bills in the following statuses are synced automatically from Zipalti to Intacct:
- Scheduled for payment
- Submitted for payment
- Paid
- Partially paid
Payers can choose to sync bills from Zipalti 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.
Retracted approvals
When an approved bill is synced to Intacct, it includes the approval date.
- If the bill is sent back to AP in Zipalti, it's retracted, and in Intacct, this is synced as a reversal with the retracted date.
- If the bill is approved again, this is synced as a new bill 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 Zipalti
- GL accounts linked to multiple entities sync from Intacct to Zipalti.
- 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 Zipalti. Unit values must be unique in Intacct for sync to be successful.
- 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 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 = $993GL accounts linked to multiple entities sync from Intacct to Zipalti.
-
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 Zipalti 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 Zipalti 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 Zipalti that were added, updated or deleted since the last sync are collected and synced to Intacct.
Mapped fields
|
Zipalti |
Intacct |
|---|---|
| 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 Intacct user interface | |
All GL accounts in Intacct that were added, updated or deleted since the last sync are collected and synced to Zipalti.
Mapped fields
|
Zipalti |
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, Zipalti, or both systems.
Mapped fields
|
Zipalti |
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 Zipalti to Intacct.
Mapped fields
|
Zipalti |
Intacct |
|---|---|
| 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 |
All vendor credit records that were added, updated or deleted since the last sync are collected and synced from Zipalti to Intacct.
- When a vendor credit is applied in Zipalti, 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 Zipalti.
Mapped fields
|
Zipalti |
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 Zipalti.
Mapped fields
|
Zipalti |
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 Zipalti 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 Zipalti, 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
|
Zipalti |
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 Zipalti.
Mapped fields
|
Zipalti |
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 Zipalti status according to the status map | ||
| ^ Same for all the podocumententry lines | ||
Mapped PO receiver statuses
|
Zipalti |
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
|
Zipalti |
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. ZipaltiRelatedPurchaseOrder[]. 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. ZipaltiRelatedPurchaseOrder[]. 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. ZipaltiRelatedPurchaseOrder[]. PurchaseOrderNumber |
PurchaseOrderNumber | createdfromǂ |
| * Day/ month/ year are extracted from a single string | ||
| ^ Same VendorId for all items | ||
| ǂ Only relevant for non-update scenarios | ||
Comments
0 comments
Please sign in to leave a comment.