Skip to main content
Administrator Guide
Last Updated: 2023-06-23
Process: Book-to-Bank Reconciliation

Process: Book-to-Bank Reconciliation

You can use this checklist of tasks to help guide you through a book-to-bank reconciliation.
  1. Access the
    Find Bank Statements
    report.
    Verify that you've entered or uploaded all of your prior day bank statements for the period.
    Security: These domains in the Banking and Settlement functional area:
    • Process: Bank Reconciliation
    • Process: Bank Statement - Reporting
  2. Access the
    Book to Bank Summary - Uncleared Bank Statement Lines
    and
    Book to Bank Summary - Uncleared Operational Transactions
    reports.
    Check for unreconciled statement lines and operational transactions.
    Security: These domains in the Banking and Settlement functional area:
    • Process: Bank Reconciliation
    • Process: Bank Statement - Reporting
  3. Access the
    Book to Bank Summary
    report.
    Review the status of your bank accounts. You can use the color-coded health indicator to identify the balances that require the most attention.
    Security:
    Report Execution
    domain in the Tenant Non-Configurable functional area.
  4. Review the transaction variances and additional information in the book-to-bank subreports.
  5. (Optional) Run these tasks to fix any cash journals in error:
    • Fix Operational Journals With Errors
    • Fix Data Errors for Journal Entries
    Security:
    • Process: Audits and Corrections
      domain in the Financial Accounting functional area.
    • Set Up: Payroll - Company Specific (Accounting)
      domain in the Core Payroll functional area.