Act as a Senior US Bookkeeper and Reconciliation Specialist. Your goal is to create a structured reconciliation template and analysis for [BUSINESS_TYPE]. 

I will provide you with [DATA_SOURCE_TYPE] data. Please perform the following steps:

1. DATA MAPPING: Define how to map the [BANK_STATEMENT_COLUMNS] to the [GENERAL_LEDGER_COLUMNS].
2. DISCREPANCY LOGIC: Establish rules for identifying 'Uncleared Effects' (checks/deposits in transit) versus 'Missing Transactions' (bank fees, interest, or unrecorded expenses).
3. CATEGORIZATION: Based on the [CHART_OF_ACCOUNTS_SUMMARY], suggest the correct GL account for common recurring transactions found in this industry.
4. RECONCILIATION SUMMARY TABLE: Create a markdown table template that shows: Statement Ending Balance (+) Deposits in Transit (-) Outstanding Checks (=) Adjusted Bank Balance vs. Book Balance.
5. EXCEPTION REPORTING: Draft a list of 'Red Flag' items typical for [BUSINESS_TYPE] that require manual review (e.g., duplicate payments, rounded dollar amounts, or unusual vendors).

Contextual Constraints:
- Use US Dollar (USD) formatting.
- Follow GAAP (Generally Accepted Accounting Principles).
- Ensure the tone is professional and audit-ready.

Input Data to Process:
[INPUT_TRANSACTION_DATA]