Xero Rapid Integration - Activity Sub-Totalling within a single GL code

Access: Payable Administrators

When several Kindo payable items are linked to the same XERO GL code - our integration will automatically sub-total all weekly payments received for these items into a single amount. This suits most users.

However sometimes the school needs to sub-total to a greater degree of detail and know how much was received for individual activities within a single revenue code. For example - Year 2 camp / Year 3 camp and Year 4 camp fees may all be coded to a single “Camp Fees” GL account within XERO - but the school may need to account for each Year Group camp separately.

Although this cannot currently be fully automated within the Kindo Xero Rapid  Integration – we can still recommend a workaround solution that will reduce the administrative time required to account at this level.

The best way for you to capture this additional level of detail is as follows:

Within Kindo Item Editor

Add a suffix to the XERO GL account linked to the Payable item.
(Suggest between 001 and 100 - but can be any numerical suffix up to 3 decimal places)

In the example above – If your GL code for Camp Fees is 1000.

Then each Payable item could be entered as:
Year 2 Camp GL Code 1000.001
Year 3 Camp GL Code 1000.002
Year 4 Camp GL Code 1000.003

The result of this is that within your weekly Payments summary report – these separate items will be sub-totalled per that unique account identifier.

     

When the Draft invoice is created in XERO using the Xero Rapid Integration

The Draft invoice lines will be populated with the appropriate descriptions of Year 2 Camp, Year 3 Camp and Year 4 Camp and the correct sub totals of $400, $1,000 and $1,650 respectively. However, the GL code field will be BLANK – as the numbers 1000.001, 1000.002 and 1000.003 are not valid GL numbers.

So the only manual task required for completion of the invoice before approval is the population of the correct GL code of 1000 on each line.

• Related Articles

• Kindo Payables and Xero Rapid Integration - Updated July 2024

  Improvement to our Rapid Xero Integration! Our Rapid Xero integration takes things one step further than other systems by automatically creating your Xero draft invoice with customised ledger codes at the click of a button. Don't spend hours coding ...

• What is Xero Rapid Integration with Kindo?

  Access: Payable Administrators While other systems have Xero integrations, this one is so quick, we’ve had to insert ‘rapid’ into the name! It outstrips others hands down – no matching, no batching – just click “Create Xero Invoice” and your Kindo ...

• Xero Rapid Integration - How to process a negative invoice

  Access: Payable Administrators The below steps outline how to process a negative invoice when using the Kindo Xero Rapid Integration function, where refunds exceed payments within a given weekly period. Our current Kindo Xero Rapid Integration ...

• Initial set up of Xero Rapid Integration

  Access: Payable Administrators You can request Xero Rapid Integration simply by emailing the helpdesk - helpdesk@kindo.co.nz Once we have set up the additional Xero pages, you will get a confirmation email and can begin the setting up process. You ...

• Kindo Payables and Xero Rapid Integration

  Access: Payable Administrators This page provides an overview of Kindo Payables and Xero Rapid Integration, including links to the relevant support pages for the initial set up of Xero Rapid Integration, creating a draft invoice for Xero, and viewing ...