Getting started

Adding members and importing them from a CSV file

Add members one by one or in bulk from a spreadsheet, set membership numbers, opening balances and haptas per month, and invite members to see their own savings.

3 min read Admins & treasurers Updated 30 October 2026
All guides

In MandalHisab a member is a person who saves with the Mandal. A member does not need a login — the treasurer can run everything. Members who want to check their own savings on their phone can be invited later, and they only ever see their own records.

Add one member

  1. 1

    Open Members and tap “Add member”

    Or use the + button in the bottom bar and choose Add member.

  2. 2

    Enter the full name

    This is the only required field.

  3. 3

    Membership number

    Leave it blank and MandalHisab numbers members automatically (M0001, M0002…), or type your own numbers to match the old register. Letters, digits and / - _ are allowed.

  4. 4

    Joining date, mobile, email and address

    All optional. The mobile number lets the treasurer call a member straight from the dues list.

  5. 5

    Haptas per month

    1 for most members. Use 2 or 3 if they pay that many haptas every month under one name.

  6. 6

    Invite to the app (optional)

    Tick Invite to the app by email if they should see their own savings. They set their own password.

  7. 7

    Save

    The member appears in the list and, if the monthly hapta is set up, is enrolled from their joining month.

Import many members at once

If your members are already in a spreadsheet, tap Import CSV on the Members screen. Export your sheet as a CSV file (in Excel or Google Sheets: File → Download → CSV, maximum 2 MB), then choose it. MandalHisab first checks the file and tells you how many members are ready to import, how many will be skipped and any errors — nothing is saved until you tap Import.

ColumnRequired?Notes
nameYesThe member's full name
membership numberNoLeave blank to auto-number
phoneNoMobile number
emailNoNeeded only to invite them to the app
addressNo
joining dateNoYYYY-MM-DD or DD-MM-YYYY
notesNoAnything else worth keeping
Rows with a membership number or phone that already exists are skipped, so running the same file twice won't create duplicates.

Opening balances

If the Mandal has been running before MandalHisab, each member already has savings. Open the member and add their opening balance — the total they had saved up to your starting date. Their savings passbook then starts from that amount, and every later hapta, interest credit and withdrawal adds to or takes from it.

Opening balances and later corrections are recorded as audited adjustments with a reason, so anyone checking the books can see where a number came from.

Member status

  • Active — pays hapta and appears on the monthly screen.
  • Inactive — paused; no new hapta is created, but their history and savings stay.
  • Left — has left the Mandal, usually after their savings are paid out.

Members are never deleted, because their payments are part of the Mandal's history. Changing the status keeps the books complete.

Something in this guide doesn't match what you see, or your Mandal works differently? Tell us — we update the guides as the app changes.

Bring your Mandal's hisab online

Free during early access. Set up in a few minutes.