SQLWorks to Make Tax Digital

**NEW Update**

We’re Officially Recognised by HMRC for Making Tax Digital!

SQLWorks Accounting was approved for five key functionalities following demonstration of a sandbox environment to HMRCs review team. Learn more about Making Tax Digital with SQLWorks here.

recognised

 


We’ve updated our SQLWorks software to support Making Tax Digital – with Lineal staff officially demonstrating their work to HMRC’s Review Team during January 2019.

SQLWorks Accounts Prefs can be linked directly with a company’s HMRC VAT Account, granting permission to submit quarterly VAT returns for 18-months before re-authentication is required.

making tax digital authorisation

Making Tax Digital will be available for all SQLWorks Accounts Admin users via the existing VAT Ledger, and allows the accounts administrator to report their VAT return (shown in boxes 1-9) directly to HMRC’s system at the press of a button.

SQLWorks can also report up-to-date VAT account status information (such as obligation, payment and liability entries) from a company’s HMRC account, and access logs recording the full audit trail of communication between HMRC and our software. Once submitted, the company’s VAT return quarter is locked down to ensure security of reporting.

 


Lineal Software Solutions have been officially registered as a provider developing software suitable for HMRC’s new ‘Making Tax Digital’ initiative.

The new tax regulation, which will require UK businesses to undertake tax reporting (initially VAT) via digital links from April 2019, will need approved accounting software to report directly and digitally to a company’s HMRC digital tax account via web API.

Only software which passes a reporting test set by HMRC using example data will be approved for Making Tax Digital (Phase 2 standard.)

Mike Matthews explained: “Currently only around 130 software providers in the UK are registered as developing for direct Making Tax Digital accounts reporting. SQLWorks has had the ability to calculate your VAT return for many years, but very soon, you’ll be able to process your submission direct to HMRC digitally too.”

making tax digital software

HMRC says a quick Hello to SQLWorks during testing…

“HMRC’s main aim is to remove any re-keying or manual re-processing of data – which will make SQLWorks the perfect integrated solution for processing business all the way from quotation to sale, to direct VAT reporting.”

“The government have recently altered some of the software rules being put into place for making tax digital, but we’re hard at work to make sure all SQLWorks customers can begin reporting VAT digitally from next year.”

Recent figures collected by The Institute for Chartered Accountants have suggested awareness of Making Tax Digital is still very limited, with less than half of businesses stating they were unaware of changes that are about to come into force.

This Page will be updated periodically with the latest SQLWorks Making Tax Digital news – please check back for updates! 30.10.18

For an effective, integrated software solution – contact our team today.

Introduction to EC VAT Reporting

SQLWorks allows users to accurately report on EC VAT, as part of their VAT Ledger.

In order to report on EC VAT, every sales and purchase account to be included must first have a country and VAT reporting setting saved against it.

For each customer or supplier, this can be set under the ‘Bank and VAT’ tab in the Sales Ledger/Purchase Ledger.

To set up the customer/supplier for EC VAT reporting, choose the correct European country from the ‘VAT Country’ (SL) or ‘Country Name’ (PL) fields, and select the correct setting under ‘VAT Setup’. ‘INC’ is for accounts which need VAT to be included, ‘Exempt’ for accounts with reportable VAT of zero value, and ‘NRT’ for accounts with non-reportable VAT.

Whether the selected country is part of the EC VAT reporting can be set in the SQLWorks countries list (found under ‘Countries’ in Address Editor.) Double click a country from the list to edit it from ‘UK’ to ‘EU’ or ‘World’ and click save. The EU category may also be used to designate countries not formerly part of the European Union, but part of the European Economic Area (e.g.: Norway.)

System Administrators may wish to force users to include a company VAT number when dealing with EEA customers/suppliers, for tax reporting purposes – this policy can be enforced via Preferences > Accounts Prefs > ‘Finance, Analysis, Dept & Tax’* Tab, by ticking the ‘EEC VAT requires VAT No in:’ option for either Purchase Ledger (PL), Sales Ledger (SL) or both. This will restrict users from saving any new transactions against sales/purchase accounts without a known and saved company VAT number.

Accounting admins may also choose which nominal codes need to include or exclude VAT by choosing a nominal code in the Nominal Ledger, clicking edit, and ticking the ‘Add VAT’ checkbox in the top right, before saving.

SQLWorks will collate EC VAT figures in the VAT Ledger beside UK VAT, in the ‘EC VAT’ columns (1 & 2), and VAT Ledger users can click the ‘EC VAT’ buttons at the top of each EC Vat column to view the transactions included in that section.

The VAT Ledger will also produce EC VAT totals in the ‘Total’s group’ section at the bottom of the window (3). These are then used in the Form 100 totals, allowing SQLWorks accounts users to complete an accurate VAT return.

 

For additional help or SQLWorks accounting expertise – contact our team today.

*This tab may be labelled ‘VAT & Dates’ in older versions of SQLWorks.