Money tips

Expense tracking for a NGO treasurer: a simple system

How an NGO treasurer in India can track money with one simple system: fund tags, ten categories, a weekly routine and a monthly bank check.

Editorial illustration for Expense tracking for a NGO treasurer: a simple system

An NGO treasurer needs one simple system: a separate bank account for the organisation, one line in a sheet for every rupee in or out, a bill or voucher photo for every spend, and a monthly tick-off against the bank statement. Keep to about ten categories and a fixed weekly slot, and the system will survive a busy week.

How does money move through a small NGO?

Money arrives in lumps and is often tied to a purpose: a grant instalment for a particular project, donations by UPI and cheque, membership or event contributions. It leaves in many small pieces: stipends, travel, printing, workshop food. The treasurer's real job is to know, on any given day, how much of the balance is free and how much belongs to a project.

That is why the bank balance alone is not enough. Add a column called fund next to every entry, with the value General or the name of the project.

Which categories fit an NGO?

  • Programme costs, one sub-line per project
  • Staff salaries and stipends
  • Volunteer travel and food
  • Rent and utilities
  • Printing and communication
  • Events and workshops
  • Professional fees, such as audit and accounting
  • Equipment and repairs
  • Bank charges
  • Advances to team members, not yet settled

On the income side, keep grants, UPI donations, cheque or cash donations, membership or event income, and interest as separate lines.

What does one month look like?

Take simple, made-up numbers. A ₹3,00,000 grant instalment is meant for Project A, and ₹45,000 of general donations arrives by UPI. Project A spends ₹1,60,000 on programme costs and ₹60,000 on stipends. General costs are rent ₹15,000, travel ₹12,000, printing ₹8,000, professional fees ₹10,000 and admin ₹5,000.

FundMoney inMoney outLeft
Project A₹3,00,000₹2,20,000₹80,000
General₹45,000₹50,000₹5,000 short
Total₹3,45,000₹2,70,000₹75,000

The overall surplus of ₹75,000 looks comfortable, but it hides that general costs ran ₹5,000 ahead of general income. Whether project money may cover general costs depends on the grant terms, so ask the funder or your auditor rather than assuming.

What routine survives a busy week?

  1. Pay every expense from the organisation's account, or from a petty cash float recorded in a register.
  2. Photograph the bill or voucher the same day and name the file with the date and amount.
  3. Once a week, for twenty minutes, add the entries to the sheet with the fund tag.
  4. Once a month, tick each sheet line against the bank statement and write down anything that does not match.
  5. Give the committee a one-page summary: money in, money out and balance by fund.

What is easy to forget?

  • Advances given to volunteers that were never settled with a bill.
  • Cash collected at events that never reached the bank.
  • Donations in kind, which deserve a note even without a value.
  • Bank charges and interest credits.
  • Money received late in the month that belongs to the next month's plan.

What should the monthly report to the committee show?

A single page is enough if it answers the questions trustees actually ask.

  • Opening balance, by fund
  • Money in, by source
  • Money out, by category
  • Advances still unsettled, with names and dates
  • Items on the bank statement that are not yet in the sheet
  • Large payments due next month

The arithmetic should be easy to follow. If the general fund opened at ₹30,000, received ₹45,000 and spent ₹50,000, it closes at ₹30,000 plus ₹45,000 minus ₹50,000, which is ₹25,000. Anyone on the committee can check that in seconds, and that is the point of a short report.

Where does a personal tracker fit?

If you pay some costs from your own pocket and wait to be reimbursed, keep those in your own record as well. SpendixAI can take your own account's statement and let you add cash expenses by hand, with receipts kept beside each transaction, which suits a treasurer's personal money. It is a personal tool: Pro covers one personal workspace and is not a team or approvals system, so the organisation's books belong in the organisation's own ledger.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports