The pasTransfer ETL tool has the ability to consume a wide variety of data sources from the OnQ application suite using a variety of custom sources located in the Ledger Wizard.  This data can then be easily transformed, aggregated, mapped, and exported to a wide range of destination systems (including back office ledger and BI tools).
 
We commonly integrate with the following types of OnQ reports:

• Accounting Report
• Management Report
• Detailed Receivables Recap
• AR Aging Detail
• Occupancy Analysis Report

Typical integrations use some permutation of the above reports.
 
Benefits
There are many benefits associated using pasTransfer to integrate with OnQ but here are some of our biggest benefits:

1. Saves Time! One of the biggest benefits with this integration is the time saved from daily data entry tasks. Timely journal entry preparation is completely eliminated. Instead of manually entering the data from the daily reports, our integration extracts the data from the reports and makes it available for upload to destination systems.
    
2. Fully Automated! With the use of our pasTransfer application a lot of the manual day to day operations become fully automated. For example, suppose you want to take the data from one of the daily OnQ reports such as the Accounting Report and input this data into another destination ledger system. pasTransfer has the ability to take the data from the source report, manipulate/transform the data so that it is readable by the destination system, and send this data straight to the destination system within minutes!
    
3. Mapping! As expected, there may be account codes used in your OnQ reports such as codes from the Management report that aren’t valid account codes in your destination system. With the use of our pasPortal/Excel mapping options, you can use a sheet to map each source account code in the report to a valid account code in the destination system so that it posts correctly.  

How it Works & What to Expect

pasTransfer works directly in conjunction with other products in the pasUNITY Enterprise Suite to fully automate the OnQ integrations. There are many options as to how the report gets exported from OnQ and processed by pasTransfer. A few of the common delivery methods we offer are receiving reports through FTP, email, direct upload to the matrix or even dropping the OnQ reports in a specific folder on the server for processing. We also provide an audit trail that shows exactly what data was processed in the destination system which is useful for compliance purposes.

In closing, integrating with OnQ can be extremely useful to any company (regardless of size) who deal with report/data generation for multiple properties on a daily basis. pasTransfer can help to improve both time and efficiency on normal reporting related OnQ tasks.