How to import details into SFS using Excel

Importing details into the system using Excel

To import details into the system from Excel, you must first generate a template with the column names. This can be done by right-clicking the small blue box at the top-left corner of the grid you wish to populate and pressing the Generate Microsoft Excel Template option.














When all the information is filled in, you can now import the data into the system. To do this, right-click on the small blue box at the top-left corner of the relevant grid and this time choose the Import from Microsoft Excel option. 




You will then be prompted to choose the file.




The chosen file (e.g. ToImport.xlsx) will then be opened so that you can verify that the correct file was chosen. To finalise the import, click on OK when the following message box appears: 




Should the Excel file contain any errors, the system will open up the file you were trying to import (e.g. ToImport.xlsx), mark each line containing an error in red and display an extra column with the error message related to that particular line.







    • Related Articles

    • How to Export or Import Entity Details in SFM

      In this article, you will learn about exporting and importing entity details into SFM. The process is the same for both client entities and supplier entities. Remember to access Current Year > Sales > Client Maintenance for clients, and Current Year ...
    • Import Gateway - Transactions

      The Shireburn Financial Manager (SFM) provides facilities to allow the importing of accounting data from third-party applications and/or your own work sheets into SFM. The options include the import of Nominal, Sales and Purchase transactions. ...
    • Creating and Updating Contracted Prices in SIMS using Excel

      Creating New Contacted Prices Scenario 1: Adding a new contracted price for an existing client Go to Support > Clients and choose the client. Click on the Contracted Prices tab. Press + or 'Insert' on the keyboard. Enter the stock code and choose a ...
    • How can I import a stock-take (physical quantities)?

      Depending on your setup, there are a number of different ways to import physical quantities during a SIMS stock-take: Import from Initialise To manually import a stock take, click on Import from Initialise and select Import All. Enter the Store ...
    • How to import and export data through Excel

      You can export data to Excel by going to Support > Stock cards and right-clicking the blue box button in the top-left corner of the data grid (near the column headers). Then navigate to Export to Microsoft Excel and select the required fields (note ...
    • 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 ...