âī¸Exporting & Import Expenses to Tally
How to Export Accounts from Tally to Pemo
Press
Ctrl+E
(Export) > Select Masters or Transactions.Press
C
(Configure) to set the export options:For Masters, choose the type of master (e.g., ledger) or select All Masters to export everything.
File Format: Export as CSV, or convert the exported file into CSV format to import into Pemo.
How to Import Expenses from Pemo into Tally
After exporting your expense data from Pemo, follow these steps to import it into Tally. Depending on your version of Tally, use the relevant method below:
For Tally Versions that Accept XML Files Only
Open the CSV export from Pemo in Excel.
Identify the column data that needs to be copied into the XML Generator Template.
Use the template to generate the XML file required by Tally. Ensure column headers remain unchanged.
đ Watch this video for guidance on using the XML Generator Template.
Pemo Power Tip: Make sure to keep the column headers unchanged. This helps prevent any confusion when working with the template below.
đĨ Download the XML Generator Template
For Tally Versions that Accept Excel Sheets
Save the CSV file from Pemo as an Excel sheet.
In Tally, go to the Import option on the toolbar:
Select Transactions from the dropdown:
Choose the saved Excel file to import.
Pick the Pemo Mapping Template:
Pemo Power Tip: You need to create a Pemo Mapping Template that maps Tally fields to Pemo export file headers before using the import feature. Below is a sample template for reference
Last updated