Content
Wages Report
Office Sales Report
Export Invoices Summary Report for Oracle JD Edwards EnterpriseOne
📈Finance Portal Enhancements
Wages Report
In the Wages Report, you can retrieve wage details related to payroll data for the week ending within the specified date range. The report is generated based on the Office Code.
How to Access the Wages Report?
To access the Wages Report:
-
Click Reports → Payroll → Wages Report
How to Generate the Wages Report?
In the Wages Report window:
- Select the date range in Date From and Date To. By default, the last week's date range is selected
- Select the Office Name (if required)
- Click Export To CSV and the data is exported successfully for the selected date range in the CSV format
The Wages Report is saved and downloaded in the CSV format as shown in the figure below.
|
Field Name |
Description |
| Batch/transaction# | Shows the batch number generated at the backend per payrun. |
| Office Number |
Shows the office code fetched from the Office Master. |
| G/L Date | Shows the week ending date for the payroll. |
| Business Unit | Shows the Client Office Code/ Head Office Code based on the Explanation field details. |
| Object Account Number |
Shows the Object Account Number based on Wages, Allowance, Net Payroll, Tax Amount, Superannuation, Work Cover, and PR Tax. The Gross Payroll, Allowance, Net Payroll, PAYG, and Superannuation are based on the member's office, and the Work Cover Amount and Payroll Tax Amount are based on the client's office. |
| Subsidiary Account | Shows the State of the Head Office for the available client's office. |
| Ledger Type | By default, the Ledger Type select will be 'AA'. |
| Debit/Credit Amount | Shows the Debit/Credit amount. |
| Explanation |
For your reference - The Gross Payroll, Allowance, Net Payroll, PAYG, and Superannuation PL, Superannuation BS are as per the member's office, and the Work Cover PL, Work Cover BS, and Payroll Tax PL and Payroll Tax BS are as per the client's office. Based on the mapping available, the amount is displayed in Debit/Credit Amount |
| Company | Shows the Head Office code. |
Sample Figure of the Downloaded Wages Report
Office Sales Report
In the Office Sales Report, you can retrieve sales and margin report for each office for the week ending within the specified date range.
How to Access the Office Sales Report?
To access the Office Sales Report:
-
Click Reports → Management → Office Sales Report
How to Generate the Office Sales Report?
In the Office Sales Report window:
- Select the date range in Date From and Date To. By default, the last week's date range is selected
- Select the Service Location and Office Name. Based on the selected Service Location and Office Name, the report will be generated
- To print the report, click Print Report and the report is generated for the selected date range. Now, you can print, export, or copy the report
- To export the report, click the Export To CSV, and the data is exported successfully for the selected date range in the CSV format
The Office Sales Report is generated by clicking the Print Report as shown in the figure below.
|
Field Name |
Description |
| Office Code |
Shows the Office Code linked to the relationship office of the client. The office code is fetched from the Office Master. |
| Service Location | Shows the Service Location. |
| Sales - Current Period |
Shows the invoiced amount in the Gross Margin Report for the client during the specified period. |
| Sales - Prior Period |
Shows the previous invoiced amount in the Gross Margin Report for the client during the corresponding prior period. |
| Margin - Current Period |
Shows the payrun amount in the Gross Margin Report for the client during the specified period. |
| Margin - Prior Period |
Shows the previous payrun amount in the Gross Margin Report for the client during the corresponding prior period. |
| Hours - Current Period |
Shows the paid hours in the payrun for the client during the specified period. |
| Hours - Prior Period |
Shows the previous paid hours in the payrun for the client during the corresponding prior period. |
| Margin Per Hour - Current Period |
Shows the period margin amount/ paid hours in the payrun for the client during the specified period. |
| Margin % - Current Period |
Shows the margin percentage in the payrun for the client during the specified period. The Margin % is calculated using this formula → (selected Period Margin Amount / Invoiced Amount in the Gross Margin Report for the client for a selected period) * 100. |
| Unique Associates Paid - Current Period |
Show the unique number of members in the payrun for the specified period. Note that the total members in the header are the unique members in the payrun for the period selected. |
| Unique Associates Paid - Prior Period |
Show the previous unique number of members in the payrun for the corresponding prior period. Note that the total members in the header are the unique members in the payrun for the previous period. |
Note that the Total displayed in the header of the report represents the cumulative amount for the specified headings.
Sample Figure of the Office Sales Report
The Office Sales Report is saved and downloaded in the CSV format by clicking Export to CSV as shown in the figure below.
Export Invoices Summary Report for Oracle JD Edwards EnterpriseOne
In the Export Invoices Summary, you can conveniently extract invoice data for external accounting software 'Oracle JD Edwards EnterpriseOne' as shown in the figure below.
The authorised users can access and extract this report.
How to Access this Report?
To access the Oracle JD Edwards EnterpriseOne Report:
-
Click Reports → Invoice → Export Invoices Summary - Accounting
How to Generate this Report?
In the Export Invoices Summary - Accounting pop-up window:
- Select Oracle JD Edwards EnterpriseOne option
- Select Period Ending, and Client Group
- Click Report and the data is exported successfully for the selected Period Ending
Sample Figure of the Downloaded Report
The Oracle JD Edwards EnterpriseOne Period Ending Report is saved and downloaded in the CSV format as shown in the figure below.
