This is probably a question for Amanda, (if you are about?)
I am doing March's bank reconciliation in QB (yes I know, all behind!) I notice that in the bank rec window QB lumps the payroll altogether as one sum. The problem I have is that there were two employees who didn't actually get physically paid until the beginning of April so I need to show these two amounts as outstanding on the bank rec. (They were included in the payroll lump sum). Any ideas how I deal with this?
QB is annoying in this respect as when I run the payroll, it automatically assumes that everyone has been paid!
I haven't got payroll on my version at home, I use it at a clients so can't have a go and see what happens. I am guessing abit here, what about deleting that payment the 2 employees who didn't get paid until the 1st April and changing there pay date on their pay cheq/slip. That way it would delete the payments in the bank account and then re-enter then as being paid on a different date??? I know its not ideal but it may work? Have a tinker with it and let me know as like I say its abit of a guess!!! I know what you mean that it lumps them all together.
Had another thought but don't know if it would work ok or not. What about journalling our all the payslips (lump sum) and then journalling back in the ones that are paid as per QB and then do a separate journal to the ones for a different date?? Not really sure if it will work though.
Maybe Sheila will be on here later as I know she is a wizz at payroll. I would be interested to find out how to do it?
Just wondering why the program is collating all the payroll in one figure, are you creating a bacs file by any chance? Normally if paying by cheques/cash, the system lists all payments separately.
I have not used bacs through quickbooks fully, I tried it once and know it does collate all payments into one figure in a file that you can export out, and then import into the online banking system for the system to break down and disperse to the employees, but the bank I used didn't support the file type so there was no point, I just had to create payments as normal and go through the online payments manually so I never got as far as reconciliation with bacs payments. If that is the case though, 2 bacs files should really have been created, one for one payment date, and another for the 2 employees paid later.
-- Edited by mushroom on Tuesday 3rd of May 2011 03:42:29 PM
Had another thought but don't know if it would work ok or not. What about journalling our all the payslips (lump sum) and then journalling back in the ones that are paid as per QB and then do a separate journal to the ones for a different date?? Not really sure if it will work though.
Maybe Sheila will be on here later as I know she is a wizz at payroll. I would be interested to find out how to do it?
cheers.
I'd go for this option. I don't use QB payroll for my QB client but Sage Payroll and I journal the entire payroll into QB because the salaries are mostly paid by bacs with the odd one cash and they need to go to the relevant classes. I debit the net pay for each employee to staff salaries and relevant class then credit the lump sum to the bank to match the bacs payment and for the cash payment I do a separate journal and credit cash account. Also do a separate journal for paye and ni to give the amount paid to HMRC match the payment from bank. Hope that makes sense.
Many thanks for replying. I decided to go the journal route in the end. There was actually only one employee who had been paid later, so it was easy just to journal that payment out and then I'll journal it back in when I do April bank rec.
Mushroom (love the nickname!) - yes I am creating a bacs file. This could explain why it is lumping the payments together. If when I create the payroll payments I choose the option cheques instead of bacs maybe it will post the payments separately. I know I've had the payments on the bank rec separately before, so this could be it!
Sheila - problem with QB payroll is that it creates the payroll payments and posts them automatically, so the only way to change them after I've run payroll is to do journals or delete payments individually. (Actually, suppose I could have done that )
