All Collections
Integrations
QuickBooks Online
Sync Accounts, Vendors, Expenses and Invoices to QuickBooks
Sync Accounts, Vendors, Expenses and Invoices to QuickBooks
Kara Bates avatar
Written by Kara Bates
Updated over a week ago

Accounts, vendors, expenses and invoices can be synced from Avianis to QuickBooks (but not the other direction). Here is a list of the data points that will transfer to QuickBooks for each.

Accounts

  • Account Name

  • Address

  • Email

  • Work Phone

  • Fax

Vendors

  • Vendor Name

  • Address

  • Email

  • Work Phone

  • Fax

  • Toll Free

  • Website

  • Account Number

  • Billing Contact (If vendor contact is designated billing role)

Expenses
To sync expenses to QuickBooks, the expense categories need to be tied to existing chart of accounts. Read Integrations: QuickBooks Online in Avianis to understand more on associating expense categories and accounts. Note: Attached receipts do not sync to QB.

  • Account name from trip the expenses is tied to

  • Payable to

  • Payable with

  • Amount 

  • Payment Data

Invoices
To sync invoices to QuickBookes, line item types must be tied to existing products and services. Read Integrations: QuickBooks Online in Avianis to understand more on associating line item types to products and services. QB is not accepting the "Taxes" value from the Avianis invoice. To add the taxes into the invoice on the QB side, add an additional line item to your QB invoice. Payment applied to the QB invoice will reflect on the Avianis invoice. 

  • Account 

  • Billing Address

  • Invoice Date

  • Due Date

  • Line Items
         Type = Product/Service
         Description
         Quantity
         Amounts

Sync accounts, vendors, expenses and invoices

  1. Access the account, vendor, expenses or invoice record you want to sync.

  2. Click on the green QuickBooks icon in the top right corner of the page

  3. An additional pop up opens. Click "Sync".

Ref: I-Q02

Did this answer your question?