Đã hoàn thành

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.

Kỹ năng: CakePHP, Codeigniter, PHP

Xem thêm: 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

Về Bên Thuê:
( 16 nhận xét ) Dublin, Ireland

Mã Dự Án: #1668229

Đã trao cho:


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

$750 USD trong 10 ngày
(101 Đánh Giá)

21 freelancer đang chào giá trung bình $618 cho công việc này


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 trong 28 ngày
(200 Đánh Giá)

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 Thêm

$1000 USD trong 30 ngày
(80 Đánh Giá)

lets do this

$600 USD trong 10 ngày
(92 Đánh Giá)

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

$600 USD trong 15 ngày
(225 Đánh Giá)

(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 Thêm

$599 USD trong 18 ngày
(22 Đánh Giá)

Please see pmb. Thanks

$475 USD trong 25 ngày
(17 Đánh Giá)

Value addition is our differentiation.

$850 USD trong 14 ngày
(7 Đánh Giá)

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

$450 USD trong 12 ngày
(13 Đánh Giá)

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 Thêm

$550 USD trong 45 ngày
(1 Đánh Giá)

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 Thêm

$250 USD trong 3 ngày
(18 Đánh Giá)

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 trong 5 ngày
(5 Đánh Giá)

Quick and professional work. Dramin team. Check PM.

$500 USD trong 15 ngày
(1 Đánh Giá)

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 Thêm

$1000 USD trong 25 ngày
(2 Đánh Giá)

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

$450 USD trong 15 ngày
(2 Đánh Giá)

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 Thêm

$850 USD trong 20 ngày
(0 Đánh Giá)

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

$600 USD trong 10 ngày
(0 Đánh Giá)


$300 USD trong 4 ngày
(0 Đánh Giá)

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 trong 35 ngày
(0 Đánh Giá)


$600 USD trong 5 ngày
(0 Đánh Giá)

I have the necessary experience, skills and abilities.

$400 USD trong 10 ngày
(0 Đánh Giá)