Find Jobs
Hire Freelancers

Excel reconciliation of bank and scroll receipts

₹1500-12500 INR

Closed
Posted almost 5 years ago

₹1500-12500 INR

Paid on delivery
Need an excel expert which can deliver result within 2-3 days for reconciliation of bank account with bank scroll receipts Bank scroll receipt is bifurcated in multiple branches which is been credited in bank account in different manner sometimes amount is a little different sometimes more then one amount of receipt is merged and credited in bank account and accounts can also be different I will provide you with the invoice wise sheet which will contain scroll date and receipt date for each invoice for scroll identification and also merged bank statement of all the accounts. There are around 6000 scrolls. Which are of around 49000 invoice. With around 25-30000 bank credits for the same. But it’s a complicated process so be sure that you can do this reconciliation and i need which invoice is received in bank against which credit amount. One credit can have more than one invoice. Add ‘orange’ in your description when you bid to know that you have read this description. Also amount can be a little different then actual in some cases. I need a full reconciliation report for this And in best possible time. I am also an excel expert but i am unable to do this so please be sure about completeness and bid only if you can do this.
Project ID: 20339813

About the project

20 proposals
Remote project
Active 5 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
20 freelancers are bidding on average ₹6,364 INR for this job
User Avatar
[orange] INR 2500 ONLY !!!!! [BBA & MBA in Accounting, Banker, Excel Expert] Sir, Please contact me, I can send you DRAFT project file to ensure my expertise. If you are 100% satisfied first, then award me the project. I have expertise in Excel Formula Generation, Excel VBA, Pivot Table, Chart, Graph etc. I have more than five years of real job experience of this kind of work. I will be very much grateful if I get the opportunity to work for you. Thanks, Anowar
₹2,500 INR in 2 days
4.9 (44 reviews)
4.4
4.4
User Avatar
I am a Chartered Accountant & Business Consultant. I have more than 5-year experience in the field of FINANCE, ACCOUNTING, AUDIT, RISK ASSESSMENT and BUSINESS MANAGEMENT. I have performed more than+50 accounts and business related assignment. I have audited financial institutions such as Insurance Companies, Leasing Companies and Banks, Currently, I am working as a Finance Executive in a leading roll in a technology-driven company Tech Access Pakistan Pvt Limited. I have also worked as a supervisor at the Audit and Assurance Department of Crowe Horwath Hussain Chaudhury & Co Chartered Accountants, Lahore Office, Pakistan I can provide you with all your required services including Business Plan Writing, Management Overview, Financial Statements in accordance with IFRS/GAAP, Financial Modelling (Budgeting and Forecasting), Financial Analysis, (SWOT, PESTAL,ICFR,CAR,CRR,LCR,Process Flow,Exposure, project risk profiling, value for money analysis transaction structuring and many others.
₹7,000 INR in 7 days
4.9 (25 reviews)
4.2
4.2
User Avatar
Proposal - Orange I will move all your excel data into my sql server. And then I can do anything using SQL Query. I am a database architect. I have more than 14 years of experience in various technologies as mentioned below: Database/Datawarehouse - SQL Server, Oracle, MySQL -- Proficiency (P4) BI - Microsoft MSBI and Informatica ETL -- Proficiency (P4) Dotnet - C# (core), ASP.Net (core), MVC, Javascripting etc... -- Proficiency (P3) Cloud - Azure (Paas and IaaS) -- -- Proficiency (P1) My Technical background • A goal-oriented professional with more than 14 years of experience in IT Database Management and Project Management specifically Airlines, Telecommunications and Health care domain • Having good amount of practical exposure on AngularJS, MVC, Javascript, ASP.Net with C#, VB.Net language and executed multiple projects independently. • Possess expertise in Data Warehouse/Data mart concepts, data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models • Experience in relational and dimensional data modeling using ERWIN, understanding of Ralph Kimball and bill Inmon methodology for dimensional modeling, star and snowflake schemas • Having depth knowledge of large database design techniques; experience in data analysis, data cleansing, and data transformation and migration using ETL tools;
₹12,000 INR in 4 days
5.0 (1 review)
2.4
2.4
User Avatar
"ORANGE" I have read all your details that you have mentioned. I have more than 4 years of experience in Data entry and fast typing (60+ speed without errors) and Recently i have completed Similar Task on ERPTALLY for my client so i know what you want. I feel fit for your project because i can complete this project on time. please feel free to contact me. Thank you Regards Rajnish Kumar
₹5,000 INR in 2 days
5.0 (1 review)
0.9
0.9
User Avatar
Hi, i have 3+ years exp in reconciliation of banks and vendors..i will allocate 2 full days for this project and complete in time with accuracy and with explanation. please let me know so that we can discuss further _"Orange"
₹5,555 INR in 2 days
5.0 (1 review)
0.4
0.4
User Avatar
Hi, I want to offer my service for this project. I do these type of project before. kindly com on pmb for more detail. regards, muhammad majid raza
₹1,500 INR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Because i am a banker. I have some experience of reconciliation in my bank. I was also a member of the reconsiliation team of my bank.
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, my name is CA Mayank. With long time experience (7+ years) with Finance, Accounting and especially with Quickbooks, some of my job experience are working remotely with several US companies. I am proficient is in these tasks: Financial Reports (Daily Banking Report, P&L, Forecast Reports), A/R, A/P, Bank Reconciliations, Payrolls, Invoice/Receipts, Billing etc.
₹9,900 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
'orange' HI, I just try understand your case in my last 11 years experience as an Audit, this bit reconciliation is depend to the goals it self. I ever had to reconcile of more than 15,000 sales invoice transaction and re-match which is cash payment, collect by collector, paid third party. Sometimes it killed us if the payment no reference. I see that your problems a little bit same, lot of data missing to reconcile as banks transfer didnt match against invoices and credit amount. as your mention, you also an excel expert, did you already categorized and sub categorized or leveling per case. it impossible to finish it up in 2-3 days. the realistic were 2 weeks if no leveling the case. Thanks, Brillian
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Orange! I am a CA Finalist and have vast experience of handling accounts on excel and complex data. So, i am sure i can do this quite easily
₹9,000 INR in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I am practicing chartered accountant in jaipur. I have been engaged in the field of accounting auditing since 5 years. My aim is to provide quality service to my clients on time.
₹2,777 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have total experience of 6+years as a Accounts person in different organizations. Looking forward to your positive response and expect to hear from your soon for an interview to further discuss my qualification and experience.I am available for an interview at a mutually convenient time.
₹1,500 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello I have experience working at public accountant firm as an accountant and an auditor for 5 years. I am used to working with ACL and Ms. Excel. It would be great if i can assist you. Let me know if you say yes.
₹8,888 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi There, I am excited to help you to complete this project. Having 5 years of experience in accounting & tax field, 1-year experience in teaching field (Tally ERP 9, Microsoft office) I am educated as CA IPCC & Bachelor of commerce degree and expert computer user. I have sound knowledge in MS Office products. My typing speed is outstanding in delivering this project on time. I can do Proof Read, Data Entry, Copy and Paste, Excel, Word, accounting, Filling of TAX returns & online forms, Formatting, Cleaning, Sorting, Conversion of PDF Excel, Word, Power point, Image file works of your data. I have done various outsourcing projects & I have created GST & MONTHLY ATTENDANCE TEMPLATES IN EXCEL. I am committed to providing high-quality service and interested in building a long run working relationship with you. Your 100% satisfaction will be my goal. So, no need to spend your time on searching. Chat with me ASAP and start your journey toward success we can discuss the data details and fields, delivery time. For more details please check my profile. Thank you.
₹7,555 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Between dozens of offers, I may be your best choice. Let’s give us a try and you will see. Best regards, Gentian
₹4,444 INR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
we are providing best services to our client. you can approach me for ur work.
₹7,777 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
"Orange" HI, I am a Chartered Accountant and i have read your description and trust me you have written it very precisely . i understood the work you want and why you want to do this. I know this is complicated task and laborious task but i believe i would be able to complete this task. Mail me your files and sit relax. Regards CA Arpit Goyal 7840058542
₹3,333 INR in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I Have 16yrs Accounting & excel Experience & promise to complete the project as per your requirement.
₹12,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I can work in excel with VBA tool or database work in access. Please share your details for completion of target.
₹7,000 INR in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Jul 14, 2018

Client Verification

Other jobs from this client

Company registration
₹600-1500 INR
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.