Please enable JavaScript.
Coggle requires JavaScript to display documents.
Project - Attachment of Earnings process (My process (Make spreadsheet…
Project - Attachment of Earnings process
Why does it need to change?
Unorganised spreadsheet
Needs to be more clear where the money is being sent and that to correct amounts have been deducted
Bank details to be clearer as well as email addresses
If there are any requirements such as using a persons NI number as the reference this info needs to be easily recognisable
Sage report - doesn't tell you which department/court/or company it is that needs to be paid
What is it?
When a worker owes money to courts, companies and departments
An Employer has the responsibility to deduct what is owed from the workers wages
The deduction will need to be after tax and NI has been deducted
There is normally a minimum a worker needs to earn to have the deduction made - this can be weekly or monthly and is usually in smaller sums rather than one large amount
Deductions are made in Month A from the worker and then paid to the companies, courts and departments in month B in one payment
Idea
A spreadsheet that contains:
all workers who need to make deductions
where the deduction is being made too
how much
when the last payment was made
Requirements
Different spreadsheet options
Organised by who is owed money
Organised by worker
Organised by values
Must haves for spreadsheets
Bank details and requirements
Workers name - Code - NI number
Values
Other bits
Would be a good idea if there was a way of every week workers who did not have a deduction could change colour - if they reach the 5 week mark to ask branch if they work for us - if 12 week then to be changed to cancelled as they will be P45'd
A cancellation tab - this means they wont be removed - instead moved so if they come back we still have a record
My process
Make spreadsheet prototypes
Make a survey for those who will be using it to fill in
Analyse the results and choose a format
Create the final system
Make amendments
End findings - is it sustainable