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 29th June 2021 – 5th July 2021. Their regular wage is £500 and they are being fully furloughed.


Therefore 2 days of the pay period fall in June and 5 days in July.

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

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

3. Perform the July calculation = £71.43 x 5 days = £357.15 x 70% = £250.00

4. Total up the 2 amounts = £114.28 + £250 = £364.28*



* 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 29th June – 30th June

  • Weekly pay period falling in claim period = 29th June – 5th July

  • 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 June (£2,500) and July (£2,187.50) as follows:



 

 

 

 

 

 

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

 

 

 

 

 

 

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

Coronavirus (Covid-19) - Guidance for BrightPay users21-22 BrightPay - System Requirements21-22 BrightPay - DownloadIntroduction to BrightPayImportant Information for Mac UsersStarting the New Tax YearImporting From The Previous Tax YearInstalling BrightPayMoving to BrightPay from another payroll softwareBureau Enhancements - Useful Functionality for Bureau Licence HoldersEmployer DetailsEmployee DetailsCoding NoticesPayroll CalendarProcessing PayrollImporting Pay Data using CSV FilePaying EmployeesRTICommon HMRC Error MessagesAnalysisPayroll JournalsHMRC PaymentsMaking Corrections to PayrollScheduling Future PaymentsSwitching an Employee's Pay FrequencyDirectorsOff-Payroll Working (IR35)StartersLeaversStudent 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 TestimonialsGender Pay Gap ReportingLeave Reporting & Employee CalendarAnnual LeavePayslip TranslationsBacking Up/Restoring Your PayrollConstruction Industry Scheme (CIS)Automatic EnrolmentBrightPay ConnectGDPRBrightPay Licence Terms and Conditions