Em Andamento

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 ".com.au" 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.

Thanks

Habilidades: .NET, Programação C#, Java, Python, Visual Basic

Ver mais: 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

Acerca do Empregador:
( 532 comentários ) Salisbury, Philippines

ID do Projeto: #539988

Premiar a:

MAnkita

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

$100 USD em 3 dias
(62 Avaliações)
6.4

91 freelancers estão ofertando em média $136 para este trabalho

meetesh

Pelase let me know

$200 USD in 5 dias
(64 Comentários)
7.9
creatorul

Professional solutions

$300 USD in 2 dias
(198 Comentários)
7.8
rajtuhin1

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 Mais

$50 USD em 1 dia
(217 Comentários)
7.3
yousefla

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 dias
(67 Comentários)
7.2
guoxinliu917

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

$50 USD in 2 dias
(85 Comentários)
7.0
srinichal

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

$120 USD in 2 dias
(88 Comentários)
6.9
AlosDeveloper

Hello please see PMB

$250 USD in 0 dias
(47 Comentários)
6.7
phil999

plz chk pm

$200 USD in 7 dias
(28 Comentários)
6.3
netcoder

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

$111 USD in 11 dias
(91 Comentários)
5.9
SigmaVisual

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

$225 USD in 3 dias
(26 Comentários)
6.0
convergesystems

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

$45 USD in 3 dias
(19 Comentários)
5.6
nsurani

We have both passion & expertise to do the same.

$40 USD in 2 dias
(15 Comentários)
5.5
kevneth

Hi, I'm quite new in [url removed, login to view], 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 Mais

$100 USD in 2 dias
(27 Comentários)
5.4
gelo76

I'm expert in data procesing.

$100 USD in 2 dias
(13 Comentários)
5.1
Yurilad

I can help you

$200 USD in 10 dias
(15 Comentários)
4.9
DamithaKD

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

$100 USD in 5 dias
(16 Comentários)
4.9
hfeeki

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 dias
(1 Comentário)
4.8
pbq

I can do this for you. Please check PM.

$100 USD in 5 dias
(11 Comentários)
4.6
mneo

Hi, Please read your PMB. Regards,

$80 USD in 3 dias
(26 Comentários)
4.4
prodezyners

Hi, Please check PMB. -Thanks, prodeZyners.

$200 USD in 2 dias
(6 Comentários)
4.3