QuickBooks Commerce + Microsoft Excel + QuickBooks Online Integrations

How to connect QuickBooks Commerce + Microsoft Excel + QuickBooks Online

Zapier lets you send info between QuickBooks Commerce and Microsoft Excel and QuickBooks Online automatically—no code required. With 6,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Do even more with QuickBooks Commerce + Microsoft Excel + QuickBooks Online

With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with QuickBooks Commerce, Microsoft Excel, and QuickBooks Online. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

New Address
Triggers when a new address is created.
Trigger
Instant
Try It
New Contact
Triggers when a new contact is created.
Trigger
Instant
Try It
New Invoice
Triggers when a new invoice is created.
Trigger
Instant
Try It
Order Finalized
Triggers when an order has been marked as finalized.
Trigger
Instant
Try It
- CompanyRequired
- Address LabelRequired
- First Name
- Last Name
- Company Name
- Address Line 1Required
- Address Line 2
- Suburb
- City
- State
- Country
- Zipcode
- Email Address
- Phone Number
Action
Write

- CompanyRequired
- First NameRequired
- Last Name
- EmailRequired
- Phone Number
- Mobile
- Fax
- Notes
- Invite to your B2B eCommerce Portal?
Action
Write
- CompanyRequired
- First Name
- Last Name
- Company Name
- Address 1
- Address 2
- City
- Country
- Zip Code
Action
Search

- Order Number
- Reference Number
Action
Search
- Company NameRequired
- Company Code
- Email Address
- Filter Relationship TypeRequired
- Tax Number
- Phone Number
- Fax Number
- Website
- Description
- Tags
- Assigned To
- Default Price List
- Default Tax Type
- Default Stock Location
- Default Branding Theme
- Default Discount Rate
Action
Search or write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- TableRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write
New Bill
Triggers when a new bill is added.
Trigger
Scheduled
Try It
New Estimate
Triggered when you add a new estimate.
Trigger
Scheduled
Try It
New Invoice
Triggered when you add a new invoice.
Trigger
Scheduled
Try It
New Sales Receipt
Triggered when a new sales receipt is added (with line item support).
Trigger
Scheduled
Try It
New Purchase Order
Triggers when a new purchase order is added.
Trigger
Scheduled
Try It
Updated Customer
Triggered when an existing customer is updated.
Trigger
Scheduled
Try It
- VendorRequired
- Bill Number
- Line Item
- Line Description
- AmountRequired
- Qty
- Unit Price
- Line Class
- AP Account
- Customer
- Due Date
- Transaction Date
Action
Write
- VendorRequired
- Terms
- Transaction Date
- Due Date
- Bill Number
- Department
- Global Tax Calculation
- Product/Service
- Description
- Qty
- Rate
- AmountRequired
- Billable?
- Customer
- Line Class
- Tax Code
- AP Account
- Memo
Action
Write
- Full NameRequired
- Display Name
- Title
- First Name
- Last Name
- Company
- Email
- Phone
- Mobile
- Fax
- Website
- GST Registration Type
- GSTIN
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Notes
- Currency
- Tax Registration Number
- Tax Resale Number
- Job/Parent Customer
- Bill with Parent?
- Preferred Payment Method
- Preferred Delivery Method
- Terms
- Customer Type
Action
Write
- Payee TypeRequired
- Payment TypeRequired
- Bank/Credit AccountRequired
- Payment Date
- Payment Method
- Reference Number
- Print Later?
- Account
- Description
- Amount
- Billable Status
- Tax Code
- Customer
- Class
- Product/Service
- Description
- Quantity
- Rate
- Amount
- Billable Status
- Tax Code
- Customer
- Class
- Memo
Action
Write
- Journal Date
- Journal Number
- AccountRequired
- Debit AmountRequired
- Description
- Customer Name
- Vendor Name
- Employee Name
- Department
- Class
- AccountRequired
- Credit AmountRequired
- Description
- Customer Name
- Vendor Name
- Employee Name
- Department
- Class
- Memo
- Currency
- Exchange Rate
Action
Write
- Customer
- Find Customer by Name/Email
- Email
- Send Later?
- Note
- Message
- Line AmountRequired
- Service Date
- Line Description
- Product/Service
- Line Item Quantity
- Line Item Unit Price
- Line Item Tax Code
- Line Item Class
- Transaction Date
- Total Discount
- Payment Method
- Payment Reference Number
- Deposit To Account
- Sales Receipt Number
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Currency
- Exchange Rate
- Class
- Tax Code
- Total Tax
- Tax Calculation
- Shipping Tax
- Shipping Cost
- Department
Action
Write
- VendorRequired
- Purchase Order Status
- Mailing Address
- Shipping Address
- Purchase Order Date
- Ship Via
- Purchase Order Number
- Account
- Description
- Amount
- Customer
- Class
- Product/Service
- Description
- Quantity
- Rate
- Amount
- Customer
- Class
- Your Message to Vendor
- Memo
Action
Write
- InvoiceRequired
- EmailRequired
Action
Write
- Time Activity TypeRequired
Action
Write
- InvoiceRequired
- Customer
- Email
- Cc
- Bcc
- Send Later?
- Billing Address
- Shipping Address
- Terms
- Invoice Date
- Due Date
- Ship Via
- Shipping Date
- Tracking Number
- Invoice Number
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- Amount
- Tax
- Class
- Message Displayed on Invoice
- Message Displayed on Statement
- Accept Payment Via Bank Transfer
- Accept Payment Via Credit Card
- Tax Code
- Total Tax
- Tax Calculation
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Shipping Tax
- Shipping
- Deposit
- Class
- Department
- Location
- Currency
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Search FieldRequired
- Search ValueRequired
Action
Search
- Product NameRequired
Action
Search
- Search FieldRequired
- Search ValueRequired
- Full NameRequired
- Display Name
- Title
- First Name
- Last Name
- Company
- Email
- Phone
- Mobile
- Fax
- Website
- GST Registration Type
- GSTIN
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
- Address Country
- Shipping Address Line 1
- Shipping Address Line 2
- Shipping Address City
- Shipping Address State Code
- Shipping Address Zip Code
- Shipping Address Country
- Notes
- Currency
- Tax Registration Number
- Tax Resale Number
- Job/Parent Customer
- Bill with Parent?
- Preferred Payment Method
- Preferred Delivery Method
- Terms
- Customer Type
Action
Search or write

- Filter Relationship Type
Trigger
Instant
Try It
New Fulfillment
Triggers when a sales order is (fully or partially) packed and a new fulfillment is created.
Trigger
Instant
Try It
New Order
Triggers when a new order is created.
Trigger
Instant
Try It
Order Fulfilled
Triggers when an order has been completely fulfilled.
Trigger
Instant
Try It
- Company NameRequired
- Company TypeRequired
- Company Code
- Tax Number
- Phone Number
- Fax Number
- Website
- Email Address
- Description
- Tags
- Assigned To
- Default Price List
- Default Tax Type
- Default Stock Location
- Default Branding Theme
- Default Discount Rate
Action
Write
- Order Number
- Status
- Reference Number
- CustomerRequired
- Shipping AddressRequired
- Billing Address
- Assignee
- Stock Location
- Currency
- Default Price List
- Email
- Phone Number
- Issued At
- Ship At
- Tax Treatment
- Tags
- Notes
- Order Source URL
- Variant SKURequired
- QuantityRequired
- Price
- Discount (%)
- Extra Note
- Tax Type Code
- Tax Rate Override (%)
- Has Freeform Line Items
Action
Write
- Company Name
- Company Code
- Company Email
- Filter Relationship Type
Action
Search
- CompanyRequired
- First Name
- Last Name
- Company Name
- Address Line 1Required
- Address Line 2
- City
- Country
- Zipcode
- Address LabelRequired
- Suburb
- State
- Email Address
- Phone Number
Action
Search or write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Storage Source
- Folder
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Storage Source
- FolderRequired
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
New Account
Triggered when you add a new account.
Trigger
Scheduled
Try It
New Customer
Triggered when you add a new customer.
Trigger
Scheduled
Try It
New Expense
Triggers when a new expense is added.
Trigger
Scheduled
Try It
New Invoice
Triggered when you add a new invoice (with line item support).
Trigger
Scheduled
Try It
New Payment
Triggered when a payment is received (with line item support).
Trigger
Scheduled
Try It
New Sales Receipt
Triggered when a new sales receipt is added.
Trigger
Scheduled
Try It
New Vendor
Triggered when a new vendor is added.
Trigger
Scheduled
Try It
- VendorRequired
- Terms
- Transaction Date
- Due Date
- Bill Number
- Department
- Currency
- Global Tax Calculation
- Description
- AmountRequired
- Billable?
- Customer
- Class
- AccountRequired
- Tax Code
- AP Account
- Memo
Action
Write
- CustomerRequired
- Email
- Send Later?
- Billing Address
- Credit Memo Date
- Credit Memo Number
- Class
- AmountRequired
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Credit Memo
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping Cost
Action
Write
- CustomerRequired
- Number
- Line AmountRequired
- Line Description
- Line Item/Product
- Line Item Quantity
- Line Item Tax Code
- Line Item Service Date
- Rate
- Expiration Date
- Message displayed on estimate
- Billing Address
- Shipping Address
- Shipping amount
- Bill Email
- Send later
- Discount Value
- Discount Percent
Action
Write
- TypeRequired
- NameRequired
- Description On Sales Forms
- Sales Price/Rate
- Description On Purchase Forms
- Cost
- SKU
- Category
- Is Taxable?
Action
Write
- CustomerRequired
- Email
- Cc
- Bcc
- Send Later?
- Billing Address
- Shipping Address
- Terms
- Invoice Date
- Due Date
- Ship Via
- Shipping Date
- Tracking Number
- Invoice Number
- Service Date
- Product/Service
- Description
- Quantity
- Rate
- AmountRequired
- Tax
- Class
- Message Displayed on Invoice
- Message Displayed on Statement
- Accept Payment Via Bank Transfer
- Accept Payment Via Credit Card
- Tax Code
- Total Tax
- Tax Calculation
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Shipping Tax
- Shipping
- Deposit
- Class
- Department
- Location
- Currency
Action
Write
- CustomerRequired
- Total AmountRequired
- Unapplied Amount
- Transaction Date
- Payment Method
- Payment Reference Number
- Deposit To Account
- Line Amount
- Memo
- Line Linked Invoice
Action
Write
- Refund FromRequired
- Customer
- Email
- Billing Address
- Refund Receipt Date
- Refund Receipt Number
- Transaction Class
- Payment Method
- Check Number
- Print Later?
- Product/ServiceRequired
- AmountRequired
- Service Date
- Description
- Quantity
- Rate
- Tax
- Class
- Message Displayed On Refund Receipt
- Memo
- Apply Tax After Discount?
- Discount Value
- Discount Percent
- Sales Tax Rate
- Shipping
Action
Write
- Sales ReceiptRequired
- Email
Action
Write
- CustomerRequired
- Company
- Email
- Title
- First name
- Middle name
- Last name
- Suffix
- Display name as
- Phone
- Mobile
- Fax
- Other
- Website
- Print On Check As
- Notes
- Billing Address - Street
- Billing Address - City/Town
- Billing Address - State/Province
- Billing Address - ZIP code
- Billing Address - Country
- Shipping Address - Street
- Shipping Address - City/Town
- Shipping Address - State/Province
- Shipping Address - ZIP code
- Shipping Address - Country
- Exemption Details
Action
Write
- Full NameRequired
- PhoneRequired
- Email
- Website
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
Action
Write
- Account NameRequired
Action
Search
- Invoice NumberRequired
Action
Search
- NameRequired
Action
Search
- Full NameRequired
- PhoneRequired
- Email
- Website
- Address Line 1
- Address Line 2
- Address City
- Address State Code
- Address Zip Code
Action
Search or write

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How QuickBooks Commerce + Microsoft Excel + QuickBooks Online Integrations Work

Step 1: Authenticate QuickBooks Commerce, Microsoft Excel, and QuickBooks Online.
30 seconds
Step 2: Pick one of the apps as a trigger, which will kick off your automation.
15 seconds
Step 3: Choose a resulting action from the other app.
15 seconds
Step 4: Select the data you want to send from one app to the other.
2 minutes
That’s it! More time to work on other things.

Connect apps

Connect QuickBooks Commerce + Microsoft Excel + QuickBooks Online

About QuickBooks Commerce

Manage your multi-channel and wholesale business in one place with QuickBooks Commerce. Increase operational efficiency with supply chain, reporting, and accounting automation.

Related categories

eCommerce

About Microsoft Excel

Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets. Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.

Help

Related categories

Similar apps

OneDrive

File Management & Storage, Microsoft

Smartsheet

Spreadsheets

Quip

Documents

About QuickBooks Online

QuickBooks Online is the web version of the popular accounting packages QuickBooks. Use any Zapier integration to connect QuickBooks Online to hundreds of other apps.

Learn more Help

Related categories

Accounting

Similar apps

Xero

Accounting

FreeAgent

Accounting

Wave

Accounting

PRODUCTS

CAPABILITIES

By team

QuickBooks Commerce + Microsoft Excel + QuickBooks Online Integrations

How to connect QuickBooks Commerce + Microsoft Excel + QuickBooks Online

Do even more with QuickBooks Commerce + Microsoft Excel + QuickBooks Online

New Address

New Contact

New Invoice

Order Finalized

Create Address

Address LabelRequired

First Name

Last Name

Company Name

Address Line 1Required

Address Line 2

Suburb

City

State

Country

Zipcode

Email Address

Phone Number

Create Contact

CompanyRequired

First NameRequired

Last Name

EmailRequired

Phone Number

Mobile

Fax

Notes

Invite to your B2B eCommerce Portal?

Find an Address for a Company

CompanyRequired

First Name

Last Name

Company Name

Address 1

Address 2

City

Country

Zip Code

Find an Existing Sales Order

Order Number

Reference Number

Find or Create Company

Company NameRequired

Company Code

Email Address

Filter Relationship TypeRequired

Tax Number

Phone Number

Fax Number

Website

Description

Tags

Assigned To

Default Price List

Default Tax Type

Default Stock Location

Default Branding Theme

Default Discount Rate

New Row in Table

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

TableRequired

Updated Row

Storage Source

FolderRequired

SpreadsheetRequired

WorksheetRequired

Trigger Column

Add Row to Table

Storage Source

FolderRequired

SpreadsheetRequired