Download - The New Ledger Reviewer
![Page 1: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/1.jpg)
The New Ledger Reviewer The New Ledger Reviewer
Presented by:Minerva NelsonPresented by:
Minerva Nelson
![Page 2: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/2.jpg)
Why Replace Ledger Annotator and Reviewer?
Why Replace Ledger Annotator and Reviewer?
• For improved data integrity
• To handle large numbers of simultaneous users and sets of data
• To allow for additional functionality in search and results screens
• For improved data integrity
• To handle large numbers of simultaneous users and sets of data
• To allow for additional functionality in search and results screens
![Page 3: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/3.jpg)
How will this impact you?How will this impact you?
• The New Ledger Reviewer will replace the current Annotator and Reviewer to provide one application for your reconciliation needs.
• Users will need to launch all enpets from this new application.
• The New Ledger Reviewer will replace the current Annotator and Reviewer to provide one application for your reconciliation needs.
• Users will need to launch all enpets from this new application.
![Page 4: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/4.jpg)
New Ledger Reviewer AdvantagesNew Ledger Reviewer Advantages
• Provides a sound and defensible reconciliation process.
• Recommended tool for SAS 112 Compliance.• Tracks error types and error rates - providing
departments with statistical information which may alert them to problem areas.
• Allows for different methods of reconciliation.• Reconciliation available daily, weekly or monthly.
• Provides a sound and defensible reconciliation process.
• Recommended tool for SAS 112 Compliance.• Tracks error types and error rates - providing
departments with statistical information which may alert them to problem areas.
• Allows for different methods of reconciliation.• Reconciliation available daily, weekly or monthly.
![Page 5: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/5.jpg)
Other FinancialLink Tools To Consider
Other FinancialLink Tools To Consider
• Projects• Overdraft Profile System• Index copy screen
- Warnacct (E & W)- Tracking costs via sub index- EII (Early Index Inactivation)
• Projects• Overdraft Profile System• Index copy screen
- Warnacct (E & W)- Tracking costs via sub index- EII (Early Index Inactivation)
![Page 6: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/6.jpg)
NavigationNavigation
![Page 7: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/7.jpg)
NavigationNavigation
![Page 8: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/8.jpg)
NavigationNavigation
Will many people access?
Group id’s are specifically ownedby one department. Once you leave
or transfer to a new department, do not continue to use.
![Page 9: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/9.jpg)
New Selection Screen - full viewNew Selection Screen - full view
![Page 10: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/10.jpg)
Selection Screen - top viewSelection Screen - top view
![Page 11: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/11.jpg)
Ledger Reviewer -IFOP LookupLedger Reviewer -IFOP Lookup
![Page 12: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/12.jpg)
Ledger Reviewer - Project LookupLedger Reviewer - Project Lookup
![Page 13: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/13.jpg)
Status & Stop QueryStatus & Stop Query
![Page 14: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/14.jpg)
New Selection Screen - view options
New Selection Screen - view options
Display max rows = 41Unchecked = 14 rows
![Page 15: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/15.jpg)
View Options - pagingView Options - paging
Unchecked = 14 rows
![Page 16: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/16.jpg)
View Options - max rowsView Options - max rows
Checked = 41 rows
![Page 17: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/17.jpg)
New Selection Screen - view options Db/Cr Indicators
New Selection Screen - view options Db/Cr Indicators
![Page 18: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/18.jpg)
Results screen - Db/Cr Indicators
Results screen - Db/Cr Indicators
![Page 19: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/19.jpg)
New Selection Screen - view options E&W
New Selection Screen - view options E&W
![Page 20: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/20.jpg)
Error and Warning Code ValidationError and Warning Code Validation
![Page 21: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/21.jpg)
100% Reconciliation100% Reconciliation
• New feature allows users to view transactions that have not been reconciled.
• What is the difference between the “OK” and the check box?
• New feature provides check off history.
• New feature allows users to view transactions that have not been reconciled.
• What is the difference between the “OK” and the check box?
• New feature provides check off history.
![Page 22: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/22.jpg)
New Selection Screen - 100% Reconciliation
New Selection Screen - 100% Reconciliation
![Page 23: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/23.jpg)
Review Process - 100%Review Process - 100%
![Page 24: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/24.jpg)
Review Process - 100%Review Process - 100%
Items marked as “OK” have disappeared and items marked
with problem codes remain
![Page 25: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/25.jpg)
Selection Screen - 100% checked only
Selection Screen - 100% checked only
![Page 26: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/26.jpg)
Result Screen - 100% checked only
Result Screen - 100% checked only
CHK is an internal control feature for departments
![Page 27: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/27.jpg)
Check off HistoryCheck off History
![Page 28: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/28.jpg)
Transaction Sampling Reconciliation
Transaction Sampling Reconciliation
• Sampled transactions now appear with an S icon in a column named Sampled.• Sorting capability on items that
have been sampled.• Sampling profiles run at ledger
close.
• Sampled transactions now appear with an S icon in a column named Sampled.• Sorting capability on items that
have been sampled.• Sampling profiles run at ledger
close.
![Page 29: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/29.jpg)
Selection Screen - Transaction Sampling
Selection Screen - Transaction Sampling
![Page 30: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/30.jpg)
Results Screen - SampledResults Screen - Sampled
![Page 31: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/31.jpg)
Selection Screen - Transaction Sampling
Selection Screen - Transaction Sampling
Not checked
![Page 32: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/32.jpg)
Results Screen - View all SampledResults Screen - View all Sampled
![Page 33: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/33.jpg)
Enpets Enpets
• Enpet’d transactions now appear with a pink check mark in a column labeled with a check mark.• Sorting capability on items that have
been enpet.• Using the enpet “check all” feature
with paging.
• Enpet’d transactions now appear with a pink check mark in a column labeled with a check mark.• Sorting capability on items that have
been enpet.• Using the enpet “check all” feature
with paging.
![Page 34: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/34.jpg)
Displaying enpets within the Ledger Reviewer
Displaying enpets within the Ledger Reviewer
![Page 35: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/35.jpg)
Sorting enpets within the Ledger Reviewer
Sorting enpets within the Ledger Reviewer
![Page 36: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/36.jpg)
Enpet - WarningEnpet - Warning
![Page 37: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/37.jpg)
Enpet - Check AllEnpet - Check All
Once user selects Enpet All
they still need to launch enpet
![Page 38: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/38.jpg)
EnpetsEnpets
** All items that are enpet should be assigned a problem code.
** This includes any previous items that have already been marked as “OK”.
![Page 39: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/39.jpg)
Review Process - Enhancements
Review Process - Enhancements
• New ** warning to save.• New drill down feature on
account code.• Add a note for action taken.• New mouse over functionality on
many items.
• New ** warning to save.• New drill down feature on
account code.• Add a note for action taken.• New mouse over functionality on
many items.
![Page 40: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/40.jpg)
Assigning Problem Codes & Saving
![Page 41: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/41.jpg)
Account Code detail
![Page 42: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/42.jpg)
Adding a NoteAdding a Note
![Page 43: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/43.jpg)
Review - mouse over functionality
![Page 44: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/44.jpg)
Assigning Problem CodesAssigning Problem Codes• If the charge is allowable, allocable,
reasonable and the amount is correct, it is OK.• If the charge is on the wrong index or fund the
problem code would be: INDEX/FUND.• If the account code is incorrect the: WRONG
ACCT problem code should be used.• INCOMP DOC should be used if there is no
drill down available and the proper paper back up cannot be found.
• If the transaction has occurred outside the project period for the fund/award use: EXP DATE.
• If the charge is allowable, allocable, reasonable and the amount is correct, it is OK.
• If the charge is on the wrong index or fund the problem code would be: INDEX/FUND.
• If the account code is incorrect the: WRONG ACCT problem code should be used.
• INCOMP DOC should be used if there is no drill down available and the proper paper back up cannot be found.
• If the transaction has occurred outside the project period for the fund/award use: EXP DATE.
![Page 45: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/45.jpg)
Assigning Problem Codes Cont….Assigning Problem Codes Cont….
• The KEY ENTRY problem code is for other errors that appear to be due to data entry mistakes.
• SALES TAX should be used when sales tax is incorrect in any way, amount, application etc.
• EMF-PEND code used by EMF (OPAFS) to indicate a follow up with a department.
• JUSTIFICATI can be used by either OPAFS or the department when there is an inadequate explanation on a transaction.
• VENDOR ERR can be used when a mistake has been made by the vendor that needs to be corrected.
• The KEY ENTRY problem code is for other errors that appear to be due to data entry mistakes.
• SALES TAX should be used when sales tax is incorrect in any way, amount, application etc.
• EMF-PEND code used by EMF (OPAFS) to indicate a follow up with a department.
• JUSTIFICATI can be used by either OPAFS or the department when there is an inadequate explanation on a transaction.
• VENDOR ERR can be used when a mistake has been made by the vendor that needs to be corrected.
![Page 46: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/46.jpg)
Correction ProcessCorrection Process
• Once the problem codes have been saved the correction process can begin.
• After the transaction is correct the problem code should be changed to OK.
• One transaction can have multiple problem codes assigned.
• Once the problem codes have been saved the correction process can begin.
• After the transaction is correct the problem code should be changed to OK.
• One transaction can have multiple problem codes assigned.
![Page 47: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/47.jpg)
Problem Code History BoxProblem Code History Box
• History box shows the userid(s) that assigned the problem code(s).
• For items that are sampled with a global profile, the history box will initially display the userid for Debbie Rico or Lyle Kafader.
• History box shows the userid(s) that assigned the problem code(s).
• For items that are sampled with a global profile, the history box will initially display the userid for Debbie Rico or Lyle Kafader.
![Page 48: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/48.jpg)
History box - SampledHistory box - Sampled
![Page 49: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/49.jpg)
Custom FindsCustom Finds
• Ledger Reviewer allows for the “custom find” of many types of transactions.
• Users can pull up all Express card transactions by using a specific IFOPAL or Project and rule class combination.
• Users can use this approach for many other types of transactions (marketplace orders, account code, description, etc.)
• Ledger Reviewer allows for the “custom find” of many types of transactions.
• Users can pull up all Express card transactions by using a specific IFOPAL or Project and rule class combination.
• Users can use this approach for many other types of transactions (marketplace orders, account code, description, etc.)
![Page 50: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/50.jpg)
Custom Find - Express CardsCustom Find - Express Cards
Rule classRule classXXCD = Express card transactionsXXCD = Express card transactionsXCRD = Express card use taxXCRD = Express card use tax
![Page 51: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/51.jpg)
Result of Custom find - Express Cards
Result of Custom find - Express Cards
![Page 52: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/52.jpg)
Custom Find - MarketplaceCustom Find - Marketplace
![Page 53: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/53.jpg)
Result of Custom find - Marketplace
Result of Custom find - Marketplace
All PO’s via theNew Marketplace
begin with doc number 9
![Page 54: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/54.jpg)
Custom Find - DescriptionCustom Find - Description
![Page 55: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/55.jpg)
Result of Custom find - Description
Result of Custom find - Description
![Page 56: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/56.jpg)
Helpful HintsHelpful Hints
• Save often• Always use the Return to Query
Form button• Users should always check
previous months to make sure prior problem codes are corrected and changed to OK
• Save often• Always use the Return to Query
Form button• Users should always check
previous months to make sure prior problem codes are corrected and changed to OK
![Page 57: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/57.jpg)
Blink CastBlink Cast
• Other helpful video podcasts on Blink for fund managers• Transaction Sampling• Transaction Sampling Management Report• CCM• My Funds• Projections
• Other helpful video podcasts on Blink for fund managers• Transaction Sampling• Transaction Sampling Management Report• CCM• My Funds• Projections
![Page 58: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/58.jpg)
Thank youfor your interest in
The New Ledger
Reviewer
Thank youfor your interest in
The New Ledger
Reviewer
![Page 59: The New Ledger Reviewer](https://reader036.vdocuments.us/reader036/viewer/2022062801/568143c3550346895db0517c/html5/thumbnails/59.jpg)
Questions? Questions?