How to Export Tally Data from SwilERP Software
SwilERP features the option for their users to export vouchers for tally. Users can export the data from SwilERP to do accounting in tally. The voucher is a supporting document for accounting. And the Master data will help you find every master of accounts. To import the voucher in tally, you need to export the voucher file in XML format. With SwilERP, you can easily export the voucher data by selecting parameters. But first, you have to export masters data and then export the vouchers with the same selected date range. Users can find this option from Import/ Export Data section in system form.
This option allows you to Tick or Untick few details that you want to include or exclude in the exported data. As below written:
- Master: Users select the master option to include all masters detail in the exported data.
- Location with account and group: Always tick-mark on this option to include location wise details.
- Closing stock value: When you tick-mark on this option, the closing stock value will include.
- Opening balance: When you tick-mark on this option, the opening balance will include.
- Alias with customer A/c: If you want alias detail, then tick-mark on it.
- Exclude bank vouchers: If you want to exclude bank vouchers then tick-mark on it.
Start with Login in SwilERP dashboard to initiate the process
- Go to the System> Import/ Export> Import Patient Opening Balance
Reference image:
How to Export Data for Tally
After that, you will see Export/Import Data window. Follow the below-mentioned steps to initiate the process:
Step:1) Export Master Data
- In the next slide will appear a new Import patient opening balance window.
- Go to the Transaction section and click on the Export for Tally option.
- Select the Given Options to include them in the exported file. (Information regarding these options is given at the starting of the article)
- To export the master data it is mandatory tick mark on the Master option.
- Select the Rupees symbol from the given options. (Select the rupees symbol as per tally)
- Select the Date Range "From" to "To" in which in you want to export the Masters. (Only the selected date range data will be exported)
- Users can also Regenerate Closing Stock for the given dates by clicking on it.
- Click on the Export for Tally option to export the file into XML format.
- Select the option between Summary and Detail in which you want to export the Master Data.
Note: To export the Master Data you have to tick-mark on the "Master" and "Location with A/c and Group".
As shown in the below-given image:
- Press OK to continue.
- After that, a pop-up window will appear to select the file path to save it.
- Enter the File Name and Save the file in your selected path.
As shown in the below-given image:
- After saving the file in your system.
- You will get the "Data Exported Successfully" message in the next slide.
Reference image:
Step:2 Export Vouchers Data
After exporting master data now you have to export the Voucher Data. For this follow the below-mentioned steps.
- Follow the same process as written in "step 1", but the only thing you have to do is untick the Master option.
- Click on the option and tick mark on the voucher by applying a filter on it.
- Select same Date Range as same you selected while exporting the master data.
- Now, export the data by clicking on the Export For Tally option.
Reference image: