Using the Stock Statistics report to reconcile POS sales

Which report should be used to reconcile POS sales?

The Stock Statistics report should be used for reconciliations as it exports the sales data from all POS ID's linked to the particular location. Apart from showing the sales data from the POS machines, it is able to highlight the transactions performed on the Main System (MS).


To generate and export this type of report from your Shireburn Inventory Management System (SIMS):


1.    Go to Reports > Sales > Stock Statistics.




                          


2.    Filter the data by Location.


            a.    Browse to the Locations Tab.



             b.    Select the shop location to report for with the cursor...





             c.    ...and hit the Spacebar.


 



Only the row (Location) which is highlighted by a light blue colour will be reported. In the illustration shown above, DEMO SHOP - MOSTA will be reported.


3.    Generate the Stock Statistics report with the following options:



    


4.    Select Export and choose the desired format.







5.    Expected output: see attached.









    • Related Articles

    • How to issue a Daily Sales Reconciliation report

      To issue a Daily Sales Reconciliation report in SIMS, go to: SIMS > Reports > Sales Daily Sales Reconciliation If VAT Codes are needed to be shown in the same report, use the 'VAT TABLE' option as highlighted below:  

    • An overview of the e-Reports module in SFM

      The e-Reports module for SFM is an add-on solution that automates the distribution of statements from SFM to multiple clients via e-mail or print. The cost- and time-saving functionalities of the module give you the ability to send statements en-mass ...

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

    • How do I print sales transactions across different financial years?

      As from SFM Version 2.0.8.56, a user can print sales transactions across different financial year. The report to achieve this is called Transactions for All Accounts, and it is found in Current Year > Sales > Client's Reports > Transaction History ...

    • How can I print a Sales Ageing Report up to a given date?

      A user can print a Sales Ageing Report across different financial years. The report is called an Ageing History, and it is found in the Reporting list under the Sales and Purchases Ledgers. When this report is chosen, the user is given the print ...

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

    • SIMS - User Manual

      The attached PDF includes the necessary functions and features of SIMS to get you started. SIMS User Manual.pdf