In Progress

Process a CSV File

We have a financial csv file containing financial details that will be extracted from paypal each month.

Your job would be to process this file and categorize and summarize the contents.

You would maintain in a simple database (could just be a text file) a list of rules concerning categorization and report accordingly.

Essentially this is just a data extraction project with the ability of the user to add/modify/delete their own categories and choose which field(s) and part of/all contents of these fields are "defined" as a category.

This gives the ability to assign their own categories to any transaction in the csv file.

The CSV file contains both debits and credits (sales, money transfers, refunds, purchases, etc).

A debit transaction is a minus figure, a credit transaction is a positive figure.

Fee's are paypal charges in a separate field and need to be tracked as well.

To categorize a specific transaction the user should select

a) debit or credit

b) The Type e.g. "Refund" or "Payment Sent" or "Payment Received" or "Subscription Payment Received" (there are many others) - This maps to a field in the CSV file.

In the case of debits

c) The name (another csv field) would "map" to a specific user specified category

d) the currency (USD, AUD, etc), gross amount, fees, and nett figures (all csv fields) would be retrieved

In the case of credits

e) The item title (if NOT empty) is the major classification for category

otherwise if title is empty then the name and from email address is used as the category

f) the currency (USD, AUD, etc), gross amount, fees, and nett figures

In the case of e) and f) all are csv fields.

Some types see b) above are not to be included in the processing (you would ignore this record and not include it in figures).

Unless a record is "excluded" as per the rule about it should always be included.

For each "category" of records about you maintain a separate running total.

Note the "Category" shown here is the user entered category (see below).

At the end of the file, you would create a summary file showing all categories, number of entries per category, and amounts (totals, and fees).

You would also create a new csv file containing a category code, date, and transaction reference (unique field in original CSV file).

Effectively this is all the "records" which have been processed, but assigned to their categories.

Another file would also be created containing all records that a category could not be found for (no rules were entered by the user). This is so the user could see the records, and then enter rules for these records, and re-process the csv file. Eventually this file would be empty as all records got categories.

All user specified categories would need to be permanently recorded in a database (might just be a text file) so that future processing uses these settings.

The user needs to be able to add/edit/delete these categories.

Finally, there needs to be a file that is created to record any tax payable or deductable for australian orders.

If an order is placed for a business in australia, 10% GSt is applicable, and if a customer makes a purchase and the live in australia, 10% GST is applicable.

This file would contain any records that meet this criteria so the relevant amount can be submitted to the tax department.

Both the details of each transaction and the overall total of GST for debits and total of GST for credits needs to be recorded, together with all transactions.

Determining whether a record is needing to be included as a "GST" transaction involves looking for several possibilities searches (all in the original csv file).

1) If the Country field has data in it, include if the value is "Australia"

2) If the email address for the record has "" as part of it.

3) If another field says "Non-US".

It will be a combination of 1 or more of these parameters.

There may be more minor functionality than listed here (to do with categories) but this is effectively what we are looking for.

The program can have a GUI Interface or just be command driven.

Any language is fine, but please indicate which language you will be using.


Skills: .NET, C# Programming, Java, Python, Visual Basic

See more: process csv file, create csv gui interface, csv file processing, csv processing, will process csv, create money transaction csv file using, what makes you unique, transaction charges, simple file database, sales job title, sales job in australia, sales job australia, reference paypal, purchase summary, paypal reference, paypal payment says pending, new job in australia, looking job in australia, looking for a job in australia, looking for a job australia, looking a job in australia, job searches australia, job searches, job it australia, job australian

About the Employer:
( 532 reviews ) Salisbury, Philippines

Project ID: #539988

Awarded to:


Hello,Please refer your [login to view URL] you.

$100 USD in 3 days
(62 Reviews)

91 freelancers are bidding on average $136 for this job


Pelase let me know

$200 USD in 5 days
(64 Reviews)

Professional solutions

$300 USD in 2 days
(198 Reviews)

I am an Expert in Automated Processing of CSV Files, and can start ASAP after a short discussion with you. I have completed 78 projects world-wide and got excellent reviews in each of them, you can read them in my p More

$50 USD in 1 day
(217 Reviews)

Hi, I can get it done for you. Please contact me by PM if you like to discuss. Best Regards, Yousef

$110 USD in 2 days
(67 Reviews)

Hello, I can do it for you. Please check my PMB. Thanks.

$50 USD in 2 days
(85 Reviews)

Can do this in VB if you send a sample file...willing to show demo also

$120 USD in 2 days
(88 Reviews)

Hello please see PMB

$250 USD in 0 days
(47 Reviews)

plz chk pm

$200 USD in 7 days
(28 Reviews)

Hi, I think I can do it in .NET:-)! Best regards, netcoder:-)

$111 USD in 11 days
(91 Reviews)

We can help in your project, please check PMB to see our related experience.

$225 USD in 3 days
(26 Reviews)

We at [login to view URL] work for clients which always have these kind of requirements. Please give us a chance to sere [login to view URL] will not be disappointed. Please contact us at [login to view URL] for more inf More

$45 USD in 3 days
(19 Reviews)

We have both passion & expertise to do the same.

$40 USD in 2 days
(15 Reviews)

Hi, I'm quite new in [login to view URL], but I have done some programming works in another coder website and have some good ratings there (link will be provided up on request) I'm interested to this project. I'm 7 ye More

$100 USD in 2 days
(27 Reviews)

I'm expert in data procesing.

$100 USD in 2 days
(13 Reviews)

I can help you

$200 USD in 10 days
(15 Reviews)

I am a Programmer for 5 years i can do this. and give you a perfect program.

$100 USD in 5 days
(16 Reviews)

I am an expert in python csv processing. I can well done this job for you, I will support my project for 1 year after the project complete, Glad to see your messages.

$30 USD in 2 days
(1 Review)

I can do this for you. Please check PM.

$100 USD in 5 days
(11 Reviews)

Hi, Please read your PMB. Regards,

$80 USD in 3 days
(26 Reviews)

Hi, Please check PMB. -Thanks, prodeZyners.

$200 USD in 2 days
(6 Reviews)