EoFY Checklist including Payment Summaries and Empdupe file

Dee Burgin_6949616

Is there a link you can send me on the step by step process of doing the Payment Summaries and Empdupe file at the end of the Financial Year please ??

Mirko

Hi Dee, welcome to the Reckon Community & thank you for your post. I've located this article which runs through EOFY steps inclusive of EmpDupe process: http://kb.reckon.com.au/issue_view.asp?ID=4155

Hope it helps.

Mirko

Dee Burgin_6949616

Thank you for the prompt reply. And the link will help enormously ..... happy EOFY !!!

Mirko

You're welcome Dee. It will be a good one when it's all over Hope all goes smoothly for you!

Michelle_6954083

This reply was created from a merged topic originally titled Group Certificates. I'm preparing to print my Group Certificates and realized that not all the employees have pulled through has this happened to any Thanks

Mirko

Hey Michelle, please run through this EOFY Checklist and see if that resolves the problem. Thanks, Mirko

Michelle_6954083

Thank you that was a quick resolve had to set the printing of payslips to both.

Phil_6945793

Thanks Mirko for the link to  http://kb.reckon.com.au/issue_view.asp?ID=4155 . It is quite helpful even though it applies to QuickBooks and not Payroll Premier.

We have a complicated pay rate structure so need software with more grunt so use Payroll Premier. However, we also have the issue of no payment summaries being generated for employees with zero tax deducted for the financial year. I can't fathom why Reckon haven't addressed this issue as it's over 5 years old now!! A payment summary should be generated for all employees regardless of wether they have had tax deducted or not. What if they have 2 jobs and the aggregate of the two jobs, with unrelated employers, requires them to pay tax ? To require Payroll Premier users to add $0.01 to one pays tax and then to have to take it out is not a fun task, especially for 5 years. And this year we have the added complexity that when you do add the one cent, the GROSS changes?????? There is a bug in the way it originally calculated the pay at the time and when you go to edit it for the tax, it corrects the bug. Come on Reckon - fix this (it is the year 2014 and we put a man on the moon in 1969 with a computer with less grunt than a current mobile phone!!) 

Phil_6945793

This is the error with the gross. This should be a Total Gross of $71.08 ?

George Tsalacopoulos

This reply was created from a merged topic originally titled PAYG payment summaries do not match yearly pays report. I am preparing PAYG payment summaries (INB) the same as every year for the last 10. This time the payment summaries do not match the totals (gross/tax etc) in the yearly pays report. The yearly pays report is correct. In compiling the PAYG summaries, the software has added an extra weeks wages for each employee. Any help would be appreciated please.

Phil_6945793

Hi George, Be careful here. Don't know if this helps but according to what I can ascertain, the ATO works on PAID DATE for Payment Summaries, not Period End Date. When running Payment Summaries you should change the 'Preference', 'Printing' to 'Date Paid'. So if a pay ended prior to 30 June but was paid on or after 1 July then that pay will not be included in 2013 Payment Summaries. When you run all yearly reports, be they yearly pays report or payment summaries they all should then match. 

Waratah Golf Club

This reply was created from a merged topic originally titled EmpDupe File. I am in the process of completing our payment summaries but can not create the EmpDupe file.

I am following the instructions;
Choose Reports menu > Payment Summaries > Create EmpDupe file for ATO

I get through the first two steps but it doesn't offer me an option to create the file?

Can anyone help please?

Erika De Nobrega

This reply was created from a merged topic originally titled UNABLE TO PRINT PAYMENT SUMMARIES. KEEP ASKING ME TO ENTER COMPANY LEGAL ADDRESS EVEN THOUGH IT HAS BEEN ENTERED???

Phil_6945793

Hi Erika and Others

Please specify what system you are running and what version - Payroll Premier/Quickbooks??

Impossible to help unless that info is present on chats

Pancho's Dust

I have two errors on an EmpDupe file submitted to the ATO.

Reason Code:  VR04                      Total errors:    1
The field must not contain blanks or non numeric characters.

Reason Code:  VR34                      Total errors:    1
The Payer Australian business number or Withholding payer number field contains an Australian business number therefore the Branch number field must be within the range of '001-999'.

Where in Reckon accounts can I enter the correct details? Or. Any other suggestions.

Mirko

Hey Pancho's Dust, this thread may help: https://community.reckon.com.au/reckon/topics/i_am_unable_to_upload_emdupe_file_to_the_ato_from_reck...

Pancho's Dust

Thanks, it directs me to where i can edit company information, however, the reason code vr04 States "The field must not contain blanks or non numeric characters." It does not say which field. If I remove the spaces in my ABN, Reckon automatically puts them back.
Reason code vr34 states that a branch number is required but I cannot see where to enter that in Reckon accounts.

Mirko

Hey Pancho, do any company records or employee have character details like '&'?

Branch number, try adding 001 to the right of your ABN number as per the screenshot by Graham in that thread.

Keen to hear how you go.

Pancho's Dust

After speaking to the ATO I have been informed that error code vr04 pertains to non numeric characters in the payees income amount. After checking the printed version I can see no non-numeric characters.
Error code vr34 pertains to the missing 3 digit branch number. I can see nowhere in Company>Company Information to enter this.

Mirko

3 digit branch number goes to the right of the Tax Rego ID.

Re: VR04 I'll ask one of our techs if there is anything else that could contribute.
-Mirko
?

Pancho's Dust

Bingo! After adding the branch code where I had ABN entered I created an new EmpDupe file and it was successfully lodged. Thanks

Jason Jiao

Hi Pancho, 

VR04 might be caused by the Branch number as well, because it shifts characters to the incorrect data field as a result. Just enter the 3 digit branch number and validate the file again.

Let us know if you still encounter the error message.

Thanks
Jason?

Pancho's Dust

Makes sense, as all I did was add branch number and all was well.

jessica_6902150

Hi
I have problem with exporting Empdule file from reckon. I just have 2 options to save to file to B or Q drive?

How do I copy to other location?

Mirko

Hey Jessica, you'd need to save it to your Q drive. Once it is saved you can download it to your local drive. If you haven't used the feature yet, we have a video on how upload/download works. ^mirko

jessica_6902150

Hi MirKo!

It is very helpful!!!!
Thank you! 

Michelle_6954083

Hi I may be missing something and need to submit the EMPUDUPE file and the help says to go to Employee Menu click Process Payment Summaries and the click ATO Magnetic Media please help.

Michelle_6954083

Please disregard my inquiry .. Thank you ?

Mirko

Seeing as it's the end of the 14/15 FY, it might be time to bump this thread up to help some of our newer community members! ^Mirko.

Trevor Watson

And older members too Mirko

Mirko

Trevor, of course. It might even be a good one for all members to bookmark somewhere!

Trevor Watson

One thing to note is the location of the saved empdupe file has changed.

It is now

C:> ProgramData > Reckon > Reckon Accounts 2015 > edition & flavour 20xx > filename > Export Files > EMPDUPE Files > EmpDupe.txt

Would be nice if you could update the kb article with this info.

Mirko

Great point Trev, I'll raise this with the team that looks after KBs.

Lilia Sorban

HI

I have discrepancies between Payroll summary report and total of all group certificates. There is difference of $4, because of rounding cents. Is there any possibility to fix it. Please help.

Many thanks

Carla Biacchessi

Hi Mirko
I have prnted and payment summaries and reports much perfectly but I am trying to save payment summaries via electronic file in order to lodge electronically to the ATO but it is giving me an error such as:
---------------------------
Error Copying File or Folder
---------------------------
Cannot create or replace ABAPages: The filename, directory name, or volume label syntax is incorrect.


---------------------------
OK  
---------------------------

and also another one when I click ok such as:
---------------------------
There is a problem with the auregfind file
---------------------------
Failed to load auregfind
Error, line 0, reason: The filename, directory name, or volume label syntax is incorrect.


---------------------------
OK  
---------------------------

Are you able to help as I have been looking for a solutions and I seem not able to find it.
Thank you
Carla

[Deleted User]

Have you checked that you have all the employees TFN in correctly and the business details in company information are correct. I had a similar problem last year and it was as simple as checking the data. Good luck