QuickBooks Online + monday.com + Microsoft Excel Integrations

How to connect QuickBooks Online + monday.com + Microsoft Excel

Zapier lets you send info between QuickBooks Online and monday.com and Microsoft Excel 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 Online + monday.com + Microsoft Excel

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 Online, monday.com, and Microsoft Excel. 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 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
- Board IDRequired
Trigger
Instant
Try It
- Board IDRequired
- Column IDsRequired
Trigger
Instant
Try It
- Board IDRequired
Trigger
Instant
Try It
- Board IDRequired
Action
Write
- Item IDRequired
Action
Write
- Board IDRequired
- Item IDRequired
- Override empty fields
Action
Write
- Board IDRequired
- Column TitleRequired
- Column TypeRequired
Action
Write
- Board IDRequired
- Group ID
- Item NameRequired
- Subitem Name
Action
Write
- Item IDRequired
- BodyRequired
Action
Write
- Item IDRequired
Action
Write
- Board IDRequired
- Item IDRequired
- ColumnRequired
- FileRequired
- File NameRequired
Action
Write
- Board IDRequired
- Column to search inRequired
Action
Search
- Board IDRequired
- Item IDRequired
- Column
Action
Search
- Board IDRequired
Action
Search
- Board IDRequired
- User :Required
Action
Search
- 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
- Board IDRequired
Trigger
Instant
Try It
New Board
Triggers when a new board is created.
Trigger
Scheduled
Try It
- Board IDRequired
- Column IDRequired
Trigger
Instant
Try It
New User
Triggers when a new user joins your monday.com account.
Trigger
Scheduled
Try It
- Board IDRequired
- Group IDRequired
Action
Write
- Board IDRequired
- Item IDRequired
- New Item Name ValueRequired
Action
Write
- Board NameRequired
- Board KindRequired
- Template Id
Action
Write
- Board IDRequired
- Group NameRequired
Action
Write
- Board IDRequired
- Item NameRequired
- Subitem NameRequired
Action
Write
- Board IDRequired
- Group IDRequired
Action
Write
- Board IDRequired
- Group IDRequired
- New Group Title
- Should add group to top?
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Board IDRequired
Action
Search
- Board IDRequired
- Item IDRequired
- ColumnRequired
Action
Search
- Board IDRequired
- Item IDRequired
Action
Search
- 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

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How QuickBooks Online + monday.com + Microsoft Excel Integrations Work

Step 1: Authenticate QuickBooks Online, monday.com, and Microsoft Excel.
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 Online + monday.com + Microsoft Excel

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

About monday.com

monday.com helps you move projects forward fast, letting everyone know what's been done on a task—and what needs finished right now.

Learn more Help

Related categories

Project Management

Similar apps

Trello

Project Management

Asana

Project Management

Insightly

CRM (Customer Relationship Management)

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

PRODUCTS

CAPABILITIES

By team

QuickBooks Online + monday.com + Microsoft Excel Integrations

How to connect QuickBooks Online + monday.com + Microsoft Excel

Do even more with QuickBooks Online + monday.com + Microsoft Excel

New Account

New Customer

New Expense

New Invoice

New Payment

New Sales Receipt

New Vendor

Create Bill (Account Based)

Terms

Transaction Date

Due Date

Bill Number

Department

Currency

Global Tax Calculation

Description

AmountRequired

Billable?

Customer

Class

AccountRequired

Tax Code

AP Account

Memo

Create Credit Memo

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

Create Estimate

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

Create Product/Service

TypeRequired

NameRequired

Description On Sales Forms

Sales Price/Rate

Description On Purchase Forms

Cost

SKU