Examples of statements of account of real bank

Page 1 of 1
7 posts
Examples of statements of account of real bank

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
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"
Re: Examples of statements of account of real bank

Woodsman
New MMEX User

Posts: 3
Joined: Fri Jun 12, 2009 4:11 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! :mrgreen:
Re: Examples of statements of account of real bank

Nikolay
MMEX Developer

Posts: 2284
Joined: Sat Dec 06, 2008 8:27 am
Location: Sankt-Petersburg, Russia
Re: Examples of statements of account of real bank

amanda
New MMEX User

Posts: 4
Joined: Thu Nov 05, 2009 8:46 am
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?
Re: Examples of statements of account of real bank

amanda
New MMEX User

Posts: 4
Joined: Thu Nov 05, 2009 8:46 am
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"
Re: Examples of statements of account of real bank

elliswr
MMEX Developer

Posts: 151
Joined: Tue May 05, 2009 2:21 am
Location: Granbury, TX
[*]OFX[*]
Re: Examples of statements of account of real bank

jlkaram
New MMEX User

Posts: 1
Joined: Wed Feb 17, 2010 4:07 pm
Hi

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

Thanks

Date Payee Amount
27-6-2009 ITT 25
Page 1 of 1
Who is online

Users browsing this forum: No registered users and 16 guests