Trying to set up a payroll system for 1 or 2 casual employees

Closed
kirmar Posts 1 Registration date Saturday 10 January 2015 Status Member Last seen 10 January 2015 - 10 Jan 2015 à 15:27
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 13 Jan 2015 à 06:07
I'm trying to set up a payroll system for 1 or 2 casual employees. Most forums recommend a manual system. Can excel add up a year to date column across different sheets? eg sheet 1 Gross $200; Year to Date $200 and then on the next sheet Gross $150; Year to date $350. I would like to have the maths done automatically to reduce the risk of errors. Even if I could get excel to transfer data across sheets I could then add a previous column and work with that. Please help.
Related:

1 response

vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 262
13 Jan 2015 à 06:07
Hello Kirmar,

Using simple formulae, Excel certainly can add up across sheets.

Have a look at the following link:-

https://www.dropbox.com/s/7drs2zezog5buxz/RCJSMOM.xlsx?dl=0

I set up this draft household Yearly Income/Expenses Work Book for the Poster (as a guide for her). It shows you what simple formulae can do across a number of sheets. For the sake of the exercise, I just formatted three months and a Summary sheet for the Poster. Have a play with it and see what you think.

If its more or less what you are after, then I'm sure we can adjust it to suit your needs.

Kind regards,
vcoolio.