July 29, 2005 at 1:30 pm #11389
Is there a method to Print the details of the Revenue Canada cheques?
ie: Block Rev Can payment and be able to get a list of the employees, the deductions from each, and the company portion, which totals the payment.
Post Edited (07-29-05 10:48)August 4, 2005 at 3:38 pm #12859
Like in NV1 (PRREPORT) there is Payroll Report in NV2 which you can access by right mouse clicking on the top green table (shows employees) Print > Payroll Report.
There are two templates available for Payroll Withholdings:
American Users: payroll_us_withholdings_payable.xls
Canadian users : payroll_ca_withholdings_payable.xls
Press F3 in the Template value field in Payroll Report to see a list of the available templates.
Note: You must complete the Payroll Report Codes Window to define the account suffixes and employer accounts to report on the template. See the NewViews 2.0 manual Payroll > Custom Payroll Reports for more information.
I also suggest that you review the template in Excel.
MartinAugust 4, 2005 at 6:48 pm #12860
The PRREPORT does not provide the breakdown of specific remittance cheques (listing the employee cheques and amounts).
Does the nv2 withholdings_payable?August 4, 2005 at 7:44 pm #12861
PRREPORT when set to details will provide a breakdown of the employee cheques that should make up the amount of the CRA remittance (you must use the correct date range) including the employers E.I. and C.P.P. contributions. The employer accounts are specified in the notes view of the template.
MartinSeptember 12, 2005 at 7:04 pm #13011
The problem with PRREPORT is that it prints the actual information for the date ranges recorded in the various accounts.
For example if you voided several pay cheques after remitting than those cheques would no longer be included in the PRREPORT, and therefore the printout would not match the actual remittance figures.
The next remittance would deduct for the voided cheques and again PRREPORT would not reflect the difference for that pay period.
My question regarding nv2 was “is there a method to print the actual employee cheque detail which make up specific remittances (regardless of when you print the report, at the time or twelve months later).September 13, 2005 at 11:36 am #13015
This request is like the Rev. Can Payments question. I’ll forward your request and get back to you.
MartinSeptember 15, 2005 at 8:37 am #13021
>Re: Rev Can Audit
>Posted by: HMah (AC5-Webproxy46.direcpc.com)
>Date: September 12, 2005 03:04PM
>The problem with PRREPORT is that it prints the actual information for
>the date ranges recorded in the various accounts.
I’m not sure how a report that prints ‘actual information’ can be construed as a ‘problem’, but let’s continue …
>For example if you voided several pay cheques after remitting than
>those cheques would no longer be included in the PRREPORT, and
>therefore the printout would not match the actual remittance figures.
Well, they would be included in any report printed *before* you voided the checks and (obviously) not be included in a report printed *after* voiding them. The 1st report would match the remittance and the 2nd would not. The same would be true for any other remittance report you could think of once you start changing/deleting transactions dated in the past.
The solution seems clear: Don’t void pay checks, use reversing entries instead (dated in the current period.)
>The next remittance would deduct for the voided cheques and again
>PRREPORT would not reflect the difference for that pay period.
Using reversing entries would solve that.
>My question regarding nv2 was “is there a method to print the actual employee >cheque detail which make up specific remittances (regardless of when you print the >report, at the time or twelve months later).
In the scenario you describe, this is impossible. You can’t print a report showing deductions & contributions that matches an actual remittance, void some pay checks, then produce a report that somehow includes pay checks that are no longer there.
About the only thing that would be possible is to ‘archive’ a snapshot of the amount details at the time you produce the remittance check. The pay withholdings feature *could* do that – but you run smack into a problem if you edit the remittance amounts before posting the check. In that case the details would not match the remittance and you’re back in the same boat you started in.
BobSeptember 17, 2005 at 12:40 am #13022
I agree, using reversing entries in the current month would solve the problem, Assuming no-one ever voids a paycheque.
I prefer your suggestion of an archive snapshot at the time of calculation. Something like the T4SUM in nv1 saved by the date or ck# as part of the filename.
The purpose of the request is when Rev Canada does an assessment, they always ask for the details of the remitted amounts. The snapshot archive would provide that exact details of each cheque. Where cheques were voided, they would have to be included in the next archive listing.
You must be logged in to reply to this topic.