UK Tax Reporting

cfch's Avatar


16 Nov, 2020 06:04 PM

It's great (in Version 2020 and later) to see that the UK Tax Date (6th April) is now included as an option in preferences but could we now please get UK Tax Year Reporting?

At the moment if you choose, say, 6th April 2019 to 5th April 2020 you get a report with 3 columns:

  1. 6th April 2019 to 31st December 2019
  2. 1st January 2020 to 5th April 2020
  3. A total of the above.

If you choose 6th April 2016 to 5th April 2020 you get:
1.6th April 2017 to 31st December 2017
2. Calendar 2018
3. Calendar Year 2019
4. 1st January 2020 to 5th April 2020.

I'm sorry the UK tax system is so obtuse but what you need is a report which shows a SINGLE column for each Fiscal Year so and covers 7 years (again a tax requirement).

See attached file.


  1. 1 Posted by Stuart Beesley ... on 16 Nov, 2020 06:08 PM

    Stuart Beesley - JUST A FELLOW USER's Avatar


  2. 2 Posted by dwg on 16 Nov, 2020 07:35 PM

    dwg's Avatar

    I'm a fellow user.

    In Australia the tax Year starts on July 1 and I use the Income and Expense reports for Tax reporting. I just set my saved report to all dates and chose it to group by fiscal years, The result is having a series of columns each covering a fiscal period 1/7 through 30/6, I'm not seeing any problem.

  3. 3 Posted by cfch on 16 Nov, 2020 08:47 PM

    cfch's Avatar


    Thank you so much for your reply. I've found the option, tested it and it works!

    Problem solved.

    All the best.


  4. 4 Posted by Stuart Beesley ... on 17 Nov, 2020 09:55 AM

    Stuart Beesley - JUST A FELLOW USER's Avatar

    WOW - I had never seen the April 6 date - when did this arrive? I also had not understood the Fiscal Year Start setting in Preferences and the linkage to the Fiscal Year grouping in (only) some reports. This is great!!! Thanks for the tips guys!!

  5. 5 Posted by cfch on 17 Nov, 2020 09:58 AM

    cfch's Avatar

    It was first introduced in version 2020 but not really publicised! It makes a huge difference to all of us in the U.K. and I suggest to Moneydance that they include a reference to it in their FAQs and elsewhere.



  6. 6 Posted by dwg on 17 Nov, 2020 10:25 AM

    dwg's Avatar

    I can find the April 6 Option for Fiscal year as far back as Moneydance 2012 - I do not have anything older installed.

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:


Already uploaded files

  • 7_year_draft_report.xlsx 9.84 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

25 Jan, 2021 04:49 PM
25 Jan, 2021 04:42 PM
25 Jan, 2021 04:18 PM
25 Jan, 2021 03:15 PM
25 Jan, 2021 02:40 PM