Set Up Rollup Transactions for use with Integrated Accounting Packages


This video explains how to set up and use rollup transactions when synchronising with an integrated accounts package. Step by step instructions can be found below the video.


When using rollup transactions, stock items on a sales order will be grouped into a single entry according to their VAT rate. This is particularly useful if you have a lot of stock items that would exceed the limitations of your accounts package. Before enabling this function you must have first created a stock item (with the relevant VAT rate and stock controlled option disabled) to represent your VAT rates within the integration, these will be mapped in the steps below. To enable Rollup:


  1. Go to [Accounts | Accounts Syncronisation].
  2. Click Edit.
  3. Enable the Use Rollup Transactions toggle.
  4. We would strongly recommend you also enable the Only Export Stock Items On Invoices toggle.
    1. This step is optional, however. if it is not enabled then KCC will attempt to create all of your stock items in Xero. If this exceeds the Xero limit, the integration will not work until these are removed.
  5. At the bottom of the screen set the Rollup Stock Item to be used for each tax rate.
    1. Please note: there should be two entries for each item, one for sales, and one for purchases.
  6. Click Save Xero.

Did you find this article helpful?