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

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:

Go to Direct Posting >> Invoices & Collection in Batch >> In the new window, Select the Non-Member Income Account >> Select Instrument Type >> Instrument Bank (put the Bank name) >> Instrument Number ( Reference Number) >> Select Deposited In Bank A/C(Interna Bank Account) >> Comment >> Amount >> Date >> Click on Calculate Total >> Click on Save.




2. Excel Upload:

i. Posting via Excel >> Invoice & Collection using Excel >> In the new window, in step 1 download excel template >> Save in CSV format >> In excel template >> In Column C Non Member Income Account* (mention GL no of Non member income account) >> In Column D Instrument Type* (fill up Instrument type like Cheque 1 , Net Banking 2, Cash 3, DD 4) >> In column E Instrument No* (fill up cheque no.) >> In Column Instrument Bank* (mention bank name) >> In column G Bank Account (Mention here bank GL no.) — >> In Column H Comment* >> In column I Amount* >> In column J (Cheque date Or cheque received date.) >> Save this template in CSV format.


ii. Again Go to the Non-Member Income Tab >> Click on Batch Upload Non-Member Income from excel >> Go to the step 3 and Browse this template >> Click on Upload Document Tab >> In the window, preview will be shown >> Verify the details and click on Calculate Total >> Save. 

    • Related Articles

    • What is the difference between Member and Non Member Income?

      Member Income: This refers to revenue generated from the members of the apartment community or residential association. Members are typically the residents or homeowners who are part of the community. Member income sources may include monthly ...

    • How to upload opening balance for non-member income?

      Please follow the below steps to upload opening balance for non-members: The capability to upload opening balance for Non-Member Income is exclusive to the ADDA Moderator. Step 1: Log in to ADDA>> Admin >> Income Tracker>> Non-Member Income Step 2: ...

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

    • What is Income Tracker ?

      Income Tracker is a specialised module within the ADDA platform designed to streamline and manage both member(Resident) and non-member(Other Than Resident) incomes for residential communities and homeowners associations.

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