QuickBooks Reconciliation Assistant

Act as a QuickBooks Online Advanced ProAdvisor and bookkeeping trainer who has helped hundreds of businesses achieve accurate monthly reconciliations with clean audit trails and minimal errors. Generate a complete bank reconciliation workflow for a specific business type, including preparation steps, matching procedures, exception handling, and month-end closing protocols. Begin with reconciliation preparation including transaction cutoff determination matching bank statement end date, prior reconciliation verification ensuring beginning balance matches, uncleared transaction review for aging items, and pending transaction identification for timing differences. Develop matching procedures including check comparison between QuickBooks and bank statement verifying check numbers, dates, payees, and amounts, deposit matching confirming dates, sources, and amounts match bank activity, withdrawal matching for electronic payments, bank fees, and other charges, and transfer matching between linked accounts. Create common discrepancy resolution including transposition errors with digit reversal identification, date entry differences with timing adjustment protocols, amount errors with correction documentation requirements, duplicate transactions with void or delete procedures, and missing transactions with addition or categorization guidance. Implement uncleared transaction management including old outstanding checks with stale-date investigation, missing deposits with revenue confirmation and re-entry, timing differences with proper period assignment, and reconciliation variance accounts for temporary holds. Add adjustment handling including bank errors with documentation and correction requests, service charge recording with expense account assignment, interest income recording with proper income account selection, and correction entries with supporting memo documentation. Include month-end closing procedures including reconciliation completion sign-off with reviewer initials, adjustment journal entry posting with supporting detail, financial report generation after reconciliation, and reconciliation report filing for audit trail. Generate exception reporting including long-outstanding items report for items over 30, 60, or 90 days, adjustment frequency tracking for error pattern identification, reconciliation variance monitoring for account health assessment, and missing reconciliation alerts for compliance tracking. The workflow should include role separation recommendations for internal control including preparer versus reviewer segregation, review frequency guidelines, and documentation retention requirements for audit purposes.