This accounting integration allows for the interactive upload of accounting information from Point of Rental to Xero. This integration is only available for Elite systems.

Required setup:

• Configurations>Accounting Configurations>Account Numbers>Accounting Export set to “API - Xero”
• Account Numbers>Settings>Export Mode set to “Transaction”

• Create a single “generic” Cash customer record in Elite and populate the customer number on the API configuration screen(Settings)
• Account numbers mapped to Xero chart of accounts
• Tax codes mapped to Xero codes. Configurations>Accounting Configurations>Tax Tables>Accounting Code
• Configurations>Accounting Configurations>Multi-currency Currency codes mapped to Xero currency codes
• Closed accrual accounting
• Adjustments must be turned on for Save Closed Account & Cash Modifications System Configurations>Parameters>Accounting Tab

Functionality specific to “Transaction” Mode

Counter System

• When a contract is closed on an account customer, it will be exported to Xero as a Sales Invoice (SI) on that same customer’s account.
• If any amount of the contract was paid prior to closing, the Sales Invoice created in Sage will be credited for that amount.
• If payment is made on the contract at the time of closing in Elite, that payment will be exported as a separate payment and applied to the contract.
• When the first contract for a customer is exported to Xero, the customer will also be exported.
• When a contract is closed on a cash customer, it will be exported to Xero as a Sales Invoice on the internal Cash Customer account.
• This customer is the one whose customer number is configured on the API Setup screen.

Account Payments

• Payments and credits can be applied to open contracts.
• Payments and credits cannot be applied to completed contracts
• Credits created from account payments will be exported to Xero as customer credits.

Payments and Credits entered in Xero

• When an Elite sourced credit is allocated to an invoice in Xero, the allocation will be imported back into Elite. Both the source credit contract and the account contract will be updated accordingly.
• When a customer payment is entered in Xero and allocated to an Elite sourced Sales Invoice, the allocation will be imported into Elite and applied to the source contract.  The reference number will be visible in the payment history.

Purchase Orders

• When a purchase order has all of the relevant invoice information, it can be exported using the AP Export Tool. Purchase Orders>Options>Export to AP
• It will then be available in the Import tool to import into Xero
• The invoice number will be written to the reference field in Xero and the purchase order number will be the bill number

Import Tool

Transactions and journal entries are imported into Sage using the Import Tool. Customer and Vendor changes (Name, address, phone number, email, contact name, website, and credit limit) made in Point of Rental will also appear here for import.

Select your task and choose ‘Run’. Once imported, you will see a log of what happened.