1 / 101

Vehicle & Motor Carrier Services

Vehicle & Motor Carrier Services. Electronic Registration & Title (ERT). Required by Iowa Code 321.20(2) System being built by Iowa DOT IT staff Partnership Iowa DOT Iowa Automobile Dealer Association / individual dealers Iowa counties eDealer Services (EDS). ERT progress.

julier
Télécharger la présentation

Vehicle & Motor Carrier Services

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Vehicle & Motor Carrier Services

  2. Electronic Registration & Title (ERT) • Required by Iowa Code 321.20(2) • System being built by Iowa DOT IT staff • Partnership • Iowa DOT • Iowa Automobile Dealer Association / individual dealers • Iowa counties • eDealer Services (EDS)

  3. ERT progress • Pilot began on January 1, 2018 • Two dealers currently transacting • Statistics since launch: • Over 3,000 total transactions • Transactions in 77 counties

  4. ERT next steps • Monthly IT rollouts for bugs and enhancements • Adding additional new dealers – spring 2019 • County Edit – projected in 2019 • Adding all new dealers – 2019 • Adding Used Car transactions – projected in 2020

  5. VRT VPN Access: CheckPoint Migration • DOT is discontinuing the use of Pulse Secure • New Product Checkpoint • Complies with Windows 10 • More secure • Better uptime • Phased Rollout to the counties

  6. The purpose of today’s presentation is to show how to properly perform Monthly Consolidation, EFT, Daily Balancing and NSF. MVD – Accounting Procedures

  7. At the end of the day counties should reconcile and close out their cash drawers. Processes, reports and spreadsheets may vary from County to County. Daily Balancing

  8. Daily Reconciliation • Reconcile a cash drawer with physical assets to make sure the actual amount in the drawer matches the amount that ARTS has in the cash drawer • If the user detects an error when reconciling a cash drawer with physical assets, he/she should also reconcile with product totals • To reconcile: • Count the actual amount of each payment type in the cash drawer (cash, checks, etc). • On the Cash Drawer menu Click Activity Manager • The Activity Manager window appears.

  9. Daily Reconciliation • On the Cash Drawer list at the top of the window • Click the cash drawer the user wants to balance • Match the amount listed in the cash drawer to actual amount counted in the cash drawer. • Ensure the total amount is the same. • Match the exact amount of each payment type • Use the following resources to help the user: • Check report under cash drawer>Reports>check report • Statement inquiry report under cash drawer>inquiry>statement inquiry • Product transaction inquiry report under cash drawer>inquiry>product transaction inquiry • Product inquiry report under Finance > Inquiry > Product Inquiry • If the cash drawer balances, go directly to sweeping the cash drawer.

  10. Sweeping a Cash Drawer • Sweep a cash drawer to clear funds from it. • The user should reconcile the cash drawer before sweeping it. • Sweep the cash drawer only when open • Cash drawers can be swept to another cash/Vault drawer or to a bank account. • On the activity manager under Cash Drawer select the cash drawer to be balanced

  11. Sweeping a Cash Drawer • Click the Transfer/sweep tab • Click Load Detail. • The cash/check/pre-paid etc. amounts will appear. • Under Sweep Options • Click the drop down • Choose Vault

  12. Sweeping a Cash Drawer • Count each payment type • Verify the payment types match the amount listed in the cash drawer to the actual amount counted. • If it Balances click Save at the bottom of the screen. This will sweep the funds into the Vault. • Continue sweeping all drawers to the vault until all drawers are counted and swept. • Count each payment type in the Vault. • Once verified and balanced sweep all funds to the Bank.

  13. Sweeping a Cash Drawer • Transfer/Sweep to the Bank • Ensure the cash drawer listed at the top is the Vault. • Click Load Detail if the payment types aren’t showing. • Under Sweep to Account • Select the Bank listed in thedropdown • Click Save

  14. Congratulations! You have successfully completed Daily Balancing!

  15. IMPORTANT: Must be submitted to the Treasurer of the State by the 9th of each month (or the last working day before the 9th) so all moneys not retained for deposit by the counties are remitted to the Treasurer of the State by the 10th. Processes, reports and spreadsheets may vary from County to County. ARTS Month-End Consolidation Process

  16. Procedure for printing the Product Transaction Report On your ARTS toolbar select CASH DRAWER INQUIRY PRODUCT TRANSACTION INQUIRY 1 2 3

  17. Procedure for printing the Product Transaction Report • Enter From Date • Through Date • Click Search

  18. Procedure for printing the Product Transaction Report • The report will display • Click Print

  19. Special Note: Make Adjustments if Needed • If any hand adjustments were made to the daily product transaction report used for daily balancing, the same adjustments need to be made to the monthly product transaction report. Example-Adjusted Journal Entry or an NSF

  20. Procedure for printing the Product Inquiry Report On your ARTS toolbar select FINANCE INQUIRY PRODUCT INQUIRY 1 2 3

  21. Procedure for printing the Product Inquiry Report • Enter From Date • Through Date • Click Search

  22. Procedure for printing the Product Inquiry Report • The report will display • Click Print

  23. Special Note: Make Adjustments if Needed • If any hand adjustments were made to the daily product inquiry report used for daily balancing, the same adjustments need to be made to the monthly product inquiry report. Example-Adjusted Journal Entry or an NSF

  24. Procedure for Month End Consolidation Process On your ARTS toolbar select FINANCE CONSOLIDATION MONTH END CONSOLIDATION 1 2 3

  25. Procedure for Month End Consolidation Process • Assure the county’s account group shows. • Validate date range is for the month balancing/consolidating (grayed out)

  26. Special Note: Counties that process DL • Notice the total for DL retention is listed under the Account Group • Adjusted journal entry automatically done each month.

  27. Procedure for Month End Consolidation Process • Expand the Account Group - click on the plus sign (+)

  28. Procedure for Month End Consolidation Process • Select the county primary account group by clicking it once.

  29. Procedure for Month End Consolidation Process • Review displays both county and state totals broken out into product (associated GL account). • Click Review

  30. Procedure for Month End Consolidation Process • To review the revenue: • click on the plus sign (+) to expand each group or click print

  31. Review – Page 1 (Sample of primary account group review)

  32. Review – Page 2 (Sample of primary account group review)

  33. Review – Page 3 (Sample of primary account group review) Use totals from these reports to post to county’s spreadsheet to reconcile/balance to the month end in ARTS

  34. Procedure for Month End Consolidation Process • Preview displays both county and state totals broken out into each GL account (Parent Account) • Click Preview button.

  35. Procedure for Month End Consolidation Process • To review the revenue: • click on the plus sign (+) to expand each group or click print

  36. Preview – Page 1(Sample of primary account group Preview)

  37. Preview – Page 2 (Sample of primary account group Preview) Use totals from these reports to post to county’s spreadsheet to reconcile/balance to the month end in ARTS

  38. Procedure for Month End Consolidation Process • Once the Primary Account Group has been balanced • Go back to the main Month End Consolidation screen • Assure Primary Account Group is highlighted • Click on Consolidate

  39. Procedure for Month End Consolidation Process • Verify the total is still the same • Click Consolidate

  40. Procedure for Month End Consolidation Process • Click “Yes” to confirm – This will move your totals your to your account group

  41. Procedure for Month End Consolidation Process • On the main Month End Consolidation screen Primary Account Group line should be $0.00 • Totals should now be up at the Account Group Level

  42. Special Note: Open and Print Totals for Account Group: • Review • Displays both county and state totals broken out into each GL account (Parent Account). • Preview

  43. Procedure for Month End Consolidation Process • Print the Review level: • Ensure the Account Group line is highlighted • Click Review

  44. Procedure for Month End Consolidation Process • To review the revenue: • click on the plus sign (+) to expand each group or click print

  45. Review – Page 1(Sample of account group review)

  46. Review – Page 2 (Sample of account group review) Use totals from these reports to post to county’s spreadsheet to reconcile/balance to the month end in ARTS

  47. Special Note: Preview and Print Totals for Account Group: • Review • Preview • Displays only the totals that will be sent to the state, broken out into each GL account (Parent Account). • This total amount will be what the EFT request is.

  48. Procedure for Consolidation Process • To print the Preview level • Click Preview

  49. Procedure for Consolidation Process • To review the revenue: • click on the plus sign (+) to expand each group or click print

More Related