Fermé

Excel spreadsheet for credit card reconciliations

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.

Thanks

Compétences : Saisie de Données, Excel, HTML, PHP, Design de site internet

en voir plus : need template credit card, excel spreadsheet development need require, need someone convert excel spreadsheet web form, credit card statement reconciliation template, credit card reconciliation process, credit card reconciliation example, credit card tracking spreadsheet, excel reconciliation template, reconcile credit card receipts, credit card expense report template, business credit card reconciliation form, need buy virtual credit card, need credit card view webcam, need virtual credit card, need 1000 credit card, need credit card processor oscommerce, excel spreadsheet business card, excel credit card spreadsheet, excel spreadsheet credit card payments, transfer credit card statement data excel spreadsheet

Concernant l'employeur :
( 0 commentaires ) London, United Kingdom

Nº du projet : #18056779

26 freelance font une offre moyenne de £91 pour ce travail

jaylancer43

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 ( Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(636 Commentaires)
8.3
schoudhary1553

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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(278 Commentaires)
7.6
ponnarasiBabu

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(414 Commentaires)
7.4
sunsoftpro

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(161 Commentaires)
7.3
bdoutsource

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(180 Commentaires)
6.6
kevivu

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(77 Commentaires)
5.8
asadkhan3533

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(81 Commentaires)
5.7
periyannas

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(68 Commentaires)
5.7
choprac

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(98 Commentaires)
5.6
billpinder82

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(28 Commentaires)
5.2
citijayamala

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(59 Commentaires)
5.4
FerriSoft1

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(17 Commentaires)
5.2
khudammunir

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, Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(25 Commentaires)
5.1
aubrey03

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] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 3 jours
(54 Commentaires)
5.1
khurram1984

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(17 Commentaires)
4.3
chintuag

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 4 jours
(6 Commentaires)
3.8
Logo199

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(11 Commentaires)
3.8
paulodayto08

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 2 jours
(15 Commentaires)
3.4
dataexplorer

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 10 jours
(9 Commentaires)
2.9
bernardopoliv

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(4 Commentaires)
2.6