Deposits of unallocated payments on accounts in the SFM VAT reports

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 ...
    • 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 ...