TallyPrime and Microsoft Excel automations
TallyPrime holds vouchers like receipts, and Microsoft Excel gets each one as a row through “Add Row To Table”.
Set up an automation: when new receipt event occurs in TallyPrime, add row to table in Microsoft Excel
Build it50agents builds it as an automation, and asks before anything goes outside.
TallyPrime and Microsoft Excel in practice
Used for
TallyPrime holds vouchers like receipts, and Microsoft Excel gets each one as a row through “Add Row To Table”.
Best template
“New Receipt event occurs” in TallyPrime, then “Add Row To Table” in Microsoft Excel. Each receipt recorded in Tally Prime adds a row to an Excel table.
Watch out
“New Receipt event occurs” fires on create, update or delete, so one receipt can add several rows.
TallyPrime and Microsoft Excel templates
Pick one and Captain builds it with you.


When no purchase activity detected in TallyPrime, add row to table in Microsoft Excel
Build this

When new account statement event occur in TallyPrime, add row to table in Microsoft Excel
Build this

When new delivery note event occurs in TallyPrime, add row to table in Microsoft Excel
Build this

When new purchase order event occurs in TallyPrime, add row to table in Microsoft Excel
Build this

When new receipt event occurs in TallyPrime, add row to table in Microsoft Excel
Build this

When new debit note event occurs in TallyPrime, add row to table in Microsoft Excel
Build this

When no purchase activity detected in TallyPrime, update row in Microsoft Excel
Build this

When new account statement event occur in TallyPrime, update row in Microsoft Excel
Build this

When new delivery note event occurs in TallyPrime, update row in Microsoft Excel
Build this

When new purchase order event occurs in TallyPrime, update row in Microsoft Excel
Build this

When new receipt event occurs in TallyPrime, update row in Microsoft Excel
Build this

When new debit note event occurs in TallyPrime, update row in Microsoft Excel
Build this
TallyPrime and Microsoft Excel triggers and actions
Every one of both apps. A trigger starts the work; actions are the steps.
Triggers
13- New sales event occursRuns when a sales voucher is created, updated, deleted, or saved as PDF in TallyPrime.
- New purchase event occursRuns when a new purchase voucher is created in a chosen company.
- New debit note event occursRuns when a debit note is created, updated, deleted, or saved as PDF in a chosen company.
- New credit note event occursRuns when a credit note is created, updated, or deleted in Tally Prime. Choose voucher types to filter.
- New payment event occursRuns when a payment is created, updated, or deleted in Tally Prime.
- New receipt event occursRuns when a receipt is created, updated, or deleted in Tally Prime. Choose voucher types to filter.
- New sales order event occursRuns when a sales order is created, updated, or deleted. Choose voucher types to filter.
- New purchase order event occursRuns when a purchase order is created, updated, deleted, or saved as PDF in a chosen company.
- New delivery note event occursRuns when a delivery note is created, updated, deleted, or saved as PDF in a chosen company.
- New account statement event occurRuns when a new receipt note is recorded in Tally Prime.
- New payment due reminderRuns when new payment due reminder is received. Optionally filter by company or customer.
- No purchase activity detectedRuns when no purchase activity is recorded for a chosen period.
- Account statement exportedRuns when a new account statement is created.
No triggers match.
Actions
4- Find rowFind a Row in a table by column and value
- Create spreadsheetCreate a New Spreadsheet
- Update rowUpdate Row
- Add row to tableAdd a row to an Excel table
No actions match.
Questions about TallyPrime and Microsoft Excel
What can start a TallyPrime and Microsoft Excel automation?
“No purchase activity detected”, “New account statement event occur”, “New delivery note event occurs”, “New purchase order event occurs” and “New receipt event occurs”, and the others in the templates above.
Which other apps work with both TallyPrime and Microsoft Excel?
Notion, WooCommerce, RouteLogic and APITemplate.io. Each one has templates with TallyPrime and with Microsoft Excel, so a third app can join the same job.
All TallyPrime integrations · All Microsoft Excel integrations · Every app, A to Z
Connect TallyPrime and Microsoft Excel
Or pick another template above. Free to start.
Build it with Captain