Synchronization
Select a category below to see information about synchronization between BC and Tipalti.
- Tipalti supports only payment terms that depict a number of days after the invoice date, thus only terms of the format shall be synced.
- Only payment terms that were synced from BC may be used on payees (otherwise their sync will fail).
- Existing vendors are synced from BC to Tipalti during the first time sync.
- Vendors in BC have a Vendor Posting Group (VPG) field which indicates their AP account. This should be configured in Tipalti as a custom field of type list, and mapped in the configuration wizard, or else the default VPG will be set in BC.
The payee’s selected payment method is synced to BC. If the payment method wasn’t selected, the payment method configured as default in BC will be set in BC. If the payment method is CASH - BC will automatically mark the approved bill (posted purchase invoice) as ‘Paid’ in BC, and the actual payment details won’t be synced.
- In BC, ‘location’ is a native field and can be mapped as a custom field of type list on bill/VC header/ lines.
- Dimensions are read from BC to Tipalti and may be mapped with Tipalti’s custom fields.
- The chosen custom field value on a bill or VC header / line is synced to BC, as part of the invoice’s sync.
Custom field value deletions and status change (active/inactive) in BC are not synced to Tipalti. Thus, if you delete a value in BC you need to manually delete it in Tipalti, under Administration > General > Custom fields.
Project and task fields are mapped as custom fields in Tipalti.
- Bills in the following statuses are synced automatically from Tipalti to BC as posted purchase invoices:
- Pending payment
- Scheduled for payment
- Submitted for payment
- Paid
- Partially paid
- Currently, syncing bills before approval is not available.
- Edit post approval is supported (according to the bill’s settings), but this will be synced to BC same as retract approval, since BC doesn’t allow editing posted invoices.
- Retract approval is supported. The bill will be reversed in BC (by applying a purchase credit memo to it) and a new invoice with the original invoice number with a suffix will be created, with the updated information, once it is reapproved.
Invoice files can be automatically synced to BC and downloaded from within the bill record under Incoming Document Files.
To sync bill invoice files:
-
In the Sync Wizard screen, under Sync Preferences, check the Sync bill image box.
Vendor credits are synced as ‘Posted Purchase Credit Memos’ to BC, similar to bills, with the exception of:
- Voiding and updating vendor credits is currently not supported: the purchase credit memo should be canceled manually in BC.
- Payment are synced from Tipalti to BC.
- Currently only payments paid from accounts with the same currency as the payment will be synced to BC (No payer Fx). Multi-currency payments with Fx must be entered manually to BC.
- Void payments are not synced, thus a voided payment must be handled manually in BC (E.g., a rejected payment).
- GLA general ledger (GL) is used for recording transactions related to business assets, liabilities, equity, revenue and expenses. and bank accounts sync from BC to Tipalti.
- Currently all accounts (excluding bank accounts and AP accounts) are displayed on the bill line expense accountThe general ledger (GL) account that is debited for the payment amount drop down.
- Bank accounts with no currency are set in Tipalti with the company’s base currency from BC.
- A deletion of a GL account or bank account in BC is not synced to Tipalti, but blocked accounts aren’t synced and will be updated as inactive in Tipalti if already synced.
Tax tables sync as codes from BC to Tipalti
- Support for synchronizing tax codes and their associated amounts on transaction lines in BC.
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.
This section details the mapped fields between Tipalti and BC.
Mapped fields
Tipalti |
BC |
---|---|
Number | Number |
Name | Display name |
External ID | System ID (internal) |
Mapped fields
Tipalti |
BC |
---|---|
Number | Number |
Name | Display name |
Currency* | Currency |
External ID | System ID (internal) |
* If the currency from BC is empty - the company’s currency in the ERP will be used.
Mapped fields
Tipalti |
BC |
---|---|
Payee ID | Not mapped with BC |
Alias | No.* |
Company name / or first + last + middle name** | Name |
Payee entity type | Partner type (individual maps to person) |
Company name | Name (if payee entity type = ‘Company’) |
First name | Name - first part (if payee entity type = ‘Person’) |
Last name | Name - second part (if payee entity type = ‘Person’) |
Street 1 | First Address line |
Street 2 | Second Address line |
City | City |
State | State |
Zip | Postal code |
Payment term | Payment term |
Payment method | Payment method*** |
(ExternalID) - Appears in Sync failures as BC ID | System ID (internal) |
*Only synced during the first time sync from BC, since the numbering convention can be set in BC and must be unique.
**When syncing a payee from Tipalti, the name is determined according to the payee entityAn entity can be a subsidiary, division, business unit, brand, etc. of your organization. Entities can have similar or different AP processes and workflows. type:
Company: the Name will be equal to the company name
Person: first + middle + last name (whichever exists)
When syncing a payee into Tipalti - the same logic will apply in reverse (for person - first name will contain the first word from the name field, and last name will contain the last word from the name field).
Mapped fields
Tipalti |
bc |
---|---|
Payee external ID | Maps to vendor |
Due date | Due date |
Invoice date | Invoice date |
Invoice date | Posting date |
Invoice number | Vendor invoice number |
Currency | Currency code |
Bill line Quantity | Bill line Quantity |
Bill line Unit price | Bill line Unit price |
Bill line Description | Bill line Description |
Bill line Expense account | Bill line Account |
Vendor credits are synced to BC as credit memos. The mapping is identical to bills.
Mapped fields
Tipalti |
Xero |
---|---|
Tipalti payee | Maps to vendor |
Account (Virtual Account ID) | Bal. Account No. |
Transaction date | Posting Date |
Refcode | External document ID |
Payment Amount | Amount |
* In Xero UI: Details to appear on your bank statement |