Use the Drill Down area in Transaction View to extract transaction lines for one or more pay sequences in a format that can be opened in Excel. You can also load transactions for all employees when the Drill Down area is active.
Before you start
Open Transaction View and select the pay sequence or sequences you want to review.
Export transaction details
-
Open Transaction View.
-
Select the pay sequence or sequences to include, then select OK.
-
Make sure the lower Drill Down area is visible.
-
If it is not visible, select View > Drill Down.
-
-
Click in the Drill Down area and switch to Sequences View so the lower section displays the transaction lines for the selected pay sequence or sequences.
-
To include transaction lines for every employee, click inside the Drill Down area, then select View > Drill Down View > Load All Employees.
-
If required, press F10 to customise the columns before exporting.
-
When loading all employees, consider adding a Name column so each transaction line can be matched to an employee.
-
-
With the Drill Down area still active, select Data > Save As, then choose Excel or CSV.
-
Enter the file name and save location, then select Save.
By default, the file is saved to the company data Temp folder unless you choose another location.
Copy the results directly into Excel
-
Click inside the Drill Down area.
-
Select Data > Send To... > Send To Clipboard.
-
Paste the copied transaction lines into Excel.
The exported or copied data is a raw extract of the transaction lines shown in the Drill Down view. It can be used for further analysis, including pay variance checking.
If “Load All Employees” is not available
The Load All Employees option is part of the Drill Down view. Before looking for the option:
-
Make sure the lower Drill Down area is visible.
-
Click inside the lower Drill Down area so it is the active section.
-
Confirm that you are working in the Drill Down view, then select View > Drill Down View > Load All Employees.
If the lower area is not active, the option may not be available where you expect it.
Exporting permanents
If you need an extract of employee permanent transactions rather than transactions from a particular pay sequence, you can generate this directly from Transaction View.
-
Open Transaction View and do not select a pay sequence. Select Cancel on the Pay Sequences form if it appears.
-
In the lower Drill Down area, select View > Drill Down View > Permanent Transactions.
-
Select View > Drill Down View > Load All Employees to display permanent transactions for all employees.
-
If required, press F10 to customise the columns. Add the fields needed for the report, such as employee code, employee name, allowance or deduction code, description, start date, end date, bank account, quantity and total amount.
-
Use the filter options to narrow the results. For example, to a particular allowance or deduction.
-
With the Drill Down area active, select Data > Save As and choose Excel or CSV. Alternatively, select Data > Send To > Clipboard and paste the results into Excel.
The extract contains the permanent transaction details displayed in the Drill Down view. Permanent transactions can include allowances and deductions and may have effective start and end dates, so check the selected columns and filters before saving the extract.
Automating the extract
If you need this information extracted automatically at regular intervals, a MYOB consultant can create a custom SSRS report and a corresponding subscription. This work is likely to be chargeable.