Project Description
Bank reconciliation is overdue across both my business and personal accounts, and I want everything brought fully up to date and kept that way going forward. The records already sit in Excel alongside my cloud-based ledger (QuickBooks Online); what’s missing is the methodical matching of every bank and credit-card transaction, flagging of duplicates or errors, and production of a clean, balanced statement that agrees with the general ledger. Accuracy, confidentiality, and a clear audit trail are essential.
Scope of work
• Reconcile every linked business and personal bank or card account for the past six months, then continue monthly.
• Investigate and explain any discrepancies, uncleared items, or bank fees.
• Update the Excel workbook and QuickBooks file so closing balances tie exactly to the bank.
• Provide a concise reconciliation summary each cycle.
I will supply PDFs or CSVs of bank statements, current ledgers, and view-only system access via a secure channel. Solid experience with Excel formulas, QuickBooks (or equivalent), and standard bookkeeping principles is required so the hand-back files are ready for my accountant with zero rework.
Please outline your experience handling multi-account reconciliations and the turnaround time you can reliably commit to; consistency matters more than speed.