Excel Accounting Automation & Macro Development -- 2

₹600-1500 INR

Closed

Posted over 1 year ago

₹600-1500 INR

Paid on delivery

As an accountant, I'm looking for an expert who can assist me in automating my manual accounting tasks in Microsoft Excel. The tasks include creating books of accounts, reconciling, processing payroll, and preparing financial statements like P&L and Balance Sheets. Key Responsibilities: - Automate the creation of books of accounts, General Ledgers, Trial Balance, and P&L - Develop macros for Excel to streamline these tasks - Automate data entry, transaction categorization, and report generation in the books of accounts Ideal Skills and Experience: - Proficient in Microsoft Excel and VBA for macro development - Strong background in accounting - Experience in automating tasks in Excel - Ability to create user-friendly automated systems - Proficiency in advanced Excel functions like VLOOKUP, INDEX, and MATCH. - Experience in data analytics and visualization tools within Excel. - Certifications such as CPA or ACCA that demonstrate a strong understanding of accounting principles. - Experience with developing and integrating Excel Add-ins for enhanced functionality. - Basic understanding of SQL for potential future database integrations. - Meticulous attention to detail to ensure accuracy in financial reports and automated tasks. - Skills in testing and quality assurance to ensure the system runs smoothly and without errors. - Experience in creating financial models and scenarios using Excel. - Strong problem-solving skills to troubleshoot and resolve any automation and accounting-related issues. - Experience with project management to ensure timely delivery of automated solutions. - Proficiency in creating and using Pivot Tables for data analysis and reporting. - Experience in creating custom Excel functions for unique accounting needs. - Skills in advanced Excel charting techniques to visually represent financial data. No integration with external accounting software or databases is required. The automated system should have an intuitive and user-friendly interface for ease of use. [ it is of my client who need it urgently] The project needs to be completed within 2 weeks. The user interface should be highly customized to include specific user preferences and ease of navigation.

Project Management

Software Architecture

MySQL

Usability Testing

Web Hosting

Project ID: 38873754

About the project

6 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

6 freelancers are bidding on average ₹1,050 INR for this job

@Asadjutt111

With over a decade of proven project management experience in my repertoire, I am confident in my ability to not only meet but exceed your expectations within the proposed two weeks timeline. In managing projects across diverse disciplines, I've learned how to remain flexible, adapt quickly, and deliver results that align precisely with my clients' needs and preferences - all key components for this Excel accounting automation task. My skills in Microsoft Excel and VBA for macro development would be invaluable in creating a fully automated accounting system tailored to your requirements. From generating books of accounts and general ledgers, to processing payroll and P&L statements, I can streamline each process with the utmost precision and simplicity --- no SQL/database integration worries here! What's more, my background as an accountant complements these technical abilities, equipping me with a unique understanding of the financial intricacies involved.

₹600 INR in 1 day

4.7

(11 reviews)

3.1

@Asif031984

I bring over 15 years of experience and have successfully delivered 80+ projects during the freelancer as well as other remote freelancers. Some of areas are mentioned below: • Bookkeeping, Accounting, Taxation, compliance, payroll, and system-based solutions. • Data Analytics, Visualization, Advanced Excel dashboards, Power BI, and expert analytics tools for problem-solving, Microsoft, Google sheet • Financial Planning & Advisory, Projections, business plans, financial modelling, investor due diligence, and pitch decks. • Being a FCMA, CIPFA & CPA, I have strong strength on writing different research papers. • ERP Implementation & Advisory: System analysis, business analysis, and gap analysis. • Startup Advisory, FinTech: Dashboards, BizOps, and strategic support for startups. • Strategic Planning, Turnaround, Cost optimization and project recovery. • ESG, Cybersecurity, Forensic audits, compliance, legal & contract advisory. Let’s chat how I can support your business needs effectively.

₹1,500 INR in 7 days

0.0

(0 reviews)

0.0

@abhitgupta07

As a Chartered Accountant article, I possess strong expertise in accounting and related compliance matters. My proficiency in Excel, combined with excellent communication skills, enables me to collaborate effectively and ensure the successful completion of projects through mutual effort and understanding.

₹1,050 INR in 10 days

0.0

(0 reviews)

0.0

@lifechoices09

Hi there, With 4+ years of experience, I've automated accounting tasks in Excel, streamlining bookkeeping, payroll, and financial statements. Let's discuss further. Please feel free to message me so we can discuss this further. Best, Florence

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@avdheshruchi

My Bid is Rs. 1050. We Provide you good professional service with accuracy on deadlines. We have good professionals team to serve you on time .

₹1,050 INR in 7 days

0.0

(0 reviews)

0.0

@dimitrid6

I have 20+ years experience working as a business consultant / project manager with middle and large size companies, in various business fields such as manufacturing, logistics, sales, customer service etc. Optimization of processes is the typical outcome of the greater goal of improving the bottom line. My work incluced extensive communication with top and middle management, designing and implementing management systems primarily on spreadsheet platforms. Working with accounting departments to design and create various databases from which to extract automated reports, using VBA, multiple excel functions is a common practice. I would be happy to provide you with any additional information upon request.

₹1,050 INR in 7 days