Consolidating / merging multiple Tax Agencies - Australian Taxation Office, Australian Tax Office, ATO etc in QuickBooks
Performing a clean install or clean uninstall of QuickBooks QBi
Modifying the date or pay period without unlocking the net pay will cause incorrect RESC reporting on Payment Summaries / Empdupe file
My Super reports and my Payment summary are not reporting the same RESC amounts.
How to set the default email program to work with QuickBooks for emailing invoices.
End of Year Process of Payment Summary, Magnetic Media form and EMPDUPE file creation.
I have entered a FBT amount and it is not showing on my Payment Summary for the financial year, I use QuickBooks QBi.
Payment Summaries do not display / print employees with a zero tax amount in Payroll Premier
Error opening file: This file is either corrupt or not a valid version 6 data file
QuickBooks PDF problems on 64-bit Windows Operating Systems when emailing or reconciling
Deductions and Allowances report incorrectly on the Payment Summary in Payroll Premier
RESC amount on the Payment Summary is incorrect or does not agree with my payroll reports
Error opening a company file on a QBi network
Preparing Payment Summaries and Empupe Files in Payroll Premier
Overwriting the Super amount gets reported in RESC on payment summary.
How to Activate QuickBooks
Cannot print from QuickBooks Hosted
Persisting errors: H101, H202... -6123,0 & -6147,0 with Windows & Term Server or Virtual Machines
RemoteApp Disconnected. Your computer can’t connect to the remote computer.... when logging onto Qu
0% Super (SA) is written to RESC on payment summary.
Employee Tax Scale changes to Shearer – Non Resident + FL in Payroll Premier 2011/12
Employee Tax Scale field is blank after upgrading to Payroll Premier 2011/12
PAYG Tax does not change when Flood Levy applied in Payroll Premier 2011/12
NSW State Payroll Tax threshold showing the incorrect amount in QuickBooks 2011/12
Question: Consolidating / merging multiple Tax Agencies - Australian Taxation Office, Australian Tax Office, ATO etc in QuickBooks
How do I consolidate / merge multiple Tax Agencies - Australian Taxation Office, Australian Tax Office, ATO etc in QuickBooks?
Solution:
In this scenario, we have 2 suppliers – Australian Tax Office and Australian Taxation Office. By default, the payroll features in QuickBooks QBi 2008/09 uses the default name “Australian Taxation Office”. - Therefore the Tax Agency must be set to Australian Taxation Office in the preferences. - If you are currently using QuickBooks 2007/08, follow the steps below before upgrading to QuickBooks QBi 2008/09.
QuickBooks 2007/08: If you have multiple Tax Agencies in your Supplier list, follow the steps below:

1. From the Edit menu, select Preferences 2. From the Tax icon, select the Company Preferences tab 3. Change the Tax Agency to a Supplier that does not relate to Australian Taxation Office

4. Click OK 5. Repeat Steps 1 & 2 6. Turn OFF tax tracking by selecting No. Click OK 7. From the Suppliers menu, select Suppliers List 8. Tick Show All to include inactive suppliers 9. Locate all Suppliers that are related to the tax agency - Australian Taxation Office 10. Right click Australian Tax Office and select Edit 11. Rename the Supplier Name to Australian Taxation Office. Click OK 12. A message will appear - "This name is already being used. Would you like to merge them?" Click Yes 13. Repeat steps 11 to 14 if you have more than two Tax Agency suppliers 14. From the Edit menu, select Preferences 15. From the Tax Icon, select Company preferences 16. Turn ON tax tracking by selecting Yes 17. From the Tax Agency drop down select Australian Taxation Office. Click OK
Note: If you have already upgraded to QuickBooks QBi 2008/09, and is not feasible to revert back to QuickBooks 2007/08, follow the steps below.
QuickBooks QBi 2008/09: Note: In QuickBooks QBi, each tax liability account must have Unique Tax Supplier, Example (Tax Payable to have Australian Taxation Office as a supplier assigned) and (PAYG liability to have ATO as a supplier assigned), this doesn’t apply if your PAYG account is a subaccount of your Tax Payable.
Step1: 1. From the Lists menu, select Chart of Accounts 2. Tick Include inactive on the bottom of the list 3. Locate Sales Tax Payable (If Sales Tax Payable does not exist, continue to Step 2) 4. Right click Sales Tax Payable and select QuickReport: Sales Tax Payable 5. Change the Date Range to All 6. If there are no transactions associated with this account, close the report. If transactions are present, you will need to edit each transaction and save it to another account (e.g. to Tax Payable) 7. Select Sales Tax Payable and from the Edit menu, select Delete. Click OK Step2: 1. From the Edit menu, select Preferences 2. From the Tax icon, select the Company Preferences tab 3. The Default Tax Agency is set to Australian Tax Office. Click OK

4. From the File menu, select Utilities > Export > Lists to IIF Files… 5. Tick Payroll Items and click OK 6. Select a location to save the file (e.g. Desktop) 7. In the File name field, enter payroll.IIF and click Save

8. Minimise QuickBooks 9. Locate the file, right click and select Open With > Choose Program 10. Tick Select the program from a list and click OK 11. From the list, select Notepad and click OK 12. Locate and rename Australian Taxation Office to Australian Tax Office as shown below
 13. From the File menu, select Exit 14. A window will appear stating that the file has changed. Click Yes 15. Maximise QuickBooks - from the File menu, select Utilities > Import > IIF Files… 16. Locate and select payroll.IIF and click Open 17. A message will appear stating that your data file has been imported. Click OK 18. From the Suppliers menu, select Suppliers Centre 19. From the View dropdown menu, select All Suppliers to include inactive suppliers 20. Locate all Suppliers that are related to the Australian Tax Office 21. Generate a QuickReport for each supplier to identify how many transactions are present 22. Right click the supplier and select QuickReport 23. Change the Date range to All 24. In this case, Australian Tax Office has five transactions as shown below:

25. Australian Taxation Office only has one transaction as shown below:

26. Once you have identified which Supplier has the least number of transactions, double click each transaction and rename Australian Taxation Office to Australian Tax Office 27. If the transaction is associated with the Tax Payable account, delete the line and renter the amount. This will refresh the transaction and assign it to the correct tax agency 28. Select the line and press CTRL and Delete on your keyboard

29. When you have re-entered the Tax Payable and Amount, the Australian Tax Office will appear in the Customer: Job as shown in the screenshot below

30. Click Save & Close 31. Repeat steps 28 to 32 until all transactions are removed 32. From the Supplier Centre, select Australian Taxation Office and from the Edit menu > Delete. Click OK 33. If it cannot be deleted, edit the supplier and rename it to ATO old, ATO old 1, etc… 34. From the Edit menu, select Make Inactive 35. Rename your active and main Supplier to be Australian Taxation Office
Question: Performing a clean install or clean uninstall of QuickBooks QBi
How do I perform a clean install or clean uninstall of QuickBooks QBi?
Solution:
It is sometimes necessary to perform a clean install or uninstall to remove residual QuickBooks installation files and folders left behind by Microsoft Add or Remove Programs. This is most often required when the QuickBooks function is damaged or when reinstalling QuickBooks does not correct an issue.
Caution: Performing a clean install of QuickBooks requires that you also reinstall any other Intuit software programs that share the same installation folder; including Quicken and customer Manager.
It is also advised to back up your company file to a safe location to prevent it from being accidentally deleted or overwritten. If you are unable to make a backup through QuickBooks you should use Windows' Copy/Paste command to copy your company files.
Please be sure to have your QuickBooks installation CD-ROM and license key handy before reinstalling QuickBooks.
To perform a clean install or a clean uninstall;
1. Click the Start button and then select Control Panel:
Microsoft Windows 7 & Vista:
a. Select Programs and then click Programs and Features b. Select QuickBooks in the list of programs and click Uninstall c. Follow the instructions to uninstall QuickBooks
Microsoft Windows XP:
a. Double-click Add/Remove Programs b. Select QuickBooks in the list of programs, and then click Remove c. Follow the instructions to remove QuickBooks
2. Manually remove the following QuickBooks installation folders:
Note: Removing the entire Intuit folder will also remove all of the sub folders that are contained within it. Your installation folders may appear differently depending on the version or versions of QuickBooks installed on your computer.
Windows 7 & Vista:
QuickBooks:
1. C:\Program Data\Intuit 2. C:\Program Data\Common Files\Intuit 3. C:\Users\<current user>\AppData\Local\Intuit 4. C:\Users\Public\Public Documents\Intuit 5. C:\Program Files\Intuit 6. C:\Program Files\Common Files\Intuit
Windows XP/2000:
QuickBooks (Pro, Premier, Enterprise Solutions):
a. C:\Program Files\Intuit b. C:\Program Files\Common Files\Intuit c. C:\Documents and Settings\All Users\Application Data\Intuit d .C:\Documents and Settings\All Users\Application Data\Common Files\Intuit e. C:\Documents and Settings\All Users\Documents (Shared Documents)\Intuit
Windows 7 & Vista: - C:\Program Data\Intuit
Windows XP/2000: - C:\Program Files\Intuit
If the Application Data or Program Data folder are not visible:
Windows 7 & Vista:
1. Click the Start button and select Computer 2. In the upper left, click the Organize button 3. Select Folder and Search Options 4. Click the View tab 5. Click Show hidden files and folders 6. Click OK
Windows XP:
1. Right-click on the Start button and select Explore 2. Select the Tools menu and then select Folder Options 3. Click the View tab, and then under Advanced Settings, select the Show hidden files and folders checkbox 4. Click OK
Once QuickBooks is completely removed from your system, you may proceed with a new installation.
Question: Modifying the date or pay period without unlocking the net pay will cause incorrect RESC reporting on Payment Summaries / Empdupe file
Why is the RESC reporting incorrect on Payment Summaries / Empdupe file when editing the date or pay period?
Solution:
This will occur if you have modified the date or pay period without selecting Unlock Net Pay. It does not take into account the changes you have made.
To resolve this;
- Edit the pay
- Click Paycheque Detail
- Click Unlock New Pay
- Modify the Pay Period and click OK
- Click Save & Close
The RESC reporting on Payment Summaries / Empdupe file will now be correct.
Question: My Super reports and my Payment summary are not reporting the same RESC amounts.
Why don't my super reports show the RESC amounts entered as a YTD adjustment for my SS ( Salary Sacrifice) and EA (Employee Additional ) super items?
Solution:
***** THIS ISSUE HAS BEEN RESOLVED IN THE 2011/12 EDITION *****
The Super reports are designed to only pick RESC amounts from paycheques and not as a result of any YTD adjustment.
However, the total figure that appears on the payment summary and EMPDUPE file will include paycheques and YTD adjustments.
In order to reconcile your payment summary figures with your super report figures you need to do the following:
1- Go to reports drop down menu. 2- Go to Employees and Payroll. 3- Select Payroll Item Detail Report . 4- Click on Modify report and then Filters. 5- In the Filter box choose Payroll Items then select all RESC-related super items such as SS and EA. 6- The report will show amounts for the payroll items selected for the specified date range.
Question: How to set the default email program to work with QuickBooks for emailing invoices.
When I try and send an invoice to a customer via email, I get a message saying that you need to setup outlook before using this feature. How can i do this? I am already using outlook as the email handler for my email.
Solution:
To resolve this problem:
1. Open Internet Explorer
2. Click on Tools then Internet Options and Programs tab
3. To choose your email program:
Windows XP: click in the E-mail field
Windows 7 & Vista: click on Set Programs in the Internet Programs section and then Set your default program
4. Select Microsoft Office and click OK.
QuickBooks will now use Microsoft Outlook as the default mailer.
Question: End of Year Process of Payment Summary, Magnetic Media form and EMPDUPE file creation.
It's the end of the financial year and I need to print the employee's Payment Summaries and send my EMPDUPE file to the ATO, what do I have to do?
Solution:
The information below relates to the 2007/08 QuickBooks and financial year. Click here for KB 4155 for information relevant at 30/6/2011 and for QuickBooks QBi series
QuickBooks is only designed to print Payment Summaries on plain paper which is not an accepted format. The ATO accepts Payment Summaries via two methods:
- QuickBooks Electronic file (Empdupe)
- Print out using ATO provided stationery
Note: You will need to hand write the Contact Name (Payroll) when printing out payment summaries.
The ATO has specified a new format for the INB payment summary for pays from July 1, 2007 and beyond with the new payment summaries there is no longer a need for a separate payee’s tax return copy. Only one copy is given to each employee and the employee keeps this for their own records. There is also no longer a need for a separate Notice to payee.
QuickBooks can create the EMPDUPE file an employer is required to send to the ATO.
To do this;
1) Go to the 'Employees Navigator' and select 'Process Payment Summaries'. 2) Tick the employees a payment summary needs to be created for. 3) Click on the 'Electronic File' button. 4) In the 'Save In' screen choose a location to save the file and click 'Save'.
Along with this file you must also submit the "Magnetic Media Information" form, you can obtain a copy from the ATO website at: http://www.ato.gov.au/content/downloads/MEI30459PSARMagMediaV8.pdf
Question: I have entered a FBT amount and it is not showing on my Payment Summary for the financial year, I use QuickBooks QBi.
How do I report a FBT amount on my Payment Summary in QBi?
Solution:
The FBT year is the 12 months beginning 1 April and ending 31 March.
Example:
To report FBT for the 20x0/x1 financial year, the FBT should be entered between the 1 April 20x0 and 31 March 20x1.
Setting up the item:
Go to the Payroll Item List and select New. Follow the prompts at each window, as described below.
- Payroll Item Type:
Choose the Company Contribution item type.
- Name Used In Payments & Payroll Reports:
Select a suitable name (e.g. FBT).
- Agency for company-paid liability:
Select the Agency, Liability and Expense accounts that you would use for FBT.
- Tax Tracking Type:
This needs to be assigned to Reportable Fringe Benefits. QuickBooks will now show all amounts assigned to this item under the Reportable Fringe Benefits section of the employee's INB Payment Summary.
- Taxes:
Untick PAYG so that PAYG tax isn't calculated on the FBT item.
- Calculate Based On Quantity:
Select Neither.
- Gross vs Net Window:
Leave the Gross Pay radio button selected. Note that any selection in this window is not relevant as the FBT amount will be manually recorded.
- Default Rate & Limit:
Leave both of these fields blank, you will be manually entering the FBT amount when Processing the pay.
Once the FBT item has been set up you can select it on an Employee Pay make sure you enter the pay sometime before the end of March to reflect on this financial year.
Question: Payment Summaries do not display / print employees with a zero tax amount in Payroll Premier
Why are Payment summaries not displaying / printing employees with a zero tax amount in Payroll Premier?
Solution:
The payment summaries Payroll Premier are designed to show all employees that have a tax amount which in the majority of cases is all employees. In some exceptional situations whereby an employee incurs no tax if they have a 100% salary sacrifice or they are under the age of 18 that earn $112 or less weekly, $225 or less fortnightly and $489 or less monthly; in this case will not generate a payment summary.
To generate Payment summaries to display/print employees with a zero tax amount, you will need to Edit a pay and enter .01 tax;
1. From the Employee List, right click and select Show Employees Pay 2. Select and right click on the last pay and choose Edit 3. Tick Edit This Pay 4. Enter 0.01 in the Tax box 5. Click OK
Note: All employees that have a zero tax amount will need to be edited.
Question: Error opening file: This file is either corrupt or not a valid version 6 data file
Why can’t I open my Payroll Premier data file? I get the error: "This file is either corrupt or not a valid version 6 data file"
Solution:
The data file is corrupt.
Solution
Restore your last backup.
1. Close down all programs including Payroll Premier
2. Delete the file QCompany.TPS file:
a. In Windows Explorer navigate to:
Windows 7 & Vista: C:\QPRollvXX\Data;
Windows XP: C:\Program Files\QPRollvXX\Data
where XX is the Version Number of the program. eg:
19 = 2010/11
18 = 2009/10.
3. Open up the Payroll Premier program;
4. Open sample company sampleco.qpw;
5. Restore your last successful backup which is FILENAME.QPB
If your last backup is not current, restore the Payroll Premier Autobackup. The Autobackup will restore your file to the last pay run.
To restore an Autobackup:
1. Close down all programs including Payroll Premier
2. Click on the Windows Start Button > All Programs > Payroll Premier 20YY-YY > Payroll Premier Recovery; (where YY-YY represents the year verion)
3. Click Next on the Welcome to the Payroll Premier Recovery Wizard
4. Select the radio button for ‘I wish to recover back to a previous pay’ and click Next;
5. Select the file and date from the table (take note of the warning) and click Next;
6. If the choice is correct and you want to proceed, click Yes;
7. Click Finish to close the Payroll Premier Recovery Wizard.
8. Open Payroll Premier and your datafile.
Question: QuickBooks PDF problems on 64-bit Windows Operating Systems when emailing or reconciling
Why do I get the error: ' Could not print to printer. Check your printer selection. Printing may have been cancelled from another program'?
Solution:
This is an error that will occur on a 64-bit Windows Operating System.
The solution below can be used for the following errors as well:
· QuickBooks PDF Converter Activation Error -20: You cannot print directly to the QuickBooks PDF Converter. Try using QuickBooks Save as PDF menu option or Activation error. Printer not activated. Error code -20.
· The device is not ready.
· QuickBooks could not save your form as a PDF file.
· Unable to save as PDF.
· Other .PDF file-related errors may occur when you email transactions.
· QuickBooks stops responding when you try to reconcile accounts.
Solution
Check for PDF Converter conflict with older versions of QBi
- Make sure that you are logged in to Windows with administrator rights. Check with your network administrator to see if you have administrator rights. Ensure that QuickBooks is closed.
Windows 7 & Vista users must login as the built-in Administrator:
1. Click on Start, then All Programs, then Accessories, then right click Command Prompt and left click Run as administrator;
2. Type in the following command to turn on or off the account:
a. Turning on: net user administrator /active:yes
b. Turning off: net user administrator /active:no
- Click the Windows Start button and choose Control Panel.
· Windows 7: Under Hardware and Sound, click View Devices and Printers.
· Windows Vista: Under Hardware and Sound, click Printer.
· Windows XP: Double-click Printers and Faxes.
- If you see both QuickBooks v303 PDF Converter and QuickBooks PDF Converter, continue with this section. Otherwise go to the next section: If problems persist, reassign the Port for the QuickBooks v303 PDF Converter.
- Right-click the QuickBooks v303 PDF Converter and choose
· Windows 7: See what’s printing.
· Windows Vista & XP: Open.
- If there are items in the print queue, clear the queue, then close the window.
· Right-click on QuickBooks v303 PDF Converter
· Windows7: select Remove Device.
· Windows Vista & XP: select Delete.
- Right-click on the other QuickBooks PDF Converter and view the printer queue. Delete items in the queue then close the window. Now choose to delete the QuickBooks PDF Converter.
- Close the Devices and Printers window.
· Delete the QuickBooks printer files – QBprint.qbp and wpr.ini:
§ Windows 7 & Vista: C:\Program Data\Intuit\QuickBooks 2010-11\
If you cannot see C:\Program Data then it is hidden. To unhide it click on Organize > Folder and Search Options > View > and in the Advanced Settings box, under Hidden files and folders, click on the radio button Show hidden files, folders and drives.
§ Windows XP: C:\Documents and Settings\All Users\Application Data\ Intuit\QuickBooks 2010-11\
· Go to the QuickBooks installation directory. The default directory is: C:\Program Files x86\Intuit\QuickBooks 2010-11\.
(See Additional Note below if you cannot locate your installation directory)
- Find install.exe and double left-click to run it. Wait while the white text scrolls through the black window. When finished, close all Windows.
- Open the Devices and Printers window, right-click Amyuni Document Converter 300 and:
· Windows 7: select Printer Properties, then Rename to QuickBooks v303 PDF Converter.
· Windows Vista and XP: select Rename and enter QuickBooks v303 PDF Converter.
· **Note** The file must be renamed exactly as shown here, including spaces.
- Close the Devices and Printers window and test PDF functionality in QuickBooks.
If problems persist, reassign the Port for the QuickBooks v303 PDF Converter.
1. Delete the QuickBooks printer files – QBprint.qbp and wpr.ini:
§ Windows 7 & Vista: C:\Program Data\Intuit\QuickBooks 2010-11\
§ Windows XP: C:\Documents and Settings\All Users\Application Data\ Intuit\QuickBooks 2010-11\
2. Click the Windows Start button and choose Control Panel.
· Windows 7: Under Hardware and Sound, click View Devices and Printers. Then right-click the QuickBooks v303 PDF Converter and choose See what’s printing.
· Windows Vista: Under Hardware and Sound, click Printer. Right-click the QuickBooks PDF Converter and choose Open.
· Windows XP: Double-click Printers and Faxes. Right-click the QuickBooks PDF Converter and choose Open.
3. If there are items in the print queue, clear the queue, close the window, right-click the QuickBooks v303 PDF Converter and choose Properties.
4. Click the Ports tab and then click the Add Port button.
5. Select Local Port and click the New Port button.
6. Enter NUL: in the Enter a port name field, click OK, and then click Close.
7. Be sure that the NUL: port is selected in the Ports list and click Apply.
8. Click the Advanced tab.
9. Select Spool print documents so program finishes printing faster.
10. Clear the checkbox labelled Enable advanced printing features.
11. Select Print directly to printer.
12. Click the Driver drop-down arrow and select Amyuni Document Converter 300.
13. Click Apply and then click OK.
14. Right-click the Windows taskbar and choose Task Manager.
15. Click the Processes tab.
16. Select splWOW64.exe and click the End Process button.
§ Windows 7 and Windows Vista: Click End Process in the warning window.
§ Windows XP: Click Yes in the warning window.
17. Close all applications and restart the computer.
Test PDF generation in the following order:
Open any Report in QuickBooks 2010/11 and email it.
Open a Tax Invoice, select a Quicken Standard Template and email the invoice.
Open a Tax Invoice, change the Template to your desired template and email it; it should email successfully.
When complete, Windows 7 & Vista users should log out of the built-in Administrator account.
Additional Note
To find the location of your installation directory:
· right-click the QuickBooks 2010-11 desktop icon and select Properties;
· read the location in the Target box;
· click on Open File Location to open to the installation directory in Windows Explorer.
Question: Deductions and Allowances report incorrectly on the Payment Summary in Payroll Premier
Why are my Deductions and Allowances reporting incorrectly on the Payment Summary for financial year 2009/10? My deductions and allowances payroll items are properly configured and Deduction and Allowance reports show the correct amounts.
Solution:
The Payment Summary is configured to display information according to the Date Paid, regardless of the datafile’s printing preference. However, Deductions and Allowances will still show amounts according to the datafile’s printing preference.
This problem will appear where your last pay of the financial year has a pay end date on or before the 30th June and a date paid on or after 1st July. The Payment Summary will display all other components on a Date Paid basis and so exclude the last payment, but the deductions and allowances will be displayed on a Pay End Date basis and include the last payment.
Solution
Change printing preferences to Date Paid:
· Click on File, then Preferences, then Printing
· In the Print By box, choose Date Paid
o Note: changing this preference will re-index your datafile. The time this re-indexing will take depends on the size of your file. Large files with over 100 employees may take over half an hour to re-index.
· Check the Payment Summaries again.
Question: RESC amount on the Payment Summary is incorrect or does not agree with my payroll reports
Why is QuickBooks reporting the RESC amount on the Payment Summary incorrectly?
Solution:
The RESC field will report all Super amounts paid from pre-tax earnings above the statutory 9%, or where a collective agreement exists, above the agreed rate. For more information on RESC users should refer to their accountants or click here for the ATO’s information page.
QuickBooks reports all super salary sacrifice (SS) and employer additional (EA) super items to RESC. QuickBooks will also report amounts in excess of the statutory 9% for Super Guarantee Act (SA), and in excess of the collective agreement rate (CA) super items, if the option Calculate RESC difference for SA and/or CA payroll items is ticked in Preferences for Payroll & Employees.
QuickBooks will only make the calculations for RESC for pays processed in QuickBooks 2009/10 R2 versions and later. If you did not upgrade to QuickBooks 2009/10 R2 before processing your first pay in the financial year 2009/10, then the pays processed before the upgrade will not have RESC calculated and are not being reported in the Payment Summary.
YTD adjustments with RESC-related items will not be included on reports, but they will be included in the payment summary.
Solutions
Solution 1: If you upgraded to QuickBooks 2009/10 R2 or later after the first pay for financial year 2009/10 had been processed.
Solution 2: If all pays have been processed in QuickBooks 2009/10 R2 and later.
Before starting on a solution, make a new backup of your company file. Do not override existing backups.
Solution 1: If you upgraded to QuickBooks 2009/10 R2 or later after the first pay for financial year 2009/10 has been processed.
- Ensure your company file is configured to calculate RESC for excess super in SA and CA super items:
- Click on Edit, then Preferences, then Payroll & Employees and then Company Preferences;
- Tick the box Calculate RESC difference for SA and/or CA payroll items and click OK.
- Open each pay processed before the upgrade and refresh all RESC-related super items – SA, CA, SS and EA:
- Click on Reports, then Employees & Payroll and select Payroll Item Detail;
- Click on the Modify Report button and change the date range to the period 1 July 2009 to the pay before the upgrade;
- Click on Filter and in the choose Filter box select Payroll Item;
- In the Payroll Item box select Multiple payroll items;
- Then select all super payroll items of SS and EA and any SA and CA type items that paid excess amounts; click on OK;
- Print out the report.
- Double click on the first item to open the Paycheque window;
- Click on the Paycheque Detail button to open the Review Paycheque window;
- Click on Unlock Net Pay at the bottom of the screen, take note of the releveant super amounts, delete these super items, reinput the super items with the same amounts;
- click OK to save changes and close the Review Paycheque window; click Save & Close to save the Paycheque window;
- continue with these steps until all relevant super items for all affected employees have been refreshed.
Your Payment Summaries should now report RESC correctly.
Solution 2: If all pays have been processed in QuickBooks 2009/10 R2 and later
- click on Reports, then Super Report by Employee;
- click on the Modify Reports button and change date to This Financial Year;
- in the columns box tick RESC Amount and click OK;
- Examine the RESC Amount column entries for irregularities;
- Correct errors by refreshing the relevant pays – follow steps 3(g) to 3(k) above.
- Continue until all irregularities resolved.
Your Payment Summaries should now report RESC correctly.
If this step did not resolve the problem completely, repeat these steps with a Super Report by Fund.
Additional Note If you have entered a YTD adjustment that has included
Question: Error opening a company file on a QBi network
Why am I receiving errors - "H101," "H202," "H303," "H505", -6077,0, -6123,0 -6000, -80, -82 when opening a company file on a networked QuickBooks QBi?
Solution:
QuickBooks is trying to establish a connection to the company file and can't communicate with the server. Several issues can cause these errors:
1. Hosting configuration settings are incorrect.
2. The firewall is blocking incoming or outgoing communication to the company file.
3. The .ND file is damaged or incorrect.
4. QuickBooks can't obtain the IP address of the system or server hosting the company file.
Solutions
We suggest that users follow the following steps in rectifying this issue. Although your problem is due to one of these conditions, following all these steps will ensure that your network QuickBooks is properly configured.
As a preliminary step users should restart their computers and try again before continuing with the following steps.
Step 1: Ensure that only one PC is hosting multi-user access
· For a Client/Server network – only the File Server is hosting multi-user access through the Database Server Manager.
· For Peer-to-Peer networks – only the host PC is hosting multi-user access.
To check hosting on workstations, click on File then Utilities:
1. If you see Host multi-user access then the workstation is properly configured
2. If you see Stop Hosting multi-user access, click on it to turn off hosting.
To check hosting on a Server:
· Click on Start then enter services.msc in the search programs... or Run box;
· find Quickbooks Database Server Manager or QBCF Monitor Service and note whether it is set to Automatic and is Started. If not refer to Step 2 below.
· Find QuickBooksDBxx (where xx is your QBi version) and note whether it is set to Started. If not refer to Step 2 below.
Try opening your company file.
Step 2: Restart the QuickBooks Services on the Server.
1. Click on Start then enter services.msc in the search programs... or Run box;
2. find QuickBooks Database Server Manager or QBCF Monitor Service, right-click and select Properties;
3. click on the Stop button;
4. in the Startup Type box select Disabled and click on OK to close
5. find QuickBooksDBxx (where xx is your QBi version), right-click and select Properties;
6. if the service was started, click on the Stop button;
7. in the Startup Type box select Disabled and click on OK to close
8. click on QuickBooks Database Server Manager or QBCF Monitor Service, right-click and select Properties;
9. click on the Start button and click Apply;
10. in the Startup Type box select Automatic and click on OK to close;
11. click on QuickBooksDBxx (where xx is your QBi version), right-click and select Properties;
12. in the Startup Type box select Automatic and click on OK to close;
Try opening your company file.
Step 3: Delete the .ND files.
1. Click on Start then Computer and browse to the folder containing your company files;
2. Ensure that you can see all file extensions and find and delete the .ND files associated with your company files;
3. On the File Server, launch the QuickBooks Database Server Manager, select your folders containing company files and scan; minimize when complete.
4. Launch QuickBooks on one workstation and open a company file. Open the same file on a second workstation to confirm multi-user access.
5. On a Peer-to-Peer network, launch QuickBooks on the Host PC and open a company file. Switch the file to mulit-user mode and open it on a workstation to confirm multi-user access.
Step 4: Ensure the QuickBooks User has permissions to access the company files:
i. Right click & select Properties on the folder where the company files are stored.
ii. Go to the Security tab.
iii. Under the Groups or user name list on Security tab – locate QBDataServiceUserxx (where xx is QBi version).
iv. If QBDataServiceUserxx is not in the Groups or user name list, click Add.
v. On Select Users or Groups window, click on Advanced…
vi. On the second window of Select Users or Group window, click on Find Now.
vii. Locate QBDataServiceUserxx from the Search Result below then click Ok.
viii. QBDataServiceUserxx appears in the list of Security tab.
ix. Allow QBDataServiceUserxx full control to the folder by ticking the checkbox for Full Control. Then click Apply and OK.
Try opening your company file.
Step 5: ensure that all QuickBooks processes are made exceptions in your firewall, anti-virus and other monitoring programmes:
· FileManagement.exe located in C:\Program Files\Intuit\QuickBooks 20xx-xx
· QBCFMonitorService.exe located in C:\Program Files\Common Files\Intuit\ QuickBooks
· QBDBMgr.exe located in C:\Program Files\Intuit\QuickBooks 20xx-xx
· QBDBMgrN.exe located in C:\Program Files\Intuit\QuickBooks 20xx-xx
· QBGDSPlugin.exe located in C:\Program Files\Intuit\QuickBooks 20xx-xx
· QBW32.exe located in C:\Program Files\Intuit\QuickBooks 20xx-xx
· QBUpdate.exe located in C:\Program Files\Common Files\Intuit\QuickBooks\ QBUpdate.
· Port 10174 for 2011/12; Port 10173 for 20010/11 and Port 10172 for 2009/10 and earlier
Your QuickBooks is now properly configured for multi-user access across a network.
Question: Preparing Payment Summaries and Empupe Files in Payroll Premier
What steps do I need to take to ensure my employees have correct Payment Summaries and that I submit a correct Empdupe to the ATO?
Solution:
The default reporting setting in Payroll Premier is the Pay End Date, that is, the last day of the pay period.
The ATO requires payroll information to be reported on a Date Paid basis, that is, the day the employee was actually paid.
Where your Pay End Date and Date Paid are on or before the 30th June, Payroll Premier will automatically produce the correct Payment Summaries and Empdupe.
If you have a pay with a Pay End Date in June and a Date Paid in July, or a Pay End Date in July and a Date Paid in June, your Payment Summaries will print correctly but you will need to make a printing preference adjustment to get a matching Empdupe file.
Your Empdupe file will print according to your printing preference. By default the printing preference is set to Pay End Date. If that is your setting (and it will be if you have not changed it), then the Empdupe will be different to the Payment Summaries.
To change your printing preference:
1. On the top menu line select File and then Preferences and Printing icon;
2. Change the Print By box to Date Paid and click Save;
3. Create the Empdupe file;
4. Return your preference to Pay End Date.
Note: When you change the Print By box Payroll Premier will re-index your file. This process will take a little time. If you have a particularly large data file – over 100 employees (current and terminated) and many years of history – you should allow a couple of hours for this process to complete. During this process you may get a Not Responding message - do not act on it and let Payroll Premier continue and finish naturally.
Question: Overwriting the Super amount gets reported in RESC on payment summary.
Why when I overwrite the Super amount when preparing pays, the amount gets reported in the RESC field of the Payment Summary?
Solution:
The Australian Government requires you to report any payments of super in excess of the 9% Super Guarantee (SA) or an approved collective agreement rate (CA) separately on the payment summary in the RESC field.
QuickBooks will automatically report some super payroll items to RESC – super salary sacrifice (SS) and employer additional (EA)
QuickBooks has a preference setting that when checked will automatically calculate and report amounts outside the statutory or collective rates to RESC. If the amount you are entering for Super is different to these rates, then the difference will be reported to RESC on the payment summary.
Reckon acknowledges that the automatic calculation function for SA and CA will report any difference whether that amount is greater or less than the 9% or collective agreement rate. It should report only amounts greater than the 9% or collective agreement rate. This problem is being investigated.
Solution
You must first understand why you need to alter the amount of Super as QuickBooks is configured to calculate the correct amount of Super. Common reasons you may want to do this are:
- The Super item is incorrectly configured;
- Other payroll items are impacting on Gross Payments leaving a lower amount to calculate super on;
- Correct an overpayment in a previous pay.
Your first step is to verify that all items are correctly setup and being used in the correct manner.
1. Super Items
a. The correct super type is selected:
i. SA for the 9% Super Guarantee;
ii. CA for approved collective agreement amounts;
iii. EA for Employer Additional amounts (reports to RESC);
iv. SS for Super Salary Sacrifice (reports to RESC);
v. MV for additional super contributions made by the employee from after-tax pay (member voluntary);
b. Tax Tracking Type is set to None;
c. Taxes have no ticks;
d. Not based on Quantity;
e. Paid on Gross Pay;
f. Is not an annual limit;
- All relevant Income items are included for calculating Super.
- Deductions can be pre-tax, post-tax or part of a salary package (non-super salary sacrifice). Users should check with their accountant or the ATO for direction into which category their deduction falls:
- Pre-tax deductions require a Tax Tracking Type of Gross Payments and Taxes checked. These settings will reduce earnings for calculation of Super and PAYG;
- Post-Tax deductions require a Tax Tracking Type of Deductions and Taxes unchecked. These settings will not reduce earnings for calculation of Super and PAYG;
- Salary Packaging will require special treatment to reduce PAYG paid but have Super calculated on normal earnings. Click here for details.
- Allowances and Additions can be taxable or tax-free. Users should check with their accountant or the ATO for direction into which category their allowance or addition falls:
- Tax-free allowances and additions require a Tax Tracking Type of Allowance and Taxes unchecked. These settings will not impact on earnings for calculation of Super and PAYG;
- Taxable allowances and additions require a Tax Tracking Type of Gross Payments and Taxes. These settings will increase earnings for calculation of PAYG. If Super is to be paid on the Allowance or addition, that item must be ticked for inclusion in the Super payroll item setup.
Where your setup information is not correct you will need to correct it. Then you will need to:
- delete these items from the employee’s Payroll and Compensation Information, and reinput them;
- open the effected pays, delete the item and reinput it.
Your super should calculate correctly.
Where you still need to alter the Super amount that QuickBooks calculates and this amount is not to report to RESC on the payment summary:
- Before processing the pay, click on Edit > Preferences > Payroll & Employees > company Preferences and untick the box Calculate RESC differences for SA and/or CA items; click OK
- Prepare the pay and overwrite the Super amount. This amount will not be reported.
- When the pay has been processed go back and tick the box Calculate RESC differences for SA and/or CA items in Preferences.
We strongly recommend that you have the box Calculate RESC differences for SA and/or CA items in Preferences ticked to ensure you do not understate amounts for reporting purposes.
Question: How to Activate QuickBooks
What steps must I follow to successfully activate QuickBooks so that I can start using it for the first time or to apply a service pack, patch or tax table update?
Solution:
Before you can use your company file, apply a service pack, patch or tax table update your QuickBooks must be activated. This process confirms to us that you are using a properly licensed version of QuickBooks.
To successfully activate ensure that:
· You are logged onto the computer with Administrator privileges
· You have a datafile opened
· There are no other security features on your computer or network that will block your ability to modify your computer’s registry.
You can check whether your QuickBooks is activated by:
· From the Help menu, select My License Information
· The page will display QuickBooks is Activated
Or
· Press Ctrl 1 to open the Product Information page
· At the end of the second line “License Number” will be the words ACTIVATED or NOT ACTIVATED
You must have a datafile opened.
You can open your company file from its location or from the No Company Open screen. Your recently opened files will be in the box.
If you have just installed or re-installed your QuickBooks and there are no files showing in No Company Open, and you are not sure where your company file is located, then open the sample file. You can open the sample file by clicking on Open Sample File box on the No Company Open screen.
If for some reason the sample file does not open, then you can open the sample file directly by:
File > Open or Restore a Company File > Open a file (.QBW or .QBA) and browse to:
a. Windows 7, Vista & Server 2008: “C:\Users\Public\Documents\Intuit\ QuickBooks\Sample Company Files\QuickBooks 20xx-xx”
b. Windows 2000, XP & Server 2003: “C:\Documents and Settings\All Users\Documents\ Intuit\QuickBooks\Sample Company Files\QuickBooks 20xx-xx”
c. QuickBooks 2007/08 and earlier: “C:\Program Files\Intuit\QuickBooks 20xx-xx”
Computer Logon Account Status
If you are not sure of your account status and permission levels you will need to check with your IT technician.
Activating QuickBooks
- From the File menu, select Activate QuickBooks. If this is the first time you are activating QuickBooks then you will be able to activate across the web.
- If you have previously activated this version of QuickBooks the web activation attempt will fail. You will need to press Ctrl 3 or Ctrl F12; to launch the Activation Screen.
- Call Reckon Customer Service on the telephone number provided.
- The Reckon Representative will ask you for the Product Key which is on the second line.
- The Customer ID line is optional, but if you enter a number it must be your Reckon Customer ID number.
- The Reckon Representative will give you a License Key which you need to enter in the 4 empty boxes on the License Key line and then click on Finish.
- You will get a message: QuickBooks is Activated.
- To verify that QuickBooks is activated, shutdown QuickBooks (with your company file or sample file opened), then relaunch QuickBooks. If you get a message that QuickBooks is not activated then:
- You did not have a datafile opened when you activated; or,
- You are not logged on to this PC with Administrator privileges; or,
- You have been blocked from modifying the registry of this PC – you may need to refer to your IT technician.
Ensure that you have Administrator privileges, you are not blocked from modifying the registry and open a datafile and try again.
If you still get the error
If you still get the ‘QuickBooks is not activated’ message but when you press Ctrl 1 it says you are activated, then continue with the next steps.
QBi series – Enter the last refresh date into the QBW.INI file
· Close Quickbooks, then in Windows Explorer browse to C:\Users\Public\Public Documents\Intuit;
· Find and right-click on QBW.INI and Open With Notepad;
· The first line should read [REGISTRATION] – see note below;
· Move your cursor down to the start of the next line that has a square bracket:
it could be [FONTS] or [QBLICENCE];
· Press on the Enter key to create a blank line and enter the following:
o LastRefreshDate=July 1, 2010
§ where the date is the date you last activated QuickBooks;
§ must enter it exactly as it appears above with the US date format;
§ you can Copy&Past the above entry and then modify for your date;
· Click on File and Exit and select Yes to close and save the file;
QuickBooks 2007/08 and earlier
You will be modifying the Registry directly. Modifying the Registry can affect your operating system. If you are unsure of the steps below, please contact your IT technician.
Open the registry:
- Windows 7 & Vista:
- From the Windows Logo, type regedit in the Start Search field - Press Enter on your keyboard
- Windows XP:
- From the Start menu, select Run - Type regedit in the Open field
Create a backup of your Registry:
From the File menu, select Export Type a name in the File name field and Save in to a location on your computer (e.g Desktop)
From the Registry Editor window, locate and click on the + symbol next to these hierarchal folders:
HKEY_LOCAL_MACHINE > SOFTWARE > Intuit > QuickBooksRegistration > xx.0
Where xx refers to the version number of your QuickBooks:
2007/08 = 16.0
Highlight the folder relating to your installed QuickBooks version, i.e.:
- QuickBooks Accounting = atom
- QuickBooks Plus = basic
- QuickBooks Pro = pro
- QuickBooks Premier = superpro
- QuickBooks Enterprise = bel
Modify the Registry value:
- From the Edit menu, click New > String Value
- Type LastRefreshDate and press Enter
- Double click on the LastRefreshDate string
- Enter today's date in the Value Data field as MONTH DD, YYYY (e.g July 30, 2008)
- Click OK
- Close the Registry Editor Window
Check Operation of QuickBooks
Open QuickBooks and confirm that you no longer get the ‘QuickBooks is not activated’ message.
Restart the installation of the service pack, patch or Tax Table update.
How should the QBW.INI file look when I open it?
You should see the following:
[REGISTRATION]
Qbmode=000073a4142b
ActivatedProduct=accountant
WELCOMEVERSIONNUMBER=Version 19.0D
CustNum=880400
RegistrationNumber=55116493066327402240
[QBLICENSE]
CURRENTFLAVOR=
[FONTS]
MAGNIFYONLARGEFONTS=0
[AUTOPATCH]
VERSION=19.0
RELEASE=Pw2
(more lines follow)
Question: Cannot print from QuickBooks Hosted
From time to time you may experience problems printing from QuickBooks Hosted by Reckon Online due to problems with the QuickBooks print files.
You may receive an error message:
1. Error: Printer Settings Damaged
2. Error: ‘QBW32 has performed an Invalid Page Fault in module qbwwpr32.dll’.
3. Error: ‘QBW32.exe has performed Invalid Page Fault in spool32.dll’
You may experience the following behaviours:
1. Partial printing of the form
2. Cannot print from Printer Setup or print a report from QuickBooks display
3. Cannot view or edit the printer settings in a report
4. Printer settings do not retain changes for margins, etc
5. Problems emailing or saving as PDF
6. PDF image is only partially created
7. Cannot select a different printer when trying to print BAS Report
8. When trying to print a cheque whether by normal print or print forms window, Quickbooks freezes.
Solution:
Your QuickBooks printer files (qbprint.qbp and wpr.ini) are damaged.
Solution
Firstly, ensure that you ticked the printer box and the ports box in the RemoteApps window when you log onto QuickBooks Hosted.
If this is the first time you are trying to print from QuickBooks Hosted, update your printer driver from the manufacturer’s website.
Next, determine that the source of the printing problem is with QuickBooks and not with another component of your system.
1. Determine that there is no problem with your printer – that is, other applications from your local computer are able to print to this printer.
2. Verify that all users on QuickBooks Hosted are having printing difficulties.
3. Where possible, print to another printer and check whether QuickBooks behaves in the same manner.
4. Log in to QuickBooks Hosted on another computer and check whether the same problems are occurring.
When you are satisfied that the problem rests with QuickBooks and not another component, use the QuickBooks Hosted System Maintenance tools to delete the printer files. It is safe to delete them as QuickBooks will recreate these files when it is launched again.
Using QuickBooks Hosted System Maintenance
1. All users must exit QuickBooks and log off QuickBooks Hosted
2. The QuickBooks Hosted Admin user (qbi\1234567-1) to launch the web browser and go to:
www.quickbooksonline.com.au
3. On the page Welcome to Reckon Online page, in the Your Online Account section, click on Manage Your Account
4. Enter your username and password to open the Manage Your Account index page
5. On the left-hand side under System Maintenance, click on Delete Print Files
6. In the Delete Print File table, click on the Delete Print File hyperlink
7. File Deleted will appear in red when the process is complete
8. Click on Logout to end this session or on Help to select another function.
Log into QuickBooks Hosted and you should now be able to print.
Question: Persisting errors: H101, H202... -6123,0 & -6147,0 with Windows & Term Server or Virtual Machines
Why do I continue to get the errors H101, H202, H303, H505 and -6123,0 or -6147,0 on my network of Windows 7 and Terminal Server 2008, as well as on a network of virtual machines (on Windows 7).
Solution:
The first step is to follow the procedures outlined in KB404: “H101, H202, H303, H505 and -6123,0 when hosting multi user access with QuickBooks QBi”.
If the same problems persist, then consider the next two points:
1. The company filename must be longer than 9 characters to operate in a network that involves Windows 7 and Terminal Server 2008 machines.
2. Allow the QuickBooks processes through Port 10180 and 10174 (10173 for 10/11 and 10172 for 09/10 and 08/09) on any firewall, antivirus or internet monitoring service. See KB220 for the processes that must be made exceptions
If you have just installed QuickBooks on a new server and are experiencing this problem then you may have an issue with your mapped network drive.
When opening the QBW file from the workstation, the .ND file would get changed by the workstation. Its new contents would point to the data file path using a UNC path. The server name listed in the UNC path was the OLD server name, because the network drive was still mapped using the old server’s name. Although the old server name still works and resolves to the new server name, it is still a problem for QuickBooks. The QuickBooks Database Server Manager pays attention to the server name being used to attempt the connection, rather than the IP address or other connection method.
Solution: Disconnect the mapped network drive, and reconnect it using the new server name. This will allow the workstation to communicate with the QuickBooks Database Server Manager using the new server name. Your company files should now open.
Question: RemoteApp Disconnected. Your computer can’t connect to the remote computer.... when logging onto Qu
Why can’t I log onto QuickBooks Hosted 2011/12? I get the error:
RemoteApp Disconnected.
Your computer can’t connect to the remote computer because an error occurred on the remote computer that you want to connect to. Contact your network administrator for assistance.
I had no problems the first time.
Solution:
When you logon on the QuickBooks Hosted landing page, your username should include the letters “qbi\” at the start. That is, qbi\1234567-8 rather than 1234567-8. Occasionally QuickBooks Hosted will allow you to login without the qbi\. However, the next time you try to logon, it will not accept the username without qbi\ and generates the error.
Solution
Enter your username in the format: qbi\1234567-8.
Question: 0% Super (SA) is written to RESC on payment summary.
Why when I enter 0% for the Super amount when preparing pays, the amount gets reported in the RESC field of the Payment Summary?
Solution:
The Australian Government requires you to report any payments of super in excess of the 9% Super Guarantee (SA) or an approved collective agreement rate (CA) separately on the payment summary in the RESC field.
QuickBooks will automatically report some super payroll items to RESC – super salary sacrifice (SS) and employer additional (EA)
QuickBooks has a preference setting that when checked will automatically calculate and report amounts outside the statutory or collective rates to RESC. If the amount you are entering for Super is different to these rates, then the difference will be reported to RESC on the payment summary.
Reckon acknowledges that the automatic calculation function for SA and CA will report any difference whether that amount is greater or less than the 9% or collective agreement rate. It should report only amounts greater than the 9% or collective agreement rate. This problem is being investigated.
Solution
If 0% Super is being paid, then remove the Super Payroll Item from the Employee file.
If you need to show a 0% Super on the payslip, create a new super item with a category other than statutory super (SA), collective agreement (CA), employer additional (EA) or super salary sacrifice (SS).
Additional Information
You can also untick the box Calculate RESC difference for SA and/or CA payroll items in Preferences > Payroll & Employees > Company Preferences.
However, this step may compromise your correct reporting of RESC on other employees if you are paying above 9% on a super (SA) category or above the authorised collective agreement (CA) rate.
Question: Employee Tax Scale changes to Shearer – Non Resident + FL in Payroll Premier 2011/12
Why are some of my employees’ Tax Scales changing to Shearer – Non Resident + FL after upgrading to Payroll Premier 2011/12?
Solution:
This issue has been resolved with a patch that can be downloaded from: http://www.quicken.com.au/Support/ServicePackDownload.aspx?cat=PAYP1112TaxUpdate
Please read the instructions before applying the patch.
You will experience this issue if you change details in the employee record after you have started but not completed a pay run.
If you have customised tax scales that are listed below Shearer – Non Resident + FL, then the last on the list will be selected.
Our Product Development Team is investigating this issue.
Workaround
Do not make changes to the employee record after you have started a pay run.
If you need to make a change to an employee record, cancel the pay run, make the change to the employee’s record and run the pay again.
If it is not feasible to cancel the pay run, do the following:
1. In the Pay Run screen, Disable all employees whose records need to be adjusted from this pay run:
a. Highlight the employee;
b. Click the Activities button at the bottom of the screen;
c. Select Disable Pay.
2. Complete the pay run for the other employees;
3. Click on the Pay Run icon, re-enable the employees for the pay run and then select Activities > Cancel Pays to delete the pay run:
4. Make the changes to the employee details
5. Run the pays again but process only for this employee:
a. Click on Activities > Process Pays;
b. On the Process Pays Window, click on Pay Dates and modify for the correct dates;
c. On the process Pays Window, click on Advanced > Employee > Selected > click the dropdown menu and select the employee
d. Click Process Pays to complete the pay run for this employee;
e. Click on the Pay Run icon again, Activities > Cancel Pays.
Your pay run and updates to Employee record is complete.
Question: Employee Tax Scale field is blank after upgrading to Payroll Premier 2011/12
I have upgraded to Payroll Premier 2011/12 and when I opened my company file for the first time I choose to apply the Flood Levy to my employees. When I view their Tax Scale field it is blank.
Solution:
You will experience this issue if your company file is on a network location and you did not follow the preferred method for upgrading. Your installation now lacks the tax files needed for the new financial year.
As your employees now have a field called Apply Flood Levy ticked, Payroll Premier cannot find the appropriate tax files.
Workaround
1. Close Payroll Premier
2. In Windows Explorer, go to C:\QPRollV20\Data
3. Highlight the following files by holding down the Ctrl key and left clicking once on the following files:
a. Qtax.tps
b. Qtaxinfo.tps
c. NEWQtax.tps
d. NewQtaxinfo.tps
4. Right-click and select Copy
5. Browse to your network folder that contains your Payroll Premier files and Paste these files by right-clicking the background and selecting Paste.
6. You now have the latest tax scales to use in Payroll Premier 2011/12.
If you have memorized reports, you will need to copy the reports files from the previous version’s data subfolder and paste to the current version’s network folder:
1. In Windows Explorer, go to C:\QPRollV19\Data
2. Highlight the following files by holding down the Ctrl key and left clicking once on the following files:
a. Reports.k02
b. Reports.K01
c. Reports.dat
d. Reportde.k02
e. Reportde.k01
f. Reportde.dat
3. Right-click and select Copy
4. Browse to your network folder that contains your Payroll Premier 2011/12 files and Paste these files by right-clicking the background and selecting Paste.
5. Your memorised reports will be available to you in Payroll Premier 2011/12.
Additional Information
For the correct method of upgrading a payroll Premier file on a network location, see KB 4157 for full instructions.
Question: PAYG Tax does not change when Flood Levy applied in Payroll Premier 2011/12
My employee is earning more than $50,000 and is not exempt from the Flood Levy, but he is still paying the same amount of tax as last year. Why?
Solution:
The ATO formula for the Flood Levy stipulates that the amount of Flood Levy be rounded down to a whole dollar amount, in line with the procedure for other taxes.
This stipulation means that an employee must be earning $60,400 per year, or $1,061 per week (tax-free threshold claimed), before one dollar of Levy is deducted from pay.
It will be at $70,700 per year or $1,261 per week (tax-free threshold) before the levy deduction amount will jump from one dollar to two dollars a week.
Employees are still liable for the full amount of the Levy on their annual income. This method of applying the Levy will mean that some employees will have less than their full liability for the Levy deducted from their regular pay. The shortfall will be recovered in annual income tax returns.
To confirm the correct amount of tax payable users should check details with the ATO tax calculator on their website.
Question: NSW State Payroll Tax threshold showing the incorrect amount in QuickBooks 2011/12
Why is the NSW State Payroll Tax threshold showing the incorrect amount?
Solution:
The NSW Government announced changes to the Payroll Tax threshold levels after the QuickBooks 2011/12 Tax Table Update was finalised, so the threshold level in QuickBooks is incorrect, still showing the levels applicable in 2010/11.
For the 2011/12 financial year the correct levels are:
- threshold: $678,000 annual and $56,500 flat monthly;
- tax rate: 5.45%.
A patch has been prepared to update the NSW Payroll Tax table.
Detailed Steps
- Close QuickBooks
2. Note the location of your Quickbooks Installation folder:
a. Right-click on your QuickBooks short-cut;
b. Left-click on Properties
c. Left click on Find Target
The address bar will show where your folder is located. The default location is C:\Program Files\Intuit\QuickBooks 2011-12\
- Click on this link http://www.quicken.com.au/library/exe/NSW State Payroll Tax 2011-12.exe to download the patch and save to a location on your PC (like your Desktop or special folder for downloads)
4. Run the application:
a. Windows 7 & Vista: right-click it and select Run As Administrator
- Windows XP: double click on the application
- Select your QuickBooks Installation folder in the Destination folder field
- Click on Install. (There is no notification when the process is complete)
- Open QuickBooks and check calculations: Threshold should be 56,500 per month and percentage should be 5.45%
|