Release Date: 02 July 2020
Summary
As the Prism Finance module records all expense detail by horse, owner and date, and keeps that data as an historical account of charges, there is often little need to replicate the volume of data in Xero.
Furthermore, the default behaviour of our Prism to Xero integration is to create invoices in Xero unique to each owner and horse in a given Statement period. Customers typically will pay one amount per period to pay all horse invoices on their Statement. Accounts receivable administrators often need to select multiple invoices in Xero when reconciling owner payments.
To reduce the volume of data in Xero and to improve the reconciliation of customer payments to invoices, we have released a new feature where you can choose to consolidate invoices and/or invoice lines in Xero. In this article we explain the current Prism to Xero Invoice integration, and three new options you may elect to implement.
Current Prism to Xero Invoice creation
This example below shows how the integration creates invoices in Xero now.
Customers typically will pay one amount per period to pay all horse invoices on their Statement. Accounts receivable administrators often need to select multiple invoices in Xero (three in the abvoe example) when reconciling owner payments, adding time to the reconciliation task.
Option 2: Consolidate invoice lines by Account and Tax Rate
You can now choose to consolidate invoice lines in Xero by Account and Tax Rate, but retain unique customer invoices by horse.
Consider this example below.
Benefits > Reduce the volume of data in Xero. Improve Xero system performance.
To reconcile a customer payment with this option, you still need to select all relevant invoices (three in this example above).
Option 3: Consolidate invoices into one Xero invoice, and consolidate invoice lines by Description, Account & Tax Rate
To even further reduce data in Xero, you can now choose to consolidate invoices in Xero and consolidate invoice lines by Description, Account and Tax Rate.
Consider this example below. All invoices for an owner in a given Statement period are consolidated in one invoice in Xero, with the Xero Invoice Number matching the Prism Statement ID. But invoice lines (expense lines in Prism) are still itemised.
As the Xero Invoice Number matches the Prism Statement ID, the customer reconciliation process is greatly improved, provided your customers add the Statement ID as a payment reference.
Benefits > Reduce the volume of data in Xero. Improve Xero system performance. Reduce time required to reconcile customer payments.
Option 4: Consolidate invoices into one Xero invoice, and consolidate invoice lines by Account & Tax Rate
To take advantage of any invocie consolidation options above, please contact
support@prism.horse to request which option you desire. Please specify exactly the option you wish to implement, including the text description of the option.
Option 2: Consolidate invoice lines by Account and Tax Rate
Option 3: Consolidate invoices into one Xero invoice, and consolidate invoice lines by Description, Account & Tax Rate
Option 4: Consolidate invoices into one Xero invoice, and consolidate invoice lines by Account & Tax Rate