Find Jobs
Hire Freelancers

Write Excel Macro to Automate Bank Reconciliation

$30-250 USD

Folyamatban
Kiadva ekkor: körülbelül 5 évvel ezelőtt

$30-250 USD

Teljesítéskor fizetve
I am looking for someone to write a macro that will automate my bank reconciliations by matching transactions exported from a bank account with transactions exported from an ERP. The macro will review bank statements and ERP statements; compare them; match off same items and list out outstanding items (items that were left umatched). In order to fully understand and execute this project, an understanding of the bank reconciliation process is an added advantage and will make it a lot easier for you to write the macro. So please take some time to read up this accounting process. I have attached several files to facilitate the understanding of the task and the desired output.
Projektazonosító: 18567183

A projektről

18 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
Hi, I am an Excel Expert with very good knowledge of VBA. I can do this automation of bank reconciliation. Please come on chat for more details. Thank you Awaiting your response.
$80 USD 3 napon belül
4,3 (40 értékelés)
4,5
4,5
18 szabadúszó adott átlagosan $182 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without changing my bid or playing games. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly and at my FIRST BID. I promise to deliver 100% Satisfaction.I have more than 5 year of experience in Accounting, Excel, Excel Macros, Excel VBA, Microsoft. Please ping me for more discussion.
$250 USD 4 napon belül
4,9 (289 értékelés)
7,7
7,7
Felhasználó avatár
Hi, I have excellent experience in preparing vba based reconciliation tools and can do a bank reconciliation tool with perfection. This tool will take your previous bank reconciliation, match any outstanding amounts, match new amounts cashBook vs Bank, enlist any new outstanding amounts and make new reconciliation. Thanks
$250 USD 14 napon belül
4,9 (129 értékelés)
7,0
7,0
Felhasználó avatár
I would like to suggest to you an Excel application which enables you to reconcile and manage databases in a spreadsheet. You can record the information by hand or by uploading databases, into a master file with a possibility to review/update them in the excel. There is a search engine with high search capability and during the process, Excel validates the information and prepares opened/closed transactions reports and export files based on parameters and criteria. There is a report generator which enables to develop templates independently. The system is secured with usernames and passwords.
$250 USD 3 napon belül
4,9 (80 értékelés)
6,9
6,9
Felhasználó avatár
Greetings! I am qualified Accountant and Excel expert with ten years of experience in working with macros. Please PM to discuss further. Thank you.
$155 USD 3 napon belül
4,8 (82 értékelés)
6,9
6,9
Felhasználó avatár
Hi, You won’t make the right candidate selection without knowing what your project on writing Excel macro that will automate your bank reconciliations by matching transactions exported from a bank account with transactions exported from an ERP will look like. Fortunately, I can show you how your job will look like before you award the project. I have vast experience working on similar projects and I am confident I can exceed your expectations. I am passionate about flawless results and I can assure you of a job well done. I am ready to start working on the sample right away. Will you be available for a quick chat? Thanks for your time
$200 USD 3 napon belül
4,8 (44 értékelés)
6,0
6,0
Felhasználó avatár
Hello, I am Excel and VBA expert. I can do it in VBA (Excel VBA macros). If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 80 projects. Jan
$200 USD 5 napon belül
5,0 (79 értékelés)
5,8
5,8
Felhasználó avatár
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. I have worked in brs in ERP implementation. Also, I have delivered BRS excel based solution recently. Hope that experience will help me to deliver you a good solution. Willing to take up your project. Thank you, Regards.
$200 USD 4 napon belül
4,9 (82 értékelés)
6,0
6,0
Felhasználó avatár
I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$200 USD 3 napon belül
4,9 (72 értékelés)
5,7
5,7
Felhasználó avatár
am not a random bidder.. Please ping me if you are interesetd with my proposal and share more detail.. thank you..
$250 USD 5 napon belül
4,9 (24 értékelés)
5,0
5,0
Felhasználó avatár
I have 10 years experience with Data Processing in Excel. I work with: Excel Data Processing Data Collecting (Using Macro) MS Office VBA Excel VBA Macro Automation User Forms Data Analyzing PivotTable Chart Data Presentations And any task related to Excel Feel free to contact me. Thanks and Regards Mst. Ruma Aktar
$50 USD 3 napon belül
5,0 (32 értékelés)
5,0
5,0
Felhasználó avatár
Hi, I have gone through your requirements. I understood the process of matching. I am really excited to make this excel. I have worked as a quantative analyst in a bank for last 7 years. I have done similar projects multiple times. We can chat more if you are interested. Thanks, Arpan
$77 USD 3 napon belül
4,9 (59 értékelés)
4,4
4,4
Felhasználó avatár
Hello mate, I have ability to do this project: Excel VBA, Microsoft, Excel Macros, Excel I always: -Do project fast as possible. -Charge a reasonable cost. -Provide Quality Product. All my previous project was feedbacked 5 stars. because i CARE the customer feeling. so please give me a chance to work with you.
$158 USD 3 napon belül
5,0 (4 értékelés)
3,8
3,8
Felhasználó avatár
hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. I feel fit myself for this project. please contact with me. Thanks.
$100 USD 1 napon belül
4,7 (21 értékelés)
4,1
4,1
Felhasználó avatár
Hi there, Hope you are doing well. If you switch on Google sheets then you can save your time anf system dependencies. I can also provide best solution to you for your problem and can do it ASAP. Regards Rahul
$278 USD 3 napon belül
5,0 (1 értékelés)
1,0
1,0
Felhasználó avatár
Hello, I am a professional VBA developer plus I have understanding of bank domain as well. I can create macros to automate and implement the reconciliation process. I have 10 years of experience in working with excel, creating macros etc and once awarded this project, I am set to exceed your expectations. Please ping me for any queries. Thanks. Regards Mohd F.
$200 USD 5 napon belül
5,0 (2 értékelés)
0,5
0,5
Felhasználó avatár
Hello. I am very interested in your project. I have full experience in Excel, VBA, Macro. You can know my skills if you see my profile. If you hire me, I will provide you good result. I want to discuss details on chat. Best Regards.
$155 USD 3 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hello Sir or Madam: I use regular expressions to do it. I have already work this kind of jobs. I have been working with Excel for long time. I just need to know INPUTS and OUTPUTS, I am certied as chartered accountant from my secondary school. In short, ASAP I finish ASAP I deliver, aprox. 3 days. fixed price. post-sales service. I wait for your contract. Sincerley yours.
$222 USD 10 napon belül
0,0 (1 értékelés)
0,0
0,0

Az ügyfélről

NIGERIA zászlója
Lagos, Nigeria
4,9
4
Fizetési mód hitelesítve
Tagság kezdete: febr. 18, 2013

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.