Synced fields - Quickbooks Online
The following tables list the data values that are synced between VOGSY and Quickbooks Online (QBO).
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 → QBO | QBO → VOGSY |
|---|---|---|---|
Organization name |
|
|
|
Organization email |
|
|
|
Customer |
|
|
|
Supplier |
|
|
|
Organization website |
|
|
|
Organization phone number |
|
|
|
Organization VAT number |
|
|
|
Organization VAT type |
|
|
|
Organization payment condition |
|
|
|
|
|
|
|
To the attention of |
|
|
|
Invoice email address 1 |
|
|
|
Invoice address |
|
|
|
Invoice address zipcode |
|
|
|
Invoice address city |
|
|
|
Invoice address country |
|
|
|
Supplier number |
|
|
|
Debtor number |
|
|
|
Person (Organization Contact) data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Person name |
|
|
|
Person last name |
|
|
|
Person email |
|
|
|
|
|
|
|
|
|
|
|
Address |
|
|
|
City |
|
|
|
Zipcode |
|
|
|
Country |
|
|
|
Invoice data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Project number |
|
|
|
Invoice number |
|
|
|
Project name |
|
|
|
Invoice date |
|
|
|
Due date |
|
|
|
|
|
|
|
|
|
|
|
Amounts |
|
|
|
Payment condition |
|
|
|
Invoice Line data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Line description |
|
|
|
Line amount |
|
|
|
VAT amount |
|
|
|
VAT type |
|
|
|
VAT percentage |
|
|
|
Invoice line total |
|
|
|
Invoice line quantity |
|
|
|
Purchase invoice data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Project number |
|
|
|
Supplier name |
|
|
|
Creditor invoice number |
|
|
|
Invoice number |
|
|
|
Project name |
|
|
|
Invoice date |
|
|
|
Due date |
|
|
|
Currency code |
|
|
|
Currency rate |
|
|
|
Amount |
|
|
|
Inclusive amount |
|
|
|
Purchase invoice line data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
|
|
|
|
Amount |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Expenses data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
Project name |
|
|
|
Invoice date |
|
|
|
Due date |
|
|
|
|
|
|
|
|
|
|
|
Description |
|
|
|
Amount |
|
|
|
VAT amount |
|
|
|
VAT type |
|
|
|
|
|
|
|
VAT type data
| This data is synced daily. |
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Description |
|
|
|
Name |
|
|
|
Percentage |
|
|
|
Second description |
|
|
|
Second percentage |
|
|
|
Archived |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ledger account data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Description |
|
|
|
Account type |
|
|
|
Account number |
|
|
|
Distribute to project |
|
|
|
Department data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
|
|
|
|
Name |
|
|
|
Accounts payable data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
Status |
|
|
|
Accounts receivable data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
Status |
|
|
|
Journal entries data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Payment conditions data
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Name |
|
|
|
Days till Due Date |
|
|
|
Invoice text |
|
|
|
Book entry data
| This data is not synced as a unique entity. VOGSY only syncs journal entries but uses some fields like the book entry number and book entry date in the journal entries. |
| Field name | During setup | VOGSY → QBO | QBO → VOGSY |
|---|---|---|---|
Journal |
|
|
|
Book entry number |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|