Synced fields - Exact

The following tables list the data values that are synced between VOGSY and Exact.

Every day VOGSY reads all book entries and journal entries from Exact and creates them in VOGSY if they do not already exist.
Some of the data that is synced displays on a form in VOGSY or the target software. If the data value is associated with a field that displays to the user, the name of the field is listed in the Field name column in bold. If the data value is not associated with a field that displays to the user, the data name is listed in the Field name column in a monospace font. These conventions are used in order to give you a complete understanding of the data that is synced.
The During setup column indicates whether or not the listed item is fetched from Quickbooks Online during the mapping stage of the integration setup. These items are not stored in VOGSY’s database during the setup.

Organization data

Field name During setup VOGSY → Exact Exact → VOGSY

Organization name

check bold

check bold

close thick

Organization email

check bold

check bold

close thick

Customer

check bold

check bold

close thick

Supplier

check bold

check bold

close thick

Organization website

check bold

check bold

close thick

Organization phone number

check bold

check bold

close thick

Organization VAT number

close thick

close thick

close thick

Organization VAT type

check bold

check bold

close thick

Organization payment condition

check bold

check bold

close thick

external_invoice_address_id

check bold

check bold

close thick

To the attention of

close thick

check bold

close thick

Invoice email address 1

check bold

check bold

close thick

Invoice address

check bold

check bold

close thick

Invoice address zipcode

check bold

check bold

close thick

Invoice address city

check bold

check bold

close thick

Invoice address country

check bold

check bold

close thick

Supplier number

check bold

close thick

close thick

Debtor number

check bold

close thick

close thick

Person (Organization Contact) data

Field name During setup VOGSY → Exact Exact → VOGSY

Person name

check bold

check bold

close thick

Person last name

check bold

check bold

close thick

Person email

check bold

check bold

close thick

list of mobile phone numbers

check bold

check bold

close thick

list of landline phone numbers

check bold

close thick

close thick

Address

close thick

check bold

close thick

City

close thick

check bold

close thick

Zipcode

close thick

check bold

close thick

Country

close thick

check bold

close thick

Invoice data

Field name During setup VOGSY → Exact Exact → VOGSY

Project number

close thick

check bold

close thick

Invoice number

close thick

check bold

close thick

Project name

close thick

check bold

close thick

Invoice date

close thick

check bold

close thick

Due date

close thick

check bold

close thick

currency_code

close thick

check bold

close thick

currency_rate

close thick

check bold

close thick

Amounts

close thick

check bold

close thick

Payment condition

close thick

check bold

close thick

Invoice Line data

Field name During setup VOGSY → Exact Exact → VOGSY

Line description

close thick

check bold

close thick

Line amount

close thick

check bold

close thick

VAT amount

close thick

check bold

close thick

VAT type

close thick

check bold

close thick

VAT percentage

close thick

close thick

close thick

Invoice line total

close thick

close thick

close thick

Invoice line quantity

close thick

close thick

close thick

Purchase invoice data

Field name During setup VOGSY → Exact Exact → VOGSY

Project number

close thick

close thick

close thick

Supplier name

close thick

check bold

close thick

Creditor invoice number

close thick

check bold

close thick

Invoice number

close thick

check bold

close thick

Project name

close thick

close thick

close thick

Invoice date

close thick

check bold

close thick

Due date

close thick

check bold

close thick

Currency code

close thick

check bold

close thick

Currency rate

close thick

check bold

close thick

Amount

close thick

check bold

close thick

Inclusive amount

close thick

check bold

close thick

Purchase invoice line data

Field name During setup VOGSY → Exact Exact → VOGSY

description

close thick

check bold

close thick

Amount

close thick

check bold

close thick

vat_amount

close thick

check bold

close thick

vat_type

close thick

check bold

close thick

vat_%

close thick

close thick

close thick

total

close thick

close thick

close thick

quantity

close thick

close thick

close thick

Expenses data

Field name During setup VOGSY → Exact Exact → VOGSY

project_number

close thick

close thick

close thick

employee_id

close thick

check bold

close thick

Project name

close thick

close thick

close thick

Invoice date

close thick

check bold

close thick

Due date

close thick

check bold

close thick

currency_code

close thick

close thick

close thick

currency_rate

close thick

close thick

close thick

Description

close thick

close thick

close thick

Amount

close thick

check bold

close thick

VAT amount

close thick

check bold

close thick

VAT type

close thick

check bold

close thick

vat_%

close thick

close thick

close thick

VAT type data

Field name During setup VOGSY → Exact Exact → VOGSY

Description

check bold

close thick

close thick

Name

check bold

close thick

close thick

Percentage

check bold

close thick

close thick

Second description

close thick

close thick

close thick

Second percentage

close thick

close thick

close thick

Archived

close thick

close thick

close thick

ledger_account_vat_due_key

check bold

close thick

close thick

ledger_account_vat_payable_key

check bold

close thick

close thick

contra_ledger_account_vat_due_key

check bold

close thick

close thick

contra_ledger_account_vat_payable_key

check bold

close thick

close thick

Ledger account data

Field name During setup VOGSY → Exact Exact → VOGSY

Description

check bold

close thick

close thick

Account type

close thick

close thick

close thick

Account number

close thick

close thick

close thick

Distribute to project

close thick

close thick

close thick

Department data

Field name During setup VOGSY → Exact Exact → VOGSY

id

check bold

close thick

close thick

Name

check bold

close thick

close thick

Accounts payable data

Accounts payable and accounts receivable data are only synced to check if the outstanding amounts are paid.
Field name During setup VOGSY → Exact Exact → VOGSY

paid_amount

close thick

close thick

check bold

paid_amount_other_currency

close thick

close thick

check bold

Status

close thick

close thick

check bold

Accounts receivable data

Accounts payable and accounts receivable data are only synced to check if the outstanding amounts are paid.
Field name During setup VOGSY → Exact Exact → VOGSY

received_amount

close thick

close thick

check bold

received_amount_other_currency

close thick

close thick

check bold

Status

close thick

close thick

check bold

Journal entries data

Field name During setup VOGSY → Exact Exact → VOGSY

ledger_account

close thick

check bold

check bold

amount

close thick

check bold

check bold

amount_other_currency

close thick

check bold

check bold

description

close thick

close thick

check bold

currency_key

close thick

close thick

check bold

currency_rate

close thick

check bold

check bold

department_key

close thick

check bold

check bold

holding_key

close thick

check bold

check bold

company_key

close thick

check bold

check bold

Payment conditions data

This data is imported to VOGSY from Exact, replacing any previous VOGSY data.
Field name During setup VOGSY → Exact Exact → VOGSY

Name

check bold

close thick

close thick

Days till Due Date

check bold

close thick

close thick

Invoice text

check bold

close thick

close thick

Book entry data

Field name During setup VOGSY → Exact Exact → VOGSY

Journal

close thick

check bold

check bold

Book entry number

close thick

close thick

close thick

year

close thick

check bold

check bold

period

close thick

check bold

check bold

journal_entries

close thick

check bold

check bold

date

close thick

close thick

check bold

holding_key

close thick

close thick

check bold

company_key

close thick

close thick

check bold

department_key

close thick

close thick

check bold