Reference: Book-to-Bank Reports

You can use the book-to-bank reports to perform a thorough book-to-bank analysis that meets audit and management reporting requirements. After you run bank reconciliations, you can use the summary and subreports to review variances between the bank account and cash ledger balances and determine the corrective actions to take.

This table describes the reports in more detail:

Report	Description	Security
Book to Bank Summary	Compares bank statement balances against the ledger bank balances in a summarized, high-level format. Using key metrics, you can identify the root causes of discrepancies between the balances for a specified company or company hierarchy, period, and bank accounts. You can drill down into the report column details, or access the associated subreports for more logical subgroupings of the details. Graphical indicators on the right side of the report represent the status of your bank account balances: Green circle: All differences between the bank balance and cash ledger balance are accounted for and explained in the report. Red diamond: Unexplained differences between the bank balance and cash ledger balance require further analysis.	Report Execution domain in the Tenant Non-Configurable functional area.
Book to Bank Summary - Bank Account Balance	Displays the prior-day ending bank balance in bank account currency using the latest noncanceled bank statements for the period. You can use this subreport to assess your ending bank balance for the selected company or company hierarchies, period, and bank accounts. You can also drill down on a prior-day ending bank balance for a bank account to: Compare the beginning and ending ledger balances. View the bank statement summary of the opening and closing ledger amounts and transaction details. View the number of unreconciled bank statement lines.	These domains in the Banking and Settlement functional area: Process: Bank Reconciliation Process: Bank Statement – Reporting Set Up: Bank Entity Reports: Cash Forecast Reporting domain in the Cash Management functional area.
Book to Bank Summary - Ledger Balance	Displays month-end cash ledger balances in bank account currency for a specified period and company. You can use this subreport to: View the ledger balances for each of your bank accounts. Workday calculates the balances as the sum of the transaction debit minus the credit. Drill down on the balance for each journal source to view all transaction details. Identify unreconciled cash journal lines to reconcile with bank statement lines.	Reports: Financial Accounting domain in the Financial Accounting functional area.
Book to Bank Summary - Uncleared Bank Statement Lines	Displays unreconciled bank statement lines in a prior or current period. You can use this subreport to: Compare all reconciled statement lines with unreconciled statement lines for a root-cause analysis on bank balance differences. Drill down on bank statement lines to view the details. You can then decide whether to: Create an ad hoc bank transaction for either the bank statement line amount or the difference between the statement line and a transaction. Reconcile a bank statement line with the reconcilable item to clear the bank statement line.	Process: Bank Statement - Reporting domain in the Banking and Settlement functional area. Reports: Cash Forecast Reporting domain in the Cash Management functional area.
Book to Bank Summary - Uncleared Operational Transactions	Displays all unreconciled operational transactions in a prior or current period. You can use this subreport to: View all reconciled items with the unreconciled items for a root-cause analysis on ledger balance differences. Drill down on operational transaction totals to view individual item details. You can then decide whether to: Create an ad hoc bank transaction for either the reconcilable item amount or the difference between the statement line and a reconcilable item. Reconcile a reconcilable item with the corresponding bank statement line to clear the transaction. Note that this report excludes unreconciled electronic payment reconciliation groups (EPRG).	Process: Bank Reconciliation domain in the Banking and Settlement functional area.
Book to Bank Summary - Cross Period Reconciled Bank Statement Lines	Displays the future-period bank statement lines reconciled to operational transactions with an accounting date that falls in either the selected or earlier period. Example: You reconcile a transaction posted to the ledger in the selected period to its corresponding bank statement line that's recorded for the next period. You can use this subreport to determine if the transaction amount is the variance between the bank and ledger balances displayed on the Book to Bank Summary report for the selected period.	Process: Bank Statement - Reporting domain in the Banking and Settlement functional area. Reports: Cash Forecast Reporting domain in the Cash Management functional area.
Book to Bank Summary - Cross Period Reconciled Operational Transactions	Displays the future-period operational transactions reconciled to bank statement lines with a line date that falls in either the selected or earlier period. Example: You reconcile a bank statement line in the selected period to a reconcilable item that's posted to the ledger in the future period. You can use this subreport to determine if this transaction amount is the variance between the bank and ledger balances displayed on the Book to Bank Summary report for the selected period.	Process: Bank Reconciliation domain in the Banking and Settlement functional area.
Book to Bank Summary - Reconcilable Items Stopped, Canceled or Escheated in Future Period	Displays: Payments marked as stopped for a specified date range and company. Reconcilable items marked as canceled or escheated for a future period. You can use this subreport to: Take corrective actions on the payments marked as stopped. View the reversal entries for canceled or escheated payments posted in a future period.	Process: Bank Reconciliation domain in the Banking and Settlement functional area.
Book to Bank Summary - Non-Operational Transactions	Displays the nonoperational cash journal lines posted to the ledger account in a prior or current period. You can use this subreport to: View cash journal amounts for nonoperational transactions, such as manual or Accounting Center journals. Assess the differences between ledger balances and bank balances.	Reports: Financial Accounting domain in the Financial Accounting functional area.
Book to Bank Summary - Payments in Settlement	Displays all settled payments in a prior or current period that are awaiting payment acknowledgment or rejected by the bank. The payments are for bank accounts configured with required payment acknowledgments. You can use this subreport to: View payments that aren't reconcilable based on a payment acknowledgment status. These also include non-canceled payments from electronic payment reconciliation groups (EPRG). Determine the corrective action to take, such as canceling or reprocessing the payments. You can then reconcile the cash ledger balances to your bank balances.	Process: Bank Reconciliation domain in the Banking and Settlement functional area.
Book to Bank Summary - Cash Journals in Error	Displays operational and nonoperational cash journal lines posted to the ledger account with errors. Example: Missing ledger accounts due to incorrect cash account posting rules. The report includes all journal lines in a prior, current, or future period. You can use this subreport to determine the root causes of differences between bank balances and ledger bank balances due to errors in the posted journal lines.	Reports: Financial Accounting domain in the Financial Accounting functional area.

Concept: Book-to-Bank Reconciliation