Create Your Non Profit Invoice Template for Planning Effortlessly

Non profit invoice template for Planning

If you're looking to create a balance sheet for a non-profit, then you've come to the right place. We have created a balance sheet template built specifically for nonprofits. And what we've done is a little bit unique. What we've noticed is a lot of balance sheet, templates are just that they're template of the balance sheet, but they don't really help you figure out how to fill it out. And so what we've done is we've created a 2 tab spreadsheet here in the first tab lists a number of questions in plain English and the hope is that you can just answer these questions. Then when you answer the questions the balance sheet will be filled out for you automatically and so I'm going to show you how to walk through and Use this template. And and before I do that, just real quickly, my name is Adam Hoeksema I'm the co-founder of projection hub and we've helped tens of thousands of entrepreneurs and nonprofit leaders create Financial projections for their business. And specifically today, we're looking at this balance sheet template and wanted to walk you through that. So let's jump in. All right, so you'll be able to grab this balance sheet template for free by going to the link in the description the video below and then you'll be able to follow along. So the first thing you need to know is that every cell that's highlighted in blue, is an assumption that you can change. You can change the Name the date and then the balance sheet is broken down into assets, liabilities and net assets for a non-profit. And often times you'll hear for nonprofit A balance sheet is called a statement of financial position, but if you've been asked for a balance sheet or a statement of financial position, they're really the same thing for our purposes here. So, the first thing you want to do is enter in the how much cash you have in all company bank accounts, this could be checking savings and CDs. Cash equivalents and then you want to know how much do your customers owe you? So this is typically considered accounts receivable. Then if you have any inventory, how much did you pay for that inventory that you currently have on hand? And what dollar amount of Grants? Have you been awarded but not yet received. So this would be what's called grants receivable. So you may have applied for a grant. You've been notified that you won the grant, but you haven't received it yet. Or maybe you've only received a portion. What you want to enter here is the amount that you have not yet received. And then what dollar amount of donations or contributions, have been committed, but not yet received. So again, this could be might have pledges or pledge donations where you've received a portion of the Pledge, but not everything. Again, you'll want to put in, just the amount that has been committed but not yet received here. Next, if you have any long-term assets, so this will be a non-profit. I've left this blank but if you have any Machinery or equipment furniture and fixtures that you own, If you if you're leasing the space and you paid for leasehold improvements to that space, you'll want to enter that dollar amount here. Then how much should you pay for any land or buildings that you own? And what is the value of any long-term Investments that you own? So it could be stocks bonds or other long-term Investments and then lastly here what dollar amount have your assets depreciated since you purchased them. Now, if you have an accountant or CPA you should probably ask them what they have listed as depreciation like on your tax return or your 990 and that's what you would want to enter in here, but if you don't have an account, and you're trying to figure this out, we've put here to learn a little bit more about how to calculate depreciation. Then other assets again, this may not be super relevant to most nonprofits. So you may just leave this blank but the value of intangible assets like patents trademarks copyrights and what dollar amount of customer deposits? Are you currently holding. So if a customer pays you in advance for services and you're holding that as a deposit, that's what you'd want to enter here. And then lastly, do you have any other assets that we haven't already asked about? You can enter that dollar amount here. Okay next we're going to look at liability. So liabilities here, how much do you currently owe on unpaid bills to suppliers vendors contractors? This is typically known as accounts payable. How much have you agreed to pay out in Grants to others that have that you have not yet paid. So let's say some nonprofits receive grants and donations, and then turn around and give out grants to sub-awardees or sub-grantees. So if you are granting funds to other people and you have committed to Grant to them, but you have not actually provided that grant money to them, yet, that would be what you want to enter here as a payable. Alright, how much you currently own short-term loans that you will have to pay off in less than 12 months? So this could be a credit card balance. That would be a good example of that. And then this is a little trickier. How much will you have to pay in the next 12 months on any long-term loans that you have? So if you have long-term loans, what you need to do here is add up your monthly payment, x 12, and that's what you're going to have to pay back. And then in the next 12 months, that's at least probably going to be the simplest thing here to do. You're probably really looking to put the principal amount that you'll be paying back in the next 12 months. So, again, that could be a little bit trickier but to be very precise. You what you want to show here, is the principal. And not the interest in the principle of that longer Term Loan. Then you have any other bills or debts that you need to repay in the next 12 months. And then long-term liability. So this is how much you owe in loans to Banks and other business lenders. These are longer-term loans a longer-term portion of that and do you have any other long-term debt that we have already added? And after you enter all that, then the last question here is what dollar amount of Grants contributions and donations currently have restrictions. So you might get a grant and that Grant comes with a restriction that it has to be used for this specific purpose. So let's say you got a hundred thousand dollar Grant and all 100,000 needed to be used for a particular purpose and you haven't used it for that purpose yet. Well, then it's restricted and you would need to put that full hundred thousand dollars here. And once you've done all that, you can click this, generate your balance sheet, click view, it'll bring you to your statement of financial position, our balance sheet here and it will show you everything you need here. And at the end of the tell you whether it's balanced and it should be balanced based on the way we built it, but this will just in case, there's anything that's broken and that can be a warning. If it says anything other than balanced you'd want to double check. And make sure. But the idea here is that your assets here, your total assets, should equal your total liabilities and equity And so, those two things should be balanced Then the last thing I'll do is I'm just going to give a little commercial if you need to create a full Financial projection for a nonprofit organization, we do have a full Financial projection template that helps you think through how to build out projections not just a balance sheet as of a particular point in time as of like today. But you want to build out projected balance sheet, projected, cash flow, projected income statement. That's what this template allows you to do. You can enter in different things like your operating expenses, your salaries And then ultimately, you're going to get some nice charts and graphs and a five-year projection of your statement of activities, your cash flow and then five-year balance sheet projection or statement of financial position. So, what we did today was just a balance sheet as of a particular point in time. And then this template, this projection template will allow you to create a projected balance sheet for the next five years for your nonprofit. So if you have any questions, please don't hesitate to reach out, leave us a comment, support@projectionhub.com and we would Be happy to help you. Thanks.