Cumulative Update Mapping Rules

When you create a cumulative update, QuickFile sorts your income and expenditure into HMRC reporting categories using mapping rules. Each nominal code is assigned to a specific HMRC reporting category.

Each type of business has its own separate set of mapping rules: a self-employment business, one or more UK properties and one or more foreign properties. For guidance on how to structure your QuickFile accounts, see the MTD account configurator.

Prefer to watch?

Prefer a video walkthrough? Watch our QuickFile Cumulative Update Mapping Rules Explained tutorial on the QuickFile Help Guides YouTube channel.

Find your mapping rules

You can view and change your mapping rules in the MTD settings for your business.

  1. Click Reports > Self Assessment to open the Self-Assessment workflow.

  2. Click Options > MTD Settings.

  3. Click Self employed nominal account mappings.

You can also open the mapping rules from a draft cumulative update.

Check the self-employment categories

A self-employment business has 2 income categories and 15 expense categories. The income categories are Turnover, takings, fees, sales or money earned and Other business income.

Click the arrow beside a category to expand it and see the nominal accounts assigned to it. The mapping page shows the template as Custom, with a Revert to default link.

Add a nominal account to a category

  1. Expand the category you want to change, then click Add new mapping.

  2. In the Map nominal code to HMRC category dialog, choose the nominal account in Nominal account name.

  3. Tick Mark as disallowable if the nominal account should be reported as disallowable.

  4. Click Add nominal code.

  5. Click Save Mappings.

Mark expenses as disallowable

When you add a nominal account to an expense category, tick Mark as disallowable before you click Add nominal code. Postings to disallowable nominal accounts are reported separately in your cumulative update.

Choose what happens to unmapped amounts

A nominal account that is not assigned to a category is reported in the unmapped row for its range. Each unmapped row has a Post to drop-down. The rows are:

  • Unmapped Income (4000-4999)
  • Unmapped Cost of Sales (5000-5999)
  • Unmapped Expenses (6000-9999)

The Post to drop-down lists Ignore and the categories in that section. Choose a category to report unassigned amounts under it, or choose Ignore to leave them out of your report.

Warning: If an unmapped row is set to Ignore, income or expenses can be left out of your report. Use Ignore only when you report for several entities, such as a self-employment business and UK or foreign property income, and you separate them by nominal code.

Check the property mappings

Use the Business type drop-down to switch between Self Employment Business, UK Property and Foreign Property. Each business type has its own categories:

  • UK Property: 6 income categories and 10 expense categories.
  • Foreign Property: 5 income categories and 9 expense categories.

To add a nominal account to a UK property category, expand the category and click Add new mapping, as for self-employment.

How changes affect your updates

Changes to your mapping rules apply straight away to draft cumulative updates. Submitted updates and earlier saved versions are not changed.

Related videos

Two videos cover the steps that follow mapping:

Related topics

New to Self Assessment in QuickFile? Start with Self-Assessment Workflow for an overview of the centralised workflow for Income Tax and Self Assessment.