Tally & Excel Accounting Tasks
Budget: $2 – $8 USD
I use Tally Prime / Tally ERP for day-to-day bookkeeping and need experienced hands to keep everything up-to-date and fully reconciled. The workload centres on three core areas:
• Voucher and ledger upkeep – enter every sale, purchase, payment, receipt and journal accurately each day so all ledgers stay current.
• GST compliance – post GST invoices, then prepare the basic GST reports I need for filing (GSTR-1, GSTR-3B, mismatch checks).
• Bank reconciliation – match bank statements with Tally, investigate variances and close each period with zero unreconciled items.
Alongside Tally work, I often export data to Microsoft Excel for deeper analysis. You will create and maintain spreadsheets that include clean data entry sheets, smart formulas and automated reports or stock/account statements pulled from the books.
I already have seven years of accounting data in the system; clean continuation and accuracy are critical. Please be comfortable navigating both the classic Tally interface and the latest Tally Prime layout, and be ready to share periodic backups and working Excel files so I can review progress at any time.
Deliverables will be accepted once:
• All daily vouchers are posted with correct GST codes and narration.
• Bank accounts reconcile to the statement balance.
• Monthly GST summary tallies with the ledgers.
• Excel reports reflect the same figures shown in Tally.
If you have a reliable workflow for batch importing or shortcut keys in Tally, feel free to use them—the end result just needs to be precise and auditable.
• Voucher and ledger upkeep – enter every sale, purchase, payment, receipt and journal accurately each day so all ledgers stay current.
• GST compliance – post GST invoices, then prepare the basic GST reports I need for filing (GSTR-1, GSTR-3B, mismatch checks).
• Bank reconciliation – match bank statements with Tally, investigate variances and close each period with zero unreconciled items.
Alongside Tally work, I often export data to Microsoft Excel for deeper analysis. You will create and maintain spreadsheets that include clean data entry sheets, smart formulas and automated reports or stock/account statements pulled from the books.
I already have seven years of accounting data in the system; clean continuation and accuracy are critical. Please be comfortable navigating both the classic Tally interface and the latest Tally Prime layout, and be ready to share periodic backups and working Excel files so I can review progress at any time.
Deliverables will be accepted once:
• All daily vouchers are posted with correct GST codes and narration.
• Bank accounts reconcile to the statement balance.
• Monthly GST summary tallies with the ledgers.
• Excel reports reflect the same figures shown in Tally.
If you have a reliable workflow for batch importing or shortcut keys in Tally, feel free to use them—the end result just needs to be precise and auditable.
Related categories:
Accounting
Excel
Finance
Intuit QuickBooks
Bookkeeping
Excel VBA
Excel Macros
Bank Reconciliation