How to make Debit/Credit Entry in bulk through excel?
iSocietyManager help you import Debit and credit note in bulk. This will help to save you a lots of time. Following steps to import Debit and credit note.
Step 1: Go to Main Menu (Payment), Select “Import Payment Receipt” option from drop down menu
Step 2: Click on “Download Template“.
Step 4: Once excel file will be downloaded. In Excel file we have to provide the data given in the template
- Flat No : Unit No
- Transaction Date : Date of Debit or credit note
- Amount : Amount of Debit or credit
- Type of Payment: We can make Credit in case of credit entries and same you can make Debit in case of debit note
- Payment mode: We can make Credit in case of credit entries and same you can make Debit in case of debit note.
- Bill Plan : Name of the bill plan for which you want to make a debit or credit. e.g. Maintenance, Electricity, Miscellaneous.
- Note* CGST, SGST, IGST, TDS, Remarks, GL Code, Society Account is not mandatory.
Once the Debit and credit template is ready, then you can now import the excel sheet in iSocietyManager.
Step 3: Click on Choose File then choose the payment template excel file.
Step 4: Click on Upload Payment button.
Once you click on Upload payment then it will show successful message
Leave a Reply
You must be logged in to post a comment.