Collaborate on Rent Receipt Template Excel for Non-profit Organizations with Ease Using airSlate SignNow

Rent receipt template excel for non-profit organizations

hi I'm Michelle Carly and I'm going to show you how to use the Big Easy bookkeeping system for a small nonprofit group the system works with Microsoft Excel 2003 or newer it's a cash basis system I've updated the accounting terms to make it simple for treasurers that are unfamiliar with bookkeeping you enter data in three simple worksheets the deposits which is similar to your cash receipts the checks which is similar to cash dispersements and the cash and charges for anything that did not go through your checkbook you can see I've put in the year end date of April 30th for this chapter is going to follow a fiscal year I've changed the months from a calendar year to starting with May 1st I'll click over to the deposits and you can see I've already put in some C Income categories here these first two columns pertain to sales and sales tax so I'm going to go ahead and hide those I've entered one deposit here for Mary green for $40 for chapter dues I'm going to record that over here if I scroll to the right you could see I've recorded the $40 under Mary Green's name in the subcategory section now I'll show you where to record your checks as you can see I've put in category expense categories along the top here I've issued a check here for $100 for rent and I'm going to show you here how to record your cash or credit card purchases I've entered two items here one is a credit card purchase of 2560 which was for some supplies and a $40 cash expenditure for stamps now to show that this is a cash expenditure we just put a c here and it swings the amount over here to decrease our cash on hand you can see where the cash has been decrease by clicking on your account balance tracker he'll here you'll see we started the cash on hand with $100 we just had a $45 cash expenditure and now we're left with $55 cash on hand here's the amount we started with in the checkbook and here's the amount of the deposit that we made for $40 and $100 rent payment so our cash our checking balance is this amount here I'll scroll down and you can see that we are showing a loss of $130 60 which will show up on the income and expenses if we scroll down here you'll see $130 60 here's the rent payment the postage and the supplies now I'll click on the bank reconciliation and you can see that in this area you can reconcile your checkbook you reconcile by clicking on the deposits and putting a little X next to the amount that cleared and you you'll see the outstanding deposit is gone and the same with your checks I'll show this check is clearing the bank also and now you know you're in Balance because you have a zero for difference let's head over to the summary and you can see the reports that it generates by clicking on settings and I'm going to click on summary I'm now in the summary I'll show you where you can put in your budget here so here are the budget amounts that I previously entered and I'll click over to year-to dat deposits you can see we received $40 in chapter I'll click on the year-to DAT checks and you can see we paid out $100 in rent and postage supplies all in May you've got all the months here I'll click on the year-to-date income statement and you would be able to see 12 months budget amounts here your year-to dat amounts and you have quarterly actual versus budget and I'll click on the subcategories and you can see you can see how much Mary green had paid going back to the income statement this is the U year-to-date income statement that will give you the um total amounts to put on your tax return for the Year this is an annual purchase and you get a new set of files every year you get support for 12 month months uh a CD that comes in the mail along with a receipt organizer so you can keep receipts for all the expenses that you have listed here and that's it thank you for watching