Find Jobs
Hire Freelancers

Automate Reconciliation

₹1250-2500 INR / hour

Closed
Posted about 6 years ago

₹1250-2500 INR / hour

We reconcile books with bank & would like to atomize it. Here are the steps that we follow: [login to view URL] Find attached reco working Pre & Post file. We would like to have a macro to automate all these steps & willing to make modification in steps as mentioned in doc.
Project ID: 16350270

About the project

21 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

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
21 freelancers are bidding on average ₹1,893 INR/hour for this job
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered ten excel vba projects in the past two months. I also have expertise in finance domain and have implemented, supported Bank Reconciliation Process which was part of Finance module ERP. I believe I can complete your work in 5 hours, but the deadline is 2 days. Thank you, Regards.
₹2,500 INR in 5 days
5.0 (111 reviews)
6.4
6.4
User Avatar
- Went through the Steps in google sheet and the July Reco before and after reconcilation. - Based on the month of reconcilation, the bank statment and ledger the steps could be run using a click of a button. - transactions made into one line - including updating closing balance - Depsoits, Outstanding, Adjustments, Expenses, matching bank and books. - Have done similar bank transactions in 3-4 projects, Where the ledger recsoncilation against the bank statement having multicurrencty transactions. - Similar extraction and consolidatoin of bank statments Checkin and saving and having the Debits and Credits into separte speets for each account. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., Sample HighComplex Projects using Macros:(via Freelancer) - Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations. - System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report. - Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.
₹1,400 INR in 40 days
4.7 (50 reviews)
6.0
6.0
User Avatar
Greeting, I have understood your Automate Reconciliation task and can do it with your 100% satisfaction. Please ping me for more discussion. I have more than 5 years of experience in Excel, Excel Macros, Excel VBA, Visual Basic
₹2,083 INR in 40 days
4.8 (14 reviews)
5.2
5.2
User Avatar
Dear Hiring Manager, I have worked on various automation projects in excel using macros. My expertise in Excel includes, but not limited to: Macros, Web Scraping, User Forms, Pivot Tables, Formulas, Customized Ribbon Buttons, Data extraction from external applications (Access, PDF, Outlook), etc. Looking forward to hear from you. Regards Chintu
₹2,111 INR in 20 days
5.0 (13 reviews)
4.1
4.1
User Avatar
Hi I'm an MBA graduate in Finance and an excel expert. I will be able to deliver a perfect result for you. Please go through my profile and connect with me if you would like to take me on board. Thank you
₹1,666 INR in 40 days
5.0 (1 review)
2.5
2.5
User Avatar
With over 3 years of experience in consulting and Automated model building and developing various tools for the largest companies (Clients), i have gained quite a bit of expertise over VBA. The project overall looks pretty interesting and actually is easy for me. Let me know if you are interested via chat. Thanks,
₹2,083 INR in 40 days
5.0 (2 reviews)
2.7
2.7
User Avatar
i have gone through the requirement and can complete it in 2 days. I have 7+ years of VBA experience. Looking forward to hear from you
₹2,083 INR in 40 days
3.6 (2 reviews)
1.4
1.4
User Avatar
I m an student bachelor in commerce with accounting honour's as its an part to my study related I m interested for this project I would love to give my whole dedicated time to this project
₹1,888 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹1,388 INR in 14 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹2,000 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹2,222 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹1,666 INR in 30 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Please find my below skill-sets: Expert in VBA Automation Advance Excel Knowledge Rich experience in automations in VBA in big projects in top brands.
₹1,251 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have experience working on Excel everyday, I have knowledge of Macros. I would be glad to help you in what you need and since now if you decide Relevant Skills and Experience I usually work automating Excel charts throgh Macros and advance functions
₹1,666 INR in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹1,666 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
₹2,777 INR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will complete this project accurately within deadline. I already created half of the macro as you mentioned. Also i am having good reconciliation experience.
₹1,388 INR in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Payment method verified
Member since Nov 25, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.