Examples of statements of account of real bank

Money Manager Ex Development related posts for both Android and Desktop

Moderator: Renato

Post Reply
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Examples of statements of account of real bank

Post by Nikolay »

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"
Woodsman
New MMEX User
Posts: 1
Joined: Fri Jun 12, 2009 10:11 pm

Re: Examples of statements of account of real bank

Post by Woodsman »

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:
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Examples of statements of account of real bank

Post by Nikolay »

amanda
New MMEX User
Posts: 2
Joined: Thu Nov 05, 2009 2:46 pm
Are you a spam bot?: No

Re: Examples of statements of account of real bank

Post by amanda »

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:
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?
amanda
New MMEX User
Posts: 2
Joined: Thu Nov 05, 2009 2:46 pm
Are you a spam bot?: No

Re: Examples of statements of account of real bank

Post by amanda »

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"
elliswr
Super MMEX User
Posts: 102
Joined: Tue May 05, 2009 8:21 am
Are you a spam bot?: No
Location: Granbury, TX

Re: Examples of statements of account of real bank

Post by elliswr »

[*]OFX[*]
jlkaram
New MMEX User
Posts: 1
Joined: Wed Feb 17, 2010 10:07 pm
Are you a spam bot?: No

Re: Examples of statements of account of real bank

Post by jlkaram »

Hi

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

Thanks

Date Payee Amount
27-6-2009 ITT 25
Post Reply