Bank Statement Conversion for Nonprofit Form 990

What Form 990 asks for

Form 990 is built around two financial statements that a bank account can largely feed. Part VIII, the Statement of Revenue, breaks incoming funds into sources, and Part IX, the Statement of Functional Expenses, reports every expense across three functions. A smaller organization often runs on cash accounting through one or two bank accounts, so the year's activity is mostly there in the statements. The problem is that a statement PDF is not something you can total or slice by category. Converting it to a CSV turns the deposits and payments into rows you can sort, which is what lets you build the two 990 schedules from data rather than from a highlighter.

Part VIII: revenue by source

Part VIII does not want one revenue number; it wants revenue split by where it came from: contributions and grants, which includes membership dues, fundraising-event income, and noncash gifts, then program service revenue, investment income, and any unrelated business revenue. With the deposits in a CSV you sort and total each source, tying grant deposits to their award letters and program fees to the service that earned them, while setting aside transfers and loan proceeds that are not revenue. That per-source total is exactly what Part VIII lines expect, and it traces back to specific deposits rather than a lump figure.

Part IX: expenses by function

Part IX is where nonprofits differ most from a business return: every expense is classified two ways, by its natural type across the schedule's lines, salaries, rent, supplies, and so on, and by its function into three columns, program services, management and general, and fundraising. So a single payment gets both a line and a column. In a converted CSV you tag each payment to its type and its function, and split a shared cost like rent or a director's salary across functions on a reasonable basis. Totaling by column then gives the program, overhead, and fundraising figures that show a funder how the money was used.

What isn't in the bank statement

The bank covers cash in and cash out, but several 990 figures come from elsewhere. Noncash and in-kind contributions, donated goods, services, or stock, are revenue on Part VIII and may need Schedule M, yet they never touch the account. Pledges and grants receivable recognized but not yet collected sit outside the cash the statement shows. And depreciation on buildings or equipment is a functional expense figured from basis, not a payment. Use the converted statements for the cash lines and add these items from your other records, so the 990 is complete rather than cash-only.

Transparency and privacy

Form 990 is a public document, so the figures behind it should be clean and defensible, and keeping the converted transaction data alongside the filing shows exactly how each revenue and expense total was derived if a board member or funder asks. Because a nonprofit's records can include donor activity, statements are processed to build the CSV and then deleted automatically, with nothing retained on a server afterward, which keeps organization and donor detail out of a third-party tool. For a bookkeeper preparing several organizations' 990s, that combination of fast per-column totals and automatic deletion keeps the work quick and confidential.

Frequently Asked Questions