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

• 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 to raise invoices in bulk on ADDA?

  There are two ways to post invoices in bulk on ADDA i.e using Excel and Batch Upload. 1. Excel Posting:- Step 1: Go to Admin >> Income Tracker >> Member Income >> Bulk Posting. Step 2: Post Invoices in Bulk >> Posting via Excel >> You can select ...

• How does the advance collection allocation work on ADDA?

  ADDA offers two modes of advance collection: Mode 1: Collection through Payment Gateway (ADDA Resident App) Request ADDA support to enable the advance payment feature for your ADDA by emailing to support@adda.io Once enabled, residents can go to the ...

• 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. ...