How the new National Insurance thresholds work

The National Insurance threshold from the 6th July will increase to £12,570, which means employees must earn £12,570 per year before paying National Insurance.

Sage 50cloud Payroll V28.02, has the new thresholds added to your Legislation Settings and automatically applied correctly based on your process date and employee status.


The new NI thresholds are automatically applied on all payrolls with a process date on or after 6th July 2022. The date employees are being paid for are not relevant to the NI thresholds, instead, it is the process date that decides which thresholds are used.

HMRC require that NI for employees is calculated period by period rather than as a year-to-date calculation.  This means that NI values calculated using the new rates are not affected by any NI calculated prior to 6th July 2022.


The new NI thresholds are applied differently for directors depending on their status.

  • Pro-Rata (Table) – NI for directors who have a Pro-rata status is calculated using the new Primary Threshold each period from 6th July onwards. This is then re-calculated in a year to date calculation using the Directors Primary Threshold, either at the end of the tax year, or if the director leaves during the tax year.
  • Annual (Non-Table) – The new Director Primary Threshold is correctly applied in the next period as soon as v28.02 is installed, even is the process date is before 6th This may cause a re-calculation of NI liability if the director has already exceeded the original Primary Threshold, as the annual calculation will use the new Director’s Primary Threshold.

Re-process pay Periods

Once you have installed v28.02, when you re-process a pay period the NI threshold used depends on the employee’s status.

Employees and Pro-Rata directors– If you reprocess any periods before 6th July the old thresholds are used.  If you re-process any periods with a process date on or after 6th July, the new thresholds are used.


  • Annual (Non-Table) – The NI calculation for any period you re-process in the tax year uses the new Directors Primary Threshold.

If you would like help with the new National Insurance thresholds or need help installing Sage 50cloud Payroll V28.02 or need any other help or advice with your payroll please contact us



Customer Activity

This shows the trading history between you and your customer.  It shows the customer’s credit limit, the balance owed, as well as the total they have paid and the turnover for the year.

Each line represents a transaction such as an invoice or a receipt.

To view the activity, click Customers, either highlight the required customer and click Activity at the top of the screen or double click the required customer record Activity.

Viewing the Customer activity

A/C  – This shows the customer account reference.

Name  – This shows the name of the customer.

Credit Limit – This shows the credit limit entered in the Credit Control tab.

Balance – The current balance of the customer account.

Amount Paid– Total payments made by the customer.

Turnover YTD – The year to date turnover value for this customer. This value is net of VAT.  The YTD figure is taken from the Sales tab and clears when you run the year end routine.  You can manually amend this value in the Sales tab.

O/s Only – If ticked, the window will update to display outstanding transactions only. Untick to show all transactions.

No – the number of the transaction.

Type – The following transaction types may appear:

SI  =  Sale Invoice

SR = Sales Receipt

SC = Sales Credit

SA = Sales on Account

SD = Sales Discount

SP = Sales Payment

Date – The date of the transaction.

Due on – The transaction due date.

Ref.  – The transaction reference.

Exchange Rate  – The exchange rate of the transaction (will not show if foreign currency not set up)

Details – Any details entered for the transaction.

Amount – The value of the transaction.

O/S – The amount of the transaction that is still outstanding.

TIP – *=Transaction is fully outstanding. P=transaction is part paid.

Debit – If the transaction represents a debit, its value appears here.

Credit  – If the transaction represents a credit, its value appears here.


Viewing transactions

Show details – opens a window breaking down any selected transaction into its component parts.  For example, a sales receipt is broken down into the invoices it paid off, and a sales invoice lists any receipts allocated against it.

Hide Details Closes the window showing the detailed breakdown.

View transaction – To view the full details of the transaction, select the required transaction then click View transaction or you can double-click the transaction.

View item – If the transaction was created from an invoice record, to see the related invoice, select the required transaction then click View item.  Alternatively, you can double-click the transaction.

View Bank charges – If you use the bank charges feature, to view any bank charges associated with the customer click View bank charges.

Amending or removing transactions

Edit transaction  – To amend a transaction while in the activity window, click the transaction then click Edit transaction.

Unallocate transaction – If you have posted a receipt or credit against an invoice in error, you can use the Unallocate  transaction option to unlink the transaction.  A sales receipt (SR) becomes a sale on account (SA) when it is unallocated, then it can be allocated against a different invoice.

Delete transaction – To delete a transaction while in the activity window, click the transaction then click the Delete transaction.

Aged balances – At the foot of the window aged balanced appear, broken down into boxes according to the ageing method chosen in Settings > Customer Defaults > Ageing.

If you would like further help with the Customer activity screen or need any other help with your Sage Accounts please contact us

Not all accountants are grey.

Call us now for your FREE consultation on 01691 654545 or click here...