Table of Contents

Refresh Reconciliation File                                                                                                            2

1.1      Refresh Reconciliation File (R09130) Session............................................................................................................... 2

1.2      Version Prompting Session.............................................................................................................................................. 3

1.3      Data Selection Session.................................................................................................................................................... 3

1.4             Processing Options Session.................................................................................................................................... 3

1.4      List of Processing Option Values Session...................................................................................................................... 4

1.5      Report Output Session..................................................................................................................................................... 4

1.6      Refresh Reconciliation File Report.................................................................................................................................. 4

Manual Reconciliation                                                                                                                   5

1.7      Manual Reconciliation – Reconciliation (R09131) Session........................................................................................... 5

1.8      Bank Account Reconciliation Session – Before Reconciling........................................................................................ 5

1.9      Bank Account Reconciliation Session – After Reconciling............................................................................................ 6

1.10         Reconciliation Print – Outstanding Items Report...................................................................................................... 7

 

Refresh Reconciliation File

This procedure describes how to submit the Refresh Reconciliation process.  Before you reconcile your accounts, you must run the;

 

1. Reconcile Void Receipt: R09552

• This report automatically reconciles voided receipts by updating the GLRCND field with the default reconciliation code 'R' on the transactions in the F0911 table. You should run these programs before you run the Refresh Reconciliation File program (R09130) so that voided and zero amount payments and receipts are not included in the Account Ledger Reconciliation table.

       b)      Reconcile Void Payment: R09551

• Instead of manually reconciling voided payments and receipts, you can save time during account reconciliation by running these programs. This report automatically reconciles voided payments and checks with zero amounts. It updates the GLRCND field with the default reconciliation code 'R' for different document types. When reconciling payments, the Automatic Reconcile Void Payment program selects payments that were voided manually and those voided during automatic payment processing

       b)      Refresh Reconcile File: R09130

• you must run the Refresh Reconciliation File program (R09130).  Typically, you run this program at the end of each period to reconcile transactions for the period.  The Refresh Reconciliation File program copies the unreconciled transaction detail for all reconcilable accounts, in preparation for manual reconciliation. Based on the beginning and ending dates entered in the processing options. Based on the status of the reconciliation field and this field must be blank in the processing options. Each time you submit the refresh reconciliation’s process, the system removes all previously reconciled transactions in the table and replaces them with new transactions that were entered since you last submitted the process.

 

1. Refresh Reconciliation File (R09130) Session

To access this option from the Master Directory follow the steps outlined below:

Steps   Choose any of the bank account to refresh after run the “Reconcile Void Receipt” and “Reconcile Void Payment”.

 

 

1. Version Prompting Session

 

Steps   Click (Check) Data Selection Click

 

1. Data Selection Session

 

Steps   Click

 

1.4             Processing Options Session

 

Steps   Enter Beginning Date Enter Ending Date Click

 

Required Fields	Field Explanation
Beginning Date	Transactions are selected based on the beginning date.
Ending Date	Transactions are selected based on the ending date.

1. List of Processing Option Values Session

Processing Option Tab Title	Processing Option Text	Processing Option Value
Dates
	1.  Enter the date you want to use as the beginning date for the build.
	2.  Enter the date you want to use as the ending date for the build.
Status
	1.  Enter a '1' to select both reconciled and unreconciled records.
Ledger
	1.  Enter a valid ledger type.  Blank will default to all ledger types.	AA
Document
	1.  Enter a '1' to include AE document type transactions.
Messages
	1.  Enter a '1' to print all messages.  Blank prints messages only for accounts that are refreshed

1. Report Output Session

 

Steps   Click (Check) Report Destination as desired Click

 

1. Refresh Reconciliation File Report

 

Steps

Manual Reconciliation

 

This procedure describes how to manually reconcile your bank accounts, or debits and credits, for other accounts.  Manually reconciling your accounts consists of these steps:

 

• Reconciling voided payments or receipts with zero amounts automatically (optional)
• Creating or refreshing the reconciliation worktable for unreconciled transactions
• Performing the manual reconciliation for bank accounts or other accounts

 

1. Manual Reconciliation – Reconciliation (P09131) Session

 

Steps   Select Bank Account Reconciliation button

 

1. Bank Account Reconciliation Session – Before Reconciling

 

Steps   Enter Bank Account Number Enter a general ledger date in the From Date field to limit the transactions that you view for the account Enter Bank Balance that appears on your bank statement Click

 

 

1. Bank Account Reconciliation Session – After Reconciling

Steps   To mark a transaction as reconciled Double click the selected rows The rows will be marked as reconciled   OR   To unreconciled a reconciled transaction, double-click the transaction or select the transaction and then select Reconcile Toggle from Row Menu

 

Fields	Field Explanation
Bank Balance	Amount from the bank statement
Outstanding Debits and Credits	Records in the reconciliation worktable that have not been marked as reconciled
Book Balance	Account balance in the Ledger
Amount to Reconcile	(The Bank Balance + the Outstanding Debits + the Outstanding Credits) - Book Balance

 

Steps   Click again The reconciled transactions will disappear from the rows

 

1. Reconciliation Print – Outstanding Items Report

 

Steps   Select Reconciliation Print from Report Menu Reconciliation Print – Outstanding Items Report