Collection sheet

Owned by Sangamesh Nadagoudar
Last updated: Jun 30, 2019 by Massabe Lydiane
4 min read

Collection sheet & Productive collection sheet - can be generated for the collections to be made for JLG Loan account + Charge and Recurring deposit mandatory account only. Collection is now also extended with productive collection sheet. 

a) Productive collection: - generates collections to be made by staff. For example: Staff John is associated with center 1 & center 2. Meeting date falling on same date - 01 January, 2010. So on generating productive collection sheet on 01 January, 2010 will display both centers collection sheet under staff John. 

 b) Collection sheet: - generates collection sheet without staff as well by selecting group, center. 

Individual collection - can be generated for the collections to be made for individual loan account + charge only. For more information, please refer - Individual collection sheet.

On this page:

Tip: It's mandatory to attach meeting in either to use collection sheet.  

Attaching meeting at Center Manage Centers.
Attaching meeting at Group Manage Group Meetings.  

To make a repayment using the collection sheet (and productive collection sheet)

The collection sheet is a way to create bulk transactions for repayment of loans (For more information, please Click Here). You can use collection sheet in two ways.

  • Using it as Productive Collection Sheet where you have to provide three parameters, namely Office, Meeting Date and Staff & later you can chose respective centers before submission.
  • Using it just as 'Collection Sheet' where you can provide Office, Meeting Date, Staff and Center. Providing 'Group Name' is optional here. 

Using Productive Collection Sheet:

  • Go to the left panel and click on 'Collection Sheet'.

  • The following window appears, provide office name, meeting date and staff.

  • Click on 'Productive Collection Sheet' to see the following window where you can select the center (The selected center is shown with Amber color). It also shows Branch Office Name, Meeting Date and center total collection for the given meeting date in terms of loan product. Here, 16200 is the collection for one loan product and 321 is the collection for the other loan product.

  • Click on  button to see the details of the collection group-wise and client-wise for the selected center as shown below or you can simply click on 'Submit and Next center' button. 

  • As you can see, there are two groups and each group with their three clients. IGL is the loan product (short name) for the group 'Santa Maria Group 2' and VRL is the loan product for the group 'Santa Maria Group 1'. You can see 'Due' for each client as well as the due for each group and you can also see Attendance where using drop-down menu, you can select whether the client is present, Absent, Leave, Late or Approved.
  • Once you verify that all the details are correct, you just click on 'Submit' button. 

Using Collection Sheet:

  • Go to the left panel and click on 'Collection Sheet' to see the following window.
      

  • Provide all the details (Selecting Group is optional. If you select the group, the collection sheet for that group is shown only, otherwise the collection sheet for all the groups for the selected center will be shown) and click on 'Collection Sheet' button to see the following window. 

  • Just like the previous one, verify the details and click on 'Submit' button. If everything goes fine, You will get the message "Collection Sheet Saved Successfully". 

Capturing payment details for collection sheet: 

Step 1) Define payment types in Admin >> Organization >> Payment type, as shown in the screenshot below. 

Step 2) Click on collection sheet:
             a - Select "Branch office", 
             b - Select Date - "Meeting calendar",
             c - Select "Staff",
             d - Select "Center", 
             e - If required select "Group".
Click on "Collection sheet"
Step 3) Once the collection sheet gets generated, at the bottom you would find:
 "Add payment type" button, Click on that. 
Step 4) In Payment type: By Inputting required fields you can capture details i.e Payment type, Account #, Receipt #, etc.

Note: As of now, for Productive collection sheet "Add payment type" is not available in the present version. 



Key Error Messages


For repayments of client loan accounts see How to Make Repayments on a Client Loan Account. 

For repayments of group loan accounts see How to Make Repayments on a Group Loan Account.