Cash Focus

Downloads Guides & manuals FAQs

Cash Focus

v3.43

Download

 

Making Tax Digital for VAT – Grant Authority

Part of the process of getting ready for MTD involved granting authority to allow Business Manager to interact with HMRC.  This permission is only valid for 18 months so many of you will be coming up to the time when it needs renewing.

We recommend that you redo this by going to Setup – VAT – MTD Settings and then Connect to HMRC.  Log in using your Government Gateway login details and then Grant Authority. You will then be set for another 18 months. If you are submitting your VAT, please exit and reopen the program before closing the period. For more information please click here.

If you do not do this you may find that you receive an error message when you come to submit your MTD VAT figures that talks about ‘Refresh Token is invalid’ or ‘Missing data on current obligations’.

Grant Authority will sort this and allow you to make a successful submission.

 

Making Tax Digital for VAT.

Please note MTD submissions made after 1 October 2019 must be made using this software.

Submissions made from older versions may be rejected.

This version of the software incorporates mandatory anti-fraud updates required by HMRC for all MTD VAT submissions after 1 October 2019.

New users – For more information about Cash Focus read the Getting started and Enhancement guides. These can be found under the Guides & manuals tab. You will also find answers and useful information under the FAQs tab.

Existing users – For more information about this update please read the Enhancement guide carefully before updating. Before you start the installation process check that your licence is up to date and that you have taken a backup of your data. You will also need to make sure the program has been closed.

Windows 8 and Windows 10 operating systems only*

 *Please note – Windows 7 is no longer supported by Microsoft, meaning future versions of Cash Focus will not install onto Windows 7 machines.  Please contact Farmplan to discuss upgrading your PC if this is applicable.

Summary of changes

Version 3.43

  • Important changes have been made to the MTD VAT anti-fraud headers
  • Postponed VAT accounting option for Imports
  • We have added the Business Internet Banking file format that is required by CYBG which includes Clydesdale, Yorkshire and Virgin banks

Version 3.42

  • Help & Support – Updated Home Page including Online Chat button
  • Year on Year comparisons – compare up to 10 years of cashflow
  • North Herts Farmers – import your direct debits from NHF
  • Suppliers/Customers – date last used
  • Suppliers/Customers – bulk finish
  • Spreadsheet import – import journals from a csv file
  • Searchcodes – new report
  • Electronic banking – Handelsbanken Fast Payment and Citibank
Show summary of changes Hide summary of changes

Getting started guides

Enhancement guides

A getting started overview

Downloading your program

You can download your program from within the Support area of the website.

To view a video showing you how to download and install locally, click here.

For a document please click here.

Please note this process may vary depending on your setup, for example if you are installing on a network.

Creating a business (Video)

Heading codes (Video)

Transaction (video)

All Covid-19 information

Temporary VAT reduction on hospitality/holiday accommodation

From 15‌‌‌ ‌July 2020 until 31st March 2021, the UK government has changed the VAT from 20% to 5% on any eat-in or hot takeaway food and drinks from restaurants, cafes and pubs, excluding alcohol. This VAT reduction also applies to all holiday accommodation in hotels, B&Bs, campsites and caravan sites.

If this applies to your business remember to change the VAT status on any relevant transactions from S (20%) to S1 (5%).

For more information please click here.

Deferral of VAT payments due to coronavirus (COVID-19)

The VAT deferral scheme ended on the 30th June. Please click here for more information from HMRC.

Please note, although payments can be deferred you will still need to submit a VAT return as usual through your software.

AutoEntry

AutoEntry Export

Export to AutoEntry

 

AutoEntry Import

Export to AutoEntry

Backup

Restoring customer data (Third Party Backup) Video

Export to AutoEntry

Backup to accountant (Third Party Backup) Video

Export to AutoEntry

Restoring a backup

Click here for a printable document.

Sending data to my accountant

Third party web backup slots can be used to supply a backup of your data to an outside consultant/accountant who wishes to interrogate the data in their own version of Farmplan. For example, if your accountant wishes to have a copy of your data at the year end. His computer will have a different licence so he will not normally be able to see your backups.

Click here for a printable document which details the use of third party slots.

Backing up data

Click here for a printable document

To backup your data click ‘File’ then ‘Backup’. There are 3 tab options:

Local Backup

This allows you to backup your data either on your computer or a removable device such as a memory stick.

  1. On the left hand side of the screen check that the correct business is displayed
  2. On the right hand side of the screen browse to the desired backup location. To expand the tree view click on the +
    (to create more folders right click on the folder and select the option to create a new folder)
  3. Highlight the desired folder click Backup Now
  4. Enter notes if desired (a date and time will be automatically added) then click OK.

Rotation of Backups

Keep a minimum of 2 backups at different stages in time on different sources. We suggest making sub-folders and use them to rotate your backups.
NEVER just rely on one backup – for example a single memory stick, which could get lost or broken.

Private Web Backups

This is the ability to back up your data to a remote web server across the internet. The backup can be restored to any computer with internet access regardless of its location, (providing it has been registered with your licence details and web access code – subject to your Farmplan licence agreement).

A password provides additional security.

NB – Farmplan do not have access to the password. If it is forgotten Farmplan will be unable to help.

You are provided with ten free Private Web slots which are available providing your support contract is up to date. (More slots are available – for more details please contact Farmplan on 01594 545000)

  1. On the left hand side of the screen check that the correct business is displayed
  2. Select the tab called Private Web Backups
  3. Highlight the slot that you wish to use
  4. Password (optional) – Other users can only access your private backups if they are using a computer with exactly the same licence details. However, if you wish, you can also password protect your backups. Put a tick in the box ‘Use Password’ and enter the password in both boxes
  5. Click on Backup Now
  6. Enter notes if desired and click Confirm
    NB – You are transferring data across the Internet so the time taken to make a backup will depend on the size of your data and the speed of your Internet connection.

Other Web Backups

This tab allows you to make Web backups which are available to Farmplan Support staff or authorised third party consultants.

Support Slot – you are allocated ONE free Support slot which can only be accessed by yourself or a member of Farmplan staff.

If you contact us with a query, we may ask you to backup a copy of your data to this slot so that we can restore it for investigation.

  1. On the left hand side of the screen check that the correct business is displayed
  2. Select the tab called Other Web Backups
  3. Highlight the slot that you wish to use, the type should show as SUPPORT
  4. Password (optional) – Other users can only access your support backups if they are using a computer with exactly the same licence details – i.e other members of your organisation OR an employee of Farmplan. However, if you wish, you can also password protect your backups. Put a tick in the box ‘Use Password’ and enter the password in both boxes
  5. Click on Backup Now
  6. You may enter notes if desired. Don’t forget to tell any recipients the password if relevant

Third Party Slots – you are allocated ONE free Third Party slot which can be used to supply a backup of your data to an outside consultant/accountant who wishes to interrogate it , for example your accountant may wish to have a copy of your data at the year end. His computer will have a different licence so he will not normally be able to see your backups.

To use this system you would make a backup to a third party slot and provide your accountant/consultant with your customer number and a third party access code – supplied by Farmplan. The third party user enters these to restore your data. You can also use passwords for additional security.

Click here  for a printable document which details the use of third party slots.

NB – To speed up the backup process select Tools / Options / General and tick the ‘Minimise backup size’ box.

Data entry

VAT adjustment

Click here for a printable document.

Partial exemption VAT

Click here for a printable document.

Input VAT only entry

Click here for a printable document.

Domestic reverse charge VAT for building and construction services

Domestic reverse charge VAT is applicable to the construction industry and comes into force on 1st March 2021.

Click here for a printable document.

Entering a deduction (contra entry)

Farmplan allows you to quickly enter a ‘contra’ entry. This type of entry refers to Invoice or Cash Analysis entries where a deduction and sales are entered on one invoice, for example where wheat has been sold but as part of one invoice you also have weighbridge charges, Levy etc., where the customer is invoicing your business on your behalf.

In the below video a Cash Analysis receipt is being entered for a sale of wheat for £5,620 which is allocated to Wheat Sales, no VAT (Zero rated). There is also a second line on the same invoice for £120 for Levy charges. This figure is entered as -£100 and allocated to Commissions/Levies code and -£20 to the VAT code. The balance of the receipt (£5,500) will be shown in the Amount box and will be posted to the customer ledger for the customer, in this case A. Rable.

Export to AutoEntry

To enter a Cash Analysis Payment or Receipt:

  • Click on Cash Analysis
  •  Select Cash Analysis Payment or Receipt
    1. Customer/Supplier – Select the customer (or supplier) from the drop down list. Use the ? to enter a new one.
    2. Transaction Details – Enter the receipt details e.g. date paid, bank account, type (e.g. cheque or direct credit/debit) and the total amount that will affect your bank account.
    3. Coding – Allocate the items on the invoice by selecting a Heading code from the drop down list.
    4. Description – Make sure that you enter a meaningful description so that you or your accountant can identify this at a later date.
    5. VAT – The program knows the default VAT rate from the Heading Code selected. If the ‘S’ (Standard) code is selected the program will automatically calculate the VAT at the
    current rate. You can change this if required.
    6. Totals – You can enter as many different lines as you need. When the Total Amount at the bottom of the screen equals the Amount you entered at the top, you have
    completed this entry.
    7. Entry Number – The program will generate an Entry Number (top left of the screen). We recommend that you write this on the invoice so that you and your accountant can cross reference it to the computer.
    8. Data Entry Templates – This is a very useful tool available within the data entry options that will speed up data entry and allow you to be consistent with your coding for similar entries.

Fuel scale charge

Click here for a printable document.

Bank reconciliation (Video)

Export to AutoEntry

 

Hire purchase agreement

Click here for a printable document.

Missing automatic repeating transactions

If  automatic repeating transactions are not available for processing you will need to check the end date. if needed, this can be amended by clicking the ? under Edit from the repeating transactions screen.

VAT Payment from / Receipt to Revenue & Customs

Click here for a printable document.

Recording my subsidy money received in euros

Click here for a printable document on Foreign Currency Transactions

Cancelling an Inter Bank Transfer

If an Inter Bank Transfer has been entered in error we recommend that the amount is edited to zero.

NB It is possible to edit Inter Bank transfers at any time unless they have been ticked on the bank reconciliation.

Installation and logging on

Operating systems (Windows and Apple information)

All our desktop programs need to be installed within a Windows environment (Windows 8 and Windows 10).  Windows 7 is no longer supported by Microsoft, meaning you will not be able to install onto Windows 7 machines.

Apple hardware can be configured with Windows 10 Pro using Parallels Desktop. Click here for more information about Apple hardware or for information about our recommended computer spec click here.

Please contact Farmplan’s Hardware teams if you have any further queries on 01594 545022.

Licencing

Licencing your accounts software

Export to AutoEntry

Licencing Farmplan software

Your software can be licenced by going to File and selecting Licence.

You will be given a new screen where you will have your details entered. Providing your Web Access Code has been entered, you can click Get Key followed by Register. 

Your licence will then be updated. To allow Farmplan to update using this method you will need to be connected to the internet.

If you do not have a Web Access Code or internet connection please contact Farmplan.

Links

Import into the bank

A module is available which allows you to create payment files which can be imported into the following banks. (If your bank is not listed please contact software support for further information.) This can be accessed by going to Tools > Electronic Payments.

 

Making Tax Digital

Re-activate the connection for MTD VAT (grant authority)

There may be some instances where you will need to re-grant authority for your software to interact with HMRC, these include:

  • If you have moved to a new machine or done a Windows update
  • Renewing your authority due to only being valid for 18 months
  • You are receiving an error message that talks about ‘Refresh Token is Invalid’ or ‘Missing data on current obligations’

If any of the above apply please click here for more information.

Issues with HMRC that are affecting Making Tax Digital for VAT

Click here to check for information on availability and any issues affecting Making Tax Digital for VAT.

Signing up for Making Tax Digital with HMRC

Click here for some frequently asked questions about signing up for MTD with HMRC.

VAT submission

Click here for some frequently asked questions relating to making a VAT submission.

Combining figures before submitting to HMRC

Click here for some frequently asked questions about combining figures before submitting to HMRC.

Self Assessment for Income Tax

MTD for VAT is the first stage of a longer term view by HMRC to make all tax records digital and available to them.  This will be extended to include all income and expenditure details for income tax purposes.  Initially this was intended to be launched in 2020 but development is currently on hold while HMRC prepare for Brexit.

Potentially there will be 4 submissions a year with income and expenditure details followed by a 5th one at the year end with the accountant’s adjustments.  However, the full details are not yet known of exactly how this will be implemented.

Setting up MTD VAT (Video)

 

Export to AutoEntry

MTD submission (video)

You must ensure you have the correct VAT period selected for your business before submitting.

For more information please see additional videos.

Export to AutoEntry

Receipt Bank

Import from Receipt Bank

 

Export to AutoEntry

Export to Receipt Bank

Export to AutoEntry

Reports

Problems reconciling the bank

Click here for a printable document.

Reporting on a leap year

To allow your reports to run on the 29th February please go to Tools and Options and tick the option to Include 29th February.

Reports showing rows with no values or finished codes

If your reports are showing entries with no values and you would like to save paper and shorten the report you can change your settings.

To do this go to Tools then Options and select the Reporting tab. You will then need to select whether you wish to see rows with no values and finished codes or not, leaving them unticked means you are not seeing them.

Export a report/document

Click here for a printable document.

Change the order of the items inspector

Click the ‘Options’ button and select the desired order.

Full description on my audit reports

Click here for a printable document.

 

Setup

My program is showing Demonstration Data, how do I access my data?

If your program is showing Demonstration Data you will need to go to File > Select Business within the program and click the drop down arrow (shown below in red) and select your own business before pressing Ok. This will then take you into your business.

If your data is on a Network please ensure you have access to the data location from outside the program.

Creating a new business part way through the financial year

Click here for a printable document.

Opening a new financial year

Click here for a printable document

Year end

Year end process

The exact procedure at year end will differ for each business, however please see below for an overview along with some suggested reports.

  • New year – The new year can be opened before the previous one is closed. This is done in Setup > Open/Close Account Periods.
  • Period 13 – The last day of the financial year is referred to as Period 13, this is often used for accountants adjustments only.
  • Bank reconciliation – Ensure that all banks are fully reconciled.
  • Update date –Before sourcing reports for the completed financial year ensure that this date is set for the last day of the required financial year. This can be done by clicking the update icon from the homepage:or from the report library:
  • Year end reports – The reports that are required will vary between businesses however we suggest the following which are in Reports > Report Library:
  1. Audit Trails – Items Listing by Heading Code
  2. Audit Trails – Heading Code Items Audit
  3. Cashflow – Cash System Check – Detailed
  4. Banks – Reconciliation Report

Click here for a printable document which gives information about successfully completing a financial year-end.