The global statement of earnings (GSOE) report allows the user to report worldwide compensation for year-end to a tax consultant. Global compensation year-end reporting is run out of the pay register.
The GSOE is a production report that can be executed from any company-level screen as well as at the individual assignment level. The report will be based on the configuration of GSOE templates.
How to configure GSOE Templates
You can configure GSOE templates at the System as well as the Company in the Templates menu.
You will have a default template set at the System and can add additional templates for specific countries. These can be overridden by GSOE templates set up at the company level. So if you are running the report in a company it will look for the Country you are running for at the company if it does not find that it will look at the default Company template, then check the System countries, and finally use the System default if none of those exist. The template also allows you to specify if you would like to include a Grand Total.
Click on the pencil icon beside the Default template at the System level to view the Details tab. On this tab, the template allows you to specify if you would like to include a Grand Total. You can also specify a Country by selecting from the Country drop down list.
The GSOE allows you to organize your data by Sections and Categories. The use of Sections and Categories is optional; you can have as many as required or none. You can configure Section and Categories as well as add Accounts to those Categories.
To configure Sections, click on the Sections tab. Press the [New] button to add a section. Enter a Name, specify if a Subtotal should be included and a Sequence.
To configure Categories, click on the Categories tab. The standard categories are Assignment Expenses, Compensation and Taxes. To configure additional categories click the [New] button, Enter a Name, specify if a Subtotal should be included and a Sequence.
Through the Accounts tab each account can be categorized for display and sub-totaling on the report.
Examples of where Categories and Sections would be used
Example 1
A client wants to organize their GSOE by Taxable vs Non-Taxable and under each of those headings, they want to organize by Compensation, Assignment Benefits, and Additional Benefit. This could be done by having:
Sections: Taxable and Non-Taxable
Categories: Compensation, Assignment Benefits, and Additional Benefits
Example 2
A client want to only organize their GSOE by Taxable vs Non-Taxable. This could be done by having Taxable and Non-Taxable set as Sections or as Categories, either of these would work. If data is to be organized in one way, Sections are typically used.
How to run the GSOE Report
Unlike other compensation reports, the GSOE does not tag data as being sent and allows data to be reported multiple times. The report will prompt the user for a number of parameters:
A date range using the parameters: Begin (Pay Register Pay Date/Comp Accum Payment Date) and End (Pay Register Pay Date/Comp Accum Payment Date). This date range will use pay register pay dates or pay register pay dates and comp accumulator payment dates as its basis.
If you need different data ranges for the pay register data and comp accumulator data you will use the Begin (Pay Register Pay Date/Comp Accum Payment Date) and End (Pay Register Pay Date/Comp Accum Payment Date) fields as well as the optional Comp Accumulator Start Date (If Different From Above) and Comp Accumulator End Date (If Different From Above) at the end of the parameters.
You can specify:
Home and Host countries using the Home Country and Host Country drop downs
Payroll System Country
the Currency to Display on Report- value selected determines which GSOE template to use for the GSOE report
select the Primary Payroll System to filter down the report or
Group by <Category > or <Pay Source>
You also have the two checkbox parameters: Show Blanks As Zeros? and to Include Comp Accumulator Data as well as being able to specify a list of Employee System Numbers (separated by commas) using the Employee Id List parameter.
The report will display twelve monthly buckets of data. If there is more than twelve months specified, then a thirteenth column called “Other” will be added to the end of the report and will roll-up all remaining period amounts. Only months with data will be displayed.
Sample GSOE Report
While the pay register screen only displays amounts in Primary Payroll System Currency, Secondary Payroll System Currency, the report can also be generated using Home Currency, Host Currency, Company Currency, or System Currency. These currencies were added as additions to the currency parameter when generating the report.
Before running the report in the additional currencies, an audit report should be generated to verify that the system could find exchanges rate to fill the other currency true-up buckets. Below is the user report type and user report configuration required to audit the currency true-up buckets:
