Sage 50 Accounting Integration

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

Required setup:

• Configurations>Accounting Configurations>Account Numbers>Accounting Export set to “API - Sage 50 UK”
• 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 Sage chart of accounts
• Tax codes mapped to Sage VAT codes. Configurations>Accounting Configurations>Tax Tables
• Configurations>Accounting Configurations>Multi-currency Currency codes mapped to Sage 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 Sage 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 Sage, the customer will also be exported.
• When a contract is closed on a cash customer, it will be exported to Sage 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 Sage as customer credits.

Payments and Credits entered in Sage

• When an Elite sourced credit is allocated to an invoice in Sage, 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 Sage and allocated to an Elite sourced Sales Invoice, the allocation will be imported into Elite and applied to the source contract.

Import Tool

Transactions and journal entries are imported into Sage using the Import Tool. Sage 50 cannot be open when an import is happening.

Make sure the appropriate company is selected if you have more than one. A list of tasks waiting to be imported will be visible. They will need to be processed one at a time

Select your task and choose ‘Run’. You will be prompted to log in.

Once imported, you will see a log of what occurred.