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 > Purchases > Supplier Maintenance for suppliers.
Before you begin, it is important to note that from the time the data is exported to Excel and then imported into SFM, no changes should be carried out on the entity details from SFM directly.
Exporting Entity Details in SFM
- In SFM, go to: Current Year > Sales > Client Maintenance. (Or Current Year > Purchases > Supplier Maintenance for suppliers.)
- When the grid opens, select the Printer icon - you can find it in the left-hand icon list.
- In the Printer menu, go to Exports > Export Client Details.
- The Clients Export List modal will open. Under the 'Export Options' section, select 'Export client details in import template format' and press Export. (If you are exporting suppliers, the modal and option are labelled with 'Suppliers' instead of 'Clients'.)
- Save the import template to your preferred location (ex Desktop).
You can now open the template and edit it as needed.
Importing Entity Details in SFM
- Make sure the template you want to import into SFM is saved on your desktop and closed.
- In SFM, go to Current Year > Sales > Client Maintenance. (Or Current Year > Purchases > Supplier Maintenance for suppliers.)
- When the grid opens, press the Excel button at the end of the left-hand tool list, followed by Import details option.
- A confirmation message will ask 'Are you sure you want to Import Clients details?', click Yes to continue.
- Select the Excel template from the desktop and click Open.
The grid will update with the information you added to the Excel template.
Related Articles
Import Entity Gateway in SFM
The Shireburn Financial Manager (SFM) provides facilities to allow interfacing of third-party applications for the posting of entity data into SFM. The system supports XML, Excel and comma delimited Text (.CSV ) formats. The Entity Importation ...How to create a Supplier Account in SFM
To create a Supplier account on SFM: Go to Current Year > Purchases > Supplier Maintenance. Press on the plus (+) sign on the top left of the screen. This will take you to the Supplier Details tab. In the Details sub-tab, input the details for the ...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 to create a Client Account in SFM
To create a Client account on SFM: Go to Current Year > Sales > Client Maintenance. Once the Client Maintenance window is open, press on the plus (+) sign on the top left of the screen. This will take you to the Client Details tab. In the Details ...Error: "Allocation in Progress for Entity" when allocating entries in SFM
Problem Error: "Allocation in Progress for Entity" when posting an allocation. Environment SFM Purchase or Sales Unallocated Entries Solution Go to Client (Current Year > Sales > Client Maintenance ) or Supplier (Current Year > Purchases > Supplier ...
Recent Articles
How to print a Remittance Advice
How to print out a Remittance Advice from SFM: Supplier > Print button > Remittance Advice Select the Reference number* of the selected Range of Payments to print out the Remittance. *Import - Fixed Assets
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 the Fixed Assets. Attached are the template and ...How to generate the INTRASTAT Report
SIMS supports the INTRASTAT module, which is available as a separate add-on. If you are interested in activating this module, please contact us at sales@shireburn.com. Updating Items with INTRASTAT Details Navigate to Main Menu > Purchases > Receipt ...Sending Remittances in Bulk using e-Reports
To send outstanding remittance advices in bulk, follow these steps: Navigate to the Remittance Advices Section Go to: - Current Year > Sepa > Sepa Maintenance - Sepa Tab (on top) - Highlight Sepa - Print > Remittance Open the e-Reports Module In the ...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 ...
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 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