The STP report transformation has been updated to support clickable values. A very useful update however as a result the modifications to support Jobkeeper have changed
A longer term solution is discussed in this thread
https://forum.manager.io/t/report-transformations-australia/30908?u=patch
But until that functionality is implemented an easy work around is:
Create a clone of “Single Touch Payroll Worksheet”
-
Goto “Settings” → “Report Transformations” → “Single Touch Payroll Worksheet” → “View” → “Clone”
-
Change the Name to something like “Single Touch Payroll Worksheet - Jobkeeper”
W1 amount includes Job keeper top up
In the “Script” section of the report transformation. Replace line 4
{% assign period_W1_amount = period | where_payslip_earnings_item: '8198caf2-1125-4f8e-9469-527583e3ea5e', 'Gross payments' %}
with these two lines
{% assign period_W1_amount = period | where_payslip_earnings_item: '8198caf2-1125-4f8e-9469-527583e3ea5e', 'Gross payments' | balance %}
{% assign period_W1_amount = period | where_payslip_earnings_item: '8198caf2-1125-4f8e-9469-527583e3ea5e', 'Allowance - Other'| balance | plus: period_W1_amount %}
The above changes results in “period_W1_amount” containing a number rather than a collection of transactions, so drill down is no longer possible for that value.
In the layout section of the report transformation, column A, row 129, delete " | balance" from the start of the text in that cell (double click on in to enable editing), ie change
{% capture csv %}{{ csv }}
{{ abn }},{{ period_W1_amount | balance }},{{ period_W2_amount | balance }},{{
To
{% capture csv %}{{ csv }}
{{ abn }},{{ period_W1_amount }},{{ period_W2_amount | balance }},{{
Note there is a new line character at the beginning of the new capture text in this cell which is not shown by Manager.
Other allowance - Description
The “Other allowance - Descripion” value is changed in the csv file from “Other” to “JOBKEEPER-TOPUP” by editing the same Layout cell (column A row 125) and replacing the string as shown below (partial string only shown)
From:
{{ employee_travelAllowance.Balance }},"Other",{{ employee_otherAllowance.Balance }},{{ employee_unionFees.Balance }}
To
{{ employee_travelAllowance.Balance }},"JOBKEEPER-TOPUP",{{ employee_otherAllowance.Balance }},{{ employee_unionFees.Balance }}
To correct the displayed user report, goto the layout, click on the row 87 label (to select the row) and choose the menu item “Insert row above”
Then edit the now blank row 87 as well as the cell column A row 88 as shown
Edit 5
Post mostly rewritten