Create bulk ledger in Suvit

Suvit helps in creating 1000s of ledgers in bulk within some minutes. Here you can also utilize the GST Mapping feature to create ledgers using GST Portal


Create Bulk Ledgers in Suvit

Step 1: Login

1 img.png

2 img.png

  • Click on "Explore Now" under Data Entry Automation

Step 2: Bulk Upload

3 img.png

  • Navigate to Bulk Upload > Ledger.

1bulkledger.png

  • Click the Download button to get the Sample Sheet.
  • Download the Sample sheet Ledger.xlsx from here.

Step 3: Fill in the Excel Sheet

12022-11-16_1035512016.png

  • Open the downloaded Excel sheet and fill in the required details (Name & Under are mandatory).
  • Locate the GST Number column and enter valid GST numbers for each party.

Step 4: Upload the Excel File

3bulkledger1.png

  • Upload the Ledger File
  • If there are any duplicate names or errors, an error log will be generated with details.

6 img.png

  • Click on the file for Next step.

Step 5: Map Fields for Ledgers

Method 1: GST Mapping for Party Creation

GST MAP 1.png

  • Select the GST Field in the uploaded Excel sheet.
  • Click GST MAPPING to fetch details from the GST Portal.

GST MAP 2.png

  • The system retrieves Party Name, State, and Tax Information based on the GST Number.
  • Choose the name as per "Trade Name" or "Business Name" from the Which name would you prefer to use for ledger creation? as shown above image.
  • Proceed to the next step for Save & Proceed .

Method 2: Map Fields for Party Creation

ledger map 1.png

  • After uploading, you will be taken to the Mapping Field Page. Map the Excel sheet fields with the system fields and click "Save & Proceed" to finalize the ledger creation.

Step 6: Confirmation

6master6.png

  • If there are any issues, a popup will display the errors.
  • You can view the errors directly or download the Excel error log for reference.

Step 7: Save & Send

8master7.png

  • Go back to the Ledger Transaction Page, select the record you want to import, and click Save.
  • Click on the right-side option "Send to Tally".

Step 8: Send to Tally

10master9.png

  • A confirmation popup will appear. Click OK to proceed or Cancel to stop.

11master10.png

  • The system will sync data with Tally, ensuring successful synchronization.

Step 9: Verify in Tally

  • After receiving the message "Your data process has been completed", check Tally.
  • The ledger masters will now be available in Tally.

You May Find This Useful:

  • Learn more about creating bulk stock items in Suvit.