Skip to content

Donors: import, duplicates, merge, PAN and donor portal

Import donors from Excel/CSV, fix "donor already exists", merge duplicate donors, reveal PAN, and help donors log in to the donor portal

Donors4 min readChecked 12 Nov 2026
On this page

Import donors

On Donors, click + New → Import donors. Upload .csv, .xlsx or .xls, up to 5,000 rows per file. Use Download template for the right columns.

  • Required: name.
  • Optional: email, phone, pan, type, category, address, city, state, pincode, nationality, notes, notifyNewProjects.
  • type must be INDIVIDUAL, CORPORATE, INSTITUTION, GOVERNMENT or FOREIGN.
  • category must be ONE_TIME, RECURRING, MAJOR or CSR_PARTNER.

Row errors and fixes:

  • "Donor name is required": fill the name.
  • PAN "X" is invalid (expected ABCDE1234F): 5 letters, 4 digits, 1 letter.
  • "Maximum 5000 rows per import. Split into multiple files."
  • "Your plan allows N ... Upgrade or remove some before importing."

Undo an import within 24 hours; after that: "Undo window expired (24h)".

"A donor with similar details already exists"

A donor with the same email, phone or ID number is already saved. Open that donor instead of adding a new one.

Merge duplicate donors

  1. Go to Donors and tick two or more donors.
  2. Click Merge and pick the record to keep.
  3. Empty fields on the kept record are filled from the others, tags are combined, and donations move to the kept donor. If any record had opted out of emails, the merged donor stays opted out.

Find donors who gave nothing this month and remind them

  1. Open Donations and click No gift this month (or open Donors and pick a period under Date range, then click "Show donors who gave nothing instead").
  2. The list shows donors with no verified donation in that period, including donors who never gave. Pick another month with Date range.
  3. Tick the donors and click Email reminder. Confirm the count: sent emails can't be recalled.
  4. The message afterwards says how many were sent and how many were skipped: unsubscribed or no email, blocked or bounced address, or already reminded this month. Reminded rows show "Reminded <date>", and a donor gets this reminder at most once a month.
  • You can send to at most 200 donors at a time.

PAN

PAN is shown masked. People with donor-management permission can click to reveal it; every reveal is recorded in the Activity log.

Donor portal

Donors sign in at /donor-portal with the email or mobile number on their donor record and a 6-digit code (sent by email, or by SMS for a mobile number). They stay signed in for 30 days. The portal link in a receipt email opens a page that sends the code with one tap and then shows that gift's year.

  • "That code didn't match": check the code. "That code has expired" or "Too many tries": tap Resend code.
  • "We have no gifts under this email/number": the email or mobile must match the donor record. Check it on the donor and save it.
  • A mobile number shared by two donors at the same NGO (for example a family phone) can't be used to sign in; those donors sign in by email.
  • "Too many sign-ins from this network": wait a few minutes or use mobile data.
  • The portal can be shown in English, Hindi, Marathi, Bengali, Tamil, Telugu, Kannada or Gujarati with the globe button.

What donors can do there:

  • For your tax filing, FY …: download the Statement (PDF) and All receipts (ZIP) for a year (April to March). From April to July the portal opens on the year just ended. If a receipt couldn't be added to the ZIP, the donor is told which one to ask you for.
  • Form 10BE: shows once you have sent Form 10BE for that year from Compliance; until then donors see "Your Form 10BE appears here after {your NGO} files it".
  • Add PAN: if gifts are held back from 80G only because PAN is missing, donors can add it once; the next download of those receipts shows 80G. Receipts already emailed don't change. The PAN on file is shown masked.
  • Goods you gave: in-kind gifts are listed apart and never counted in money totals, 80G or the statement.
  • Monthly gifts: shows the status in plain words ("Payment failing" with Update payment). Stop cancels the Razorpay subscription straight away (an active one ends after the period already paid for) and emails you. If it can't be cancelled automatically, you get a bell alert and an email asking you to cancel it in Razorpay.
  • My details and preferences: address, birthday and anniversary wishes, and Email me updates and appeals (turning it off unsubscribes them; receipts are always sent).
  • Ask {your NGO} to delete my data: creates a request under Data requests and emails you. Reply within 30 days. For a donor with no email, the request names their mobile and donor record; delete that donor by hand.
  • A donor who gives to several NGOs with the same email or mobile can switch between them (not on an NGO's own domain).

Still stuck? Talk to a person

Call or WhatsApp +91 90227 38129, or write to us.