Excel Financial Consulting & Bookkeeping

All of my business records live in Excel and I want to keep it that way while still enjoying the clarity normally found in a full bookkeeping system. The assignment is to review the current workbooks, streamline how every transaction is logged, complete accurate monthly bank reconciliations, and tighten up both accounts-payable and accounts-receivable tracking.

Scope of work
• Diagnose the existing spreadsheets and propose a clean, sustainable structure.
• Build or improve templates (and, if helpful, macros or Power Query routines) that make daily transaction entry effortless.
• Reconcile all bank statements back to the beginning of the fiscal year, flagging and correcting discrepancies.
• Create an A/P and A/R schedule that updates automatically, including aging analysis and clear outstanding totals.
• Deliver concise documentation plus a brief walk-through so I can maintain the system confidently after hand-off.

Acceptance criteria
– Every historical transaction imported and correctly categorized.
– Bank accounts reconcile to the cent with their statements.
– A/P and A/R schedules tie out to the ledger and show real-time balances.
– Step-by-step notes supplied in a separate sheet.

Strong command of Excel formulas, pivot tables, and data-cleanup techniques is essential; familiarity with advanced tools such as Power Query or VBA is a plus. Share a realistic timeline and any examples of similar Excel-based bookkeeping or financial-consulting projects you have completed so I can gauge fit and plan next steps.