| | Categories: Blog, Software Updates

November Software Update

In our penultimate software update of 2017 we only have a few changes that I want to highlight in this blog, but as always, a full history of changes is available by clicking the ‘Release History’ button on the Twinfield home screen.

Changes this month include:

  • Changes to the way VAT is displayed on Neo Quotes
  • Removal of the discount percentage when discount is an amount
  • HMRC VAT Gateway change


Changes to the way VAT is displayed on Neo Quotes

Last month we released a change to the Neo sales invoice which hides all mention of VAT when invoice lines have a VAT code of ‘No VAT’.

This month we have added this same functionality to the Neo quote document:



Removal of the discount percentage when discount is an amount

In August we released a change to Neo sales invoices to enable you to enter a discount amount or percentage at the bottom of your sales invoice.

Since then we have received some great feedback and as a result, we have implemented a small change – in that now, if you enter an amount discount, Twinfield no longer displays the calculated percentage discount as well as the discount amount.  This change has been made thanks to direct feedback from users, so thank you for the feedback.

Sales invoice as it appeared before this change (user entered a discount amount of £100.00 which Twinfield then displayed as 8.89%):


The percentage is no longer displayed when the discount is entered as an amount:


If you enter a percentage discount during data entry, then both the percentage and the amount will be displayed on the invoice.


HMRC VAT Gateway change

Lastly, HMRC are in the process of making some changes to their systems, and as a result, we have made a small change to ensure that Twinfield users can continue to file their VAT returns electronically.

If you are not currently filing your VAT returns electronically, and would like to learn how to do this, please click here to view our two videos about reporting and filing your VAT. 

| | Categories: Blog, Software Updates

October Software Update

This month we only have two main changes to tell you about.  These are:

  • Changes to the way VAT is displayed on Neo sales invoices
  • Payment and Collection schedule reports now display bank account number of payment transaction

As always, there are a number of other minor changes which you can read about by clicking the ‘release history’ button within the Twinfield home screen, and there are a number of other larger projects that are keeping our developers busy, but nothing that is ready for release just yet.


Changes to the way VAT is displayed on Neo sales invoices

In August we released the new VAT summary section on the Neo sales invoice, and in this month’s software update we have made further improvements with respect to how VAT is displayed.

Firstly, we have switched the order of the VAT Rate and Line Total columns in the body of the sales invoice, so that the line total is now on the right hand side of the invoice.

And for entities who process invoices that don’t have a VAT component, all mention of VAT on the sales invoice is now hidden.  This could be for one-off sales which are ‘out of scope’ or entities that are not registered for VAT.

In summary, if you process a sales invoice that contains VAT, the lower section of the invoice will look like this:

01 VAT sectionon invoice with VAT

And if you process a sales invoice where all lines of the sales invoice have the VAT rate of ‘No vat’, the lower section of the invoice will look like this:

02 VAT sectionon invoice without VAT

Note 1: During data entry, the invoice input screen will show the VAT column and summary as per normal.  It is only when you click the ‘send’ button that Twinfield formats the emailed/printed invoice based on the VAT content.

02a VAT section on invoice without VAT

NOTE 2: the ‘VAT not applied’ can be hidden by editing the default setting within the template.  To do this, select ‘Invoice Template’ from the ‘Related Items’ menu on the right hand side of your sales invoice data entry screen, and scroll down to the bottom of the template.  Click on the words ‘VAT: reverse charge’ (which is where reverse charge text will be displayed if you are issuing sales invoices subject to reverse charge VAT) to display the ‘Hide’ button.  Click this to supress this text from being displayed on future invoices.

03 Hide VAT not applied text

And whilst on the subject of Neo sales invoices, you may have experienced a problem previously whereby if using Google Chrome to create Neo sales invoices, and your ‘zoom’ setting was set to either a low or high percentage, your sales invoice would process as a multi-page invoice, even if you only had one line on the invoice.  The work-around for this was to set your ‘zoom’ setting to either 90% or 100% but this is no longer a problem, and you can use whatever zoom setting you like.


Payment and Collection schedule reports now display bank account number of payment transaction

Previously, if you re-ran an historical payment schedule report, the bank account number displayed for the supplier/customer was the current bank account number for that supplier/customer and not the account number used in the actual transaction.  This report has now been modified to show the historical bank account number from the transaction – although as you will note below, the wording still indicates that this is the current ‘default’ bank account number.  This will be corrected in next month’s software update.

04 Payment schedule bank account number


Monthly webinars:

Don’t forget, every month we demonstrate the changes that have been released and answer any questions that you have.  Search for ‘webinar’ within the Twinfield knowledgebase to register for the next webinar or to watch recordings of previous webinars.


| | Categories: Blog, Software Updates

September 2017 Software Update

This month we only have two new enhancements that will be of interest to UK and Irish Twinfield users, although we are working on some larger projects that will be released upon completion later this year or early next year.

As usual, there are also some smaller changes which are documented within the ‘Release History’ which can be accessed from within Twinfield, but the two new enhancements that I wanted to focus on here are:

  • Reimport failed bank statements
  • New BACS formats – BACS Standard 18 and Bankline

Re-import failed bank statements

If you are using Yodlee to automatically import your bank statements, you may have found that for one reason or another, your bank statement import has failed.  Yodlee has successfully extracted the bank statement data from your bank and sent it to Twinfield, but Twinfield rejected the import. 

The most common reason for this is that the accounting period does not exist.  For example, Friday was the first day of the new financial year, but the new financial year has not yet been created in Twinfield.  Today, Monday, you have arrived at work to find that Yodlee was unable to import Friday’s bank statement over the weekend (because the accounting period didn’t exist).

Another reason could be that you have just created a new bank account, but forgot to set the currency of the bank account.  You then linked Yodlee to the bank account, and the import of bank transactions failed.

Within the ‘Manage Feeds’ screen you can see that your Yodlee connection is valid.  The status says ‘Connected’ and the ‘Up to date as at’ date shows yesterday or today’s date:


But your bank statement does not appear in the electronic bank statement processing screen.

So the next place to check is the bank statement ‘History’ screen (the small ‘History’ button on the Cash and Banks screen).

Depending on the number of bank accounts you have, you may need to sort or filter the screen to find the bank statements for the respective bank account, but you will find something similar to the example below:


To find out why the bank statement import failed, click anywhere on the bank statement line:




To re-import the failed bank statements, resolve the root cause of the problem – which in this case is simply to open the September accounting period (but if you need assistance, please call our support desk), and then select ‘Manage Feeds’ and from the quick access menu on the right-hand side of the respective bank feed, select ‘Retry import of failed bank statement’:


This will display the following screen – which tells you the bank account you have selected and how many failed bank statements Twinfield will attempt to reimport:


After clicking the ‘Import’ button, re-visit the bank statement History screen, and you will see that the bank statements have now been successfully imported (or if they failed, you will see why they have failed a second time):


Our intention is to improve this functionality further and enable a user to reimport a failed bank statement from the history screen.  We will let you know when we add this functionality.


And just another note about the history screen, you will notice in the above screenshots, that only the failed bank statements have a hyper-linked ‘action’.  If the import was successful there isn’t a hyperlink because there is no error log to view.

The exception to this is when a bank statement is imported with a warning, and the most common example of this is when the accounting period for the respective transactions exists, but is closed:


Click on the bank statement line to view the warning:



New BACS formats – BACS Standard 18 and Bankline

As you may be aware, different banks have different file formats for uploading payment requests from software such as Twinfield to the banks’ internet banking or desktop banking software.

In July we released a new BACS format to enable Bank of Scotland users to upload payments directly from Twinfield, and this month we have released two more formats: BACS Standard 18 and Bankline.

BACS Standard 18 is used by a number of banks including Bank of Ireland and HSBC, and Bankline if the format used by members of the Bankline group – RBS, NatWest, and Coutts Private Banking.

These have been added to the drop-down menu listing BACS formats (within the Cash & Banks maintenance screen) as per below.


Please note that we still have the old NatWest format listed because we believe that some users may still be able to use this format.  But if you have been using the old NatWest format combined with our Excel macro-enabled BACS payment converter spreadsheet to convert the format to the Bankline format, you may now edit your bankbook settings and change the format to either Bankline or Royal Bank of Scotland (both options produce the same format BACS file).

We don’t yet support all BACS formats for all banks, so if you have a requirement for a particular BACS payment format, please let us know via your account manager or our support desk.



Monthly Twinfield webinars:

Just a quick reminder that on the penultimate Friday of every month we run a 60 minute webinar to demonstrate the new functionality released that month, and to answer any questions you might have.

Our August webinar was cancelled due to the delayed release of the software update, so in our next webinar we will cover both the September and August updates.

To register for the webinar, or any future webinars, please search for ‘webinar’ within the Twinfield knowledgebase.  This will provide links to the registration page for each webinar that we currently have scheduled as well as links to recordings of past webinars.


And as always, if you have any questions about this month’s software update, or Twinfield in general, please contact your account manager or call our software support team.



Richard McChesney
Product Manager for Twinfield in UK and Ireland.


| | Categories: Blog, Software Updates

August 2017 Software Update

This month we have made further improvements to Neo sales invoices, and have also upgraded the supplier list screen and improved our API.

As always, a full list of the changes can be found by clicking the ‘Release History’ button on the Twinfield home screen, but I have the main changes below:

New VAT Summary for Neo sales invoices and quotes

We have added a new VAT Summary section to sales invoices and quotes, which makes it clear to the customer how much VAT has been charged, and at what rate.

Previously, when you processed your Neo sales invoices and quotes, the VAT section of your document looked like this:


This told the customer that VAT was applicable at the reduced rate on an amount of £10.00 and at the standard rate on £100.00, but if more than one VAT rate was applicable the user had to calculate the total VAT content themselves, and the actual percentage rate was not displayed.

We now have a new VAT Summary section which appears to the left of the total section as per below:


The VAT Summary shows the VAT rate name (this is the short name for the applicable VAT rate), the percentage and both the VAT exclusive and VAT amounts, and there is now only one VAT line in the total section regardless of how many VAT rates are applicable to the invoice.

Please note:
If you have previously edited the short names of your VAT rates in order to show the applicable VAT percentages, you will now want to edit those short names to remove the percentages otherwise the above VAT summary will show the percentage as a part of the VAT name, and will repeat it in the VAT % column.
To edit VAT rate names, select Company Settings, VAT, and select the VAT code for which you want to rename the VAT rate. Click on the VAT rate and rename by typing a new ‘Short name’.


New Neo sales invoice discount section

When processing a sales invoice, you now have the ability to enter an invoice discount at the bottom of the invoice.


The drop-down menu on the right of the discount field enables you to switch between a discount percentage and a discount amount, and in both cases the discount percentage and amount are calculated to two decimal places and displayed, along with a new ‘Subtotal after discount’ line in the total section of the printed invoice, and are prorated against all lines (and VAT rates) on the invoice:



API for Neo Articles

Twinfield has an open API which enables software developers to link their software into Twinfield to both read from the Twinfield database and write to it.  The API is used by our TwinApp partners and also by many of our larger users who have developed their own portals for reporting purposes, for example. 

We have made plenty of improvements to Twinfield over the last two or three years, adding new tables to the database and new data entry screens for users, but have not kept the API up to date which means that software developers have not been able to link their software into some of the new Twinfield functionality.

The start of the improvements to the API has been to make the Neo Articles available, and over the coming months we will be making more Neo functionality accessible via the API – starting with customers and sales invoices.  Please watch this space.

Full details about the Twinfield API are available here.


New supplier list view

We have now brought the Neo supplier list screen into line with the customer and articles list screens which we updated in March.

As with the customer list screen, you can view 20 suppliers per page and can sort the list by clicking on the appropriate column header.  You can also filter your supplier list using the ‘Search’ field at the top of the screen:


| | Categories: Blog, News

Twinfield case study – Liberty Leasing

Alan Cooper, finance director at Liberty Leasing, recently took time out of his busy schedule to talk to us about his experience of selecting, implementing and using Twinfield Online Accounting software.

Liberty Leasing plc is an FCA-regulated asset finance company which provides asset finance to a selection of small and medium sized companies across the UK. The company’s compound annual growth rate of about 20% over the last five years took their loan book value to over £100 million in March 2017. As Alan says: “Twinfield has helped us in our growth… and it’s become clear that it’s going to be able to help us to grow much further into the future.” We’ll certainly do all we can to help Alan and Liberty Leasing!

Click here to find out how Twinfield could help your growing business  

If you’re an existing Twinfield user with a story to tell, we’d love to hear from you – call us or discuss with your account manager.