Deposits Unallocated payments on account in the SFM VAT reports
Can I get the current amount of deposits/unallocated payments on accounts in SFM VAT reports?
Answer: From version 2.0.10.24 of SFM, you have the option to include the unallocated payments in the VAT report. The option to run a VAT Unallocated Payments Report is available from the VAT Table. This can be accessed from the Main Menu > Current Year > Nominal > VAT Table.
The unallocated payments can be found on two reports available in the Print Menu (CTRL + P).
These are the Summary Balances by Input/Output and the Unallocated Payments.
Summary Balances by Input/Output Report
In this report, you will find the summary of all the Input & Output amounts with the corresponding VAT value according to the VAT code used and the Unallocated Payments Totals, if selected.
The Unallocated Payments Totals in this report can be turned on in the printing window by ticking the Include totals of Unallocated Payments.
When this option is ticked, the system will print the Unallocated Payments Totals Summary for the Sales & Purchases. This will be printed at the end of the report.
Unallocated Payments Report
This report will provides more detailed analyses and will show a list of client/suppliers with their unallocated amounts. These will be split in two pages, one for the Sales transactions and the second page for the Purchases transactions, where applicable. For more detailed analyses of the individual client/supplier transactions, please print the Unallocated Transactions report from the Sales/Purchase Ledgers Reporting function.
VAT on Cash Accounting Only
For SFM companies set on Cash Basis (Cash Accounting), partial allocation of Receipts/Payments is not allowed.
When posting a partial Payment / Receipt against an invoice, the user will be presented with the following error:
Partial Payments/Receipts will need to be posted on account, and when the remaining amount is posted, these can be allocated against the invoice so to update the VAT Reports.
Reports from the Archive will be available from this version onwards.
Please note that companies which are on this mode of accounting should have the wording Cash Accounting on their invoices. For help in setting up the additional text on the invoices, kindly follow this article.
Related Articles
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 ...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 ...How do I allocate unallocated entries in SFM?
SFM has a tool (available both in the sales and purchase ledger) that cycles through all the entities that have unallocated entries and enables you to allocate them. Below are instructions on how this is done.Cannot archive VAT Return due to unprocessed transactions in SFM gateway
Problem Archiving VAT return and not allowing user due to unprocessed transactions in SFM gateway. The SFM Gateway has transactions that are pending import. Environment SFM Gateway in SFM. Solution Open SFM. Go to Current Year > Utilities > Import ...
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 ...