Pemo works with Tally through a CSV file: you export your expenses from Pemo and import the file into Tally. The process has five parts:
Mirror your Tally Chart of Accounts in Pemo manually or through a CSV import.
Prepare your Pemo export by assigning the correct Account and Supplier to each expense.
Export your expense data from Pemo as a CSV that matches your Tally account setup. See How to create a CSV template for downloading your transactions.
Prepare the file for your Tally version. Pemo always gives you a CSV file, so convert it to XML or re-save it yourself if your Tally setup needs a different format.
Import the file into Tally, review the entries and make quick adjustments if needed.
Note: Tally is highly customizable. You can import your Pemo data into Tally - for example using the universal template - and generate your reports from Tally.
Before you start
You need to be a Super Admin, Admin or Accountant (Internal or External). Web only.
Sync your Tally setup with Pemo
Tally uses “Ledgers” to track accounts. To ensure everything lines up, your accounts in Pemo must mirror these ledgers.
You can create accounts manually in Pemo or import them using a CSV file with ID and Name columns, as in the Chart of accounts template.
Export ledgers from Tally
Open your company in Tally.
Go to Display → Statements of Inventory / Statement of Accounts → Statistics → Ledgers.
On the Ledgers screen, press E or select Export.
Choose Excel as the format.
You can follow the same steps to export your list of suppliers.
Import into Pemo
Re-save the exported file as a CSV with ID and Name columns, then import it in Accounting export → Settings → Required for export → Chart of accounts.
Export transactions from Pemo
Once your accounts and suppliers are mapped, you can filter transactions by period and export them using your Tally CSV template.
Go to Accounting export in the left sidebar.
Set the period in the Date filter.
Tick the transactions you want to export.
Select Download.
Under Choose CSV template, choose the Tally CSV template you set up.
Select Download.
Convert CSV to XML for Tally
If your Tally version imports XML, convert the CSV to Tally's XML import format first. Pemo does not provide an XML converter, so use the conversion tool your Tally partner or accountant recommends.
Important: Keep the column headers exactly as Pemo exported them, so they map to the right Tally fields.
Import into Tally
For Tally versions that accept XML
Open the converted XML file.
Import it directly into Tally through the import screen.
For Tally versions that accept Excel
Before importing, set up a mapping template in Tally that matches Pemo’s column headers with Tally’s fields.
Re-save the CSV that Pemo exported as an Excel .xlsx file.
In Tally, go to Import → Select Transactions.
Choose the saved file and assign your Pemo Mapping Template.
Verify the import and check that accounts and suppliers align correctly.

