IAS – MTD Quarters for AP to BT to PT workflow and queries

ias-mtd-quarters-for-ap-to-bt-to-pt-workflow

IAS – MTD Quarters for AP to BT to PT workflow and queries

20th May 2026

Defect version 26.2.0.496: If you have property postings in AP with values/dates, they will show values in BT and PT but will not show in MTD quarters. This is because of a issue where the ‘dates’ you added in AP for each posting are not being transferred into PT and thus the data will not show in MTD. Our Development team are looking for a WINTER 2026 fix (No date yet). There is a workaround – manually delete the property values from personal tax and manually use a import of a CSV for the property data directly into PT, this will show the data. Also ensure no one in BT clicks ‘Refresh PT’ button as its override your manual CSV import.

How to enter income/expense data: as a example a Sole Trader- so it shows in AP, then to BT and then to PT for the clients MTD quarters. This is if you decide not use the CSV import tool in PT.

Accounts Production → Business Tax → Personal Tax Workflow Guidance. To ensure data flows correctly across modules, it is important to follow the correct process and understand how information transfers between systems.

1. Correct Setup Order

• Begin by creating the set of accounts in Accounts Production (AP).
• Once completed, open the client in Business Tax (BT).
• From there, click ‘refresh the data’ into Personal Tax (PT).
• Load the Client in PT and check

Important: Data flows one way only:

Accounts Production → Business Tax → Personal Tax
There is no data flow from Personal Tax back to Accounts Production.

2. Importance of Dates in Accounts Production

• The accounting period dates set in AP are critical.
• These dates determine how quarterly periods are identified and processed.
• Incorrect dates may lead to amount in the wrong quarters

3. Handling Quarterly Data

There are two ways quarterly figures can be populated:

Option A – Enter Data in Accounts Production (Recommended)

• Enter quarterly figures directly into AP and ensure the date falls within the relevant MTD quarter.
• This removes the need to import CSV files later.
• The data will automatically flow through to BT and PT.
• See the very bottom of this KB for Summary/Example of the AP steps

Option B – Import CSV Files into Personal Tax

• If CSV files are imported into PT:
  • You must still go back into AP and enter the corresponding postings.
  • This ensures consistency, as PT does not push data back to AP.

4. Refreshing Data and Risks

• Refreshing PT after importing CSV files may overwrite existing data in the accounting period. Therefore if you are importing CSV files into Iris Personal Tax we recommend not refreshing in Business Tax to Personal Tax
• However:
  • If quarters have already been submitted, they will not be overridden in the Digital Tax Hub, however if they have not been finalised and submitted they will be overridden.

5. Scenario: User Has Imported 3 CSV Files

If a user has already imported 3 quarters via CSV and needs to create accounts:

Best Practice:

1. Import the 4th quarter CSV file.
2. Submit all quarters.
3. Then proceed to prepare the accounts.

Why?

• Entering Quarter 4 directly in AP after importing earlier CSVs may overwrite or conflict with previously submitted data and adjustments.

Key Points:

• Always follow the correct flow: AP → BT → PT.
• Set accurate accounting dates in AP.
• Prefer entering quarterly data in AP to avoid inconsistencies.
• Be cautious when refreshing PT after CSV imports.
• Complete all quarters before preparing accounts where possible.

Troubleshooting

• MTD/DTH is omitting the AP data yet shows on the PT screens? – See the next step below and check the dates in AP fall within the correct quarter and do the refresh steps again. If still missing then check in PT, load the client and tax year and leftside of PT – UK property summary OR open the Trade period. Make sure all the buttons are switched to ‘MANUAL value’ not HMRC – Do the same for expenses as well. Now check the MTD/DTH screens – should show the Income AND expenses (and not being omitted).
• How to check/edit the quarter dates for EACH AP posting. Do this if the AP data still wont show up in PT MTD screens. At top of AP, click POSTINGS and should list them all. Right click the posting you want to edit and a pop up should show, click ‘Amend posting’, then click the DATE button , then click ‘LIST’. A new box will show (and if the 4 quarters were all showing correcting in PT) then it ask which ‘Quarter date’ this posting should come under and choose correct one and click SELECT. This now changes the date on the main posting screen against this one post. Remember to refresh from AP to BT – click refresh PT- load PT and refresh the client and should now pick up the AP data
• Warning: On the main POSTING screen (When it loads up every posting row) – do not go to the very bottom of the screen and edit the ‘date’ field there
• 
• 

Summary/Example of the AP steps:

If it’s a new period: Go to Posting | New | (screenshot) Add then add the dates of the new accounting period (screenshot) | OK. Highlight the new period | OK (screenshot). Fill in the description e.g. ‘Year end 2026’ (so we are adding in a new 2026 tax year) | OK (screenshot).

The session identifier is optional and many people use it to denote the staff member who entered the postings or the date on which this happened. You can leave it blank as well. The document type is used to specify which account postings should be there. For example doc type 1 is Opening balances and 11 is Journals. Go to Default posting date at the bottom and click the spyglass. The quarterly periods (the default option) should be displayed there (screenshot). Highlight the first quarter | Select | OK. If you selected the Doc type =1 for opening balances, it will ask for the period to generate them from. The default option is the prior year (screenshot).

Then you’ll be in a screen ready to input your postings for the first quarter (opening balances will be automatically included) (screenshot). Then make your postings by inputting a relevant account code and amount in the bottom right | Add posting.

Then, for the second quarter, click the spyglass by Date (screenshot) | List and your quarterly periods will appear again. Highlight period two | Select. Any postings made there will be dated in the new quarter (screenshot). Then make the postings for period two in the same way we did for period one and repeat for the third and fourth periods.