How to Export/Import all Customers (Debtors) party list in Excel format in SwilERP (RetailGraph)

Export/Import all Customers (Debtors) party list

How to Export/Import all Customers (Debtors) party list in Excel format in SwilERP (RetailGraph)


Customer's or Debtor’s Ledgers Option in SwilERP Software facilitates the user to easily view the ledger account and balances of the Customers/debtors and can also modify & print the ledgers as per their requirement.
To export the Customers/Debtors list in Excel format,  the user will follow the below steps: 

Start with Login in the SwilERP dashboard to initiate the process:

  1. Firstly, go to the Options menu.
  2. Select Export/Import Data option.
Reference Image:
SwilERP Window

Process to Export & Import Customers List:

  1. A new window of 'Export/Import Data' will appear on the next slide.
  2. Go to the Others section.
  3. Now click on the Customer to export/import.
  4. After clicking on the customer tab, here Customer Columns will appear, where the user can select the column as per their requirements.
Reference Image:
Export/Import Data Window
  1. Select the required fields from the Customer Columns in which you want to export and import the data.
  2. Here is given Select All option; you can tick-mark on it to choose all fields. (when If you want to Export/Import all columns)
  3. Users can also apply a Filter from the Customer tab.
  4. After selecting columns, click on the Export option to export the selected fields.
  5. And to import a file click on the Import option.
Reference Image:
Export/Import File
  1. Suppose you click on the Export option, a new window for selecting a path will appear on the next slide.
  2. Choose the Path and enter the Name of the file to save it.
  3. Click on the Save option, and an Excel file will automatically open in your system.
Reference Image:
Select Path To Save File
  1. While you click on the Import option, a new window for selecting a path will appear on the next slide.
  2. Choose the Path where your document is saved and then select the File Name which you want to import.
  3. Click on the Open option to import the selected file.
Reference image:
Select File to Import
  1. After that, you will get a "File Has Been Imported Successfully" message.
Reference Image:
Successful Message

 After following the above steps, the debtor's list will get exported and imported in Excel format.



      • Related Articles

      • Export/Import all Vendors (Creditors) party list

        How to Export/Import Vendors (Sundry Creditors) in Excel in SwilERP (RetailGraph) In SwilERP Software, the user can easily Export and Import the Ledger accounts and balances of the vendors and can also modify & print the ledgers as per their ...
      • Export/ Import Customer and Vendor List

        How to Export/ Import Customer and Vendor List in SwilERP What is a Vendor/ Customer? Vendors play an essential role in the supply chain process for pharma businesses that sell goods. A vendor is an individual or company that supplies products to ...
      • How to Export/ Import Master data

        How do exporting/importing master data in SwilERP (RetailGraph)? In RetailGraph, you have the feature to export the master data to excel sheets. You can export blank template files for master data creation using the Export/Import Master Data option ...
      • Export/Import Vouchers

        How to Export/Import Vouchers in SwilERP (RetailGraph) Software Vouchers are used to process current accounting entries, allocations, and corrections for which other means of entry into the financial system are unavailable. In SwilERP, we have a ...
      • Import/Export Inventory

        How to Import/Export Product | Product Category | Marketing Group In SwilERP When the user wants to add the Products name/ Products Category and Marketing Groups names into an Excel sheet, then they can export the details in an Excel file. After ...