Skip to end of metadata
Go to start of metadata
- Created by admin, last modified by AdrianC on Nov 15, 2016
This information applies to MYOB AccountRight version 19. For later versions, see our help centre.
https://help.myob.com/wiki/x/uwCc
ANSWER ID:6328
AccountRight Plus, Premier and Enterprise, Australia only
This support note is only applicable for AccountRight v19 and earlier, and its purpose is:
- to allow a quick display of total hours a given employee has worked for a selected job
- to allow tabulation of payroll categories allocated to a job number for a given employee for a selected Job
- to allow a "WHAT IF" analysis based on User customised Billing Markup codes.
A Microsoft Excel template is available for download at the bottom of this support note, called PAYJRNL.XLT, which links to the Payroll Journal report in AccountRight.
Its use relies on the following:
- Job numbers must be used on Paycheques. The template will not pull any job allocations from Purchase orders or Sales etc.
- The Payroll Journal report must include the Job No field.
- The report must be filtered to have a selected employee (the template isn't designed to work for all employees).
Downloading the report template
- Click the PAYJRNL.XLT file at the bottom of this support note.
At the prompt, click Save and save the file in the Spredsht folder in your MYOB program folder.
If you're using The Spredsht folder is here
(v19.12 or earlier)The Spredsht folder is here
(v19.13 or later)AccountRight Standard C:\Standard19\Spredsht
N/A AccountRight Plus C:\Plus19\Spredsht
C:\PlusClassic\Spredsht
AccountRight Premier C:\Premier19\Spredsht
C:\PremierClassic\Spredsht
AccountRight Enterprise C:\Enterprise19\Spredsht
C:\EnterpriseClassic\Spredsht
When asked if you want to overwrite the existing file, click Yes. This will replace the existing template.
- Double-click the template to open it in Excel.
- Click on the HOURS sheet.
- Select the cell range H5:J8. This range is NAMED markups, and is the range that the coding behind the buttons looks to when calculating the billing analysis.
- Change the Markup codes in the range to suit your own needs. The format must stay the same though, for example Markup code, then Description, then %.
- Insert more cells from WITHIN the initial range should you need more rows for more codes.
- Save the changes to the template.
Displaying the calculated hours for a job
- Access the Payroll Journal report (Reports > Index to Reports > Payroll tab > Payroll Journal > Click Customise).
- Filter the report for the selected employee, and choose your date range.
- Click the Report Fields tab and ensure the Job No. field is selected.
- Click Send to and choose Excel. The report opens in Excel.
- Click Calculate Hours: Display. The Entering the job box appears.
- Type in the job you wish to calculate hours for and click OK. A message box will display the result.
Calculating hours for billing analysis
- Access the Payroll Journal report (Reports > Index to Reports > Payroll tab > Payroll Journal > Click Customise).
- Filter the report for the selected employee, and choose your date range.
- Click the Report Fields tab and ensure the Job No. field is selected.
- Click Send to and choose Excel. The report opens in Excel.
- Click Calculate Hours & Billing. The Entering the job box appears.
- Type in the job you wish to calculate hours for and click OK.
- Complete the Markup Code column. Refer to the Markup Code table on the sheet for help.
- Click Update Billing.
- Click Update profit.
- Click Total. The report will show:
- the total hours worked for the job
- what it cost the employer
- what it MIGHT cost the client, and
- the profit from the billing.
Attachments