Here's a CSV from the Bank of Melbourne (Australia). They unhelpfully concatenate two fields (transaction type and transaction comment) in the second field of the CSV. \
Thank you for Reckon. Best, Peter On Friday, January 24, 2014 8:55:39 PM UTC+11, Edwin wrote: > > Hi all, > > Reckon needs your help :) > > Reckon automagically converts CSV files for use with the command-line > accounting tool Ledger. It also helps you to select the correct > accounts associated with the CSV data using Bayesian machine learning. > For more information see: > > http://blog.andrewcantino.com/blog/2010/11/06/command-line-accounting-with-ledger-and-reckon/ > > > We would like to expand reckon's ability to automagically convert csv > files. It already supports quite a few formats, but we are interested > in taking this further. For that we need more csv examples, so that we > can make sure those are correctly detected and especially make sure no > mistakes are made. You could really help us out by sending us > (anonimized) csv files as produced by your bank. We'd add those > examples to our test suite and make sure it all works well. Ideally, > we'd need a csv file containing a minimum of 5 transactions. > > The formats currently in the test suite are here: > > https://github.com/cantino/reckon/blob/master/spec/reckon/csv_parser_spec.rb#L207 > > > Full disclosure: I am not the original author, but have been > contributing code to make it correctly convert my csv files :) > > Cheers, Edwin > -- --- You received this message because you are subscribed to the Google Groups "Ledger" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
Date,Description,Debit,Credit,Balance 1/03/2014,Internet Withdrawal 01Mar06:59 Montly Expenses,1400,,21885.09 27/02/2014,Tfr Wdl BPAY Internet 27Feb08:52 770261292589460 Tax Office Payments,195,,23285.09 26/02/2014,Investment Fund Limited 90016438,,3552.5,23480.09 21/02/2014,Medical Insurance 20760784X,609.9,,19927.59 20/02/2014,Fund_2 30470935Cs,,2995.41,20537.49 19/02/2014,Paypal Australia J222222Eal3Nu,53.95,,17542.08 18/02/2014,Paypal Australia 5Hwj27U8P2Rce,60.88,,17596.03 18/02/2014,Visa Purchase 16Feb Bp Mansfield 2474 Mansfield,59.44,,17656.91 17/02/2014,Eftpos Purchase 16Feb10:07 Apvc Ltd Mansfield,150,,17716.35 15/02/2014,Atm Operator Fee Wdl 15Feb14:43 Bbl- Yea Yea Vic 03Au,2,,17866.35 15/02/2014,Atm Withdrawal 15Feb14:43 Bbl- Yea Yea Vic 03Au,300,,17868.35 13/02/2014,Visa Purchase 10Feb Paypal *Crkennedyco 402935773,658,,18168.35 10/02/2014,Tfr Wdl BPAY Internet 10Feb16:58 5444343301943764 Credit Card,46.47,,18826.35 6/02/2014,Fund_2 30470935Cs,,2995.41,18872.82 3/02/2014,Eftpos Purchase 03Feb16:14 Post Suburb Retail Post Shop Vic Au,8,,15877.41 1/02/2014,Internet Withdrawal 01Feb06:12 Montly Expenses,1400,,15885.41 1/02/2014,Internet Withdrawal 01Feb06:12 To 037-143 000647038,1300,,17285.41 29/01/2014,Rtgs Inward Payment Sgb14012903360011/Chambre De Commer,,8978.87,18585.41 29/01/2014,Tfr Wdl BPAY Internet 29Jan09:02 5444343301943764 Credit Card,1957.81,,9606.54 28/01/2014,Paypal Australia 5Hwj27Sdq8Rh2,,544.7,11564.35 28/01/2014,Eftpos Purchase 28Jan10:00 Post Suburb Retail Post Shop Vic Au,30,,11019.65 25/01/2014,Visa Purchase 23Jan Run Stop Shop Pl South Mel,79,,11049.65 24/01/2014,Atm Withdrawal -Wbc 24Jan10:26 Westpac Mdle Suburb3 Au,290,,11128.65 23/01/2014,Investment Fund Limited 90016438,,3552.5,11418.65 23/01/2014,Fund_2 30470935Cs,,2995.41,7866.15 9/01/2014,Tfr Wdl BPAY Internet 09Jan21:25 5444343301943764 Credit Card,279.78,,4870.74 9/01/2014,Internet Withdrawal 09Jan21:22 Inv 13274,78,,5150.52 9/01/2014,Fund_2 30470935Cs,,2995.41,5228.52 6/01/2014,Tfr Wdl BPAY Internet 06Jan10:30 1200004673294 Global Wallet,3300,,2233.11 2/01/2014,Internet Withdrawal 01Jan06:14 Montly Expenses,1400,,5533.11 2/01/2014,Internet Withdrawal 01Jan06:14 To 037-143 000647038,1300,,6933.11 31/12/2013,Visa Purchase 30Dec Hertz Australia P/L South Mel,127.52,,8233.11 31/12/2013,Visa Purchase 29Dec City Airport Tullamari,117.3,,8360.63 31/12/2013,Visa Purchase 29Dec Caltex City Airp City,10.95,,8477.93 30/12/2013,Visa Purchase 27Dec David Jones Limited Cheltenha,71.46,,8488.88 27/12/2013,Tfr Wdl BPAY Internet 27Dec20:43 5444343301943764 Credit Card,9928.14,,8560.34 27/12/2013,Eftpos Purchase 27Dec15:39 Fueltown Suburb P Highett Vi,95.27,,18488.48 27/12/2013,Eftpos Purchase 27Dec15:11 Shavershop Suburb Chetenham,40.96,,18583.75 27/12/2013,Eftpos Purchase 26Dec12:02 Teds Camera 40 City Au,729.95,,18624.71 24/12/2013,Fund_2 30470935Cs,,2968.27,19354.66 23/12/2013,Investment Fund Limited 90016438,,3552.5,16386.39 23/12/2013,Internet Withdrawal 22Dec09:04 Top-Up Joint Account,500,,12833.89 14/12/2013,Visa Purchase 13Dec Coles Suburb Vic,26.93,,13333.89 13/12/2013,Atm Withdrawal -Wbc 13Dec10:27 Westpac Suburb Nth 3 Au,300,,13360.82 12/12/2013,Internet Withdrawal 12Dec08:47 Dinner 3 December,85,,13660.82 12/12/2013,Tfr Wdl BPAY Internet 12Dec08:45 770261292589460 Tax Office Payments,16368,,13745.82 12/12/2013,Fund_2 30470935Cs,,2968.27,30113.82 11/12/2013,Internet Withdrawal 11Dec19:40 996111263393,756,,27145.55 10/12/2013,Doctor Somebody Jewler Tax Refund,,872.58,27901.55 7/12/2013,Internet Withdrawal 07Dec11:06 Invoice 13149,199.4,,27028.97 6/12/2013,Adelaide Uni 877854,,12298.2,27228.37 5/12/2013,Rtgs Inward Payment Sgb1312050307912Applecci : 00376973,,31.43,14930.17 3/12/2013,Visa Purchase 29Nov Apple Itunes Store Sydney,10.48,,14898.74 2/12/2013,Doctor Somebody Wbc Payt ,,2574,14909.22 2/12/2013,Doctor Somebody Wash Machine,,549.5,12335.22 2/12/2013,Internet Withdrawal 01Dec20:24 To 033-095 000228024,200,,11785.72 2/12/2013,Eftpos Purchase 01Dec15:56 Oasis Bakery Murrumbeena Vicau,12.6,,11985.72 2/12/2013,Eftpos Purchase 01Dec15:30 Discount store Av/It Chadstone Vi,1099,,11998.32 2/12/2013,Internet Withdrawal 01Dec10:18 Reception 23 Nov Part 2,148,,13097.32 2/12/2013,Internet Withdrawal 01Dec06:13 Montly Expenses,1400,,13245.32 2/12/2013,Internet Withdrawal 01Dec06:13 To 037-143 000647038,1300,,14645.32
