Can anyone help me with the database structure of a personal finance application?

Recommended Answers

Here are just some ideas:

Bank: ID, Name, Address, etc
Account: ID, Account number, Bank, Type, Parent Account?
Transaction: ID, Date, Source Account, Destination Account, Amount, Transaction Code

That should be the basic design, but I would recommend additional tables for transaction type, reason codes, etc.

Jump to Post

The Checkbook Register for Excel is a simple, easy-to-use spreadsheet for recording your pending, cleared and cancelled checks. Pre-loaded formatting includes a red font for incorrectly entered amounts

Jump to Post

All 5 Replies

Here are just some ideas:

Bank: ID, Name, Address, etc
Account: ID, Account number, Bank, Type, Parent Account?
Transaction: ID, Date, Source Account, Destination Account, Amount, Transaction Code

That should be the basic design, but I would recommend additional tables for transaction type, reason codes, etc.

Thanks for your help!

The Checkbook Register for Excel is a simple, easy-to-use spreadsheet for recording your pending, cleared and cancelled checks. Pre-loaded formatting includes a red font for incorrectly entered amounts

I already finished my project. Thanks a lot anyway!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.