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.