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