I am helping a client that currently uses spreadsheets for all its accounting and bookkeeping. It is VAT registered and will be in MTD from April 2019. The entity is a club that is an unincorporated association, and it is partially exempt. It has 5 people who provide information to the accounting system and so an online software package would be the most suitable.
I have looked at QBO but it doesn't track the VAT that "belongs" to the different cost codes and consequently it doesn't really work for partial exemption. All the VAT is recorded in the VAT control accounts, and all history relating to the VAT is promptly lost. QBO doesn't provide reports that can be used easily when doing the PE calculations eg the transactions histories only show the costs in the cost codes, and not any VAT related to the transactions. I know that HMRC has provided an "exemption" to allow entities in MTD to use spreadsheets for complicated calculations. However QBO doesn't work for the stage before that.
Is anyone able to suggest an online software package for my client that deals with partial exemption easily? With many thanks for your help.