Worked Example – Payment Profile For A Revised Award
Contents
Case
details - initial award
Case
details – revised award
Case details –
initial award
The capture process produced the following claim details
- Effective date 02-05-2009
- Processing date 06-05-2009
Claimant 1 details
- Date of birth is 30-04-1970 aged 39 at 02-05-2009
- Works 16 hours per week
Claimant 2 details
- Date of birth is 01-08-1967 aged 41 at 02-05-2009
- Works 10 hours per week
Children
- Took responsibility for two children, dates of birth – 20-09-1992 and 08-07-1995. Aged 16 and 13 respectively, at 02-05-2009
Income
- For 2008-2009 tax year - £18,600
The claim satisfied both the Working Tax Credit (WTC) and Child Tax Credit (CTC) eligibility rules and the initial award calculation. The results were as follows
Entitlement Period 1 02-05-2009 to 31-08-2009 – 122 days long
| Entitlement | Amount for period | Daily rate due |
| WTC Work Elements | Nil | Nil |
| CTC Individual Elements | £1,162.14 | £9.53 |
| CTC Family Element | £183.00 | £1.50 |
Entitlement Period 2 01-09-2009 to 05-04-2010 – 217
days long
| Entitlement | Amount for period | Daily rate due |
| WTC Work Elements | Nil | Nil |
| CTC Individual Elements | £736.88 | £3.40 |
| CTC Family Element | £325.50 | £1.50 |
Payment profile – processing date 06-05-09
Entitlement periods
- 02-05-09 to 31-08-09 = 122 days
- 01-09-09 to 05-04-10 = 217 days
Award amounts
- CTC
- 02-05-09 to 31-08-09 = £1,345.14
- 01-09-09 to 05-04-10 = £1,062.38
- Total = £2,407.52
- WTC
- 02-05-09 to 31-08-09 = Nil
- 01-09-09 to 05-04-10 = Nil
- Total = Nil
CTC daily rates
- 02-05-09 to 31-08-09 = £9.53 + £1.50 = £11.03
- 01-09-09 to 05-04-10 = £3.40 + £1.50 = £4.90
Claimant 2 payment profile
First entitlement period
- On 08-05-09 (the first day payment can be made, allowing for the lead time to make a payment to a bank account) the claimant will receive a one off payment of arrears for the period from 02-05-09 to 05-05-09, 4 days at £11.03 = £44.12
- Pay day is Friday. There are 17 Fridays in the period between 06-05-09 (the processing date) and 31-08-09 (the end of the first entitlement period).
- The regular weekly payment is calculated as the balance due divided by the number of pay days left in the entitlement period.
- The amount due between 06-05-09 and 31-08-09 = (122 – 4) days x £11.03 = 118 x £11.03 = £1,301.54 ÷ 17 = £76.56
- Regular payments of £76.56 will then be scheduled for payment every Friday from 15-05-09 to 28-08-09 inclusive
Second entitlement period
- Payment in the second entitlement period (01-09-09 to 05-04-10) is calculated as follows
- Pay day is Friday. There are 31 Fridays in the period from 01-09-09 to 05-04-10
- The standard weekly payment is calculated as £4.90 x 217 ÷ 31 = £1,063.30 ÷ 31 = £34.30
- The first payment of £34.30 will be made on 04-09-09. Payments will continue to be made on Fridays. Payments will continue to be made at the same rate until the claim is renewed or finalised in May /.June 2010
Rounding difference
- Rounding for the first entitlement period
- Total due less arrears less regular payment =
- £1,345.14 - £44.12 – (17 x £76.56) =
- £1,345.14 - £44.12 - £1,301.52 = £0.50
- Rounding for the second entitlement period
- Total due less regular payment =
- £1,062.38 – (31 x £34.30) =
- £1,062.38 – £1,064.30 = £0.92
Non standard payment
- The first payment, due on 08-05-09, will be on a non standard payment, which is the regular payment plus any rounding difference for each entitlement period, therefore
- £76.56 + £0.50 + £0.92 = £75.14
Payment summary
| Payment start | Type of payment | No of payments | Amount | Total paid |
| 08-05-09 | One off | 1 | £44.12 | £44.12 |
| 16-05-09 | Non standard | 1 | £75.14 | £75.14 |
| 23-05-09 | Standard | 16 | £76.56 | £1,224.96 |
| 04-09-09 | Standard | 31 | £34.30 | £1,063.30 |
| Total CTC | £2,407.52 |
- Effective date 18-07-09
- Notified on (processing date) 21-07-09
Claimant 1 details
- DoB 30-04-70 (39) left employment on 18-07-09 and has applied for Income based JSA
Claimant 2 details
- DoB 01-08-67 (41), works 10 hours a week. Main carer.
Children
- 2 children, DoB 20-09-92 (16) and 08-07-95 (13)
Income
- For 2009-2010 tax year (Current year) = £7,400
- Payment frequency - weekly
Calculate the daily – revised award
- The award calculation provides the start and end dates for each entitlement period, the number of days in each period and the total award for each tax credit for each entitlement period. From this information, the daily rate is calculated, rounded down to the nearest penny.
Entitlement 1 (02-05-09 to 18-07-09 = 78 days)
| Entitlement | Amount for period | Daily rate due |
| WTC work entitlement | £720.17 | £9.24 |
| CTC individual entitlement | £956.28 | £12.26 |
| CTC family entitlement | £117.00 | £1.50 |
Entitlement period 2 (19-07-09 to 31-08-09 = 44 days)
| Entitlement | Amount for period | Daily rate due |
| CTC individual entitlement | £539.44 | £12.26 |
| CTC family entitlement | £66.00 | £1.50 |
Entitlement period 3 (01-09-09 to 05-04-10 = 217 days)
| Entitlement | Amount for period | Daily rate due |
| CTC individual entitlement | £1,330.21 | £6.13 |
| CTC family entitlement | £325.50 | £1.50 |
Payment profile – processing date 21-07-09
Entitlement periods
- 02-05-09 to 18-07-09 = 78 days
- 19-07-09 to 31-08-09 = 44 days
- 01-09-09 to 05-04-10 = 217 days
Award amounts
- CTC
- 02-05-09 to 18-07-09 = £1,073.28
- 19-07-09 to 31-08-09 = £605.44
- 01-09-09 to 05-04-10 = £1,655.71
- Total = £3,334.43
- WTC
- 02-05-09 to 18-07-09 = £720.17
- 19-07-09 to 31-08-09 = £0.00
- 01-09-09 to 05-04-10 = £0.00
- Total = £720.17
Calculate underpayment or overpayment
CTC
- Amounts paid, up to and including the processing date, are calculated as follows
| 08-05-09 | Arrears | £44.12 |
| 09-05-09 | Non standard | £75.90 |
| 16-05-09 to 18-07-09 | Regular – 10 weeks at £76.56 | £765.60 Already paid |
| Total paid | £885.62 |
- Amounts due, up to the day before processing date, are calculated as follows
- 02-05-09 to 18-07-09 = 78 days at £13.76 = £1,073.28
- 19-07-09 to 20-07-09 = 2 days at £13.76 = £27.52
- Total due = £1,100.80
- The amount of any underpayment or overpayment is the difference between the amount due and the amount paid, so
- £1,100.80 - £885.62 = £215.18
- Positive result, therefore underpayment
WTC
- Amounts paid, up to and including the processing date = £0.00
- Amounts due, up to the day before processing date = 78 x £9.24 = £720.72
- The amount of any underpayment or overpayment is the difference between the amount due and the amount paid, so
- £720.17 - £0.00 = £720.17
- Positive result, therefore underpayment.
CTC daily rates
- 02-05-09 to 18-07-09 = £12.26 + £1.50 = £13.76
- 19-07-09 to 31-08-09 = £12.26 + £1.50 = £13.76
- 01-09-09 to 05-04-10 = £6.13 + £1.50 = £7.63
WTC daily rates
- 02-05-09 to 18-07-09 = £9.24
CTC rounding differences
- 02-05-09 to 18-07-09 = £13.76 x 78 = £1,073.28
- 19-07-09 to 31-08-09 = £13.76 x 44 = £605.44
- 01-09-09 to 05-04-10 = £7.63 x 217 = £1,655.71
- Total = £3,334.43
- Difference = £3,334.43 - £3,334.43 = £0.00
Claimant 1 payment profile
First entitlement period
- On 23-07-09, the first day payment can be made allowing for the lead time to make payment to a bank account, claimant 1 will receive a one off payment of arrears of £720.17
Note: Because there was previously no entitlement to WTC (it was wholly tapered), this payment could be labelled arrears or underpayment. The net result is the same – a single one off payment.
WTC rounding differences
- Rounding for the first entitlement period
- Total due less arrears less regular payment
- £404.04 - £404.04 - £0.00 = £0.00
Second and third entitlement periods
- There is no entitlement for WTC for the remainder of the award period.
Claimant 2 payment profile
First entitlement period
- On 23-07-09, the first day payment can be made allowing for the lead time to make payment to a bank account, claimant 2 will receive a one off payment of £215.08 for underpayment and arrears in the first entitlement period.
Second entitlement period
- The family pay day is Friday so the first regular payment is due on 24-07-09
- There are 6 Fridays in the remainder of the entitlement period, 21-07-09 to 31-08-09
- The balance of the amount due is the total amount due in the entitlement period less the arrears already paid. The arrears were for the period 19-07-09 to 20-07-09 and were included in the calculation of the underpayment
- 19-07-2009 to 20-07-2009 = 2 days at £13.76 = £27.52
- £605.44 - £27.52 = £577.92 ÷ 6 = £96.32
- Regular payments of £96.32 will then be made every Friday starting on 31-07-2009 and continuing until 28-08-2009
Third entitlement period
- Payment in the third entitlement period (01-09-2009 to 05-04-2010) is set up as follows
- There are 31 Fridays in this period
- The regular weekly payment is therefore £1,655.71 ÷ 31 = £53.41
Rounding difference
- Rounding for the first entitlement period: Total due less arrears amount already paid £1,073.28 - £215.08 - £885.72 = -£27.52(arrears)
Rounding for the second entitlement period
- Total due less arrears less regular payments £605.44 - £27.52 – (6 x £96.32) = £605.44 - £27.52 - £577.92 = £0.00
Rounding for the third entitlement period
- Total due less arrears less regular payment £1,655.71 - £0 – (31 x £53.41) = £1,655.71 - £0 – £1,655.71 = £0.00
Non standard payment
- The first payment, due on 24-07-2009, will be a non-standard payment made up of the regular payment plus any rounding differences. Therefore
- £96.32 + £0.00 + £0.00 + £0.00 = £96.32
Payment summary
| Payment start | Type of payment | No of payments | Amount | Total paid |
| 08-05-2009 | CTC already paid |
£885.62 |
£885.62 |
|
| 23-07-2009 | Arrears |
1 |
£215.08 |
£215.08 |
| 24-07-2009 | Non standard |
1 |
£96.32 |
£96.32 |
| 31-07-2009 | Standard |
5 |
£96.32 |
£481.60 |
| 04-09-2009 | Standard |
31 |
£53.41 |
£1,655.71 |
| Total CTC |
£3,334.33 |
|||
| 23-07-2009 | Arrears |
1 |
£720.17 |
£720.17 |
| Total WTC |
£720.17 |
