Bookkeeping Setup: Excel & Tally

I run a small business and need our entire bookkeeping cycle captured accurately every month. The work covers day-to-day sales and purchase entries, updating the Cash Book and Bank Book, maintaining all ledgers, and closing each period with a balanced Trial Balance.

The data must be recorded in both Excel and Tally; I use Tally for quick ledger look-ups while my partners prefer the flexibility of Excel. I already have a template in both platforms—once you come on board I’ll share these files so you can follow the exact layout we’re accustomed to.

Deliverables each month
• A fully updated Excel workbook that mirrors the structure I provide
• The corresponding Tally data file with identical figures
• A concise monthly report pack generated from the books (PDF and Excel), ready for management review

Acceptance criteria
• All vouchers posted and reconciled; no differences between Excel and Tally
• Cash, bank, and ledger balances tie back to statements and source documents
• Trial Balance proves the books remain in balance with zero suspense

If this initial phase runs smoothly, I’ll look to extend the collaboration for quarterly closing and year-end financial statements.