Follow

ID36 - NMI Data in Power BI

ID669 is our Online Payments process, ID36 helps track payments that have not deposited. NMI is the "Gateway" we use to connect to all the payment processors. We designed ID669 so that our clients could recover credit card fees but also easily switch payment processors, as they have a habit of increasing rates after you sign. We recommend you avoid signing a long contract; we can switch you to a different processor with just a few hours' notice. ID734 shows you transaction information from NMI so you can see your actual cost per transaction by processor.

Soon we will offer the option to have us create the deposit in eAuto, however there will still be payments that fail or ACH accounts that need to be "whitelisted".

-See here for getting Power BI in place. 

-Click here to download the file

On the landing page notice that there are 2 refresh dates:  
1. The last time that the process hit the NMI API to grab the data ( this is running on an hourly basis ) 
2. The last time the report was refreshed ( this is up to the dealer to set as many refreshes per day based on the Power BI licensing scheme. Ex. PBI Pro will allow up to 8 refreshes per day ) 
ID36 one.png

 General functionalities:
1. Filtering: Filters may be accessed by clicking on the top right corner in every report page (  filters may vary depending on the context of each report page )

ID36 two.png

ID36 three.png

2. Report Pages

Transactions Pending Settlement

ID36 four.png

  • - Qty of Transactions & Amount Pending Settlement broken down by: Sales Date, Company - Detailed table of all related transactions

Failed Transactions Actions
ID36 five.png

  • - Detailed list of all failed actions during the selected reporting period

 

All transactions Actions
ID36 six.png

- Detailed list of all transactions / actions during the selected reporting period

D. Sales Transactions

ID36 seven.png

- Qty and Amounts for all sales transactions within the selected reporting period broken down by Company, Date, Rolling Days, Week, Rolling Weeks, Month, Rolling Months
- Detailed List of all Sale transactions within the reporting period 


E. Settlements
ID36 eight.png

- Qty of settlements, Settled Amount, Average Days to settle down by Company, Date, Rolling Days, Week, Rolling Weeks, Month, Rolling Months & Transaction Type
- Detailed List of all settlement transactions within the reporting period 


F. Daily Summary
ID36 nine.png
Detailed matrix of Sales, Settlements, Check Return & Check Late Returns by Date and time 
Ability to drill-through and see all the related details
ID36 ten.png

ID36 eleven.png
G. NMI summary

ID36 twelve.png
- This is an overview report showing:
>> Transactions pending Settlement
>> Sales, settlements, Average days to settle trends for the selected reporting period


H. Cash Book – Undeposited Funds
ID36 thirteen.png
- In this report you can easily match all payment / cash book references to the related Invoices within e-Auto
>> Top table shows for every reference the amount and the quantity of related invoices
>> Select any reference and see related invoices details in the bottom table

ID36 fourteen.png

- In this report you can easily match all payment / cash book references to the related Invoices within e-Auto
>> Top table shows for every reference the amount and the quantity of related invoices
>> Select any reference and see related invoices details in the bottom table
 

I. Check late Returns ( Not Voided in EA )

ID36 20.png
Use the toggle button above the Receipts table to filter between Receipts that have or not been voided in EA
Action List  table will display all check late returns, Invoice Info table will display all related invoices


J. Sales & Recovered Fees

ID36 21.png

- Sales & recovered fees broken down by Company, Date, Rolling Days, Week, Rolling Weeks, Month, Rolling Months & Processor
- Detailed transactions showing Sales amount and recovered Fees


3. Drill-through to detail pages: Right click on tables to get all the available drilling through options ( Bank Account Details, Credit Card Details, Transaction Details, Company details )
ID36 22.png
A. Bank Account Details
ID36 23.png
B. Credit Card Details

ID36 24.png

C. Transaction details

ID36 25.png

D. Company Details

ID36 26.png
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk