Co Optive user guide / Setting up a new society
Before you start
The details, lists and balances to collect from the society before anything is entered in Co Optive.
Collect everything on this page before anyone starts typing. Most delays come from missing or mismatched data, not from the app. Keep each list in a spreadsheet, one row per item.
Data sheets
Use these sheets to collect the data. Each one is a CSV file that opens in Excel or LibreOffice. The first row names the columns. The rows below it are examples from the made-up sample society: delete them and type in your own. Keep dates as YYYY-MM-DD.
| Sheet | What goes in it |
|---|---|
| 01 Districts and blocks | Each district and block the society or its members are in |
| 02 Branches | Head office and branches |
| 03 Employer branches | Each employer office where members work |
| 04 Holidays | The society's holidays for the year |
| 05 Lists | Entries for drop-downs such as category and religion |
| 06 Users | Each person who will use Co Optive. Leave the password column empty |
| 07 Cash and bank heads | The society's cash in hand and bank accounts |
| 08 GL heads | The chart of accounts |
| 10 Schemes | Every product with its rates and limits |
| 11 Members | Every member, with shares, KYC, salary and nominee |
| 12 Savings | Each savings account and its balance |
| 13 Thrift | Each thrift account, instalment and balance |
| 14 Benevolent | Each benevolent account, instalment and balance |
| 15 Fixed deposits | Each fixed deposit |
| 16 Surety loans | Each loan, with the amount still owed |
| 17 Opening cash | The cash counted on the evening before go-live, by note |
Sheets 09 and 18 are filled in by the support team.
About the society
- Registered name, registration number and head office address
- The bye-laws, or the parts on shares, deposits, loans and interest
- Every branch: name, address, PIN code, district and block
- The financial year the society uses, normally April to March
- The society's holidays for the year, including local ones such as Raja Parba
Employers
Members are employees, and their thrift and loan instalments are taken from their salary. For each employer office where members work, collect:
- Office or branch name and code (for a bank, the branch code)
- Address, PIN code, district and block
- The officer who signs the salary deduction list
People who will use Co Optive
For each person: full name, branch, phone number, e-mail address and the work they will do (creator, releaser, approver or administrator). See Users and roles for what each type can do.
Accounts and schemes
Ask the society's accountant for these:
- The chart of accounts: each account head with its code and name, and whether it is a liability, asset, income or expenditure
- The society's own cash and bank accounts, with bank names and account numbers
- Every product the society offers (savings, thrift, benevolent fund, fixed deposit, recurring deposit, shares, each kind of loan) with its interest rate, period, minimum and maximum amounts
- The board resolution number and date that approved each rate
Members
One row per member, with:
- Member number in the old books, name, father's or husband's name, gender, date of birth
- Mobile number, e-mail address, home address with PIN code
- PAN and Aadhaar
- Employer office, PF number, designation, basic pay, date of joining
- Salary bank account: bank, branch, IFSC and account number
- Nominee: name, age, relationship and address
Balances on the evening before go-live
These must come from the old books after they are closed for the last time. Check each total against the old trial balance before you hand the lists over.
- Shares held by each member: number of shares and amount
- Each savings, thrift and benevolent account: balance and monthly instalment
- Each fixed or recurring deposit: amount, start date, period, rate and maturity date
- Each loan: amount sanctioned, date, amount still owed, interest due, monthly instalment, instalments left, and the sureties
- Cash in hand, counted, with the number of notes of each value
- Each bank account balance, matched to the bank statement