Here is an example (courtesy of, which offers its material under a Creative Commons license), using loan payments: The general form of such a function ties all of these together in a relationship that lets you specify all but one of them and solve for the remaining one. But if you take the time to understand what these functions are doing you can often use them in other ways.Īs we pointed out, all functions in Calc take arguments and in this case as you might expect the arguments would have to do with interest rates, principle amounts, time periods, and payment amounts. The thing you need to bear in mind about these is that they are all oriented to doing financial analysis on investments. So it should not come as great surprise that there are many great financial functions in Calc. And the reason for that was that you could do sophisticated financial analysis with spreadsheets. It costs as little as £1.50 to submit a VAT return and your first submission is free when you sign up for an account.As we discussed back when we first looked at spreadsheets, they were the killer app that lead to wide-spread adoption of PCs in companies. The solution submits VAT returns to HMRC and enables VAT obligations, liabilities and payments to be viewed. Saving a LibraOffice Calc spreadsheet to an Excel (xlsx, xls, xlsm) or comma-separated values (csv) file, importing the VAT figures into Easy MTD VAT then submitting them to HMRCĮasy MTD VAT is a Windows application approved for use with HMRC's MTD for VAT system.

It is, however, compatible with Excel (xlsx, xls, xlsm) and comma-separated values (csv) files, which LibraOffice Calc is able to save to.

This is why bridging software such as Easy MTD VAT must be used.Įasy MTD VAT is not directly compatible with LibraOffice Calc files so it cannot import VAT figures held in this format prior to submitting them to HMRC. LibraOffice Calc, like all spreadsheets, is an accepted solution for recording business figures but it does not have the functionality to submit VAT returns to HMRC.

If you are a VAT registered business and you record your business figures in a LibraOffice Calc spreadsheet, you are likely looking for a way to submit your VAT returns in compliance with HMRC's Making Tax Digital for VAT (MTD for VAT)

Libra spreadsheet