Required information [The following information applies to the questions displayed below.] Required: 1. Find the items that need to be reconciled between the company's general ledger and the bank statement. Ask the Question: Can we use conditional formatting to highlight reconciling items for a bank reconciliation? Master the Data: Apply the same steps as Lab 5-2 to the Lab 5-2 Alt Data.xisx dataset, with a completed bank reconciliation. Software needed - Excel - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 5 -2 Alt Data xisx Perform the Analysis: Refer to Lab 5-2 Alternate in the text for instructions and Lab 52 steps for each the of lab parts. Share the Story: Bank reconciliations are a basic internal control used by companies to ensure that their cash transaction are properly recorded. By comparing the cash transactions to the independent records of a bank, the company and its auditors can be more certain that its cash transactions are properly recorded. The company may also use this to identify Vern Richardson CPA Cash Transactions July 31, 2022 General Ledger/Company Books Bank Statement Transaction Type Required information [The following information applies to the questions displayed below.] Required: 1. Find the items that need to be reconciled between the company's general ledger and the bank statement. Ask the Question: Can we use conditional formatting to highlight reconciling items for a bank reconciliation? Master the Data: Apply the same steps as Lab 5-2 to the Lab 5-2 Alt Data.xisx dataset, with a completed bank reconciliation. Software needed - Excel - Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 5 -2 Alt Data xisx Perform the Analysis: Refer to Lab 5-2 Alternate in the text for instructions and Lab 52 steps for each the of lab parts. Share the Story: Bank reconciliations are a basic internal control used by companies to ensure that their cash transaction are properly recorded. By comparing the cash transactions to the independent records of a bank, the company and its auditors can be more certain that its cash transactions are properly recorded. The company may also use this to identify Vern Richardson CPA Cash Transactions July 31, 2022 General Ledger/Company Books Bank Statement Transaction Type