Tally & Excel Accounts Entry
Budget: ₹100 – ₹400 INR
I need support updating my accounts in both Tally and Excel. The workload covers every stage of data capture, from key-in of source documents to running automated imports or macros where possible. Accuracy is critical because all of this information feeds directly into my financial reporting.
The task centres on financial records. You will be working with:
• Income statements
• Balance sheets
• Expense reports
Expect to receive scanned vouchers, bank statements, and existing spreadsheets. Some items must be keyed in manually, while others can come in through CSV uploads or any automation you are comfortable with. I keep Tally set up with standard chart-of-accounts and GST settings; your job is to ensure each entry is coded correctly and reconciled.
Please be comfortable toggling between Tally ERP, Excel (pivot tables, VLOOKUP, basic macros), and any light data-cleaning you feel will tighten the files before posting. Completed work should leave me with balanced ledgers in Tally, matching Excel worksheets, and a brief note of any discrepancies you encountered along the way.
The task centres on financial records. You will be working with:
• Income statements
• Balance sheets
• Expense reports
Expect to receive scanned vouchers, bank statements, and existing spreadsheets. Some items must be keyed in manually, while others can come in through CSV uploads or any automation you are comfortable with. I keep Tally set up with standard chart-of-accounts and GST settings; your job is to ensure each entry is coded correctly and reconciled.
Please be comfortable toggling between Tally ERP, Excel (pivot tables, VLOOKUP, basic macros), and any light data-cleaning you feel will tighten the files before posting. Completed work should leave me with balanced ledgers in Tally, matching Excel worksheets, and a brief note of any discrepancies you encountered along the way.
Related categories:
Visual Basic
Data Processing
Data Entry
Accounting
Excel
Financial Analysis
Excel Macros
Automation