Can anyone help me with the database structure of a personal finance application?
magochi
0
Newbie Poster
Recommended Answers
Jump to PostHere 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 CodeThat should be the basic design, but I would recommend additional tables for transaction type, reason codes, etc.
Jump to PostThe 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
All 5 Replies
timothybard
12
Posting Whiz
magochi
0
Newbie Poster
stock-guy
0
Newbie Poster
barzeer
0
Newbie Poster
magochi
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.