SIMS: 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:
Related Articles
How to Import and Export Data Through Excel
Importing and Exporting Data Using Excel Exporting Data Using Excel You can export data to Excel as follows: Navigate to: Support > Stock Cards. Right-click the blue box button in the top-left corner of the data grid, near the column headers. Select ...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 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. ...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 ...
Recent Articles
SFM: How to Issue a Credit Note
A Credit Note can be used to reverse an invoice that has been posted incorrectly in SFM. This allows you to adjust or cancel the original transaction while maintaining a complete audit trail. Creating a Credit Note To create a Credit Note, navigate ...How to generate a Report by Transaction Type and Analysis Code
Generating a Report by Transaction Type in SIMS Navigate to SIMS > Reports > Miscellaneous > Analysis Code. From this screen, select the desired Transaction Type to apply as a filter. If a summarized version of the report is required, tick the ...How to Set Off a Client / Supplier
The Set Off functionality in SFM allows you to offset outstanding balances between a client and a supplier when the same entity exists in both roles. This feature is particularly useful when a company has pending sales invoices due from a client, ...Exporting or Importing Documents in Windows App
Using the Correct Redirected Path When connected through the AVD Windows app, you must export or import files using the redirected drives. Internal AVD paths (such as C:\Users or Desktop inside the session) do not allow saving and will cause ...How to Activate Advanced Commission
Advanced Commission Overview The Advanced Commission feature provides the ability to customize commission settings for all salespersons within the system. Enabling Salesperson Commission To activate this functionality, navigate to: SIMS > Admin > ...
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 2025 before starting to post entries into 2026. 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 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 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 > ...SIMS - User Manual
The attached PDF includes the necessary functions and features of SIMS to get you started. SIMS User Manual.pdf