Description
Non-Profit Organization Income Statement Generator is a simple bookkeeping spreadsheet for any non profit organization to generate income statement, called statement of activities in standard financial report, automatically. It is a broad category. It covers from religious organization, charity organization, public foundation, animal NGO etc.
There are 2 different bookkeeping versions. One yearly bookkeeping version (re-use the original file every year to generate subsequent one year report) and 5 yearly bookkeeping version (re-use the original file every 5 years).
In this spreadsheet, you can record income/expenses and group those transactions into particular projects or programs. There are 2 different classification applied for non profit financial statement in this report. With donor restrictions and without donor restrictions. It follows international accounting naming for non profit organization accounting report.
WITH DONOR RESTRICTIONS is a classification where any transactions are allocated for particular project/program and are not allowed to be used outside those project/program
WITHOUT DONOR RESTRICTIONS is a classification for general use, usually for operational of the organization
In this spreadsheet, statement of activities is divided into 2 parts only. Revenue and Expenses. And there are 5 different income statement format where all of them are fully editable and 2 optional report that should be useful if you plan to track revenue and expenses of particular projects or programs. With this flexibility, you can present suitable income statement format to particular parties.
You don’t need accounting background to record your business transactions. Just fill the transaction and all income statements will be generated automatically.
Remember that statement of activities report is different from cash flow report. Balance from each report might be different since not all cash transactions are parts of income statement. You might check my other bookkeeping spreadsheet for a spreadsheet with a more complete financial statements.
Fits to you who wants to monitor and track your business using Microsoft Excel and don’t want to spend time on sophisticated and standalone accounting software.
You can use it as :
– Your main spreadsheet to record any business transaction
– Your supporting spreadsheet to record summary of daily, weekly or monthly transaction generated from your other application
