BookmarkBookmark this page!
Mar 4, 2024

Elite | Accounting Integrations




This article will go over available accounting integrations for Point of Rental's Elite program.


Topics in this article include

 



 

Accounting Methods

The Elite application is designed to support accrual accounting methods. Either Closed or Open accrual is supported fully. While a cash accounting method is available, some features are not supported: tax integrations, API compatibility, and sequential invoices.


Integration Methods

You can integrate your accounting software with Point of Rental Elite using the following methods:

  • PofR File Export (not a true integration) - This is a flat file that exports the same data provided by the API options. It is not specific to any accounting system. This file is used with an accounting system where an API is not supported but flat file imports are supported. Multiple modes of GL detail are available.
 
  • Accounting System File Export - This is a flat file export formatted to align with specific accounting systems. You can get a daily or monthly file (batch) with GL summary entries.
 
  • Direct Integration - This allows for an integration that sends data to your accounting system automatically. Multiple modes of GL detail are available.
 
  • API ↔  API Integration - Elite has accounting API endpoints available for a user to build their own, fully API based, integration. Multiple modes of GL detail are available. To learn more about Point of Rental’s Public API, follow this link: https://api.pointofrental.com/docs 



Accounting System File Export format

With the Accounting System File Export format, Elite can export your batch summary journal entries via email or file save, where they can be uploaded manually into your accounting software. Listed below are the formats that are compatible with the Accounting System File Export.
 

QuickBooks

Peachtree - Sage 50 US

Business Works

Computer Ease

Accountmate

Tech Systems

Sage AccPac

MS Dynamics

MAS 90/200 - Sage 100/300

Simply Accounting - Sage 50 Canada

QB Separate Stores

Xero

MYOB

QuickBooks Online

Acomba

Prophet 21

 

 



Direct Integration format

Elite has direct integrations with the accounting packages listed below. Elite can send and receive data directly to and from your accounting software. Your general ledger entries, invoices, payments, purchase orders, customer records, and vendor records can be updated. 
 

MS Dynamics GP

Intacct

Xero

Sage 50 UK

QuickBooks Online



Integration Modes

Warning! DO NOT change your Accounting Export mode WITHOUT full awareness of the impact it will have. For more information, please contact our Product Support Team.

There are three distinct types of accounting modes that can be used within Point of Rental's Elite: Batch, Realtime, and Transaction. Modes define the level of detail in the GL data.


Modes are applicable to:

  • Direct Integration
  • API ↔ API
  • PofR File Export 


Here are the differences between them:

 

Data Type

Batch GL Mode

Real-Time GL Mode

Transaction Mode

General Ledger

One batch GL summary is sent to the accounting system daily. This export will include the same line items seen on the Batch GL Report.

As contracts are processed, the resulting summary GL entries are sent to the accounting system.

GL data that is not related to contract processing is sent daily.

As contracts are processed, the resulting line-level detail GL entries are sent to the accounting system.

GL data that is not related to contract processing is sent daily.

Accounts Receivable

AR is done in POR.  This cannot be managed in the accounting system.

AR is done in POR.  This cannot be managed in the accounting system.

AR is done in the accounting system.  This cannot be managed in POR.

Transaction Level Detail is Sent

No. Only GL summaries.

Yes. Only summary GL detail at the contract level.

Yes. Transaction-level details for individual invoices are sent to the external accounting system.

Customers

No functionality.

No functionality.

If at the time of posting an invoice to the accounting system, the customer does not exist, it will be created to allow posting the AR transaction details.

Payments

All payments must be done in POR. 

All payments must be done in POR. 

Payments on reservations and open contracts can be made in POR.  

Payments on closed contracts must be done in the accounting system and sync with POR.

Vendors - specific data synced will vary by accounting system.

If payable is posted and vendor does not exist, the vendor will be created to allow posting the payable.

If payable is posted and vendor does not exist, the vendor will be created to allow posting the payable.

If payable is posted and vendor does not exist, the vendor will be created to allow posting the payable.

Purchase Orders

Purchase Orders are posted as a payable in the accounting system.

Purchase Orders are posted as a payable in the accounting system.

Purchase Orders are posted as a payable in the accounting system.

 

Batch Mode

Batch Mode uses a Direct Integration format where data is communicated once, daily. File Export and Batch Mode are similar. Accounting System File Export is a manual export/import process while Direct Integration is automated. File Export is typically set up to create the file daily or monthly.


Real-Time Mode

Real-Time Mode uses a Direct Integration format. Data is communicated in real time between Elite and the accounting system.


Transaction Mode

Transaction Mode uses a Direct Integration format. Detailed data can be communicated in real-time between Elite and the accounting system.


Available Integrations by Mode

The table below lists each accounting integration available for Elite by mode.

image.png

Related Articles