IMPORTANT:When you first open the file it may say it is a “Read Only” file; however, when you save the file on your hard drive you will be able to make changes and work in the spreadsheet.
This Housing Allowance workbook is pretty well set to use. You may want to make some changes to fit your situation better. Instructions for modifying and using this spreadsheet are listed below.
With claiming housing allowance exclusion, meticulous recordkeeping is an absolute necessity! You can use this housing allowance spreadsheet to keep track of the date, description of the housing expense, how it was paid, and amount.
However, you also need to keep all necessary documentation such as:
You can keep these in a secure location such as your file cabinet or even an expandable file folder. I suggest keeping each month’s receipts in their own file folder or pocket. I would also print off each month’s expenses and totals from the spreadsheet and keep with that month’s receipts.
If you do your own taxes, you will be very glad you have all your housing allowance expenses organized and if an accountant does your taxes...they won’t groan so loud when they see you coming :)
Okay...we are ready to open your housing allowance spreadsheet and either begin to use or do any modifications we need to do to make it more user-friendly.
The first worksheet is simply a list of eligible and ineligible housing allowance expenses.
You can delete this sheet is you want to...just right click on the tab “Expenses” and click delete. When the box pops up...click delete.
The second worksheet (Jan) is where you will be recording each month’s housing expenses. I have it sectioned off in individual expenses and an extra one at the bottom for any expense you use regularly.You can keep these or rename them what you want.
Simply click on the name and retype. It will automatically update the rest of the worksheets. If you do not need as many expenses, you can delete them. Instructions for deleting rows in this housing allowance spreadsheet are listed below.
The third worksheet (Jan-Total) is a view-only sheet. It will automatically generate reports from the data you put in the second worksheet (Jan).
The remaining months are set up the same way.
The last worksheet is the “Annual” Report. It is a view-only worksheet also. You can regularly look at it to see how much you have spent in housing expenses year to date.
You may get into October or November and see you have not spent as much of your housing allowance as you have been allotted and decide it might be a good time to do that home improvement project you have been wanting to so.
Just remember you can only claim an housing allowance exclusion for the lesser amount of: your actual expense, your designated housing allowance, or the fair market rental value plus furnishings and utilities. See my housing allowance ebook for more details.
You can hide the accounts you do not need right now. With this method you can unhide them later if you need to.
Simply hightlight the accounts you want to hide and right click your mouse; go down to hide and click. You would then need to do that to all the reports...but when you need the extra accounts they are there to unhide and use.
But if you know you will not need anymore accounts and want to delete the unwanted accounts, follow these instructions:
First of all, SAVE an original copy.
****Notice: SAVE a copy before you start entering your data. This one will be your original to use every year.
If you want to DIY your payroll, I highly recommend you look at using Gusto! It is very user friendly and their support is awesome! Plus they know how to set up and maintain payrolls for churches and nonprofit organizations.
Note: I am a "partner" of Gusto, but as I have told you before ... I never recommend anything that we or our clients have not tried and love =)