Microsoft Excel + Sage Intacct
Update rows in Microsoft Excel when new invoices are created in Sage Intacct
Whenever a new invoice is created in Sage Intacct, this workflow will promptly update a corresponding row in your Microsoft Excel. This ensures your spreadsheets maintain up-to-date records, giving you more time to focus on your core business, and less on manual updates. Manage your financial records more efficiently with this Sage Intacct to Microsoft Excel workflow.
Whenever a new invoice is created in Sage Intacct, this workflow will promptly update a corresponding row in your Microsoft Excel. This ensures your spreadsheets maintain up-to-date records, giving you more time to focus on your core business, and less on manual updates. Manage your financial records more efficiently with this Sage Intacct to Microsoft Excel workflow.
- When this happens...
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Suggested Contact NameRequired
Print AsRequired
Last Name
First Name
Middle Name
Prefix
Company Name
Primary Email Address
Secondary Email Address
Primary Phone
Secondary Phone
Mobile Phone
Pager
Fax
Address Line 1
Address Line 2
Address Line 3
City
State or Territory
ZIP or Postal Code
Country
ISO Country Code
Primary URL
Secondary URL
Status
Discount
Is Taxable?
Tax ID
Show in Contact List
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice DateRequired
Due DateRequired
Action
Invoice Number
Reference Number
Description
Document ID
Base Currency
Transaction Currency
Exchange Rate - Date
Exchange Rate - Rate
Exchange Rate - Type ID
Customer Message - Choose Existing Message
Customer Message - Custom Message
Contacts - Pay To
Contacts - Return To
Contacts - Return To - Tax ID
Contacts - Return To - Tax Group
Billback Template
Attachment
CustomerRequired
Customer - Delivery Options
Payment Term
Tax Solution Key
Invoice Summary
Transaction AmountRequired
GL AccountRequired
Override Offset GL Account
Memo
Allocation
Account Label
Location
Department
Employee
Project
Customer
Vendor
Item
Warehouse
Class
Task
Cost Type
Asset
Contract
Affiliate Entity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document type
VendorRequired
Transaction dateRequired
Date
Rate
Type ID
Payment term
Shipping method
Attachment
Tax solution
Source document
Primary contact
Ship to contact
Bill to contact
Deliver to contact
ItemRequired
UnitRequired
QuantityRequired
Unit priceRequired
Line description
Line memo
Location
Warehouse
Department
Project
Task
Class
Customer
Employee
Subtotals
History records
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.CustomerRequired
Name
Sales Representative
Customer Type
Territory
Parent Customer
Shipping Method
Payment Term
Account Group
Price List
Price Schedule
Override Offset GL Account
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document type
Vendor invoiceRequired
Vendor
Transaction date
Date
Rate
Type ID
Payment term
Shipping method
Attachment
Tax solution
Source document
Primary contact
Ship to contact
Bill to contact
Deliver to contact
Item
Unit
Quantity
Unit price
Line description
Line memo
Location
Warehouse
Department
Project
Task
Class
Customer
Employee
Subtotals
History records
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Find Customer
Finds a customer based on search criteria.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Vendor
Finds a vendor based on a search criteria.
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPlan Restrictions
Storage Source
Folder
WorkbookRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPlan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
TableRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
Column IndexRequired
Apply To
Header Preservation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
TitleRequired
Column Headers
Zap Step Id
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet NameRequired
Column Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Payment Received (Accounts Receivable)
Triggers when a new AR payment is added.
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDue DateRequired
Created DateRequired
Vendor
Transaction AmountRequired
GL AccountRequired
Total Transaction Amount
Memo
Location
Department
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.NameRequired
Sales Representative
Customer Type
Territory
Parent
Shipping Method
Term
Account Group
Price List
Price Schedule
Override Offset GL Account
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Project resource
Project
Employee
Item
Labor rate
Expense rate
AP and purchasing rate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.BillRequired
Vendor
Payment term
Tax solution
Attachment
Bill summary
Location
Bill back template
Fully paid date
Pay to contact
Return to contact
Base currency
Transaction currency
Exchange rate date
Exchange rate
Exchange rate type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.InvoiceRequired
Invoice Date
Due Date
Action
Invoice Number
Reference Number
Description
Document ID
Base Currency
Transaction Currency
Exchange Rate - Date
Exchange Rate - Rate
Exchange Rate - Type ID
Customer Message - Choose Existing Message
Customer Message - Custom Message
Contacts - Pay To
Contacts - Return To
Contacts - Return To - Tax ID
Contacts - Return To - Tax Group
Billback Template
Attachment
Customer
Customer - Delivery Options
Payment Term
Tax Solution Key
Invoice Summary
Line Item Key
Transaction Amount
GL Account
Override Offset GL Account
Memo
Allocation
Account Label
Location
Department
Employee
Project
Customer
Vendor
Item
Warehouse
Class
Task
Cost Type
Asset
Contract
Affiliate Entity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Find Bill
Finds a bill based on a search criteria.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Invoice
Finds a invoice based on a search criteria.
ActionThis is an event a Zap performs.SearchFind existing data in your appFind Invoices
Finds invoices within a date range.
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
TableRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPlan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planPlan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
RangeRequired
Apply To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
Row IDRequired
Apply To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet NameRequired
Column Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
New NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Plan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet NameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan Restrictions
Storage Source
Folder
WorkbookRequired
Worksheet IDRequired
Row IDRequired
No Match Copy
ActionThis is an event a Zap performs.SearchFind existing data in your appPlan Restrictions
Storage Source
Folder
WorkbookRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Microsoft Excel
Related categories
About Sage Intacct
Related categories
Related Zap Templates
- Add rows in Microsoft Excel for new invoices in Sage Intacct
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Add rows in Microsoft Excel for new invoices in Sage Intacct
- Create spreadsheets in Microsoft Excel for new invoices in Sage Intacct
- Create new Sage Intacct contacts from updated rows in Microsoft Excel
- Add rows to Microsoft Excel table for new invoices in Sage Intacct
- Create contacts in Sage Intacct for new rows in Microsoft Excel table
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from updated rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Update Sage Intacct contacts from new Microsoft Excel rows
- Create new Sage Intacct contacts from updated rows in Microsoft Excel
- Create Sage Intacct contacts from new rows in your Microsoft Excel table
- Create contacts in Sage Intacct from new rows in Microsoft Excel table
- Create new Sage Intacct contacts from new rows in Microsoft Excel table
- Update Sage Intacct contacts when new rows get updated in Microsoft Excel
- Create new Sage Intacct contacts from new Microsoft Excel rows
- Create new Sage Intacct contacts from new rows in your Microsoft Excel table
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from newly added rows in Microsoft Excel table
Related Zap Templates
- Add rows in Microsoft Excel for new invoices in Sage Intacct
- Create spreadsheets in Microsoft Excel for new invoices in Sage Intacct
- Create contacts in Sage Intacct for new rows in Microsoft Excel table
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from updated rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Update Sage Intacct contacts from new Microsoft Excel rows
- Add rows in Microsoft Excel for new invoices in Sage Intacct
- Add rows to Microsoft Excel table for new invoices in Sage Intacct
- Create new Sage Intacct contacts from updated rows in Microsoft Excel
- Create new Sage Intacct contacts from new rows in Microsoft Excel
- Create new Sage Intacct contacts from updated rows in Microsoft Excel