Accounts Integration Mapping Tab


Accounts Integration is not enabled by default.
Training must be completed before using the accounts integration functionality.
Please email Development for more information.
Note: there will be additional costs involved if this option is enabled.


To access the Accounts Integration area, Display the drop-down 'Other Actions' menu either by pressing F9 or clicking the down arrow immediately to the right of the green circle with a white cross icon at the top of the button bar. It is where you setup and configure Khaos Control to work with your accounting package. The tab consists of the upper setup area and two lower grids:


Top Setup Area


ScrnXeroTopSetupArea.jpg
The top setup area consists of:

  • Nominals Defaults:
    • Default Purchase Nominals: The default nominal account to use for purchases.
    • Default Sales Nominals: The default nominal account to use for sales.
    • Prepayments: Used to indicate the prepayment account, which is used when exporting payments from Khaos Control.
    • Go to Xero button to connect your accounts package to Khaos Control: When connected to your external accounts package, will open the chart of accounts in that package.
    • Connection Status: Indicates whether or not you are connected to the external accounting system.
  • Options:
    • Only Export Stock on invoices: This option limits the stock items being exported to only those that appear on sales or purchase invoices, see How To: Configure Options When Setting Up Xero.
    • MultiCurrency: This option will send currency details against transactions, see How To: Configure Options When Setting Up Xero.
    • Use Rollup Transactions: This option allows for sales and purchase invoices to be exported without including multiple lines for each product, instead you can export based on one line per Tax Rate., see How To: Configure Options When Setting Up Xero.
    • Create Authorised Invoices: If ticked then invoices will be exported as Authorised.
    • Don't Export Payments: Stops prepayments from sales orders from exporting from Khaos Control to the external system.
    • Sales Other Ref Mapping: Where "Other Ref" are used against sales invoices in your external system, this option can control which value from Khaos Control goes to the other reference.
      • SOrder Code
      • Associated Ref
      • Customer PO Ref
      • Ass Ref / PO Ref
      • SOrder Code / PO Ref
    • Export Invoice Type: Allows the control of whether Sales and\/or Purchase invoices export.
      • Sales and Purchase Invoices
      • Only Sales Invoices
      • Only Purchase Invoices
    • Exclude Sales Sources: Stops certain sales invoices from exporting, for example if you did not want to send Amazon orders to your accounts package (because they were already there from some other source), then you could use this option to control that. The checkbox option depends on the sales sources setup in your system.

Map your Khaos Control Nominals to your Account Package Nominals


ScrnXeroNominalsMapping.JPG


  • KC Nominal Account: The Khaos Control nominal code.
  • External Nominal Account: The external system`s nominal code that is mapped to the Khaos Control nominal account.

Map your Khaos Control tax codes to your Account Package tax codes


ScrnXeroTaxCodeMapping.jpg


  • KC Tax Code: F4 lookup. Used to select the Khaos Control tax code to be mapped to the equivalent tax code in the external accounting package (when using Rollup Transactions) see How To: Configure Options When Setting Up Xero.
  • External Tax Code: F4 lookup. Used to select the tax code in the external accounting package to be mapped to the equivalent Khaos Control tax code (when using Rollup Transactions)see How To: Configure Options When Setting Up Xero.
  • Sales (or Purchase): Used to select whether the tax code is to be used for sales or purchase transactions.
  • Rollup Stock Items:
  • SP Ledger Stock Item:
    • Code: the code of the non-stock controlled item in Khaos Control used to represent the tax rate. See How To: Configure Options When Setting Up Xero.
    • Description: the description of the non-stock controlled item in Khaos Control used to represent the tax rate. See How To: Configure Options When Setting Up Xero.
      Note : these are only used if you intend to make S/P Ledger entries in Khaos Control, which is not recommended when integrating with an external accounts package.


See Also


Did you find this article helpful?