Top companies trust Zapier to automate work that solves their unique business problems—no coding required.
How Zapier works
Zapier makes it easy to integrate Microsoft Excel with QuickBooks Online - no code necessary. See how you can get setup in minutes.
100%
Help
Microsoft Excel
Microsoft Excel
1. Choose trigger event
QuickBooks Online
QuickBooks Online
2. Choose action
1. Select the event
Setup
Test
Microsoft Excel
Choose a trigger event
Choose a trigger
A trigger is the event that starts your Zap—like a "New Row" from Microsoft Excel.
Add your action
An action happens after the trigger—such as "Attach File(s) or Note" in QuickBooks Online.
You’re connected!
Zapier seamlessly connects Microsoft Excel and QuickBooks Online, automating your workflow.
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
Create a new record or update an existing record in your app.
Vendor
Required
Terms
Transaction Date
Due_date
Bill Number
Department
Currency
Exchange Rate
Global_tax_calculation
Description
Amount
Required
Billable?
Customer
Class
Account
Required
Tax_code
AP Account
Memo
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Deposit To Account
Required
Transaction Date
Private Note
Currency
Exchange Rate
Global Tax Calculation
Department
Transaction Source
Transaction Location Type
Amount
Required
Account
Required
Payment Method
Description
Transaction Type
Entity
Class
Check Number
Tax Code
Tax Applicable On
Cash Back Account
Cash Back Amount
Cash Back Memo
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Customer
Required
Email
Send Later?
Billing_address
Credit_memo_date
Credit_memo_number
Auto Generate Credit Memo Number
Class
Amount
Required
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
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Customer
Required
Number
Line_amount
Required
Line_description
Line Item/Product
Line Item Quantity
Line_item_tax_code
Line Item Service Date
Rate
Tax_calculation
Transaction Date
Expiration_date
Ship Date
Message displayed on estimate
Billing_address
Billing Address City
Billing Address Country
Billing Address Postal Code
Billing Address State/Province
Shipping_address
Shipping Address City
Shipping Address Country
Shipping Address Postal Code
Shipping Address State/Province
Shipping amount
Bill Email
Send later
Discount_value
Discount_percent
Class
Sales Terms
Shipping Method
Tracking Number
Private Note
Transaction Status
Apply Tax After Discount
Print Status
Department
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Type
Required
Name
Required
Description_on_sales_forms
Sales Price/Rate
Description_on_purchase_forms
Cost
SKU
Category
Is Taxable?
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Customer
Required
Email
Cc
Bcc
Send Later?
Billing_address
Shipping_address
Terms
Invoice Date
Due_date
Ship_via
Shipping_date
Tracking_number
Invoice Number
Auto Generate Invoice Number
Service Date
Product/Service
Description
Quantity
Rate
Helptext_line_amount
Amount
Tax
Class
Add Bundle Item to invoice?
Message Displayed on Invoice
Message Displayed on Statement
Project ID
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
Deposit To Account
Class
Department
Location
Currency
Exchange Rate
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Customer
Required
Total Amount
Required
Unapplied Amount
Transaction Date
Reference Currency
Payment_method
Payment Reference Number
Deposit To Account
Line_amount
Line Linked Invoice
Memo
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Refund_from
Required
Customer
Email
Billing_address
Refund_receipt_date
Refund_receipt_number
Transaction_class
Payment_method
Check_number
Print Later?
Product/Service
Required
Amount
Required
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
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Info
Invoice
Required
Email
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Time Activity Type
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Customer
Required
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
Job/Parent Customer
Bill with Parent?
Active
Customer_type
Preferred_payment_method
Taxable
Tax_code
Tax Registration Number
Currency
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Invoice
Required
Customer
Email
Cc
Bcc
Send Later?
Billing_address
Shipping_address
Terms
Invoice Date
Due_date
Ship_via
Shipping_date
Tracking_number
Invoice Number
Auto Generate 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
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Purchase ID
Required
Vendor/Customer/Employee
Payment Type
Required
Account
Transaction Date
Payment Method
Document Number
Private Note
Total Amount
Department
Transaction Location Type
Currency
Exchange Rate
Global Tax Calculation
Tax Code
Total Tax
Line Item Detail Type
Required
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Select Vendor
Required
Title
Given Name
Middle Name
Suffix
Family Name
Primary Email Address
Display Name
Fax number
Business Number
Currency Code
Currency Name
Mobile Phone Number
Primary Phone Number
Alternate Phone Number
Active
Vendor 1099
Cost Rate
Billing Rate
Web Address
Company Name
Tax Identifier
Account Number
Print On Check Name
Address__line1
Address__line2
Address__city
Address__state_code
Address__country
Address__zip_code
Balance
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Vendor
Required
Transaction Date
Document Number
Currency
Exchange Rate
Location
Department
Tax Calculation
Memo
Account
Description
Amount
Billable Status
Tax Code
Customer
Class
Product/Service
Description
Quantity
Rate
Amount
Billable Status
Tax Code
Customer
Class
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Stop on error
Required
HTTP Method
Required
URL
Required
Query string parameters
Additional request headers
Body
Action
This is an event a Zap performs.
Write
Create a new record or update an existing record in your app.
Type
Required
Id
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Estimate Id
Doc Number
Customer Name
Transaction Date
Total Amount
Action
This is an event a Zap performs.
Search
Find existing data in your app
WHERE Clause
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Id
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Info
Purchase ID
Document Number
Vendor ID
Vendor Name
Transaction Date
Total Amount
Payment Type
Action
This is an event a Zap performs.
Search
Find existing data in your app
Info
Invoice Number
Invoice ID
Invoice Date
Due Date
Action
This is an event a Zap performs.
Search
Find existing data in your app
Name
Required
Action
This is an event a Zap performs.
Search
Find existing data in your app
Info
ID
Display Name
Primary Email Address
Given Name
Required
Family Name
Required
Middle Name
Employee Phone Number
Birth Date
Billable Time
Active
Release Date
Cost Rate
Employee Mobile
Gender
Hired Date
Organization
Address Line 1
Address Line 2
Address Line 3
Address Line 4
Address Line 5
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
Info
Product Name
Required
SKU
Type
Required
Description_on_sales_forms
Sales Price/Rate
Description_on_purchase_forms
Cost
Category
Is Taxable?
Action
This is an event a Zap performs.
Search or write
Find existing data in your app, or create a new record if no data is found
For AI agents & developers
Use Microsoft Excel and QuickBooks Online with AI agents and code
Beyond Zap workflows. Call Microsoft Excel and QuickBooks Online actions directly from your AI client or your codebase, using the same 9,000+ app integrations Zapier already runs.
No code
Connect via Zapier MCP
Expose Microsoft Excel and QuickBooks Online actions as tools in any MCP client. Authenticate once, then call them in natural language.
Example actions on this page
Add Row
Attach File(s) or Note
Works with
Claude · ChatGPT · Cursor · any MCP-compatible client
There is no Python package yet. SDK is TypeScript-only (@zapier/zapier-sdk). The MCP server URL is personal to your account; get it at zapier.com/mcp.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Practical ways you can use Microsoft Excel and QuickBooks Online
Sync new expenses to Excel
When a new expense is logged in QuickBooks Online, Zapier automatically adds a new row in your designated Microsoft Excel file. This keeps your financial data organized and up-to-date with zero manual entry.
When an invoice is updated in QuickBooks Online, Zapier captures the update in Microsoft Excel. This ensures IT teams monitoring financial workflows have the latest data for analysis or reporting.
When a new project is created in QuickBooks Online, Zapier automatically adds its details into a Microsoft Excel spreadsheet. This helps project managers maintain an up-to-date project database without manual tracking.
Learn how to automate Microsoft Excel on the Zapier blog
Learn how to automate QuickBooks Online on the Zapier blog
Make work flow with AI
Level up your Microsoft Excel to QuickBooks Online integration with AI. Extract, summarize, and transform your integration data with leading AI models like OpenAI, Anthropic, and more.
Frequently Asked Questions about Microsoft Excel + QuickBooks Online integrations
New to automation with Zapier? You're not alone. Here are some answers to common questions about how Zapier works with Microsoft Excel and QuickBooks Online
What is required to integrate Microsoft Excel with QuickBooks Online using our tools?
To integrate Microsoft Excel with QuickBooks Online, you'll need both applications set up and running. You have to utilize our connector, where you create Zaps with triggers from Excel such as 'New Row' or 'Updated Row', and actions in QuickBooks Online like 'Create Sales Receipt' or 'Create Invoice'. Make sure your accounts are authenticated and authorized properly within our platform.
Can I update existing QuickBooks Online records from Excel?
Yes, you can. By setting up a zap where an updated row in Excel acts as the trigger, you can configure actions that update records in QuickBooks Online, such as updating customer details or product information. Just ensure that the mapping fields between Excel rows and QuickBooks records are correctly aligned.
How often do the integrations run between Excel and QuickBooks Online?
Integration runs are dependent on your plan type with us. Generally, Zaps can run at intervals ranging from every 5 minutes to once an hour. For instant updates, ensure that the trigger events are promptly recognized within your setup.
Is it possible to create complex workflows that involve additional steps beyond Microsoft Excel and QuickBooks Online?
Absolutely! Our platform allows for multi-step Zaps where you can include filters, paths, or include other apps like Google Sheets or Slack before completing actions in QuickBooks. This flexibility ensures you can tailor workflows exactly to your business needs.
Are there any limitations when synchronizing data between Microsoft Excel and QuickBooks?
There might be some limitations based on what information is capturable through triggers in Excel or acceptable response actions by QuickBooks online due to API restrictions. It's critical to check which fields are supported during setup to avoid any synchronization issues.
What happens if a trigger event fails during integration?
If a trigger event from Excel fails, we provide detailed logs which help diagnose the problem. You’ll need to check these logs accessible through your dashboard for issue resolution steps or rerun the action manually once corrections are made.
Do I need advanced technical skills to set up integrations between Microsoft Excel and QuickBooks Online?
No advanced technical skills are required to set up these integrations. Our platform's user-friendly interface provides step-by-step guidance throughout creating and managing zaps between Microsoft Excel triggers and QuickBook Online actions ensuring easy accessibility for all users.
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.
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.
