MMEX Discussion Forum

Posted: **Fri Jun 05, 2009 1:00 pm**

Hi folks.

Please send examples of lines of actual bank statements.
I hope it will be interesting and will help developers to improve the code.

Bank: VTB24 (Russia), CSV
Fields:
"Card Number", "date", "Data Processing", "The amount of the transaction," "Currency Transactions", "The Commission (RUR)"; "total account (RUR)"; "Reason"

Code: Select all

"0360";"11.04.2009 00:00:00";"11.04.2009";"12345";"RUR";"0";"12345";"Payment To Contract   salary"
"0360";"11.04.2009 00:00:00";"11.04.2009";"-9.96";"RUR";"0";"-9.96";"Client Loan Interests"
"0360";"11.04.2009 00:00:00";"13.04.2009";"-9500";"RUR";"0";"-9500";"ATM METROPOLITEN SPB, ROUBLE  332102"
"0360";"11.04.2009 00:00:00";"13.04.2009";"-9500";"RUR";"0";"-95";"Fee for Cash METROPOLITEN SPB, ROUBLE  332102"

Posted: **Thu Jun 25, 2009 7:19 pm**

Hi,

Here's a piece of mine

Opération number;"Ventilation";"Date";"Date of value";"check number";"P/R";"Tiers";Crédit;Débit;amount;Solde;"Catégory";"Sub-catégory";"Imputations budgétaires";"Sous-imputations budgétaires";"Remark";"accounting piece";"rapproaching number";"Info Bank";

130;"";"26/1/2009";"";"";"";"card 12345678901234";0;50,40;0;+120,21;"category";"";"";"";"card 12345678901234 23/01/09 wallmart";"";"";"";

It has been created from GRISBI, an open source project too.

I'm sorry for the poor translation of the accounting terms...
Hope it can help!

Posted: **Tue Sep 29, 2009 11:03 am**

Sample QIF file
http://linuxfinances.info/info/financeformats.html

Posted: **Thu Nov 05, 2009 6:44 pm**

I keep getting an error that says "One of the following fields: Date, Payee, Amount, Type is missing, skipping" for each line. I've tried a few variations, none of which works:

Code: Select all

What I really want:

Code: Select all

Date,Description,Payee,Category,Sub-Category,Type,Comments,Check Number,Amount,Balance
11/02/2009,CHECK # 1230,Dr Doctor,Health,Co-pay,Withdrawal,,1080,-$15.00,$1234.56
10/30/2009,MY EMPLOYER,Some Company,Income,Salary,Deposit,,,$1234.56,$2469.12
10/22/2009,CHECK # 1229,Dr. Dentist,Health,Dental,Withdrawal,,1079,-$175.00,$2294.12
10/21/2009,CHECK # 1228,Some Gym,Health,Fitness,Withdrawal,,1078,-$100.00,$2194.12
10/15/2009,MY EMPLOYER,Some Company,Income,Salary,Deposit,,,$1234.56,$3428.68

I thought I could use "Date,Notes,Payee, Category, SubCategory, Don't Care, Don't Care, Don't Care, Amount, Don't Care" For this but I'm getting the error. I don't see any column heading option for "type"! I tried importing what my bank actually gave me:

Code: Select all

"Date","Description","Comments","Check Number","Amount","Balance"
"11/02/2009","CHECK # 1080","","000001080","($15.00)","$1,234.56"
"10/30/2009","MY EMPLOYER","","","$1,234.56","$2,469.12"
"10/22/2009","CHECK # 1079","","000001079","($175.00)","$2,294.12"
"10/21/2009","CHECK # 1078","","000001078","($100.00)","$2,194.12"
"10/15/2009","MY EMPLOYER","","","$1,234.56","$3,428.68"

As "Date,Payee,Don't Care, Don't Care, Amount, Don't Care" But that doesn't work any better.

Any ideas about what I'm doing wrong here?

Posted: **Thu Nov 05, 2009 6:52 pm**

Another bank imports without error, but bungles the dates:

Code: Select all

CHECK,20091102120000[0:GMT],"CHECK 210",-3400.00
CREDIT,20091030120000[0:GMT],"EMPLOYER PAYROLL                    PPD ID: xxxxx",200.00
CREDIT,20091030120000[0:GMT],"EMPLOYER PAYROLL                    PPD ID: xxxxx",200.00
DEBIT,20091030120000[0:GMT],"CHECK # 0209      AT&T MOBILITY    CHECKPYMT         ARC ID: xxxxx",-195.70
DEBIT,20091029120000[0:GMT],"CHECK # 207       NATIONAL GRID NY CHECK PMT         ARC ID: xxxxx",-27.30
DEBIT,20091028120000[0:GMT],"CHECK # 0208     EXAMPLE           CHECK PYMT        ARC ID: xxxxx",-228.13
DEBIT,20091026120000[0:GMT],"Online Transfer to  MMA XXXXXX transaction#: xxxxx",-300.00
CREDIT,20091015120000[0:GMT],"EMPLOYER PAYROLL                    PPD ID: xxx9",200.00
CREDIT,20091015120000[0:GMT],"EMPLOYER PAYROLL                    PPD ID: xxx05",200.00
CHECK,20091008120000[0:GMT],"CHECK 205",-47.05

As "Category, date, Payee, Amount"

Posted: **Thu Nov 05, 2009 7:47 pm**

[*]OFX[*]

Posted: **Fri Feb 19, 2010 8:52 pm**

Hi

Can you please assist if the file only contains the above 3 fields????

Thanks

Date Payee Amount
27-6-2009 ITT 25

MMEX Discussion Forum

Examples of statements of account of real bank

Examples of statements of account of real bank

Re: Examples of statements of account of real bank

Re: Examples of statements of account of real bank

Re: Examples of statements of account of real bank

Re: Examples of statements of account of real bank

Re: Examples of statements of account of real bank

Re: Examples of statements of account of real bank