How to Post the Collection in batch or using excel Template?

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. 
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 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 TypeDescription
1Cheque
2BankTransfer(e.g.: NEFT)
3Cash
4DD

    • Related Articles

    • How to Upload Non Member Income in Batch & Excel Template ?

      Please follow the below steps to post None Member Income entries in Bulk: Step 1: Go to Admin Dashboard >>Income Tracker >> Non-Member Income. Step 2: Bulk Posting >> Post Invoices & Collection in Bulk >> There are two ways as below: 1. Batch Upload: ...
    • How to Post Credit note in batch or through excel template?

      As an admin, if you intend to waive any charges for owners or tenants, you can generate a Credit Note. You can post credit notes in bulk by following the steps outlined below: Batch upload:- Step 1: Login to ADDA >> Admin >> Income Tracker >> Member ...
    • How can I set a Budget Amount for Expense Heads Using Excel Template?

      Please follow the steps below to set a Budget Amount for Expense Heads Using Excel Template : Step 1: Login to ADDA ->> Admin –>> Expense Tracker –>> Budget. Step 2: Click on the “Setup Via Excel Upload” tab, you will find a new popup window open up. ...
    • How to generate invoices using ‘Preview and Post Invoices’?

      Now, you have the ability to generate multiple invoices according to your predefined settings for any day of the month, eliminating the need to manually complete an Excel template. Please follow the steps below to generate invoices using this option: ...
    • How to upload the journal entries in batch ?

      Bulk upload can be done using an excel file: Step 1: Login to ADDA -->> Admin -->> General Ledger Step 2: Click on the "Journal Entries" Tab -->> Bulk Posting. Step 3: Click on “Batch Upload Journal Entries From Excel” Step 4: Download .csv File ...