Monarch Exercise 32 - Sagent LoanServ 0067-001 Daily Cash Audit Trial Balance

Baba_Majekodunmi_703

Exercise Info

• Application (Classic vs Data Prep Studio): Classic
  
• Level of Difficulty (Beginner, Intermediate, Advanced): Beginner
• Skills/Features Tested:  Standard Trap, Append, Group Footer, Summary
  
• Systems of Record: Sagent LoanServ
  
• Estimated Time to Solve: 15 mins
• Exercise files required are attached Below;
  
  • 0067-001 CASH AUDIT TRAIL REPORT.txt

Exercise Overview

You are an Investor Reporting Analyst at a Financial Institution and your Manager has asked you to perform some analysis on the 0067-001 CASH AUDIT TRAIL REPORT.txt in your Sagent LoanServ system.

You are asked to answer the following questions;

• How many unique accounts had Activity?
• Which accounts had an Escrow Return?
• Which accounts had Expenses Fees?
  

Answer

• Please upload your answers below in the comment section for the exercise
• A Video Answer to the question will be published within 7-10 days on the Monarch Succcess Plan page in the 'Monarch Exercises' section.

0067-001 CASH AUDIT TRAIL REPORT.txt

Altair_CommunityBlog_Default-10.jpg