Please refer list of topics below. If you did not find solution of your question. Write us on support@teamob.co.in
Upon successful install of theme. Close the spreadsheet.
Open your google drive and go to Housing folder (During installation add-on has created this to copy the theme)
Open the theme and visit Housing Society > Start
Open the control panel/Sidebar (ignore if already opened). To open visit Add-ons > Housing Society > Start
Click on Settings. This will open setting sheet.
If you wanted to use SMS service. Subscribe it from any service provider of your choice. Ask them to provide you SMS gateway URL, key and sender name
Update these details in B2 to B4
In B4 update TEST or LIVE. In case of TEST you will be able to see SMS API calls in popup.
Update expenses head in A8 to A40
Update total number of flats in F2
In FAQ we have used the term side bar to represent the window opens in right of screen. This opens up when you click on Add-ons (Top Menu) > Housing Society > Start. The dashboard (First Screen) of side bar has buttons to access all the features. When you click on any button it will open another page along with related sheet. This sub page might have some other buttons/actions relevant for selected sheet only. To return back to dashboard, click on HOME icon present in top left of side bar.
Home icon redirect back on dashboard (First Screen) of side bar if you have navigated down the pages.
Click on Unit button of control panel
it will open Master sheet.
keep first entry "Others" as it is. This is to store unidentified transactions.
Follow the instructions written in control panel for each column.
Wing: Wing number like A/B/C
Unit: Apartment number like A101
Name: Name of Apartment owner
Mode: Maintenance payment mode. There are only 2 options Monthly or Yearly
Maintenance Suggestion: Amount to be paid
Live Status: Who is living in the apartment. Options are Owner or Rent
Previous Year Balance: Total previous due available on apartment
Group: Select MC if person living in apartment is member of management committee
Update vehicle details under column car1, car2 etc
This sheet has been designed to manage one year data. In subsequent years make copy of sheet and transfer apartment details only (Master sheet) along with sum of due amounts per apartment.
In control panel click on Bill Maintenance button.
Select payment mode. This will filter only those units where billing preference is same as selected payment mode.
If required filter the units on wing.
Enter billing date
In tabular section (A7:J7). Select unit. It will automatically populate name, default particulars and amount.
Repeat the process for all units to whom you wanted to bill
Press Save button present in top right of side bar.
After save you will get a confirmation alert.
For fast billing, add-on offer provision to bill all apartments together. Hence there is no need to select the units manually. Here is step to do bulk maintenance
If you are not on maintenance page click on "Bill Maintenance" button
Click on bulk maintenance button present in top right of side bar.
This will open Bulk Maintenance page.
Enter billing dates in cell A3
If you wanted to filter results on wing and billing frequency. Select it in B3, C3 (Optional)
Press "Generate" button present in side bar
This will populate all units with their maintenance amount in cell range A4 to E
Verify all entries
Make sure you have not billed any apartment for same month. If so delete the row to avoid duplicates.
Press Save button present in side bar.
Upon success it will show you an alert.
Open the side bar. Ignore if already opened.
Make sure you are on dashboard of side bar. If not click on HOME icon present in top left of sidebar.
Click on Receipt button
This will open Payment sheets.
Cell number C4 and E4 can be used to filter the unit/apartment suggestion. If you dont want to filter delete it. To delete click on cell C4/E4 and press DELETE button of your keyboard.
Double click on cell A7 to see calendar. Click on date
Click on B7 and type unit number or select from the list.
Upon selection of unit, it will automatically populate the name.
Click on E7 and select payment type. Below are the options
Maintenance: If the receipt is related to invoice you sent for maintenance.
Interest: If the receipt is bank interest.
Suspense: You dont know about the source of receipt.
Guest: If your society has guest house and this receipt is against its booking
Hall: If your society has community hall and this receipt is against its booking
Fine: If you are collecting this amount as fine
Late fee: If you are collecting this amount as late fee of maintenance (Only applicable if your society has implemented late fee for maintenance)
Others: If receipt is for some thing else not listed here.
Choose Mode (Cash/Bank)
Enter receipt number if you are issuing physical copy of receipt for reference.
No need to write any thing under Due and Late fee column. This is just for your reference.
Enter Amount you are receiving.
Repeat the process if you have more receipts in sub subsequent rows.
Press Save button present in top right of side bar
If you receive late fee along with maintenance receipt either in cash or in bank make two separate entry. eg if you receive payment of 3000 in bank from flat number A101 where 2800 is maintenance amount and 200 is late fee. Make entry in receipt form like below
When you select any unit to register receipt and choose "Maintenance" under Payment For column. Add-on automatically suggest total due amount pending on unit along with late fee. This is just for your reference and no need to edit it here.
If you are on any internal pages and wanted to return back on dashboard. Click on HOME icon present in top left of side bar.
Click on receipt button present in dashboard of sidebar to open Reports sheet.
In cell B2 select Transactions.
In cell D2 enter start date. In E2 enter end date. (Double click on cell to open calendar). Required date format is YYYY-MM-DD ie 2019-06-01
In cell G2 select the transaction type. If you wanted to view all transactions except entries of invoiced amount. Select "Excluding invoiced" in this cell.
Select Generate Report button present in top right of sidebar.
To filter the result set for specific flat select flat number in cell I2.
To filter the result set for cash or bank entries select in I3 cell.
In bottom of summary sheet you can view monthly income and expenditure. But if you wanted to view income and expenditure for a selected period, this report is useful.
In dashboard of sidebar click on receipt report button.
Sidebar will load another UI with two buttons.
Click on Generate Income/Expenditure Report button.
This will open another sheet (IncomeExpenditure).
Select start date in cell B2 and end date in cell C2.
Select Generate Report button present in top right of sidebar.
Click on receipt report button to open Reports sheet
In cell B2 select Due list
Press Generate Report button present in top right of side bar
To filter the report wing wise. Select wing in cell D2
Invoice Report: This is to list all invoices generated in particular month. Select it in cell B2. In cell D2 select month and press Generate Report button present in top right of side bar.
Search Unit: This is to display selected unit descriptions eg owner/tenant name, contact number, parking position, transaction history. To print this report select it in cell B2 and in cell D2 select unit. Press Generate Report button present in top right of side bar.
Owner Report: To print all owner names and contact number living in society.
Tenant Report: To print all units which is occupied by tenants.
Transactions: To print all invoices and receipts made during selected period.
Due list: To print all units which has maintenance due.
Statement Report: This is summarize report of bank statement you did in BankStatement sheet.
Account Report: To summarize opening cash and bank balances, payment received in cash and bank, expenses made in cash and bank, closing balance of bank and cash in hand.
Vehicle Search: To search the owner name using vehicle number.
To reconcile the monthly receipts and expenses it is required to summarize transactions of bank statement. This is also an important part of workflow of this add-on. Obtain the bank statement for the period you are about to reconcile. To describe the flow further I assume month is January.
Click on Bank Statement button present in dashboard.
This will open the sheet BankStatement.
Get the opening balance from bank statement and update in cell B2
In cell C2 update total cash amount you have in start of month ie opening balance of cash for month of January.
From bank statement summarize total amount of cheque deposited in bank and update it in cell D2
Summarize total cash deposited in bank and update it in cell E2
Summarize total NEFT/IMPS transactions and update in cell F2.
Summarize total interest and update in cell G2
If there is any other receipts summarize and update in H2
Summarize all the expenses made using cheque and update in I2
Summarize all the cash withdraw and update in J2
Summarize NEFT/IMPS payments and update in cell K2
Summarize all bank charges and update in cell L2
If there is any other withdrawal present in bank statement. Summarize and update it M2
Cell N2 will show closing balance of bank statement. Please double check and if this does not match with actual closing balance of bank statement. You might miss few entries to summarize.
In cell O2 update the total number of closing cash balance you have in hand for month of January.
Click on ledger button in dashboard of side bar.
In cell D2 select the flat number
In cell D3 select start period and in cell D4 select end period. To view the calendar double click on box.
Press Print ledger button.
If you wanted to print ledger of more than one flat in one go. You can use this feature. This is limited to print ledger of 30 units in one round. If you have more units repeat the process.
In cell D2 select the flat number. If you select say A101. It will print ledger of units starting from A101 ie A102, A103, B101, B102 etc upto 30 units.
In cell D3 and D4 select start and end period. (Double click on it to see calendar)
Print on Bulk ledger button.
It will open another sheet "BulkLedger" and you can see ledgers of units one below another.
Once printed make sure to clear BulkLedger sheet for future prints.
Click on expenses button in dashboard.
In cell A5 enter date in format of YYYY-MM-DD (Double click on cell to view calendar).
In cell B5 select expense head.
In cell D5 select expense mode ie Cash or Bank
In cell E5 enter voucher number
In cell F5 enter description of expense.
In cell K5 enter amount.
Repeat the process in subsequent rows to register more expense entries.
Press Save button present in top right of side bar.
Click on expense report button present in dashboard of side bar
It will open expenseReport sheet.
In cell C2 and D2 enter start and end period eg 2019-01-01, 2019-01-31
In cell C3 select the head (Keep blank if you wanted to print all expenses)
Press Generate report button present in top right of side bar.
To filter the expenses on cash or bank select in cell C4
In cell D4 select Head wise if you wanted to organize entries together.
Click on Unit in dashboard of side bar to open Master sheet.
Search the unit number and its corresponding F$ cell select Rent.
Update tenant name and contact number in cell J$ and K$.
In cell E$ make sure monthly maintenance which you will bill to this unit further is correct.
Click on Unit in dashboard of side bar to open Master sheet.
Search the unit number and its corresponding F$ cell select Owner.
In cell E$ make sure monthly maintenance which you will bill to this unit further is correct.
Click on SMS button present in dashboard of side bar.
In cell C2 select Invoice
Predefined content will load in cell C4. Modify the content if required.
In cell C11 select Invoice receivers
In cell E11 select month
Press Send button present in top right of side bar.
If SMS went successfully text color will change to green. If there is error it will be red.
If you dont want to send SMS to any number write 1 in corresponding D$ cell.
In dashboard click on SMS button to open SMS sheet. Ignore if already opened.
Select Due reminder in cell C2.
In cell C11 select due reminder.
This will populate list of units which has due.
Click on Send button present in top right.
Late fee is XX/- per month as defined in setting page. It calculates as follows. If maintenance amount is 2000, late fee is 100/- month and it is due since last 4 months.
Late fee = 400+300+200+100 = 1000