Reconciles the dealerships financier listing to accounting schedule.
Extra data in the report will include the first and last recorded transactions dates, and vehicle status. This in turn will aid the user to identify errors.
The report shows the balance of each floorplan account in the DMS, enabling the user to pick accounting errors at a glance.
Last section will include a reconciliation control and account totals. Control account balances are derived from the data and will equal the balances in the user's DMS.
The report will include three sections:
|•||Standard Reconciliation, only identify the missing balance, problems and/or differences in floorplan.|
|•||Full Detailed Reconciliation, listing all vehicles that have an outstanding balance in any floorplan account and are outstanding on the financier's listing.|
|•||Potential Overdues Report, to pick up vehicles that may not have been paid out. The report lists all the vehicles in delivered and sold vehicles that still have an outstanding floorplan liability, sorted by date.|
Reconciles the dealerships stock listing to accounting schedule.
An example of schedule reports that can be reconciled include inventory (New and Used), Claims, Holdback and/or Used Vehicle GST.
In the reconciliation process extra data is pulled out of the system and added to the report. This data can include vehicle status, location and/or sold date. For holdback and claims the data can be model type, status, received date, delivered date, and deal number. The extra data can be customised to the needs of the user.
|•||The data is sorted and separated by vehicle status. This allows the user to easily identify accounting errors.|
|•||The first section of the report are entries that should have cleared or are errors. For example delivered vehicles and other entries that shouldn't be in the accounting schedule such as entries processed to an incorrect control.|
|•||The last section of the report will be vehicles in the system but without any accounting.|
Last row shows column totals, so that the report user is able to control account balances.
QT Statement Converter
Processes and converts a dealership's daily 'QT Account Statement' so that it can be automatically uploaded as a complete journal entry into one's DMS.
Some Dealership Management Systems allow complete journal entries in 'Comma-Separated Values' (CSV) format to be uploaded with just a few clicks of a button.
The QT Statement Converter makes use of this possibility by loading the QT Account Statement, processing it as much as automatically possible and then converting into a CSV file ready for uploading into your DMS. The major noticeable advantage of this is to:
|•||Speed up daily processing, and|
|•||Reduce human error|
Extra Control Measures
Control measures are in place to make sure that the journal entry stays correct. For example, the entry must balance and amounts are locked for editing. The application will also not allow the user to continue if an account number or required control is missing.
Once the journal entry is complete, it will be converted into a CSV file ready for the user to upload into the DMS.
Reynolds and Reynolds, ERA DMS Users
Note: For dealerships using Reynolds and Reynolds, ERA DMS, the executables required to upload CSV files are 0293 and 0291.