Microsoft Excel + Sage Accounting

Create rows in Microsoft Excel for new sales invoices in Sage Accounting

With this workflow, as soon as a new sales invoice is created in Sage Accounting, a corresponding row is instantly added to your Microsoft Excel spreadsheet. This seamless process ensures all sales data is readily available in your Excel reports, saving you the manual effort and potential errors associated with data entry tasks. Make your financial tracking more efficient with this Sage Accounting and Microsoft Excel integration.

When this happens...
New Sales Invoice
Triggers when a new sales invoice is created.
TriggerPolling
automatically do this!
Add Row
Adds a new row to the end of a worksheet.
ActionWrite

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

Supported triggers and actions

New Contact Payment
Triggers when a new contact payment is created.
Trigger
Polling
Try It
New Customer
Triggers when a new customer is created.
Trigger
Polling
Try It
New Product
Triggers when a new product is created.
Trigger
Polling
Try It
New Sales Quote
Triggers when a new sales Quote is created.
Trigger
Polling
Try It
New Stock Item
Triggers when a new stock item is created.
Trigger
Polling
Try It

Updated Product
Triggers when a product is updated.
Trigger
Polling
Try It
Updated Sales Invoice
Triggers when a sales invoice is updated.
Trigger
Polling
Try It

Updated Service
Triggers when a service is updated.
Trigger
Polling
Try It
New Customer
Triggers when a new customer is created.
Trigger
Polling
Try It
- Payment ReferenceRequired
- Payment DateRequired
- Total Payment AmountRequired
Action
Write
Create Purchase Invoice
Creates a new purchase invoice.
Action
Write
- Business NameRequired
- Reference
- Notes
- Credit Limit
- Credit Term Days
Action
Write
- DateRequired
- Invoice Number Prefix
- Invoice Number
- Reference
- Notes
- Terms And Conditions
- Sent
Action
Write
- DescriptionRequired
- Item Code
- Notes
- Active
Action
Write
- Contact NameRequired
- Contact ReferenceRequired
- Payment ReferenceRequired
- Payment DateRequired
- Total Payment AmountRequired
Action
Write
Update Purchase Invoice
Triggers when an existing purchase invoice is updated.
Action
Write
- Date
- Quote Number Prefix
- Quote Number
- Reference
- Notes
- Terms And Conditions
- Sent
Action
Write
- Description
- Item Code
- Notes
- Active
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Filter by Contact Name or Reference
- Filter by Updated or Created Since the Given Date
- Filter by From Date
- Filter by To Date
Action
Search
- Business Name or Reference to search for the Contact GUIDRequired
Action
Search
- Invoice Number or ReferenceRequired
Action
Search
- Service Code or DescriptionRequired
Action
Search
- Business Name or Reference to search for the Contact GUIDRequired
Action
Search
- Invoice ReferenceRequired
Action
Search or write
- Product Code or DescriptionRequired
- DescriptionRequired
- Item Code
- Notes
- Active
Action
Search or write
- Quote Number or ReferenceRequired
Action
Search or write
- NameRequired
- DescriptionRequired
- Item Code
- Notes
- Active
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Column IndexRequired
- Apply To
- Header Preservation
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- TitleRequired
- Column Headers
- Zap Step Id
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- RowRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Search or write

New Purchase Invoice
Triggers when a new purchase invoice is created.
Trigger
Polling
Try It
Updated Contact
Triggers when an existing contact is updated.
Trigger
Polling
Try It
New Sales Invoice
Triggers when a new sales invoice is created.
Trigger
Polling
Try It
New Service
Triggers when a new service is created.
Trigger
Polling
Try It
Updated Contact Payment
Triggers when an existing contact payment is updated.
Trigger
Polling
Try It
Updated Purchase Invoice
Triggers when an existing purchase invoice is updated.
Trigger
Polling
Try It
Updated Sales Quote
Triggers when a sales Quote is updated.
Trigger
Polling
Try It
Updated Stock Item
Triggers when a stock item is updated.
Trigger
Polling
Try It
- Contact NameRequired
- Contact ReferenceRequired
- Payment ReferenceRequired
- Payment DateRequired
- Total Payment AmountRequired
Action
Write
- Payment Reference
- Payment DateRequired
- Total Payment AmountRequired
Action
Write
- Business NameRequired
- Notes
Action
Write
- DescriptionRequired
- Item Code
- Notes
- Active
Action
Write
Create Sales Quote
Creates a new sales Quote.
Action
Write
- DescriptionRequired
- Item Code
- Notes
- Active
Action
Write
- Description
- Item Code
- Notes
- Active
Action
Write
- Date
- Invoice Number Prefix
- Invoice Number
- Reference
- Notes
- Terms And Conditions
- Sent
Action
Write
- Description
- Item Code
- Notes
- Active
Action
Write
- Business NameRequired
- Reference
- Notes
- Credit Limit
- Credit Term Days
Action
Write
- Enter the Nominal Code or Ledger Account Diplay Name to return the Ledger Account IDRequired
Action
Search
- Invoice ReferenceRequired
Action
Search
- Product Code or DescriptionRequired
Action
Search
- Quote Number or ReferenceRequired
Action
Search
- NameRequired
Action
Search
- Filter by Contact Name or Reference
- Filter by Updated or Created Since the Given Date
- Filter by From Date
- Filter by To Date
- Contact NameRequired
- Contact ReferenceRequired
- Payment ReferenceRequired
- Payment DateRequired
- Total Payment AmountRequired
Action
Search or write
- Business Name or Reference to search for the Contact GUIDRequired
- Business NameRequired
- Reference
- Notes
- Credit Limit
- Credit Term Days
Action
Search or write
- Invoice Number or ReferenceRequired
- DateRequired
- Invoice Number Prefix
- Reference
- Notes
- Terms And Conditions
- Sent
Action
Search or write
- Service Code or DescriptionRequired
- DescriptionRequired
- Item Code
- Notes
- Active
Action
Search or write
- Business Name or Reference to search for the Contact GUIDRequired
- Business NameRequired
- Reference
- Notes
- Credit Limit
- Credit Term Days
Action
Search or write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- TableRequired
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Trigger Column
Trigger
Polling
Try It
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- RangeRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- Apply To
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
- Column Headers
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- New NameRequired
Action
Write
- Api Docs Info
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet NameRequired
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- Worksheet IDRequired
- Row IDRequired
- No Match Copy
Action
Search
- Plan Restrictions
- Storage Source
- Folder
- WorkbookRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search or write

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.

Learn more

Related categories

Similar apps

About Sage Accounting

Award winning accounting from the leader in financial accounting software. Manage invoicing, cash flow, tax, payments and more from any device through the cloud.

Related categories

Accounting

Related Zap Templates

Create new Sage Accounting products from Microsoft Excel rows when new rows are added

Create spreadsheets in Microsoft Excel for every new sales invoice in Sage Accounting

Add new rows in Microsoft Excel for new purchase invoices in Sage Accounting

Microsoft Excel + Sage Accounting

Create rows in Microsoft Excel for new sales invoices in Sage Accounting

New Contact Payment

New Customer

New Product

New Sales Quote

New Stock Item

Updated Product

Updated Sales Invoice

Updated Service

New Customer

Create Other Payment/Money Out

Create Purchase Invoice

Create Customer

Create Sales Invoice

Create Service

Update Contact Payment

Update Purchase Invoice

Update Sales Quote

Update Stock Item

API Request (Beta)

Find Contact Payment

Find Contact

Find Sales Invoice

Find Service

Find Vendor

Find or Create Create Purchase Invoice

Find or Create Product

Find or Create Create Sales Quote

Find or Create Stock Item

New Row

New Worksheet

Add Row

Add Row to Table

Clear Column by Index

Create Workbook

Delete Worksheet

Update Row

Find Row

Get Cells in Range

Get Worksheet by ID

Find or Create Worksheet

New Purchase Invoice

Updated Contact

New Sales Invoice

New Service

Updated Contact Payment

Updated Purchase Invoice

Updated Sales Quote

Updated Stock Item

Create Contact Payment

Create Other Receipt/Money In

Update Contact

Create Product

Create Sales Quote

Create Stock Item

Update Product

Update Sales Invoice

Update Service

Create Vendor

Find Ledger Account

Find Purchase Invoice

Find Product

Find Sales Quote

Find Stock Item

Find or Create Create Contact Payment

Find or Create Customer Creation

Find or Create Sales Invoice

Find or Create Service

Find or Create Vendor Creation

New Row in Table

Updated Row

Add Row(s)

Clear Cells by Range

Clear Row by ID

Create Worksheet

Rename Worksheet

API Request (Beta)

Find Worksheet(s)

Get Row by ID