openoffice base - database structure with multiple bank statements -

okay, designing database hold transactions , types, receipts received , bank account statements.

first step receipts input , transaction type created (cash/food/clothes/ect). receipt has multiple trans type records. second step match transactions in bank statements (unless cash) receipts (if any) , existing transaction type or create new one.

i going upload statements multiple accounts in multiple banks csv's , import them db.

my problem can't db structure feels right. could:

• have separate table each acct/bank feels wrong.
• combine csvs 1 acct/bank unique id.
• combine csvs single.

this should simple design problem can't seem work out.

i'm using openoffice base + other apache apps.

any appreciated.

perhaps below table names in caps column names below each table (top column name each table primary key).

statements

• statementid
• bank
• statementdate

statement_details

• sdetailid
• statementid
• detaildate
• store
• amount

ttypes

• typeid
• transactiontype

receipts

• receiptid
• store
• receiptdate

transactions

• transactionid
• receiptid
• typeid
• amount

so in scheme, complete listed fields normally: primary keys autoincrement, form/subform linking utilized fill in foreign keys possible, , remaining fields input user.

at point run sort of query or script match store name, receipt date, , amount receipts , transactions tables counterparts in statement_details table. view results query, or save sdetailid in transactions table, or save transactionid in statement_details table.

you have work out how data various csv files statements , statement_details tables.