Cash flow Statements that Work for You
Setting up a cash flow statement that works for you is not difficult. The goal is to use simple journal entries and get totals quickly providing a snapshot view of the health of a non-profit. You can generally set one up in less than one hour and it will be valid until you make a dramatic change. In order to create a working cash flow statement you will need to do some initial work to set it up to work for you.
It is not difficult to set up an excel spread sheet to track your income and expenses and automatically generate a profit and loss statement. Here is how to create it:
A) Identify Sources of Income - The first step is to identify all possible sources of income. This can usually be achieved by using prior years statements. Categorize the income so that it works best for your organization. Typical income categories would include grants, donations and sponsors. Create a tab on your spreadsheet (usually tab 2) and label it Income;
B) Identify Expense Categories - Expenses do not typically change from year to year, however you have the luxury of breaking expenses down into minute detail if you wish. Once you have identified the individual categories of expenses, create a tab on your spreadsheet (usually tab 3) and label it Expenses;
C) Create Profit and Loss - Create a profit and loss statement (tab 1 of your spreadsheet) and put in your income and expense categories. Put in a forumula at the bottom of each that provides totals. Settin up the formulas for each category of income and expenses is as simple as selecting your + sign and going to the proper tab and selecting the total for each category;
D) Restricted Funds - Some non profit organizations receive funds that are designated to go to specific events. These can be categorized on both the income and expense tabs and a separate section may be set up on your profit and loss to ensure proper accounting.
Creating a working cash flow statement for a non profit is not difficult. In fact, anyone with basic knowledge can create a spreadsheet template that works for their organization. Non profit cash flow statements are critical to the success of non profit accounting and can help you see at a glance the financial health of your organization.
Click here to download a sample non-profit cash flow statement.
image: created by Doreen Martel