PC Review


Reply
Thread Tools Rate Thread

I need an Excel Spreadsheet for Cafeteria Plan Accounting.

 
 
=?Utf-8?B?Q2Fzc2FuZHJh?=
Guest
Posts: n/a
 
      7th Aug 2006
I am using Office XP. I have been asked to track employee receipts for a
small daycare/elementary school. This is our first year to implement this
feature for about 30 teachers/employees. Each person will be allowed $500
for the year. I must record their receipts and be able to give them a
running balance at any time. I need to show spending catagories. Thank you
for your help.
 
Reply With Quote
 
 
 
 
Otto Moehrbach
Guest
Posts: n/a
 
      8th Aug 2006
I suggest that you have an input sheet and a sheet for each employee. In
the Input sheet you would have a one row, multi-column input area. The
first cell would be a Data Validation cell with all the employee names
listed. You would select the name you want and that name would be the entry
in that first cell. The remaining cells would be the entries you want to
record for that person. What do want to record exactly?
You would have 2 buttons on the sheet, one labeled maybe "Record" and
the other maybe "Balance". Selecting the name and entering the data and
clicking on the "Record" button would cause all the data you entered to be
copied to that person's sheet in the next available row. Selecting a name
and clicking on the "Balance" button would display the balance for that
employee.
Does this sound like something that might work for you? If so, I'll
work up something for you and send you the file for you to try out. If you
wish, send me an email and I'll send you what I come up with. My email
address is (E-Mail Removed). Remove the "nop" from this address. HTH
Otto
"Cassandra" <(E-Mail Removed)> wrote in message
news:0231F7DA-DFED-4EDA-BA26-(E-Mail Removed)...
>I am using Office XP. I have been asked to track employee receipts for a
> small daycare/elementary school. This is our first year to implement this
> feature for about 30 teachers/employees. Each person will be allowed $500
> for the year. I must record their receipts and be able to give them a
> running balance at any time. I need to show spending catagories. Thank
> you
> for your help.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
When do we plan to have support for ODS (OpenOffice spreadsheet) f OpenSourceUser Microsoft Excel Misc 1 21st Apr 2009 02:27 AM
formula for accounting month to each spreadsheet? =?Utf-8?B?SmFuZQ==?= Microsoft Excel New Users 4 9th Apr 2007 06:46 PM
how do i do an accounting spreadsheet =?Utf-8?B?aG93IGRvIGkgZG8gYW4gYWNjb3VudGluZyBzcHJl Microsoft Excel Worksheet Functions 2 19th Nov 2005 06:24 PM
I need a spreadsheet to plan a for sale real estate develpment =?Utf-8?B?SmltIEZyaXNoZQ==?= Microsoft Excel Programming 0 29th Nov 2004 05:21 PM
I need a spreadsheet to plan a for sale real estate develpment =?Utf-8?B?SmltIEZyaXNoZQ==?= Microsoft Excel Programming 0 29th Nov 2004 05:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:55 PM.