Please find attached a couple of csv files, one from a Broker in Canada, the second is an export of Intuit Mint web app. Much appreciate the work you are doing! If any questions, let me know. (Note the date format in the mint file is US:MM/DD/YYYY.)
Boyd On Fri, Jan 24, 2014 at 1:55 AM, Edwin van Leeuwen <[email protected]>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. > -- Boyd Kelly <[email protected]> Coast Business Technologies <http://www.coastsystems.net> C: 604.837.0765 W: http://www.coastsystems.net -- --- 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.
Transaction Type=All,Product Type=All,Symbol=,From=2012-03-01,To=2014-02-11 Transaction Date,Settlement Date,Activity Description,Description,Symbol,Quantity,Price,Currency,Total Amount,Currency ----------------,---------------,--------------------,-----------,------,--------,-----,--------,------------,-------- 2014-02-10,2014-02-10,Interest,ISHARES S&P/TSX CAPPED REIT IN,XRE,179,,,12.55,CAD 2014-01-16,2014-01-16,Reinvestment,ISHARES GLOBAL AGRICULTURE IND,COW,3,,,-81.57,CAD 2014-01-16,2014-01-16,Contribution,CONTRIBUTION,,,,,600.00,CAD 2014-01-16,2014-01-16,Interest,ISHARES GLOBAL AGRICULTURE IND,COW,200,,,87.05,CAD 2014-01-14,2014-01-14,Reinvestment,BMO NASDAQ 100 EQTY HEDGED TO,ZQQ,2,,,-54.72,CAD 2014-01-07,2014-01-10,Sell,BMO NASDAQ 100 EQTY HEDGED TO,ZQQ,-300,27.44,CDN,8222.05,CAD 2014-01-07,2014-01-07,Interest,BMO S&P/TSX EQUAL WEIGHT BKS I,ZEB,250,,,14.00,CAD 2013-07-02,2013-07-02,Dividend,SELECT SECTOR SPDR FD SHS BEN,XLB,130,,,38.70,USD 2013-06-27,2013-06-27,Dividend,ICICI BK SPONSORED ADR,IBN,100,,,66.70,USD 2013-06-19,2013-06-24,Buy,ISHARES S&P/TSX CAPPED REIT IN,XRE,300,15.90,CDN,-4779.95,CAD 2013-06-17,2013-06-17,Contribution,CONTRIBUTION,,,,,600.00,CAD 2013-05-22,2013-05-22,Dividend,NATBK,NA,70,,,58.10,CAD
"Date","Description","Original Description","Amount","Transaction Type","Category","Account Name","Labels","Notes" "2/10/2014","Dn Ing Inv","[DN]ING INV/PLA","0.01","credit","Investments","Chequing","","" "2/10/2014","Ib Granville","[IB] 2601 GRANVILLE","100.00","debit","Uncategorized","Chequing","","" "2/06/2014","So Pa","[SO]PA 0005191230116379851","140.72","debit","Mortgage & Rent","Chequing","","" "2/03/2014","Ds Lms Msp Condo","[DS]LMS598 MSP/DIV","331.63","debit","Condo Fees","Chequing","","" "2/03/2014","Dn Sun Life","[DN]SUN LIFE MSP/DIV","943.34","credit","Income","Chequing","","" "1/30/2014","Transfer to CBT (Savings)","[CW] TF 0004#3409-797","500.00","debit","Transfer","Chequing","","" "1/30/2014","Costco","[PR]COSTCO WHOLESAL","559.96","debit","Business Services","Chequing","",""
