Hope you are doing well.
1) You can create a transaction table to record the transactions of debit or credit card. Whenever there is a debit and credit in the the account balance, a transaction will be recorded in the table.
2) To display the transaction statement you can extract information from this transaction table.
Please let me know if you have any further issue regarding this.
Feel free to contact us in case you have any query.
Kindly share your feedback by clicking on either of the smiley's.