Accounting Talk
Accounting Talk
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Mea Culpa

 
Post new topic   Reply to topic    Accounting Talk Forum Index -> Quickbooks
View previous topic :: View next topic  
Author Message
PT
Guest





PostPosted: Mon Apr 16, 2007 5:22 am    Post subject: Mea Culpa Reply with quote

Our small organization has four employees, and we use QB 2005 Pro Payroll.
At the start of 2007, we added our fourth employee.
At the same time, I neglected to:
1. Update the state workers comp tax rate
2. Add the state unemployment tax and workers comp to the new
employee's profile

We pay monthly, and the two state tax forms go in quarterly, at the end of
April in this case.
So to date all taxes for the quarter are simply accruals - nothing has been
paid nor filed.

So how can I retroactively fix things? I assume I should first update the
payroll profile for each employee,
and update the state workers comp rate. Then I could delete each of the
twelve pay checks and recreate
them using the corrected data. The checks themselves wouldn't change.

Is there any easier way to do this?

--
PT
Back to top
  Ads
Advertising
Sponsor


PT
Guest





PostPosted: Mon Apr 16, 2007 7:22 pm    Post subject: Re: Mea Culpa Reply with quote

Related Question - Suppose I decide to correct several of the earlier
paychecks. The checks have all been involved in prior reconciliations, and
are marked "Cleared". Now in this case, none of the changes affect the
check amount or withholdings.

However, what, if anything, bad might happen if, say, I create a new check
say 1865A to replace check 1865, then delete original check 1865, and rename
1865A as 1865? Is this too complicated?

--
PT
"PT" <xyz@xyz.com> wrote in message
news:evufk9$jjt$1@nwnexus-news.nwnexus.com...
Quote:
Our small organization has four employees, and we use QB 2005 Pro Payroll.
At the start of 2007, we added our fourth employee.
At the same time, I neglected to:
1. Update the state workers comp tax rate
2. Add the state unemployment tax and workers comp to the new
employee's profile

We pay monthly, and the two state tax forms go in quarterly, at the end of
April in this case.
So to date all taxes for the quarter are simply accruals - nothing has
been paid nor filed.

So how can I retroactively fix things? I assume I should first update the
payroll profile for each employee,
and update the state workers comp rate. Then I could delete each of the
twelve pay checks and recreate
them using the corrected data. The checks themselves wouldn't change.

Is there any easier way to do this?

--
PT
Back to top
  Ads
Advertising
Sponsor


Laura
Guest





PostPosted: Mon Apr 16, 2007 9:45 pm    Post subject: Re: Mea Culpa Reply with quote

To answer both messages....Make all of the changes to the default profile
and update each employee's profile while you are at it. Make sure you have
the latest payroll tables. Then make a backup copy of your company file.

Try deleting one check and recreating it with the same date and check
number. Check the bank account register to see that the replacement check is
also cleared. If that worked, then redo the remaining 11 checks.

You don't need to create 1865A and rename it, etc.Just delete the first
check and recreate it. Less steps involved.

You are lucky the changes were on the employER side.

"PT" <xyz@xyz.com> wrote in message
news:f000sg$951$1@nwnexus-news.nwnexus.com...
Quote:
Related Question - Suppose I decide to correct several of the earlier
paychecks. The checks have all been involved in prior reconciliations,
and are marked "Cleared". Now in this case, none of the changes affect
the check amount or withholdings.

However, what, if anything, bad might happen if, say, I create a new check
say 1865A to replace check 1865, then delete original check 1865, and
rename 1865A as 1865? Is this too complicated?

--
PT
"PT" <xyz@xyz.com> wrote in message
news:evufk9$jjt$1@nwnexus-news.nwnexus.com...
Our small organization has four employees, and we use QB 2005 Pro
Payroll.
At the start of 2007, we added our fourth employee.
At the same time, I neglected to:
1. Update the state workers comp tax rate
2. Add the state unemployment tax and workers comp to the new
employee's profile

We pay monthly, and the two state tax forms go in quarterly, at the end
of April in this case.
So to date all taxes for the quarter are simply accruals - nothing has
been paid nor filed.

So how can I retroactively fix things? I assume I should first update
the payroll profile for each employee,
and update the state workers comp rate. Then I could delete each of the
twelve pay checks and recreate
them using the corrected data. The checks themselves wouldn't change.

Is there any easier way to do this?

--
PT


Back to top
  Ads
Advertising
Sponsor


Scott
Guest





PostPosted: Tue Apr 17, 2007 4:47 am    Post subject: Re: Mea Culpa Reply with quote

As long as the net check amount hasn't changed, I see no problem with
opening the paycheck & changing/adding the amounts in the Employer section.
I believe you need to "unlock" the check so you can do this. If the check
has already been reconciled, it's status will not change.

If you delete the check & re-enter it, it will show up as unreconciled in
your next bank rec, the prior rec will not match, and your balance forward
will be off by the check amount.

Scott
"PT" <xyz@xyz.com> wrote in message
news:f000sg$951$1@nwnexus-news.nwnexus.com...
Quote:
Related Question - Suppose I decide to correct several of the earlier
paychecks. The checks have all been involved in prior reconciliations,
and are marked "Cleared". Now in this case, none of the changes affect
the check amount or withholdings.

However, what, if anything, bad might happen if, say, I create a new check
say 1865A to replace check 1865, then delete original check 1865, and
rename 1865A as 1865? Is this too complicated?

--
PT
"PT" <xyz@xyz.com> wrote in message
news:evufk9$jjt$1@nwnexus-news.nwnexus.com...
Our small organization has four employees, and we use QB 2005 Pro
Payroll.
At the start of 2007, we added our fourth employee.
At the same time, I neglected to:
1. Update the state workers comp tax rate
2. Add the state unemployment tax and workers comp to the new
employee's profile

We pay monthly, and the two state tax forms go in quarterly, at the end
of April in this case.
So to date all taxes for the quarter are simply accruals - nothing has
been paid nor filed.

So how can I retroactively fix things? I assume I should first update
the payroll profile for each employee,
and update the state workers comp rate. Then I could delete each of the
twelve pay checks and recreate
them using the corrected data. The checks themselves wouldn't change.

Is there any easier way to do this?

--
PT


Back to top
  Ads
Advertising
Sponsor


PT
Guest





PostPosted: Tue Apr 17, 2007 10:47 pm    Post subject: Re: Mea Culpa Reply with quote

After some experimentation, that's just what I did. But I found I first had
to delete the old paycheck before the revised SUI and L & I rates were
picked up. each time I was warned about deleting a reconciled check, and
said it's OK. After completion, I looked at the April reconciliation
screen. The new checks are all there. I assume after April 30 when I do
the normal reconciliation, I'll check them off as having cleared.

-
PT

"Scott" <beamersrqNOSPAM@comcast.net> wrote in message
news:142dnQEmE5-dlrnbnZ2dnUVZ_umlnZ2d@comcast.com...
Quote:
As long as the net check amount hasn't changed, I see no problem with
opening the paycheck & changing/adding the amounts in the Employer
section. I believe you need to "unlock" the check so you can do this. If
the check has already been reconciled, it's status will not change.

If you delete the check & re-enter it, it will show up as unreconciled in
your next bank rec, the prior rec will not match, and your balance forward
will be off by the check amount.

Scott

"PT" <xyz@xyz.com> wrote in message
Related Question - Suppose I decide to correct several of the earlier
paychecks. The checks have all been involved in prior reconciliations,
and are marked "Cleared". Now in this case, none of the changes affect
the check amount or withholdings.

However, what, if anything, bad might happen if, say, I create a new
check say 1865A to replace check 1865, then delete original check 1865,
and rename 1865A as 1865? Is this too complicated?
PT


Quote:
"PT" <xyz@xyz.com> wrote in message
Our small organization has four employees, and we use QB 2005 Pro
Payroll.
At the start of 2007, we added our fourth employee.
At the same time, I neglected to:
1. Update the state workers comp tax rate
2. Add the state unemployment tax and workers comp to the new
employee's profile

We pay monthly, and the two state tax forms go in quarterly, at the end
of April in this case.
So to date all taxes for the quarter are simply accruals - nothing has
been paid nor filed.

So how can I retroactively fix things? I assume I should first update
the payroll profile for each employee,
and update the state workers comp rate. Then I could delete each of the
twelve pay checks and recreate
them using the corrected data. The checks themselves wouldn't change.

Is there any easier way to do this?
Back to top
  Ads
Advertising
Sponsor


A
Guest





PostPosted: Thu Apr 19, 2007 6:16 am    Post subject: Re: Mea Culpa Reply with quote

I may have misunderstood something along the way, but your last post
seems incorrect.

If you can see the new cheques (that were presiously reconciled) on your
April rec sheet, they'll pull April out of balance if you check them all
becuase they won't be on the april bank statement you are reconciling.

I wonder if you go back and look at the past months that you reconciled,
whether they'll be out of balance due to the cheques you deleted.

Assuming I'm correct; there would have to be a way that you can re-
reconcile those months by simply adding those cheques back in.

A




"PT" <xyz@xyz.com> wrote in news:f0318h$lh9$1@nwnexus-news.nwnexus.com:

Quote:
After some experimentation, that's just what I did. But I found I
first had to delete the old paycheck before the revised SUI and L & I
rates were picked up. each time I was warned about deleting a
reconciled check, and said it's OK. After completion, I looked at the
April reconciliation screen. The new checks are all there. I assume
after April 30 when I do the normal reconciliation, I'll check them
off as having cleared.

-
PT

"Scott" <beamersrqNOSPAM@comcast.net> wrote in message
news:142dnQEmE5-dlrnbnZ2dnUVZ_umlnZ2d@comcast.com...
As long as the net check amount hasn't changed, I see no problem with
opening the paycheck & changing/adding the amounts in the Employer
section. I believe you need to "unlock" the check so you can do this.
If the check has already been reconciled, it's status will not
change.

If you delete the check & re-enter it, it will show up as
unreconciled in your next bank rec, the prior rec will not match, and
your balance forward will be off by the check amount.

Scott

"PT" <xyz@xyz.com> wrote in message
Related Question - Suppose I decide to correct several of the
earlier paychecks. The checks have all been involved in prior
reconciliations, and are marked "Cleared". Now in this case, none
of the changes affect the check amount or withholdings.

However, what, if anything, bad might happen if, say, I create a new
check say 1865A to replace check 1865, then delete original check
1865, and rename 1865A as 1865? Is this too complicated?
PT


"PT" <xyz@xyz.com> wrote in message
Our small organization has four employees, and we use QB 2005 Pro
Payroll.
At the start of 2007, we added our fourth employee.
At the same time, I neglected to:
1. Update the state workers comp tax rate
2. Add the state unemployment tax and workers comp to the new
employee's profile

We pay monthly, and the two state tax forms go in quarterly, at the
end of April in this case.
So to date all taxes for the quarter are simply accruals - nothing
has been paid nor filed.

So how can I retroactively fix things? I assume I should first
update the payroll profile for each employee,
and update the state workers comp rate. Then I could delete each
of the twelve pay checks and recreate
them using the corrected data. The checks themselves wouldn't
change.

Is there any easier way to do this?


Back to top
  Ads
Advertising
Sponsor


Laura
Guest





PostPosted: Thu Apr 19, 2007 4:17 pm    Post subject: Re: Mea Culpa Reply with quote

"PT" <xyz@xyz.com> wrote in message
news:f0318h$lh9$1@nwnexus-news.nwnexus.com...
Quote:
After some experimentation, that's just what I did. But I found I first
had to delete the old paycheck before the revised SUI and L & I rates were
picked up. each time I was warned about deleting a reconciled check, and
said it's OK. After completion, I looked at the April reconciliation
screen. The new checks are all there. I assume after April 30 when I do
the normal reconciliation, I'll check them off as having cleared.

If the new checks are showing up in the April bank rec then something
changed when you redid the checks. Double check the date, check number and
amount of the new checks against the old ones. The program will substitute
the new checks in the old bank recs and you are good to go. Run the
Reconciliation Discrepancy report to see the details that QB feels were
changed. Match those missing records and the bank recs should correct
themselves. Right now your prior bank recs for those months impacted by the
check corrections are incorrect.
Back to top
  Ads
Advertising
Sponsor


PT
Guest





PostPosted: Fri Apr 20, 2007 6:17 am    Post subject: Re: Mea Culpa Reply with quote

But I'm not particularly concerned about the old reconciliations - they were
accurate, and I saved the reports. I'm assuming (but won't know until I do
the April 30 reconciliation), that if I mark the earlier checks as cleared
on the 04/30/07 reconciliation screen, then assuming everything else for
April is OK, the account should reconcile. Am I correct?

--
PT
"Laura" <invalid@sample.invalid> wrote in message
news:WcIVh.327209$5j1.3050@bgtnsc04-news.ops.worldnet.att.net...
Quote:

"PT" <xyz@xyz.com> wrote in message
news:f0318h$lh9$1@nwnexus-news.nwnexus.com...
After some experimentation, that's just what I did. But I found I first
had to delete the old paycheck before the revised SUI and L & I rates
were picked up. each time I was warned about deleting a reconciled
check, and said it's OK. After completion, I looked at the April
reconciliation screen. The new checks are all there. I assume after
April 30 when I do the normal reconciliation, I'll check them off as
having cleared.

If the new checks are showing up in the April bank rec then something
changed when you redid the checks. Double check the date, check number and
amount of the new checks against the old ones. The program will substitute
the new checks in the old bank recs and you are good to go. Run the
Reconciliation Discrepancy report to see the details that QB feels were
changed. Match those missing records and the bank recs should correct
themselves. Right now your prior bank recs for those months impacted by
the check corrections are incorrect.
Back to top
  Ads
Advertising
Sponsor


Laura
Guest





PostPosted: Fri Apr 20, 2007 5:15 pm    Post subject: Re: Mea Culpa Reply with quote

It should but you never know what QB will do.

I'm more concerned that something was not done correctly because these
replacement transactions *should* have cleared automatically in the original
months posted. That is why I suggested looking at the Reconciliation
Discrpency report to see the exact details. Something is not working as
expected.

"PT" <xyz@xyz.com> wrote in message
news:f094bl$1ig$1@nwnexus-news.nwnexus.com...
Quote:
But I'm not particularly concerned about the old reconciliations - they
were accurate, and I saved the reports. I'm assuming (but won't know
until I do the April 30 reconciliation), that if I mark the earlier checks
as cleared on the 04/30/07 reconciliation screen, then assuming everything
else for April is OK, the account should reconcile. Am I correct?

--
PT
"Laura" <invalid@sample.invalid> wrote in message
news:WcIVh.327209$5j1.3050@bgtnsc04-news.ops.worldnet.att.net...

"PT" <xyz@xyz.com> wrote in message
news:f0318h$lh9$1@nwnexus-news.nwnexus.com...
After some experimentation, that's just what I did. But I found I first
had to delete the old paycheck before the revised SUI and L & I rates
were picked up. each time I was warned about deleting a reconciled
check, and said it's OK. After completion, I looked at the April
reconciliation screen. The new checks are all there. I assume after
April 30 when I do the normal reconciliation, I'll check them off as
having cleared.

If the new checks are showing up in the April bank rec then something
changed when you redid the checks. Double check the date, check number
and amount of the new checks against the old ones. The program will
substitute the new checks in the old bank recs and you are good to go.
Run the Reconciliation Discrepancy report to see the details that QB
feels were changed. Match those missing records and the bank recs should
correct themselves. Right now your prior bank recs for those months
impacted by the check corrections are incorrect.

Back to top
  Ads
Advertising
Sponsor


PT
Guest





PostPosted: Sat Apr 21, 2007 8:15 am    Post subject: Re: Mea Culpa Reply with quote

I checked the Reconciliation Discrepancy Report, which showed the eight
deleted checks. Then I ran a reconciliation for April 1 - 20, using the
online bank statement. If I mark as cleared the eight checks (which now
show up as uncleared) in the reconciliation screen, then do the normal
reconciliation for all items to date, the report reconciles.

It shows that there is still some justice in the world.

--
PT
"Laura" <invalid@sample.invalid> wrote in message
news:c92Wh.61381$VU4.26078@bgtnsc05-news.ops.worldnet.att.net...
Quote:
It should but you never know what QB will do.

I'm more concerned that something was not done correctly because these
replacement transactions *should* have cleared automatically in the
original months posted. That is why I suggested looking at the
Reconciliation Discrpency report to see the exact details. Something is
not working as expected.

"PT" <xyz@xyz.com> wrote in message
news:f094bl$1ig$1@nwnexus-news.nwnexus.com...
But I'm not particularly concerned about the old reconciliations - they
were accurate, and I saved the reports. I'm assuming (but won't know
until I do the April 30 reconciliation), that if I mark the earlier
checks as cleared on the 04/30/07 reconciliation screen, then assuming
everything else for April is OK, the account should reconcile. Am I
correct?

--
PT
"Laura" <invalid@sample.invalid> wrote in message
news:WcIVh.327209$5j1.3050@bgtnsc04-news.ops.worldnet.att.net...

"PT" <xyz@xyz.com> wrote in message
news:f0318h$lh9$1@nwnexus-news.nwnexus.com...
After some experimentation, that's just what I did. But I found I
first had to delete the old paycheck before the revised SUI and L & I
rates were picked up. each time I was warned about deleting a
reconciled check, and said it's OK. After completion, I looked at the
April reconciliation screen. The new checks are all there. I assume
after April 30 when I do the normal reconciliation, I'll check them off
as having cleared.

If the new checks are showing up in the April bank rec then something
changed when you redid the checks. Double check the date, check number
and amount of the new checks against the old ones. The program will
substitute the new checks in the old bank recs and you are good to go.
Run the Reconciliation Discrepancy report to see the details that QB
feels were changed. Match those missing records and the bank recs should
correct themselves. Right now your prior bank recs for those months
impacted by the check corrections are incorrect.


Back to top
  Ads
Advertising
Sponsor


Display posts from previous:   
Post new topic   Reply to topic    Accounting Talk Forum Index -> Quickbooks All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Board Security

68 Attacks blocked

Powered by phpBB © 2001, 2005 phpBB Group