Begin the process by locating the CRE_Remit_P&I_2023 file in the shared drive via the Remote Desktop. This file is located at the following path: \EXFFILESRV\Shared\Accounting\Private\Private\Recons_2023\862100-100.

A new file needs to be created, making sure to update the file name to correspond to the current month's closing.

Create a new file and update the file name corresponding to current month's closing.

2. Modifying the 62403 Template and PAS2 sheets

Open the newly created file and navigate to the "62403 Template" sheet. Update this sheet to reflect the current month's closing date.

This guide provides step-by-step instructions on how to reconcile CRE remittance files. It includes locating and creating new files, updating data, deleting and copying data, checking for discrepancies, and generating reports. Following this guide will ensure accurate and efficient reconciliation of CRE remittance files.

CRE Remittance Reconciliation Workflow

3. Generating the Current Month-end Data via Datalinks

4. Preparing Copied Data for Analysis in a New Excel Spreadsheet