How to Set Off a Client / Supplier

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, while also having pending purchase invoices payable to the same entity acting as a supplier.

Instead of processing separate payments and receipts, the outstanding amounts can be matched and settled against each other through the Set Off process. This helps streamline account reconciliation, reduces unnecessary financial transactions, and ensures that both receivable and payable balances are updated accordingly.

To set off outstanding balances between a client and a supplier, follow the steps below.

Access the Set Off Screen

Navigate to: Current Year > Sales > Postings > Set Off



Process the Set Off

  1. In the Sales tab, select the required client. The client's outstanding transactions will be displayed in the section below.
  2. In the Purchases tab, select the corresponding supplier. The supplier's outstanding transactions will then be displayed in the section below.
  3. Review the outstanding transactions and select the entries that need to be set off.
  4. Press the Spacebar on your keyboard to mark the selected transactions for set-off.
  5. Verify that the total amount selected on the Sales side matches the total amount selected on the Purchases side. The set-off can only be processed when both amounts are equal.
  6. Once all required transactions have been selected, click the Print & Update icon to complete and process the set-off.

Permissions

If a user cannot access the Set Off function, ensure that the appropriate permissions have been assigned to their security group.

Verify the User's Security Group
  1. Navigate to Administration > User Accounts.
  2. Locate and open the relevant user account.
  3. Verify that the user is assigned to the correct security group.


Assign the ASETOFFS Permission
Once the user's security group has been identified:
  1. Navigate to Administration > Groups & Permissions.
  2. Open the security group assigned to the user.
  3. Under the Permissions Available for [Group Name] tab, search for ASETOFFS.
  4. Double-click ASETOFFS to assign the permission to the group.
    Important: If the ASETOFFS permission is not available in the list, proceed to the next section.


Verify Permission Settings
  1. Under the Permissions for [Group Name] tab, locate the ASETOFFS permission.
  2. Review all available permission settings associated with ASETOFFS.
  3. Ensure that all settings are enabled and set to True.
    Important: If any setting is configured as False, change it to True and save the changes before testing access again.

Additional Notes
  1. Permissions are assigned at the security group level, not directly to individual users.
  2. Any changes made to group permissions may require the user to log out and log back in before the new permissions take effect.
  3. If access issues persist after confirming the permissions above, verify that the user belongs to the correct security group and that all permission settings are enabled.
    • Related Articles

    • How do I display Client/Supplier Messages while Posting?

      Client/Supplier Display Messages while Posting SFM now provides an option to display messages to the user while posting entries at the Sales and Purchase Ledgers. The system provides a message to be display while posting sales/purchase documents and ...
    • How do I set a supplier's default payment type to SEPA?

      To set up a Supplier Payment Type, go to: Current Year > Purchases > Supplier Maintenance and select the supplier from the Suppliers tab. Next, click on the Supplier Details tab and then the Secondary Details sub-tab. Click the Edit option from the ...
    • 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 ...
    • How do I change a supplier's default payment type from SEPA to cheque or manual?

      To set up a Supplier Payment Type go to: Current Year > Purchases > Supplier Maintenance, and select the supplier from the Suppliers tab. Next, click on the Supplier Details tab and then Secondary Details sub-tab. Click on the Edit option from the ...
    • 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 ...
    • Recent Articles

    • 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 > ...
    • How to Delete a user on SIMS

      Note: We do not recommend deleting a user from SFM for audit and compliance purposes. Example: If you have a user with the initials JD (John Doe), and that user has previously submitted entries as shown below, deleting the user will remove the ...
    • 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