Union Report :SamT
Hello
I have three separate questions and this is Part 1 Question...
we are a union contractor, every month i need to provide a benefit report when paying in dues. instead of me doing this manually i would like to have it come from quickbooks to excel.
i know how to get the following data into excel from quickbooks.
- col #1 employee name,
- col #2 soc sec#,
- col#3 - #7 (depending on if 4 wks or 5wks) start of wk,
- under start of wk they are looking for end of wk, under end of wk they are looking for pay date,
- col #8 proof hours (which would add col #3-#7 up and subtract col #12 - if result is zero then the column can be hidden if greater than zero then there is an error somewhere),
- col #9 regular hours (taken from paychecks),
- col #10 OT hours (taken from paychecks),
- col #11 DT (taken from pay checks),
- Col #12 total hours, adds up col #9-#11,
- the next 11 cols (col #12 - col #22) can be taken from paychecks...it is for each fund and the amount of money each fund gets per employee.
thoughts, comments, need more info??
Thank you so much...Im sure this can be done but not sure exactly how as they want it set up in the columns above and I don't know much about vba or sql or obdc...
Thanks again and HELP....
Andrea