CJRS & BrightPay - where pay periods cross 2 calendar months

 

The Furlough Pay Calculator

 

Where a pay period straddles two calendar months, BrightPay’s furlough pay calculator will automatically apportion using a daily basis approach.

Example:

An employee’s weekly pay period runs from 30th January 2021 – 5th February 2021. Their regular wage is £500 and they are being fully furloughed.


Therefore 2 days of the pay period fall in January and 5 days in February.

1. Work out the daily pay rate = £500/ 7 days = £71.43

2. Perform the January calculation = £71.43 x 2 days = £142.86 x 80% = £114.28

3. Perform the February calculation = £71.43 x 5 days = £357.15 x 80% = £285.72

4. Total up the 2 amounts = £114.28 + £285.72 = £400.00*



* In some instances, users may see a few pence difference if comparing HMRC's calculations or a manual calculation with those calculated in BrightPay. This is because the published HMRC calculations are based on rounded amounts for making manual calculation easier. BrightPay uses a more direct and accurate algorithmic version of the calculation instead.

 

 

 

The Claim Report

 

Where a pay period straddles two calendar months (and thus 2 claims are required), BrightPay will apportion the pay period's gross pay into each claim period on a daily basis. Each day then has a relative weighting in line with the maximum reclaimable daily wage amounts as stipulated by HMRC. This is the only method that guarantees accuracy in all scenarios.

Example:

  • Claim period is 30th January – 31st January

  • Weekly pay period falling in claim period = 30th January – 5th February

  • Employee is paid a reclaimable furlough pay amount of £400.00 in the pay period

  • Therefore, there are 2 days in this claim period that will be accounted for.



In this instance, the pay period straddles the claim period, so we have to work out the percentage apportionment.


This is done using the ‘maximum reclaimable wage’ amounts for January (£2,500) and February (£2,500) as follows:

 

 

 

 

 

 

 

Likewise, the calculation being performed and the amount included in the February claim will be:

 

 

Need help? Support is available at 0345 9390019 or support@brightpay.co.uk.

BrightPay Licence Terms and ConditionsCoronavirus (Covid-19) - Guidance for BrightPay usersImportant Information for Mac UsersBureau Enhancements - Useful Functionality for Bureau Licence HoldersInstalling BrightPayOrdering for The New Tax YearImporting From The Previous Tax YearMoving to BrightPay from another payroll softwareEmployer DetailsEmployee DetailsCoding NoticesPayroll CalendarProcessing PayrollImporting Pay Data using CSV FileRTICommon HMRC Error MessagesAnalysisPayroll JournalsHMRC PaymentsMaking Corrections to PayrollScheduling Future PaymentsSwitching an Employee's Pay FrequencyDirectorsStartersLeaversStudent Loan DeductionsPostgraduate Loan DeductionsStatutory PaymentsAttachment of EarningsExpenses & BenefitsPensions (outside of Automatic Enrolment)Payroll GivingYear EndRates & Thresholds at a GlanceTaxNational InsuranceNational Minimum/Living WageMileage Allowance Payments (MAPs)Employment AllowanceApprenticeship LevyTermination Awards & Sporting TestimonialsOff-Payroll Working in the Public SectorGender Pay Gap ReportingLeave Reporting & Employee CalendarAnnual LeavePayslip TranslationsBacking Up/Restoring Your PayrollConstruction Industry Scheme (CIS)Automatic EnrolmentBrightPay ConnectGDPR