Unposting payroll

[La Shaunda]

Hi there -

Is there a way to unpost payroll? I do payroll weekly but I do not want it to post to my fund accounting because it messes up my bank statment.

[NeilZ]

Hi there -

Is there a way to unpost payroll? I do payroll weekly but I do not want it to post to my fund accounting because it messes up my bank statment.

Which version of Powerchurch are you running? I'm fairly sure that v10 & 11 allow you to only post to Payroll, problem with that is that you will have to manually add the transactions to post to your checking account, tax liabilities, and payroll expense.

And why would it mess up your bank statement ?? If you're doing a reconciliation, usually the end date of the statement is the last date of the month. So if you post enter and post payroll on the 1st, when you reconcile it should not pick up those posted transactions.

[Zaina]

To add to what Neil said, you can post Payroll to Fund Accounting, but not post it in Fund Accounting (it would be found under Modify Unposted Transactions) until you are ready. As long as it is unposted in Fund Accounting, it won't show on the reconcile screen. In the newer versions, 11 and 11.5, you have the option of not showing anything dated beyond the bank statement date.

Like Neil, I am curious though, what do you mean when you say it messes up the bank statement?

[La Shaunda]

Hi Neil and Zaina -

On my expense and report, the only thing that keeps my bank statement from reconciling is payroll. For example if payroll for one person is 200.00; when I process the check and post it to my fund accounting it adds the taxes and I know it should, but it seems to be adding more because the amount does not add up to the taxes and payroll. I will email back later once I have access to my paperwork. I'm sure it's a simple solution, but I don't know how to figure it out. I would love if I could call one of you. Please let me know.

Thanks
La Shaunda

[La Shaunda]

I forgot to mention I'm using version 11.

[NeilZ]

Are you NOT using the Payroll system to calculate the state & federal withholdings ??? You're doing it manually ??

Please explain exactly how you do your payroll ... oh, and which version 11: 11.1 or 11.5 - and do you have it up to the latest Maintenance Release ?

[La Shaunda]

Hi Neil -

I'm using the Payroll system to calculate the taxes. I had someone to come out and set Payroll up for me who has worked with the system for over 30 years.

The version is 11.1

Here is my problem -- not so much with the bank statement.

example: One employee income is 234.12. After Federal withholding 20.89; Employee SSI 9:83; Employee Medicare3.39; Employer SSI 14.52; and Employer Medicare 3.39; the check amount is 200.01.

Now paying this employee for five weeks is 1,000.05 When I do an Income and Expense Statement for one month it shows a total amount of 1170.60 (including taxes) for this employee salary. This is what is confusing to me because --shouldn't the amount shown be salary without taxes. Then below it shows an expense for payroll taxes from every employee 296.83. It seems as though the taxes are expensed twice on the statement - which could be throwing off the toal amount.

So when I look at the total expenses on the statement and the total debits on the bank statement they do not match and it's because of Payroll. I started doing payroll in May and before I started I had no problem with both statements balancing.

The problem seems to be when I post Payroll to fund accounting --this is when my numbers are off.
After I process payroll and post to FA something is not right and it's about to drive me crazy. Hope this makes sense and hopefully you can help me resolve the problem. I do realize that reconciling the bank statemnt does not effect Payroll. Any suggestions?

[JohnDMeyers]

You are correct in saying that you are getting twice the expense on your taxes.

Your taxes should not be set to an expense account. Rather, they should point to a liability account. Since someone else set this up, you may not have seen the screen. It asks for a liability account. When you pay the taxes, you use the checking account and liability account, again.

Here is an example with one of your payrolls (not 5 of them).

--------
Payroll:
Gross Pay:
CR 01-1110-000 checking 234.12
DB 01-5140-000 expense 234.12

Fed W/H (liability)
DB 01-1110-000 checking 20.89
CR 01-2110-000 Fed liability 20.89

SSI Employee (liability)
DB 01-1110-000 checking 9.83
CR 01-2120-000 SSI liability 9.83

Medicare employee (liability)
DB 01-1110-000 checking 3.39
CR 01-2130-000 Medicare liability 3.39

SSI Employer (expense)
CR 01-1110-000 checking 14.52
DB 01-5180-000 SSI expense

Medicare employer (expense)
CR 01-1110-000 checking 3.39
DB 01-5190-000 Medicare expense 3.39

-------

Accounts Payable (pay taxes)
Fed W/H (liability)
CR 01-1110-000 checking 20.89
DB 01-2110-000 Fed liability 20.89

SSI Employee (liability)
CR 01-1110-000 checking 9.83
DB 01-2120-000 SSI liability 9.83

Medicare employee (liability)
CR 01-1110-000 checking 3.39
DB 01-2130-000 Medicare liability 3.39

[La Shaunda]

Thanks John!

Can you tell me the process to remove the taxes from the expense account?

La Shaunda

[JohnDMeyers]

To correct your payroll, as well as fund accounting, you could void the checks in payroll, setup the accounts correctly, then rerun payroll.

To make the corrections in Fund Accounting only:
CR 01-5180-000 Fed W/H
DB 01-2110-000 Fed W/H

etc.

[La Shaunda]

Ok! I will try it tonight. Thank for your assistance. By replying, I found out about your site and I will most likely subscribe.

[La Shaunda]

John -

I'm at my computer and this is confusing.

The gentleman that set up my payroll has Payroll:

One employee income is 234.12.
Federal withholding 20.89 (Tax Deduction)
Employee SSI 9.83 (Tax Deduction)
Employee Medicare 3.39 (Tax Deduction)
Employer SSI 14.52 (Employer Liability)
Employer Medicare 3.39 (Employer Liability)

This is what you sent me earlier. Is it safe to say that the only problem here is the tax deductions and liabilities are reversed?
Gross Pay:
CR 01-1110-000 checking 234.12
DB 01-5140-000 expense 234.12

Fed W/H (liability)
DB 01-1110-000 checking 20.89
CR 01-2110-000 Fed liability 20.89

SSI Employee (liability)
DB 01-1110-000 checking 9.83
CR 01-2120-000 SSI liability 9.83

Medicare employee (liability)
DB 01-1110-000 checking 3.39
CR 01-2130-000 Medicare liability 3.39

SSI Employer (expense)
CR 01-1110-000 checking 14.52
DB 01-5180-000 SSI expense

Medicare employer (expense)
CR 01-1110-000 checking 3.39
DB 01-5190-000 Medicare expense 3.39

[JohnDMeyers]

Go to Payroll / Setup / Maintain Item Descriptions

Locate each of these items:
Federal withholding 20.89 (Tax Deduction)
Employee SSI 9.83 (Tax Deduction)
Employee Medicare 3.39 (Tax Deduction)
Employer SSI 14.52 (Employer Liability)
Employer Medicare 3.39 (Employer Liability)

Each will have two accounts assigned to them. This is where you can assign the list that I provided.

Let me know if you more questions.

[La Shaunda]

Thank you!