Thursday 23 November 2023

UK Tax - MTD for ITSA Updated

The MTDfITSA saga has been running for many years, and as of 23 November 2023, this is the current state:

Go live: start 5 April 2026 and apply to a way smaller base than the original intended group of 4.5 million users.   These are the key changes and points: 

  • Who is in?  Self-employed people and property landlords (outside of Limited companies) need to register.  Initially, landlords with joint property ownership are not mandated to join (HMRC must provide more information).  Individuals MTDfITSA that previously did a Self Assessment can have ten or multiple self-employment businesses and 0 to 3 (4 - Foreign property is unclear) property businesses under MTDfITSA (Ord UK property, FHL UK, FHL EEA, Foreign property).
  • Who is out?  Partnerships are out, and non-dom status (has specific rules).  If a person is currently self-employed but has complications such as joint individual property ownership that generates rental income, being a partner in a partnership - will mean you are outside and continue to fill in self-assessments.  Trusts/estates, LLP and Ltd are out at the start.  Specific exemptions for income from foster care and individuals without a National Insurance Number do not need to register for MTDfITSA.
  • EOPS concept is removed from MTD for ITSA
  • Quarterly submissions are now cumulative booking numbers for the business.  The quarterly figures are cumulative per business for the year, i.e. Q2 submission consists of all data from Q1 and Q2.  Unlike VAT, ITSA quarters are cumulative during the year, whereas VAT is for a specific quarter.
  • For each self-employed business or property business, a quarterly per-business submission is due to HMRC within 30 days of the quarter’s completion.  Declaration per business is still required (31 January the following year). 
  • A single crystallisation submission for the user at the year-end is due 31 January each following year.  A yearly declaration is also required.

·       Digital links/keeping (digital records).  Can’t re-key/copy and paste.   There is no requirement to use bank feeds/PDS2 data.  Some booking software firms will likely file quarterly MTDfIT returns for each self-employed (and property) business.  Spreadsheets are an acceptable form of record-keeping.   Excel and bridging software are sufficient for the source for filing.  Recording sales can use daily sales totals for the digital source but, ideally, link to the raw input system.  

·       Quarterly submissions requiring corrections are cumulative now, so you merely correct a mistake by adjusting in the next period/quarter.

  • Starting 6 April 2026, this shall apply to less than 750k users
  • Self-assessment people with a combined income of £50k for the two years previous need to register for MTDfITSA; the plan is to drop to £30k the following year.
  • There is a new penalty system.  Late payment has interest penalties, basically no penalty for 15 days late, then 2% for 16-31 days and then 4% is paid after this.  4% is on the outstanding balance from the day past due.  Payment is due the following year on the 31 January.  There are points, fines, and interest charges.  Penalty points for late filing, missing four quarters in 24 months, is £200 penalty.  Record of last 24 months retained. 

Summary of comparison between ITSA & SA:

SA

ITSA

1 SA return is done each year per person.

Four quarterly returns via approved software per business required a digital record link to the underlying transactions per self-employed business.

Ask HMRC to explain how to correct business totals for the year as 1.  missing types of expenses, 2.  As EOPS was removed, assume you have 30 days to finalise business accounts from business year-end, bringing this forward nearly eight months.

Crystallisation/Finalisation using HMRC-approved software per person, not per business.

Paper submission due 31 October for the previous year.

Online submissions are due 31 January – 9 months after the financial/tax year-end.

Approved Digital Software to submit (no paper returns).

One month after each quarter, submit the quarterly cumulative return.

No EOPS is due on 31 January the following year with new rules.  

The Crystallisation/Finalisation/Final Declaration is also due 31 January the following year.

Quarterly MTDfITSA is done per business and is due one month after the quarter period ends.  Property business quarters and year-end run in the same cycles as personal tax, starting on 6 April and ending the following year on 5 April.  As MTDfIT begins on 6 April 2026, the four quarterly submissions for the 2026-2027 tax year and filling due dates are:

Qrt start date

Qtr end date

Qtr submission due date

6 Apr 2026

5 July 2026

5 Aug 2026

6 July 2026

5 Oct 2026

5 Nov 2026

6 Oct 2026

5 Jan 2027

5 Feb 2027

6 Jan 2027

5 Apr 2027

5 May 2027

 

Self Assessment filling options:

  1. Most people use the current XML online filing done on 31 January after the personal tax year.  +-11 million people 2026/2027.
  2. Some people still use paper-based self-assessments due Oct after the tax year.
  3. MTD for ITSA will be due one month after each business quarter, and the finalisation/crystallisation process is due 31 January, the year after the personal tax year.  As HMRC calc tax, declarations are required from the taxable individual for the year and after each quarter per business. +-500k people

Tuesday 21 November 2023

Review of Browser Stacks Low Code Automated test tool

Overview: Low code testing relies heavily on complete UI end-to-end testing.  It needs to be fast, flexible, quick to correct, scale-able, highly configurable and BrowserStack's low code test tool is in beta and definitely on the right path - for me, it needs a few features.  I ran my testing against customised apps created on three platforms:

  1. Mendix low code,
  2. Microsoft's Blazer hosted on Azure Web App, and
  3. Canvas app within Power Platform. 

Tip: I've looked and use BrowserStack for many years and it has moved from being an device emulators infrastructure testing provider to a full ALM testing platform.  The low code Browser stack has a recorder to capture steps.

Where does Low Code fit into Browser Stack:

Image1. Low code automation works well as part of the full BrowserStack Platform or just using the product by itself.

Pros of the Low Code BrowserStack Product:

  • The local recording feature is easy to set up and use
  • Seamless integration with the cloud version running on BrowserStack's infrastructure
  • Logical layout of UI, little to no training required
  • UI validation using the DOM or, more importantly, screenshots using BrowserStack's AI verification (required further review) has the potential to self-heal as in the screen changes, but the validation can be smart enough to understand it is just an updated screen (example a single colour in the page and the position of the name is moved).
  • SDK is available to work with the full BrowserStack platform.
  • Not Low code specific but BrowserStack generally has the new phones included in their offering within days of being release.

Cons:

  • Provide a webhook or allow for a REST client call as a step (I'd want to log directly from the test run into Azure Monitor)
  • More run options, I'm sure it's already on the road map, but the ability to run every hour for continuous monitoring.
  • Refresh tokens on a schedule (allows you to not use MFA such as SMS codes or Authenticator).
  • Make it clear if the run is from the local or the browser, and keep the historical logs for both together.
  • Export results - I could not find this, but it would help compare step performance.
  • I use DevOps, I'm unlikely to take the whole BrowserStack platform unless i need the emulators which is what BrowserStack was originally famous for.

Summary: This is an excellent tool for testing; the low code product was still in beta when I reviewed it.  It is a nice tool and has the potential to disrupt the market.  I feel Playwright is a better point solution and integrates to CI/ALM platforms.

Referenceshttps://www.browserstack.com/low-code-automation/features?utm_source=google&utm_medium=cpc&utm_platform=paidads&utm_content=668760067900&utm_campaign=Search-Brand-EMEA-Navigational&utm_campaigncode=Core+9045914&utm_term=e+browserstack

Other

Image 2. Emulate a Samsung Galaxy phone on Android using the Chrome browser.

Thought: I like BrowserStack's reporting, clean and simple on tests and easy to get the history.

Wednesday 15 November 2023

Ignite 2023 - Microsoft Fabric - Introduction

GA: Prepare your data for AI innovation with Microsoft Fabric—now generally available | Microsoft Fabric Blog

Everything brought in and available for analysis in a single Service.  Microsoft Fabric is a unified platform that brings all your analytics under a single service.

OneLake - per Fabric instance.  Stores all data within the SaaS data-lake (scales itself), automatically index data, abides by AIP rules/labels.  Intelligent data foundations.

All data is held in the Delta Parquet format (same format for any source).  Data is ready to use.  One copy of data.

SaaS single service, no need to bring pieces together, one data sources don't need to move and slice data.  Can query using multiple approaches. Can create a short cut to files/folders/databricks and it becomes part of OneLake.  Data stays at original source but can be worked with.

Mirroring in MS Fabric - get same benefits of shortcuts, but can connect to databases including SnowFlake, Dataverse, AWS S3 buckets & CosmosDB.  Mirroring is always up to date in real time.  Data is stored in Delta Parquet format so can now use.  With these 2 approaches can use nearly any source. lots of connectors so could use: Dataverse, Cosmos, Snowflake, SQL Server, blobs on S3,..  Then can write queries across all the data. 

Copilot in Microsoft Fabric will help bring in all the data, and help analyse the data.

Copilot for Power BI is amazing for building reports - need tp play with it.

Ignite 2023 - Keynotes - Summary

15 & 16 November 2023

Good Keynote: AI is driving a lot of innovation.

Microsoft Fabric in GA (25k instances already).  New feature is 'Mirroring' - copy cosmos/SQL et al into Fabric.  OneLake.  Can bring lots of data from multiple sources into Fabric in near rela time.

MS Teams (320 million users):  Bring everything to the user in one place, not just communications but a canvas for apps.  Good place to build line of business applications.  New teams app - way faster, easier to use.  Teams Premium - intelligent meeting recap is working well, can integrate recap with copilot. 

Copilots - needed for nearly everything you do.  understand context of where you are.  MS has hundreds of copilots.

Copilot Studio - Custom GPT's, can add plugin's to add your own data, can hook into an enterprises unique data.

Copilot for Service - allows agents to get information to provide support, looks interesting.

Personal thoughts: AI is going to be a mega trend that will influence the world hugely, there will be lots of weird decisions on the journey. Currently, it is mainly proving useful as another tool to help improve existing processes.  AI helps me work faster and spend my time on exploration rather than bring base understanding together.

Part 2 Keynote:

Microsoft Graph gives the copilot context within an organisation.  Use plugins to add enterprise data or Open AI GPT's.

Surface Pro Hub 3 released  - looks good, rest of the hardware looks higher spec.

SharePoint Premium - improved knowledge and content management on SharePoint.

Copilot Studio - useful to build internal copilots.  1. Connect copilot to other systems using plugins or GPTs 2. create workflows 3.  Controlled by IT.

Copilot Studio overview

Mesh - Teams can join immersive experience/events, not sure what this means.  GA expected Jan 2024.

Microsoft 365 copilot release to GA 1 November. 

Why Copilot? MS are describing it as a productivity multiplier.  Allows users to be more productive and more creative.  Improves quality of work, avoids searching - as expected.  Makes mistakes but is getting better.

Microsoft Copilot - Bing chat is just MS copilot

So when logging use Entra Id (Azure AD), get contextual enterprise information.  Inherits security and privacy policies.  ACL controlled.  Includes MS graph and Apps.

Try it out: Copilot.microsoft.com  - Chat data is not saved/stored by MS.  Change from "web" to "work".  Also available in Windows taskbar

Ability to use copilot to pull in information, show more graphs, get data.  Good word example getting data from a pptx.

Great example of querying Excel using copilot, created a pivot table. Contrived but looks good, added rainfall from web to look at sales.  Powerful.

Never thought of copilots for being a participant in a meeting - might us amazing.  In teams meeting, takes real time notes, and pulls in info and summaries points for next meeting.  Add as a collaborative partner, can visualize discussions on a meeting whiteboard.

Loop - flexible collaboration, now with copilot.  Not my area but sounds impressive - i don't get it.  People, working with people, now also working with copilot.  Okay.

Copilot for Sales - looks promising.  Hooks into existing CRMs.

Copilot for Service - working with customers, get data that is correct to solve customers problems.  Concise summary, helps craft emails, updates CRM.  Looks very interesting!

Viva - Microsoft copilot dashboard powered by Viva - not sure on this topic.

Summary: People using copilot don't want to loose it.  AI is bringing big changes to many industries.  Promise is to take the grind out of work - sounds great let's see.  Copilot/AI will be a tool and shape how we work.