the new ledger reviewer

The New Ledger Reviewer The New Ledger Reviewer

Presented by:Minerva NelsonPresented by:

Minerva Nelson

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

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.

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.

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)

NavigationNavigation

NavigationNavigation

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.

New Selection Screen - full viewNew Selection Screen - full view

Selection Screen - top viewSelection Screen - top view

Ledger Reviewer -IFOP LookupLedger Reviewer -IFOP Lookup

Ledger Reviewer - Project LookupLedger Reviewer - Project Lookup

Status & Stop QueryStatus & Stop Query

New Selection Screen - view options

New Selection Screen - view options

Display max rows = 41Unchecked = 14 rows

View Options - pagingView Options - paging

Unchecked = 14 rows

View Options - max rowsView Options - max rows

Checked = 41 rows

New Selection Screen - view options Db/Cr Indicators

New Selection Screen - view options Db/Cr Indicators

Results screen - Db/Cr Indicators

Results screen - Db/Cr Indicators

New Selection Screen - view options E&W

New Selection Screen - view options E&W

Error and Warning Code ValidationError and Warning Code Validation

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.

New Selection Screen - 100% Reconciliation

New Selection Screen - 100% Reconciliation

Review Process - 100%Review Process - 100%

Review Process - 100%Review Process - 100%

Items marked as “OK” have disappeared and items marked

with problem codes remain

Selection Screen - 100% checked only

Selection Screen - 100% checked only

Result Screen - 100% checked only

Result Screen - 100% checked only

CHK is an internal control feature for departments

Check off HistoryCheck off History

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.

Selection Screen - Transaction Sampling

Selection Screen - Transaction Sampling

Results Screen - SampledResults Screen - Sampled

Selection Screen - Transaction Sampling

Selection Screen - Transaction Sampling

Not checked

Results Screen - View all SampledResults Screen - View all Sampled

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.

Displaying enpets within the Ledger Reviewer

Displaying enpets within the Ledger Reviewer

Sorting enpets within the Ledger Reviewer

Sorting enpets within the Ledger Reviewer

Enpet - WarningEnpet - Warning

Enpet - Check AllEnpet - Check All

Once user selects Enpet All

they still need to launch enpet

EnpetsEnpets

** All items that are enpet should be assigned a problem code.

** This includes any previous items that have already been marked as “OK”.

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.

Assigning Problem Codes & Saving

Account Code detail

Adding a NoteAdding a Note

Review - mouse over functionality

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.

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.

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.

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.

History box - SampledHistory box - Sampled

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.)

Custom Find - Express CardsCustom Find - Express Cards

Rule classRule classXXCD = Express card transactionsXXCD = Express card transactionsXCRD = Express card use taxXCRD = Express card use tax

Result of Custom find - Express Cards

Result of Custom find - Express Cards

Custom Find - MarketplaceCustom Find - Marketplace

Result of Custom find - Marketplace

Result of Custom find - Marketplace

All PO’s via theNew Marketplace

begin with doc number 9

Custom Find - DescriptionCustom Find - Description

Result of Custom find - Description

Result of Custom find - Description

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

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

Thank youfor your interest in

The New Ledger

Reviewer

Thank youfor your interest in

The New Ledger

Reviewer

Questions? Questions?