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