Reporting tool web app

We wish to develop a cakephp ([url removed, login to view]) or codeigniter ([url removed, login to view]) web app...either platform is ok for us. You should produce high quality, logical and modular code. Please produce logical class names and locations, and code should be placed into the right places (e.g. models/views/controllers)

>TECHNICAL DESCRIPTION (more general info provided below this section)

The app should provide a secure administration area and, when successfully logged in, allows user to:

1) Select two CSV files for upload from the local pc:

a) 'Payment processor monthly report'

b) 'Website sales report'

2) Enter currency conversion rate for sterling/dollar against the euro

3) Click Go, and the system will upload both spreadsheets

a) Consideration should be given to what will happen if, while processing, an error is encountered (e.g. if error, cancel upload and present report stating which rows caused an error)

4) When uploaded, the system should read in the data from the two uploaded CSV files, and generate two new CSV's for download:

a) 'sales report' -> detailed breakdown of all the sales, showing total amount invoiced (consolidated in Euros) and the total of VAT collected [default: sorted by currency/intracom/vat]

b) 'bank reconciliation report' -> pulls together the website and payment processor data to highlight any irregularities [default: sorted by currency and batch id]

NOTE: we will provide sample files for the two input files, and the desired two output files.


The goal is to create an application which allows us to do our bank reconciliation at the end of each month.

At the end of each month we can export 2 type of files:

Payment processor Realex Payment Report: This is an excel file that we manually download at the end of each

month from Realex Website (we can convert to CSV before upload to system). It contains all individual transactions that can be identified with a "Transaction ID". All transactions placed in one day are gathered in one single payment called Batch which also has an identification number.

Please note RE the payment processor monthly report file:

> amount are shown in Cents. (for example 18900 equals 189.00 euros or Sterling/Dollar)

> when you see "rebate" in the transaction column, it means that the transaction has been partially or entirely refunded.

> In the batch column, when you see -1 and not a Batch ID, it means that the transaction failed (card/payment was refused by the bank)

Webstore Sales Report: This is an .csv file that we export from Moviesoft at the end of each month.

Each transaction contains all order information (amount paid inclusive and exclusive of vat, date, name, invoice #,email,...) but also the "Transaction ID" which is used to do the link with the Realex Payement Report.

At the end of the processing we need to issue 2 reports:

1 ) Bank reconciliation report which allows us to check that all transactions placed on [url removed, login to view] have been correctly paid. We can also use this report to notice a problem with a payment (or double payment). For example a payment received but which doesn’t have any corresponding invoice on Moviesoft.com. In this report, transactions are sorted out by CURRENCY and BATCH ID (payment of the day)

2) Sales Report which is a detailed breakdown of all the sales sorted out by:


Intracom Sales

VAT Sales

This report also includes a total by currency and type of sales but also a general total in Euros. Therefore it is necessary to be able to type in before the treatment the currency exchange rate.

With this report, we are able to see the total amount invoiced (consolidated in Euros) and the total of VAT collected.

Thanks for reading.

Compétences : CakePHP, Codeigniter, PHP

Voir plus : codeigniter reporting tool, codeigniter report tool, reporting tool cakephp, reporting tool codeigniter, cakephp bank reconciliation, tool codeigniter, cakephp reporting, cakephp reporting tool, payment reporting codeigniter, what will you do for a dollar, what do you need to develop an app, web application with cakephp, web app develop, us bank check sample, to develop application in php what we need, report conversion tool, payment not received from bank, n equals, high quality names, file processor, dollar general locations, dollar general application, dollar bank, develop web app, c# web app

Concernant l'employeur :
( 16 commentaires ) Dublin, Ireland

N° du projet : #1668229

Décerné à :


expert codeigniter developer here. very much interested in this application. let's start

750 $ USD en 10 jours
(101 Commentaires)

21 freelance font une offre moyenne de $618 pour ce travail


Hello,We have 5+ years Cakephp [url removed, login to view] to provide mentioned app with all feature [url removed, login to view] check pmb for more [url removed, login to view]

700 $ USD en 28 jours
(200 Commentaires)

Experienced and serious team specialize working in any Open Source like wordpress, joomla, Open Cart etc., latest web trends like RSS, WEB 2.0 standard, PHP Frameworks like Yii, Zend, CakePHP, CodeIgniter, Seagull, Sym Plus

1000 $ USD en 30 jours
(80 Commentaires)

lets do this

600 $ USD en 10 jours
(92 Commentaires)

Hi i am very much interested in your project. please check pmb.

600 $ USD en 15 jours
(225 Commentaires)

(Please Check Our Reviews)Customer Satisfaction is Our [url removed, login to view] have an excellent and dedicated Team of software/web developers, designers, seo experts etc. We are expertise in web/software development for more than 4 Plus

599 $ USD en 18 jours
(22 Commentaires)

Please see pmb. Thanks

475 $ USD en 25 jours
(17 Commentaires)

Value addition is our differentiation.

850 $ USD en 14 jours
(7 Commentaires)

Hi Please check our offer at your private message. Regards, Eclipse Technology Solutions

450 $ USD en 12 jours
(13 Commentaires)

Dear Sir, Eulogik is a new age web based product/solution development company. Here, we ideate, brainstorm, prototype, iterate, design, develop and launch web 2.0 applications using cutting edge web technologies. We Plus

550 $ USD en 45 jours
(1 Commentaire)

Hi, This is Jeni from bistech support. We would like to inform you that we could able to develop this design project. Please find the attached document for your reference. our ball park quote is 250 US Plus

250 $ USD en 3 jours
(18 Commentaires)

Dear sir, i am CakePHP Expert an di can do for you this reporting module which take the 2 CSVs input and output your needed reports .... i am on skype now to discuss this Thanks

700 $ USD en 5 jours
(5 Commentaires)

Quick and professional work. Dramin team. Check PM.

500 $ USD en 15 jours
(1 Commentaire)

Hello, My name is Mayank, a technical team leader from E-citius Infotech Pvt Ltd. I'm interested in the position of "Cake Php Developer" you recently posted. During past 5 years we have designed, developed & manag Plus

1000 $ USD en 25 jours
(2 Commentaires)

I know exactly what you need. Please read my message in your PMB. Thank you.

450 $ USD en 15 jours
(2 Commentaires)

Hello Sir, I know you don't even see my profile because am new to freelancer. If you have glance of time please see my below small details. I am promising that you will satisfy 100%, because am very much expert Plus

850 $ USD en 20 jours
(0 Commentaires)

Hello Sir, Please check PMB for listing and confident to complete the project with quality services.. Best Regards

600 $ USD en 10 jours
(0 Commentaires)


300 $ USD en 4 jours
(0 Commentaires)

We are a global services company offering business and knowledge processing services to organizations seeking higher operational effectiveness, greater flexibility and lower operating costs.

750 $ USD en 35 jours
(0 Commentaires)


600 $ USD en 5 jours
(0 Commentaires)

I have the necessary experience, skills and abilities.

400 $ USD en 10 jours
(0 Commentaires)