Connect Run my Accounts and Microsoft Excel to unlock the power of automation
- No credit card required
- Free forever for core features
- 14-day trial for premium features and apps
Choose a Trigger
Choose an Action
How Zapier works
Zapier makes it easy to integrate Run my Accounts with Microsoft Excel - no code necessary. See how you can get setup in minutes.
Select a trigger from Run my Accounts
A trigger is an event that starts your Zap and runs the workflow. For example, with Run my Accounts, a trigger could be "New Customers."
Setup an action from Microsoft Excel
An action is what takes place after the automation is triggered. For example, with Microsoft Excel, the action could be "Add Row."
That’s it! You just connected Run my Accounts to Microsoft Excel
With Zapier, it’s never been easier to connect your apps together and automate your most tedious work. Save hours every month.
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
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.
- New Customers
Triggers new customers in Run my Accounts.
Try ItTriggerPolling - New Payments
Payments on accounts receivables.
Try ItTriggerPolling - Invoice NumberRequired
- CurrencyRequired
- Invoice DateRequired
- DuedateRequired
- Vendor NumberRequired
- Vendor NameRequired
- Vendor Contact Salutation
- Vendor Contact Firstname
- Vendor Contact Lastname
- Vendor Address1
- Vendor Address2
- Vendor Zipcode
- Vendor City
- Vendor Country
- Vendor Email
- Vendor Taxnumber
- Vendor Payment Account Number
- Vendor Terms
- Bank Name
- Bank Address 1
- Bank Address 2
- Bank ZIP Code
- Bank City
- Bank Country
- Bank IBAN
- Bank Bic
- Vendor Phone
- Vendor Mobile
- Vendor Fax
- Vendor State
- Invoice Description
- Notes
- Tax Included
- Department
- ESR Number
- Part NumberRequired
- Part Quantity
- Part SellpriceRequired
- Part Description
- Part Discount
- Part Unit
- Payment Account
- Order Number
- Internal Notes
ActionWrite- Customer NumberRequired
- Name
- Type of Contact
- Contact Firstname
- Contact Lastname
- Address1
- Address2
- Zipcode
- City
- Country
- Email
- Taxnumber
- Contact Salutation
- Phone
- Fax
- Payment Account
- Terms
- Remittance Voucher
ActionWrite
- New Invoices
Trigger to fetch newly created invoices.
Try ItTriggerPolling - Invoice NumberRequired
- DatepaidRequired
- Amount PaidRequired
- Payment Account NumberRequired
- Memo
- Source
ActionWrite- Invoice NumberRequired
- CurrencyRequired
- Invoice DateRequired
- DuedateRequired
- Customer NumberRequired
- Customer NameRequired
- Customer Address1
- Customer Address2
- Customer Zipcode
- Customer City
- Customer Country
- Customer Email
- Customer Contact Salutation
- Customer Contact Firstname
- Customer Contact Lastname
- Customer Taxnumber
- Customer Terms
- Bank Name
- Bank Address 1
- Bank Address 2
- Bank ZIP Code
- Bank City
- Bank Country
- Bank IBAN
- Bank Bic
- Customer Phone
- Customer Mobile
- Customer Fax
- Customer State
- Invoice Description
- Notes
- Tax Included
- Department
- ESR Number
- Part NumberRequired
- Part Quantity
- Part SellpriceRequired
- Part Description
- Part Discount
- Part Unit
- Payment Account
- Order Number
- Internal Notes
ActionWrite- General Ledger ReferenceRequired
- Invoice DateRequired
- Debit Account NumberRequired
- Credit Account NumberRequired
- AmountRequired
- Invoice Description
- CurrencyRequired
- Exchange Rate
- Notes
- Department ID
ActionWrite
Learn how to automate Microsoft Excel on the Zapier blog
Related categories
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.
Related categories