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