In need

P

PrimaLucci

I run a working mens ministry home that helps homeless men obtain jobs so
they can get back on their feet. To establish responsibility and
accountability, we charge a weekly, bi weekly or monthly rent depending on
what source of income our client has.

I have looked and looked and cannot find a suitable template, and I am just
not educated enough to create my own.

What I am in need of, is a template in either access or excel that will list
the following:

1. Clients name (first, middle, last)
2. Clients social security number and birthday
3. Client mobile phone number and email address
4. Photograph of client
5. Emergency contact name, phone and address
6. Client Status(Active, Inactive, Suspended), Entry Date, Exit Date.
7. Medications Client is taking
8. Base Rent Rate
9. Rent Schedule (7 days, 14 days or Monthly. where it will automatically
charge the base rent rate on the same day of the following week, two weeks or
on the 3rd of every month and calculate the balance due)
10. Rent Due Date(That will auto adjust the date due according to rent
schedule)
11. Rent Owed
12. Rent Paid
13. Rent Balance(if balance is positive/negative for period of rent due
date, it will reflect in the following rent scheduled due dates rent owed in
red highlight)
14. deposit owed, deposit paid
15. Pending background check/background check completed?
16. a notes/comments section

I know this is alot to ask for, I just cannot seem to figure this out.
Doing everything with the pen and paper method is becoming too difficult.

Whoever could make a template like this it would be GREATLY
appreciated...and even if no one does build one with what is listed above, if
someone could take the time to teach me or tell me where i can learn how to
do what is posted, it would be a tremendous help. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top