How to run a VAT return in SFM

How to Process a VAT Return

Accessing the VAT Table

The option to run a VAT return is available from Current Year Menu > Nominal > VAT Table, or from the VAT Shortcut Button.  If the VAT Return date is within your previous financial year, please run the return from Previous Year Menu > Nominal > VAT Table.



On selecting the above option, the system will take you straight into the VAT Table.  This table will display all the VAT entries since your last VAT return.  You can view the audit of all previous VAT returns by selecting the Vat Return Tab.



To re-print previous VAT returns, please visit this article.

Reporting VAT Entries

Before processing your VAT return, it is recommended to issue the required reports to fill in your VAT return.  The Summary Balances by Input/Output report can be issued from the Print Button, this report will show you the totals per VAT Code, however you can also use the Detailed Vat Report if you need more detail.



Info
The system does not print the form that you need to submit to the VAT Department; you need to use the official forms received.

Processing the VAT Return

To process (or archive) the VAT Return, click on the Vat Return Button  (or use keyboard shortcut CTRL + R).   On selecting this option, the system will display the following dialog box:



Annual Vat Account:  This is the account where the system will maintain the transactions of each of your VAT Returns.  Some users refer to this account as the VAT Liability Account.  This account should be set as a Balance Sheet Account and used only for VAT returns.  You cannot use the Vat Control Account when choosing the Annual VAT Account.

Enter Date Up to:  Enter the date of your VAT Return here up to which entries the system will process, not the date when you are submitting the return.  The system will pick up all the entries with a transactions date which is less or equal to this date.  All other transactions with a date which is greater will remain in the VAT Table ready to be processed in the next VAT Return.  For your information, the system will display the date you processed the last VAT Return.

Analysis Code (optional):  This will be used in the Journal Entry once the VAT Return is completed and is used to analyze further your transactions.

When ready, click OK.  The system will start processing the VAT Return.  During this process, the system will perform the following functions:
  1. Allocate the next VAT Return number.
  2. Archive all entries up to the specified VAT return date.  All the returns are available for re-print from the archive.
  3. Clear all entries from the Current VAT table.
  4. Automatically post the total amount of Output and the total amount of Input to the Annual VAT Account as entered above and post the contra entry into the VAT Control Account.
  5. Change the last VAT Return Date to the date entered above to prepare for the next return.
Info
It is important that you run the VAT return immediately when you fill in the VAT Department Form and submit the return.  In this way, you will remove the risk that users may back post into this VAT period and therefore change the period amounts.

Frequently Asked Questions

What happens if a backdated entry is Posted after the VAT Period has been closed?
The system fully supports this and will not stop users from posting into a closed VAT return unless the posting dates are set up accordingly.   Any new back dated entries will be automatically captured in the next VAT Return, and no entries will be skipped.   However, it is recommended to close the posting dates to stop users from posting into a closed VAT return. 

Does the system support Deposits which were not allocated (on account) in the VAT Return?
When issuing the Summary Balances by Input/Output report, an option to Include totals of Unallocated Payments can be switched on.  



All unallocated entries for the period should be listed in bottom part of the report.



Alert
Since these entries do not have a VAT Code tied to the transaction, they are listed separately at the bottom and do not have a 'VAT Amount'.  It is required to accrue for the VAT Amount element in these Deposits/Unallocated Payments.  We strongly suggest that you allocate any Unallocated Payments against Invoices where applicable.
    • Related Articles

    • How to do a Direct VAT Posting in SFM

      SFM let's you insert an entry directly in the VAT Control Account.  There are 2 different methods to do so. The Nominal Method Nominal Process - Go on Current Year > Nominal > Vat Table. - Click on Posting Button (Green button on Sidebar). - Here you ...
    • How do I Re-Print a Closed VAT return?

      SFM provides an option to re-print VAT reports for proceed VAT returns whenever required. When you run a VAT return on SFM, the system allocates a unique return number and archives all the transactions linked to this return number so all the ...
    • Cannot archive VAT Return due to unprocessed transactions in POS gateway

      Problem Archiving Vat return and not allowing user due to unprocessed transactions in POS gateway.  The POS Gateway has transactions that are not in SIMS, probably created in POS.  Environment POS Gateway in SIMS Solution Open SIMS. Go to Main > ...
    • How to generate a detailed VAT report in SIMS

      To generate a detailed report for VAT purposes, which includes specific dates and locations, follow these instructions below: Open SIMS and go to Reports > Daily Sales Analysis. Select the Detailed report option. Select the dates.  Select the ...
    • Does the system warn you if a VAT return is missed?

      Yes, on entering the VAT table screen, the system will display an information alert (shown below) if 38 days have passed from the last processed VAT return. N.B. Please note that this is just an information alert and that the system will not stop the ...
    • Recent Articles

    • How to Reverse a Sales/Purchases Transaction in SFM

      Reversing Entries in SFM Once users confirm an entry in SFM, they cannot modify any of its elements. The only available option is to reverse the entire transaction and re-post it with the correct values. The system supports both simple reversals and ...
    • Setting Up BOV SEPA v9

      Before proceeding, please ensure you are using the latest version of SFM. Starting October 5th, 2025, Bank of Valletta (BOV) will begin processing live transactions using the new SEPA file format (version 9). The older version 3 format will no longer ...
    • How do I process a Nominal Reconciliation?

      Procedure for Reconciling a Nominal Account (Current Year > Nominal > Nominal Reconciliation) Account Field: Select the relevant Nominal Account from the drop-down menu that you wish to reconcile. Details Field: Enter any necessary free text in the ...
    • How to Update SFS

      For optimal results, update SFS directly from the server. Important notes before updating: - All Users: Log out of SFS, SIMS and SFM (if applicable). - Remote Desktop Users: Log out of SFS, SIMS and SFM before disconnecting from the remote session. ...
    • How to Add Custom Footers per Client basis

      If you want to apply the same footer across all your invoices or the same footer across all your statements, please refer to this article: How to insert document footers in SFM If you need to use different footers for specific clients, SFM also ...
    • Popular Articles

    • How do I process an End Of Year in SFM?

      Overview SFM allows posting into two financial years simultaneously. This means that users do not need to finalise 2024 before starting to post entries into 2025. The end of year procedure will move the “Current Year” data into the "Previous Year". ...
    • Do I need to Process an End-of-Year in SIMS?

      SIMS does not require an end of year procedures to be run. However, SIMS controls users to only allow posting of transactions, such as sales invoices, cash sales, adjustments and purchases, within a range of dates referred to as the Posting Period. ...
    • How to setup a System Control Account in SFM? (Bank Account, Cash Account, Stock Control, etc...)

      Create the Account in your Chart of Accounts as seen below. Please make sure you use the code depending on your Heading and Sub-Heading digits. After creating the account, you need to specify the account as a System Control Account. Go to Support > ...
    • How to reset your Shireburn remote desktop service (RDS) account password

      The password for the Shireburn RDS Account used to connect to RDS server is set to expire after 90 days. A notification is provided to the user daily starting 5 days prior to the expiry date. In order to change password, the following steps need to ...
    • How to run the SIMS Archive process

      The SIMS Archive function reduces the size of the data store in Live by splitting the same data set in a different database, within the same company. This process improves the SIMS performance as it compacts the Live data set. Users can then access ...