payroll
Total Views: 34
New client does payroll entered and printed in QB but entered in manual checkbook as a lump sum. Having trouble keeping checkbook reconciled. Help????
Answer
To make sure I understand the problem, here is an example: two employees, each gets a paycheck on the 25th of October. One paycheck is for 100.00, the other one is 50.00. In to the manual checkbook, 150.00 is recorded for these 2 paychecks.
One of the employees goes and cashes his paycheck (the 100.00 one) the same day. The other one does not go to cash/deposit his check to the bank for 5 days. This will result in the 100.00 check showing up on the October bank statement, but the 50.00 check does not.
There is no way to reconcile. Out of the recorded 150.00 you will need to "reconcile" 100.00 and leave 50.00 outstanding. I don't see a possible way to do it.
I know I could not help, but I hope I could explain the "why".
Reka
Answer
If your client is entering each check in QuickBooks, why not do the bank rec using the QuickBooks Bank reconciliation feature? When I have clients who insist on continuing a manual register, I just tell them each month what their balance is at month end. For example: "The balance in your manual register is $2232.25 after check #12308". In other words, I don't waste my time reconciling their manual register if QuickBooks balances.
Comment
Client does not care what QB figure is. Only wants to see checkbook bottom line. The only way I can balance checkbook is to add all the payroll checks that have cleared back into balance after outstanding have been subtracted. Kinda wierd but seems to work.