Overview
The Estimated Profit Report (EPR) gives you a number of options when it comes to how you want to report on the data that has been cached.
Report Data in the EPR using Attributables Mode
The example below outlines how data is reported when the Attributables mode has been selected.
| Week | Job/ Customer | Pay Date | Attribution Date | Added to EPR | Transaction Date in EPR |
|---|---|---|---|---|---|
|
1 |
A |
1.1.2020 |
1.1.2020 |
1.1.2020 |
1.1.2020 |
|
2 |
A |
8.1.2020 |
8.1.2020 |
8.1.2020 |
8.1.2020 |
|
3 |
B |
17.1.2020 |
17.1.2020 |
17.1.2020 |
17.1.2020 |
|
3 |
A |
17.1.2020 |
17.1.2020 |
17.1.2020 |
17.1.2020 |
|
3 |
A |
17.1.2020 |
17.1.2020 |
17.1.2020 |
17.1.2020 |
|
4 |
C |
28.1.2020 |
28.1.2020 |
28.1.2020 |
28.1.2020 |
|
4 |
B |
28.1.2020 |
28.1.2020 |
28.1.2020 |
28.1.2020 |
The Attribution Date, the date that the data is added to the EPR, and the Transaction Date in the EPR will match the Pay Date.
How does the Attributables Mode work?
Data is attributed to all jobs and weeks on a proportionate basis. For example:
- Workplace Insurance - 1%
- Payroll Tax - 5%
- Superannuation Guarantee - 10.5% with a $450 threshold
| # | A | B | C | D | E | F | G | H | I | J | K |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Week | Job | Customer | Charge | Pay | Actual Super | Attributed Super | Attributed Payroll Tax | Attributed WI | Total Attributed | Notes |
| 2 | 1 | A | Cust A |
$120 |
$100 |
$0 |
$0 |
$5 |
$1 |
$106 |
|
| 3 | 2 | A | Cust A |
$240 |
$200 |
$0 |
$0 |
$10 |
$2 |
$212 |
|
| 4 | 3 | B | Cust B |
$240 |
$200 |
$50 |
$20 |
$10 |
$2 |
$232 |
Super threshold passed |
| 5 | 3 | A | Cust A |
NA |
$0 |
$0 |
$10 |
$0 |
$0 |
$10 |
Attribution for Week 1 (Row 2) |
| 6 | 3 | A | Cust A |
NA |
$0 |
$0 |
$20 |
$0 |
$0 |
$20 |
Attribution for Week 2 (Row 2) |
| 7 | 4 | C | Cust C |
$120 |
$100 |
$30 |
$10 |
$5 |
$1 |
$116 |
|
| 8 | 4 | C | Cust B |
$240 |
$200 |
|
$20 |
$10 |
$2 |
$232 |
In the table above:
-
Actual Super is not included in the EPR; the Attributed Super is. It is included in this table to indicate when the threshold is passed.
-
In Week 1, there is Payroll Tax and Workplace Insurance. As the Super Guarantee threshold has not been passed, there is no attribution of super.
-
In Week 2, there is no Payroll Tax and Workplace Insurance. These relate to the Week 2 pay. There is no attribution of super.
-
In Week 3, there is Payroll Tax and Workplace Insurance related to the Week 3 pay only. The super threshold has been passed, so super needs to be attributed.
-
As super applies to all pays within the month, this needs to be proportioned across the other pays that have contributed to the threshold.
-
This is why there are three rows in Week 3, even though there is only one pay event.
-
In Week 4, there is Payroll Tax, Workplace Insurance and Super. As the super threshold has been passed and the attribution of super has been included in Week 3, the super value here will apply to the Week 4 pay only.
-
The Actual Super for Week 4 is represented in a single cell, with amounts being split at an Attributed level for each job.
If the report is run at the end of the month, you could ask the following questions (for example):
| Question | Job | Customer | Income | Outgoing | Profit |
|---|---|---|---|---|---|
|
What is profit in Week 1? |
A |
Cust A |
$120(D2) |
$106(J2) |
$14 |
|
What is profit in Week 1 for a Job A? |
A |
Cust A |
$120(D2) |
$106(J3) |
$14 |
|
What is profit for Week 3? |
A, B |
Cust A |
$240(D4) |
$262(J4+J5+J6) |
-$22 |
|
What is the profit for Cust B in Week 3? |
B |
Cust B |
$240(D4) |
$232(J4) |
$8 |
|
What is profit in month for Job A? |
A |
(Cust A) |
$360(D2+D3) |
$348(J2+J3+J5+J6) |
$12 |
|
What is the profit in Week 3 for Cust A? |
A |
Cust A |
$0 |
$30(J5+J6) |
-$30 |
|
What is the profit for Cust B in a month? |
B |
Cust B |
$480 |
$464(J4+J8) |
$16 |
Comments
0 comments
Please sign in to leave a comment.