How to Post the Collection in batch or using excel Template?
Please follow the below steps to post the offline collection entries in bulk such as Cheque payments, Direct Bank Transfer or Cash:
Batch upload :
Step 1 :- Go to Admin >>Income Tracker >> Bulk Posting.
Step 1 :- Go to Admin >>Income Tracker >> Bulk Posting.
Step2:- Post Collections in Bulk >> Direct Posting >> Click on "Collection in Batch".
Step 3: In the new window, enter the Payment Amount Received >> Select Instrument Type >> Instrument Number ( Put the Cheque no. ) >> Instrument Bank (put the Bank name) >> Comment >> Select Bank & Cash A/c >> Date >> Click on Calculate Total >> Click on Save on the bottom of the page.
Excel Upload:-
Step 1 :- Go to Admin >>Income Tracker >> Bulk Posting.
Step 1 :- Go to Admin >>Income Tracker >> Bulk Posting.
Step 2: Post Collections in Bulk >> Posting via Excel >> Click on "Collection using Excel".
Step 2 :- In the new window, download the excel template as step 1 >> Save in CSV format >> In excel template Column H (fill up Amount*) >> In column I (fill up Instrument Type*) >> In column J (fill up Instrument No*) >> In column K (Fill up Instrument Bank name) >> In column L (Comment*) >> In column (Bank GL No*) >> In column N (Date of Payment)
Step 3 :- Again go to the batch posting > > Click on Collections using Excel >> Go to the step 3 >> Click on Browse this template > > Click on Upload document > > Open new window you will have a preview. Verify the details and go down > > Click on Calculate total >> Click on Save.
Enter the Instrument Type only from the following list :
| Instrument Type | Description |
| 1 | Cheque |
| 2 | BankTransfer(e.g.: NEFT) |
| 3 | Cash |
| 4 | DD |