💻
UNOSOF MANUAL
User Guidelines EN
User Guidelines EN
  • UNOSOF MANUAL
  • TAXONOMY DEFINITIONS
    • Products
      • Species
      • Varieties
      • Non-Real Varieties
    • Bunches
      • Solid Bunches
      • Rainbows
      • Bouquets
    • Boxes
      • Solid Boxes
      • Mixed / Assorted Boxes
      • Bouquet Boxes
      • Consumer Box
    • Product Definitions
      • Farm Products
      • Importer
    • Floricode
      • Floricode Schema
        • f_products
        • f_genus
    • Farm Workflow
    • Cultivation Management
    • Additional sources
  • Accounting
    • Account Transactions
      • Make Deposits
        • Commission Management
      • Retention
      • View Deposits
        • Move Unapplied Deposit Values
    • Accounting Administration
      • Company Info
      • Account info
      • Inventory Info
      • Holland Info
      • Sales Info
      • Consumer Invoices
      • Statements
      • Truck Invoices
      • Bouqueteria
      • Remote
      • Provides IDs
      • Bruto Variables
      • Sales Definitions
      • Flor de Baja
      • Alianza API
      • Projections
    • SRI Electronic Transfer
      • Invoices / Guia / Credits / Debits
        • SRI Generate/Sign/Send
        • Pre-Authorization Modifications
        • AWB Weights
        • Zip SRI Invoices
        • Email SRI Invoices
        • Invoices Used Outside UNOSOF
        • Unused (Skipped) Invoices
        • SRI Report (Check Post vs. Generated)
      • SRI Cases
      • SRI Status Comprobation
      • SRI Documents Annulment
      • SRI Blocking Messages
    • Workforce Managment
      • Manage Employees
      • Manage Departments
      • Daily Timecard
    • Accounts Management
      • Chart of Accounts
      • Manage Accounts
  • Customers
    • Customer Info
      • Customer Account Overview
        • Statement PDF Formats
        • Set Default Statements Message
      • Manage Customers
        • View Customers
        • Create a customer
          • Customer Form // Customer Info Tab
          • Customer Form // Contact Info Tab
          • Customer Form //Addresses
          • Customer Form // Accounting Tab
          • Customer Form Invoicing
          • Coface
          • Api Providers
          • Refresh Billing Customer Table and Customer Credit
        • Manage Customer Tips
      • Manage Markets
    • Customer Service
      • Email Multiple Invoices
      • Search Invoices
      • Rollback Customer Invoice
      • Send Statements
      • Manage Invoice Footers
      • Customer Credits
    • Fair Trade Management
      • Reporting
      • Invoice Format
      • Recommendations
  • Sales
    • Search Purchase Orders
      • Mass Change PO Date
      • PO's Color Codes
      • Minimum Pricing Check
      • Create PO Page Group
      • Priority Packing // Box Confirmation
      • Mass Swap Module
    • Purchase Order
      • Sales Practical Tips
      • Create a Purchase Order (V-next
        • Edit Boxes
      • Create a Purchase Order
        • Edit Boxes
        • Move boxes
        • Delete Purchase Orders
        • Box Labels
    • Invoice Purchase Order
      • Invoice Cases
    • Availability Builder
      • Create New Dispo
      • Modify pricing and box #
      • View Dispo
      • Send or Post Dispo
    • Standing Orders
      • Create Standing Orders
      • Modify Standing Orders
    • Supermarket Order Generation
    • Returned Boxes
    • Customer Mass Invoice
    • Mass Rollback Orders
    • Transfer PO
    • MIAMI
      • Delete boxes in MIAMI application
  • Pricing
    • Upload Customer Pricing
    • Upload Minimum Pricing
    • Incoterm Pricing
  • Exportations
    • LAG Integrations
    • Airway Bills
      • Commercial and Customer Invoice Mass Print Options
        • Exportation documents for Colombia
        • Exportation Documents Ethipia
    • O.E / DAE
    • Incoterms
      • Incoterm Freight By Box
    • Drivers
    • Manage Boxes
    • Cargo Agencies
    • Truck Companies
    • Truck Invoice
  • Dashboards
    • Sales Dashboard
  • Post Harvest
    • Station 1: Harvest Receiving
      • View Post Harvest Receiving
      • Field Plan Cutter Management
    • Station 2: Inventory Packing
      • View Inventory Packing List
      • Consumer Bunches
        • Generate Consumer Bunches
        • View Consumer Bunches
        • Assign Consumer Bunches
    • Station 3: Inventory Shipping
      • Scan Bunches into a Box
      • Auto-Pack Function
      • Unpack Boxes
      • Mass Print Box Labels
      • Bouquet Station 3
    • Station 4: Weight & Boxtype
    • Station 5: Truck Invoice
      • Return Box Module
    • Defections: Flor National
  • Inventory
    • Inventory Variables
    • View Inventory
      • Reading the Inventory
    • Future Availability
      • Projections
      • Future Availability Management Settings
      • Future Availability Sheets
      • Future Availability Reports
    • Inventory Management
      • Inventory Shoot
      • Inventory Prefrío Shoot
    • Inventory Packaging Boxes Scan
    • Manage Transfers Bunches
    • Manage Transfers Mallas
    • Mixed Box Management
      • Mix Box Management // create mix box
      • Mix Box Management // Recipe Management
      • Mix Box Management // S3 - Mix Box packing
      • Mix Box Management // Fix Problems
    • Exit Inventory
      • View Inventory Exits
    • Reprocess Inventory
      • Flor de Baja management
      • Manage Reprocess Inventory
      • S2 Process Downgraded Inventory
      • Report Reprocessing Inventory
    • Inventory Priority
      • Inventory Priority List
      • Priority Management
    • Post Harvest Practical Tips:
    • Box Inventory
    • Inventory Hotroom
      • Manage Hotroom
      • Hotroom Entrance
      • Hotroom Exit
  • Remote Inventory Management
  • Purchases
    • Purchases
  • Production
    • Production Management
      • Manage Products
        • Create SKU's GYP
        • Manage Product Api Mappings
    • Production Data
      • Double Life Cycle Bunches
      • Product Inventory Life
      • Daily Input Page
  • Bouquetteria
    • Bouquet Product Management
  • Reports
    • Reports
    • Production reports
    • Warehouse Reports
    • Accounting Reports
      • Customer Behaviour
      • Last Payment / Balance
      • Customer Account Review (Method)
      • Compare Reports for Multi-App Companies
        • Accounting Cases / Compare Reports for Deposits
        • Accounting cases / Compare Invoices
  • SITE MANAGER
    • Manage Locations
      • Create a New Warehouse
      • Maintain the Field Plan
      • Mass Edit Beds with Excel
    • Users
    • Users Permissions
    • Select Options
  • System Administration
    • Properties
    • Synch data
  • Vendors
    • Vendors
    • Manage Vendors
    • Requisition of Material
      • Search Purchase Requests
    • Vendor Purchase Orders
      • Search Vendor Orders
    • Order Receiving
      • View Order Receiving
    • Consignment
      • Consignment Cases
  • Alianza Logistik
    • Alianza Logistika API
    • Alianza Box Label Configuration
  • Integrations (API)
    • FreshPortal
    • Migros
    • UNOSOF API's
    • Accounting Migration Files
      • Venture
    • Cut Flower Trader (CFT)
      • Inventory Posting
      • Order Creation
    • Delaware Valley
    • Komet Sales
      • Integration Requirements
      • Load Orders from Komet to Unosof
      • Upload Stand Alone Orders | Open Market Box Inventory
      • Sunburst Farms Integration
      • Upload Bunch Inventory to Komet
    • FTD
    • Blumen Gali
    • Shopify
  • Hardware & Network & Infrastructure
    • How to Setup - PRINTER
    • How to Setup - Scale
    • Hardware Requirements
    • Network & Infrastructure Requirements
    • Tips, Optimize Network & Infrastructure.
Powered by GitBook
On this page
  • 1. PO page // Commission as "Tax".
  • 2. Apply Commission via Trading Company
  • 3. DB // Auto-apply Commission Rate
  • 4. PDF Customer Invoice // Auto-apply Commission

Was this helpful?

  1. Accounting
  2. Account Transactions
  3. Make Deposits

Commission Management

This article describes how you can apply commissions to the invoices sent to customers.

PreviousMake DepositsNextRetention

Last updated 2 years ago

Was this helpful?

Unosof is able to manage commissions applied to invoices through different methods. Its important to understand which method fits the best to your organization, based on your financial structure and needs. The explanation we give about each method, is not only to show you how things work, but above all, to show what are the pro's & con's, and to help you to make select a method that answers WHY the specific choice you made is your perfect solution. We have described 4 options, in order to pick up knowledge about this topic from different angles and points of view.

1. PO page // Commission as "Tax".

We can use the column called “TAX” on the as a Commission. This solution would allow to have the value of the flower separated from the commission %. That results that the sales values of the flowers and commission, will be separated in the sales reports. However, this idea was discarded because of two important reasons: a) We do not want to declare to the SRI, a commission as a tax. We would have to program a rule around this to make the value appear in the SRI form as a commission, and not as tax. b) Commissions are not getting paid by the customer, therefor declaring these PO/Invoice values as a sale would also be a mistake. Why declaring a 1000 dollars got sold if you get paid 900? Therefor we have to program a rule in the SRI form to only declare the PO/invoice value (900).

PROS
CONS

Sales Reports exclude Commissions.

SRI Invoice does not match with commercial and customer invoice. (unless you do declare the full amount, including the commission towards the SRI).

Customer Statement Account Reports exclude Commissions.

Costfull solution. - Unosof development rate.

Deposits applications exclude Commissions.

Customer invoice includes Commissions.

2. Apply Commission via Trading Company

Establish a Financial Trading Company. That could be just a (off-shore) bank account where you do collections with and/or be a real company outside of the country (better and cleaner option). This Financial Trading Company, has its own separated, isolated, environment (the application has is own address and its own database). Via this structure its possible to emit a secondary (and real) customer invoice with, which includes the commission values.

In order words, if the commission is 5%, via the farm application we declare USD 100,- (SRI, Commercial invoice and Customer invoice), and via the trading company USD 105,- (Customer invoice).

PROS
CONS

Farm app, excludes commissions.

Cost-full solution. - Unosof development fee - Unosof suscription fee - AWS fee

Trading app, include commissions.

Adds complexity to the financial structure, managing multiple applications requieres synch modules.

Clean sales reports, clean statements, clean deposit page, clean invoice values, everything is simply well organized.

This is already been build by UNOSOF, but still needs to be configured, setup etc.

3. DB // Auto-apply Commission Rate

PROS
CONS

As the commission rates are applied automatically, for sales representatives, this is an easy way to sell and invoice.

The entire application will show all the values including the commission rates, anywhere. - SRI, Commercial Invoice, Customer Invoices, Reports etc.

Costfull solution. - Unosof development fee.

4. PDF Customer Invoice // Auto-apply Commission

We can generate the customer invoice, the PDF itself, the PDF ONLY(!), with a commission % being included. As these commission rates get not stored via the DB (PO-, Invoice-, report values etc), and as we only SHOW this on the PDF, all the values in the system will get shown without the commission fee.

PROS
CONS

All values in the system will be shown without commission rates.

Invoices, Statements, Credits, will match with the payments (deposits).

You don't declare commission fees as invoiced towards the SRI.

This is already been build, applied, and working in UNOSOF.

The percentage commission to be entered in the camp called Commission %. For instance, in the picture above we see the client will be charged a 5% commission on top of the total value of the order.

We could modify PO values automatically at the time of creating the invoice. In other words, sales enter the normal price on the and when the invoice is created, the system will apply automatically the additional given commission fee being set via manage customers, for example 5%. The sales representative can sell a Freedom 50cm for USD 0.40, and after invoicing this rate would change to USD 0.42 (incl. the 5% commission rate). As the client will pay you USD 0.40 , the commissions will need to be applied via the deposit page as a cost.

If the user decides to opt for method 4, the commission percentage has to be set in the camp Commission % in .

creation po page
PO page
Tax column in our PO page
Manage Customers // Accounting
Manage Customers