Solution Properties
Solution ID:
260611133134073
Last Modified Date:
Mon Sep 21 13:16:12 UTC 2026
Taxonomy Path:
Case category//I have a problem with...//import/export
Author:
[email protected]
Known issue: Income Tax Export reports formatted incorrectly
Description

We've created a backup to restore which includes new formatted reports.

NOTE:

We've resolved this issue in v34.1 and above of Sage 50 Accounts. Download and upgrade to the latest version.

Cause
Resolution

Restore the fixed reports backup

To resolve this, download and restore the reports backup.

  1. Download the MTD Reports Backup.
  2. In Sage 50 Accounts, restore the reports backup.

If you're unable to restore, follow the workaround.

Workaround 

The workaround is to unmerge the required cells in excel.

  1. Open the report in Excel.
  2. Highlight the merged cell, then select Merge & Center on the Home tab of your ribbon.
  3. Select Unmerge Cells.
  4. Column C is for the description and Column D is for the debit column.
  5. Choose File, then Save. 

Upgrade your licence

Growing business? Add more companies, users, or employees to your licence with ease. Leave your details and we’ll be in touch.

 

Steps to duplicate
Related Solutions