Find Jobs
Hire Freelancers

Write Excel Macro to Automate Bank Reconciliation

$30-250 USD

En curso
Publicado hace alrededor de 5 años

$30-250 USD

Pagado a la entrega
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.
ID del proyecto: 18567183

Información sobre el proyecto

18 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 3 días
4,3 (40 comentarios)
4,5
4,5
18 freelancers están ofertando un promedio de $182 USD por este trabajo
Avatar del usuario
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 en 4 días
4,9 (289 comentarios)
7,7
7,7
Avatar del usuario
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 en 14 días
4,9 (129 comentarios)
7,0
7,0
Avatar del usuario
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 en 3 días
4,9 (80 comentarios)
6,9
6,9
Avatar del usuario
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 en 3 días
4,8 (82 comentarios)
6,9
6,9
Avatar del usuario
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 en 3 días
4,8 (44 comentarios)
6,0
6,0
Avatar del usuario
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 en 5 días
5,0 (79 comentarios)
5,8
5,8
Avatar del usuario
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 en 4 días
4,9 (82 comentarios)
6,0
6,0
Avatar del usuario
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 en 3 días
4,9 (72 comentarios)
5,7
5,7
Avatar del usuario
am not a random bidder.. Please ping me if you are interesetd with my proposal and share more detail.. thank you..
$250 USD en 5 días
4,9 (24 comentarios)
5,0
5,0
Avatar del usuario
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 en 3 días
5,0 (32 comentarios)
5,0
5,0
Avatar del usuario
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 en 3 días
4,9 (59 comentarios)
4,4
4,4
Avatar del usuario
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 en 3 días
5,0 (4 comentarios)
3,8
3,8
Avatar del usuario
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 en 1 día
4,7 (21 comentarios)
4,1
4,1
Avatar del usuario
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 en 3 días
5,0 (1 comentario)
1,0
1,0
Avatar del usuario
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 en 5 días
5,0 (2 comentarios)
0,5
0,5
Avatar del usuario
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 en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 en 10 días
0,0 (1 comentario)
0,0
0,0

Sobre este cliente

Bandera de NIGERIA
Lagos, Nigeria
4,9
4
Forma de pago verificada
Miembro desde feb 18, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.