|
Worked Example |
  
|
|
Worked Example |
|
Men At Work Constructions has three offices; Melbourne, Sydney and Brisbane.
The work activities are split between Road Crew, Transport and Construction.
The management at Men At Work Labour Hire would like to be able to report on how much each activity at each office is costing in terms of wages.
eg; Melbourne - Road Crew, Melbourne - Transport, Melbourne - Construction
Their Accounting General Ledger accounts have been setup as follows;
All wages (ie payrates, terminations & allowances) except leave go to a GL account for each office and work activity combination.
eg:
| • | Melbourne - Road Crew to GL Account 7750/100, Melbourne - Transport 7750/200, Melbourne - Construction 7750/300 |
| • | Sydney - Road Crew to GL Account 7760/100, Sydney - Transport 7760/200, Sydney - Construction 7760/300 |
| • | Brisbane - Road Crew to GL Account 7770/100, Brisbane - Transport 7770/200, Brisbane - Construction 7770/300 |
| • | Annual Leave goes to one 'pooled' account 7100/100 for all office and work activities. |
| • | Deductions to to one 'pooled' clearing account 7200/100 for all office and work activities. |
| • | Net Wages go to one 'pooled' clearing account 7300/100 for all office and work activities. |
| • | Tax goes to one 'pooled' group tax clearing account 7400/100 for all office and work activities. |
| • | SGL Totals go to one 'pooled' account 7500/000 with a credit and contra debit to the same Account number. |
How this would be setup in e-PayDay®
Each office would be set up as a Cost Code
Cost Codes are: Melbourne, Sydney, Brisbane
Each activity would be setup as a Location (or Department)
Locations are: Road Crew, Transport, Construction
In e-Port™ the GL interface is setup with the GL account numbers as above. Work your way through each of the tabs in Sage Pastel GL Accounts; Pay Rates 1, Leave 2, Termination 3, Allowances 4, Deductions 5 and Totals 6.
Each account numbers and Dr/Cr is entered for each Cost Centre/Department Combination. Using the Auto Fill options can speed up the data entry, eg:
Melbourne - Road Crew GL Account 7750100 - CR
Melbourne - Transport 7750200 - CR
Melbourne - Construction 7750300 - CR
When the employees are paid in e-PayDay®, their hours would be allocated by the pay person to the correct Cost Code (ie Office) and Location (ie Activity). So when the pay is finalised, the export file created would contain all the payroll information ready to import to Sage Pastel.
In this example we had 3 employees working in various activities in Melbourne
Melbourne - Road Crew GL Account 7750100 - CR
Melbourne - Transport 7750200 - CR
Melbourne - Construction 7750300 - CR
Below is an example of the Sage Pastel Partner 2004 export file; paydayex.txt.
We had 3 employees paid Award Rate this payrun, Road Crew, Transport and Construction.
You will see the 3 Award Rates going to the relevant account numbers.
