Reconcile Four Company Books -- 2

I have four small companies whose books have been tracked only in separate Excel sheets. Over the last two financial years I logged roughly 300–400 transactions in total, covering sales & revenue, expenses & purchases, and a handful of loan entries. I now need a one-off clean-up that brings every ledger into balance and gives me clear financial statements for each entity.

The work involves importing or re-structuring the existing Excel data, classifying each transaction correctly, checking for duplicates or omissions, reconciling against bank statements, and then producing a tidy trial balance, profit-and-loss, and balance sheet for each company. I only have basic excel spreed sheets from the bank

Deliverables
• Balanced ledgers for all four companies covering the last two years
• P&L and balance sheet per company, clearly dated
• A brief reconciliation summary that shows how the figures tie back to the source data
• Cleaned, well-structured Excel workbook (or export file) ready for any future software import

Acceptance criteria: totals in the statements must trace back to the original bank or credit-card lines, all loan balances must match outstanding amounts, and every sheet should foot with zero unexplained variance.

I’m ready to send the existing spreadsheets and bank exports as soon as we agree on the workflow and timeline.