Transaction Flow

[masudur-rahman]

[masudur-rahman]

Expense Tracker

System Entities

Accounts:

• Type {Cash, Bank, Person}
• BalanceID
• Name
• Balance
• LastTxnAmount
• LastTxnTimestamp

UserDebts:

• Name
• Email
• Contact Info
• Balance
• LastTxnTimestamp

Debtors:

• DebtorID
• Amount
• PaymentMode {Bank, Cash}
• BankID
• Date
• Remarks

Creditors:

• CreditorID
• Amount
• PaymentMode {Bank, Cash}
• BankID
• Date
• Remarks

Transactions:

• Amount
• SubcatagoryID
• Type {Expense, Income, Transfer}
• SourceID
• DestID
• Person
• Date
• Remarks

TxnCategory:

• CatID
• Name

TxnSubcategory:

• SubCatID
• Name
• CatID

Categories and Subcategories:

Food: food Restaurants (rest) Groceries (grocery) Takeout (takeout) Snacks (snacks) Fruits (fruits) Housing: house Rent (rent) Utilities (utility) Furniture () Electronics Real State Entertainment: ent Movies Subscription Recreation Books Personal Care: personal Salon Toiletries Gym Clothing Health Travel: travel Accommodation Dining Sightseeing Transportation Gifts Miscellaneous: misc Withdraw DPS Credit Card Payment Bank Transfer Giveaway Misc

---

Categories and Subcategories:

Food: -> food Restaurants -> food-rest Groceries -> food-groc Takeout -> food-take Snacks -> food-snack Fruits -> food-fruit

Housing: -> house Rent -> house-rent Utilities -> house-util Furniture -> house-furn Electronics -> house-elec Real State -> house-real

Entertainment: -> ent Movies -> ent-movie Subscription -> ent-sub Recreation -> ent-rec Books -> ent-books

Personal Care: -> pc Salon -> pc-salon Toiletries -> pc-toilet Gym -> pc-gym Clothing -> pc-cloth Health -> pc-health

Travel: -> trv Accommodation -> trv-accom Dining -> trv-dine Sightseeing -> trv-sight Transportation -> trv-trans Gifts -> trv-gift

Financial: -> fin Salary -> fin-sal Withdraw -> fin-with DPS -> fin-dps Credit Card Payment -> fin-ccpay Bank Transfer -> fin-bank Loan -> fin-loan Borrow -> fin-borrow

Miscellaneous: -> misc Giveaway -> misc-give Misc -> misc-misc

---

System Entities

Accounts:

• Type {Cash, Bank}
• BalanceID
• Name
• Balance
• LastTxnAmount
• LastTxnTimestamp

User:

• Name
• Email
• Contact Info
• Balance
• LastTxnTimestamp

Transactions: {Also will be used for Debts and Credits as expense and income, but will be mentioned in subcategory}

• Amount
• SubcatagoryID
• Type {Expense, Income, Transfer}
• SourceID
• DestID
• User
• Date
• Remarks

TxnCategory:

• CatID
• Name

TxnSubcategory:

• SubCatID
• Name
• CatID

There would be different types of transcations in system.

• Loan and Borrow will be of Expense and Income type respectively.
  • There would be a person involved
  • Either SrcID(for Loan) or DstID(for Borrow) will be used.
  • A person will be used to determine who else is involved
  • Loan and Borrow will be set in the Subcategory type
• Transfer
  • Both SrcID and DstID will be used.
  • Subcategory will be of Withdraw or Bank Transfer
• For Salary
  • DstID and SubCategory of Salary will be used
• Generic Expense
  • SrcID, and subcategory will be used..

What should be the sequence of user input ?

• Amount, Type, Subcategory, SrcID/DstID, User(only for Loan/Borrow), Remarks ?
• Type, SubCategory, Amount, SrcID/DstID, User(Loan/Borrow), Remarks ? or some other sequence ?

Type -> Amount -> SrcID (and/or) DstID -> Category -> Subcategory -> (UserID) -> Remarks