Need help with creating an excel spreadsheet for credit card [login to view URL] is basically to reconcile what we have posted as paid via credit cards in system to what we have received the money for in bank. Sounds simple, but it is not.
In system, interface posts credit card transaction with unique reference no but no credit card no.
we log in to interface to get details of the last 4 digits of the card used for that unique reference no.
third party website which processes and pays money into the bank only use last 4 digits of the credit card.
so we have to reconcile cc payments in a system which only has unique reference no to payments made by third party which only shows last 4 digit. unique reference no is translated to last 4 digits of the cc by going to the interface website.
i need a complete solution where i can know exactly for which transactions in the system we have received and which we have not.
there are further complications which we can discuss later. Because of the nature of work i only need verified experience members to contact.
Bu iş için 26 freelancer ortalamada £91 teklif veriyor
Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Daha Fazla
Hello, Hope you are doing well. I can help with you in your project Excel spreadsheet for credit card reconciliations. I can assure you the quality job. I have good experience in Data Entry, Excel, HTML, PHP, Daha Fazla
I read and understood your requirements - Excel spreadsheet for credit card reconciliations and would like to discuss more about the project. So i hope you would open a PM to discuss about the work . Regards, Ponsi
Hi Employer, I have read your description and been interested in the project. Basically, you need a script that gets the list of transactions (classify to paid and unpaid) and extracts the last 4 digits of the card nu Daha Fazla
Dear Sir, Greetings. No matter how complicated to find the best solution, skilled enough in Excel. I got few points from the description, however, few resources would help lot. Ready to start now and complete fas Daha Fazla
Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis Daha Fazla
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Sure. I can help. Willing to take up your project. Thank you, Regards.
Hi, Hope you are doing well, I read your project description and I'd like to discuss it because right now, I'm working on the same kind of project of credit card statement reconciliation. The bid is estimated, can co Daha Fazla
Good afternoon, my name is William Pinder. I am an Excel specialist with 10 years of professional experience. I operate a web development and Excel consulting service in Ontario, Canada. I have read your project desc Daha Fazla
1. I am an expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex mar Daha Fazla
Would you mind creating some sample files with muck up data, meaning like only 10 rows of data per file, and some numbers/names changed (for your security) With a sample of data I can create a proof of concept to sh Daha Fazla
Hi I would like to bid for this project. I posses Data Analytics, Research, Accountancy, Administration, Banking, Financial/Business Analysis & Reporting and Content Writing experience with Advance MS Excel Dashboards, Daha Fazla
I am an Excel and VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] Daha Fazla
Hi. I am an affiliate chartered accountant (equivalent to CPA) and a finance professional since 2009. I am currently working with clients based in US, UK, Canada, Pakistan etc on QuickBooks to maintain their books of a Daha Fazla
Dear Hiring Manager, I have worked on various automation projects in Excel using VBA and I'm sure we could automate this process also. I would like to discuss in detail to have a complete understanding of the proje Daha Fazla
I have total 7 years of working experience in process mapping , process documentation , data entry , data analysis and expert in MS office application including MS word , MS powerpoint , MS excel , Photoshop , Adob Daha Fazla
Hi Good Day! A serious freelancer here! I can help you to complete your Excel works in 1-2 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it Daha Fazla
Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional work Daha Fazla
Hello! I am very interested in this project. As an economist and VBA & Python developer, I think Ive got the skill set required do complete this task. Hopefully, you will give me a chance to show my work. Thank you v Daha Fazla