Kapalı

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

Beceriler: Veri Girişi, Excel, HTML, PHP, Web Sitesi Tasarımı

Daha fazlasını gör: 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

İşveren Hakkında:
( 0 değerlendirme ) London, United Kingdom

Proje NO: #18056779

Bu iş için 26 freelancer ortalamada £91 teklif veriyor

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 ( Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(636 Değerlendirme)
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, Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(278 Değerlendirme)
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

in %bids___i_period_sub_35% gün içinde111%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(414 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(161 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(180 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde72%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(77 Değerlendirme)
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

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(81 Değerlendirme)
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.

in %bids___i_period_sub_35% gün içinde133%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(68 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(98 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde150%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(59 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
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, Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(25 Değerlendirme)
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] Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(54 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde75%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(17 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde98%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(6 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde83%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(15 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(9 Değerlendirme)
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 Daha Fazla

in %bids___i_period_sub_35% gün içinde70%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)
2.6