Follow

ID901 - Unmapped Accounts for Financial Benchmark Reporting Overview & Sample

List of Unmapped accounts needed for ID900/Financial Model

Overview | Samples | Variables | Alert Functionality | Best Practices & Tips |  Related Alerts | Task App

Click to Subscribe 

Overview

Overview

Provides list of un-mapped accounts needed for your ID900 Series Financial Benchmark Reporting. 

These un-mapped accounts are important to identify whether you're using the report monthly or just preparing for your annual dealer group reporting requirement. It is much easier to manage these un-mapped accounts monthly as new transactions and accounts are created so you don't have to try to remember (and potentially fix) a transaction from 9-months ago.

We provide details so you can see department and/or accounts and who/when they were created. 

Run Schedule: Weekly - Monday's AM

Type of Output: Email and Task App

 

*  *  *

Sample

Sample

ID901Sample.PNG

 Sorted by Financial Model, then Account Number, then Department Number

*  *  *

Variables

Variables

ID901Variables.PNG

Variable1: Years (Accounting Periods, not calendar years) back to include (required). Set number of years alert to look back for unmapped activity,  Max is 3 years

Variable2: Enter Financial Model(s) to report for (SBA2019, NLI2018) - if left blank, then defaults to Financial Model you've already mapped accounts to in ID909:

ID901VarExplanation.PNG

 

 

*  *  *

Alert Functionality

Alert Functionality

-Alert shows DR/CR (debit/credit) which is the Total Acct/Dept activity per Variable1. If the transactions net is zero, then Acct/Dept will NOT show. If you see $0.00 in DR/CR column, then the net is pennies (less than $1.00). 

-Provides list of un-mapped accounts needed for your ID900/Financial Performance Benchmark SSRS Report

These un-mapped details can be seen on your ID909/Monthly Financials SSRS Report OR ID910/Financial Model Account Allocations SSRS Report:

ID909 best for recent unmapped accounts:

ID909Unmapped.PNG

ID910 best for historical unmapped acounts:

ID910Unmapped.PNG

 

*  *  *

 

Best Practices & Tips

Best Practices & Tips

Use this alert in order to address month to month issues all year round instead of being one big chore 1x per year. It also enables you to correct your process right away rather than having to go back to correct a year's worth of entries.

 

 

*  *  *

Related Alerts

Related Alerts

ID900 Series - Financial Benchmark Reporting

 

*  *  * 

Task App

Task App

Please see THIS LINK for review.

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