Fermé

Excel VBA project

Create a script in excel to compare and match/reconcile credit card transactions with the payment report.

We are a retail outlet where we have several customers making payment with their credit card. There are approximately 200 transactions per day. These transactions are recorded in the Point of Sale (POS) billing/cashiering machine.

The following day we receive payment from the bank for all the credit card transactions along with the details of the credit card. The details of the paid transactions are mentioned in the 'Credit Card Settlement' report.

The credit card settlement report needs to be reconciled & matched with the POS sale report and identify if any transaction is not paid. The matching is done based on amount and last 4 digits of the credit card number.

Both the POS transaction report and Credit Card settlement report is available in excel and we require a vba program to identify which transactions are paid and which are not.

Compétences : Excel, Visual Basic

En voir plus : excel vba project 2007, excel vba project plan, excel vba project search engine, fun excel vba project, finalize excel vba project, excel vba xml create xml document, 1st excel vba project, excel vba project schedule, excel vba project description, online excel vba project india, sample excel vba project, create help file excel vba project, excel vba project online work 2009, clean excel vba project, excel vba project ideas, excel vba project import, test unlock excel vba project

Concernant l'employeur :
( 0 commentaires ) Dubai, United Arab Emirates

Nº du projet : #31531234

52 freelances font une offre moyenne de 382 $ pour ce travail

(834 Commentaires)
8.9
(436 Commentaires)
8.3
(253 Commentaires)
8.2
P0L

(480 Commentaires)
8.0
(357 Commentaires)
7.3
(468 Commentaires)
7.3
(310 Commentaires)
7.4
(217 Commentaires)
7.0
VladimirLilenko

Hello! I will do it quickly and efficiently! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Excel, of course, familiar. Regards, Vladimir

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(169 Commentaires)
6.8
(169 Commentaires)
6.9
(152 Commentaires)
6.6
(142 Commentaires)
6.4
(32 Commentaires)
5.8
AccountantArman

"Sir, Sir i can write this VBA Script which will be 100% free of error. I am Excel VBA and Coding Advanced Level Expert. This is basic work for me. I can complete this project with added quality. About me I am a Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(106 Commentaires)
6.0
(118 Commentaires)
6.0
(21 Commentaires)
5.5
VBAautomation

Hi, I hope you are doing well I am a professional on SQL server, VBA programming, MS access and also in power BI. I am doing this job since 2010.I can handle your project in a very prudent manner. Give me more details Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(19 Commentaires)
5.3
(29 Commentaires)
5.2
dhanrajkarthick

Hi there, I can help you to reconcile the credit card transactions with the payment report. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Kindly go through my profile. Awaiting for your res Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(40 Commentaires)
5.1
(45 Commentaires)
5.3