Detailed Excel Bookkeeping Entries

I need my day-to-day accounting captured quickly and accurately in Microsoft Excel. The scope is centred on two core areas:

• Purchase & sales entry recorded with full transactional detail—including invoice numbers, dates, item descriptions, quantities, prices, taxes, and the exact customer or supplier involved.
• Bank and cash entry reconciliation so every figure on the Excel ledger ties back to the corresponding bank statement or cash slip without exception.

You will receive source documents (invoices, receipts, statements) by folder share each week. I expect you to post them to the workbook, reconcile balances, flag discrepancies, and keep a running schedule of outstanding items. When the month closes, I should be able to open the file and instantly trace any amount back to its original document.

Deliverables are:
1. A clean, well-structured Excel workbook containing separate sheets for purchases, sales, bank, and cash.
2. Reconciliation tabs that match ending balances to the bank statement totals.
3. A short variance note whenever something does not reconcile.

Consistency, attention to detail, and timely turnaround are essential. If you are comfortable maintaining granular data in Excel and can prove the numbers balance, I’m ready to start this week.