I have the following 'Cashbook' table columns. How do i calculate the Opening and Closing Balance of each Date (i.e, 12-12-2023, 12-11-2023). Please help.
| Transaction ID | Date | Type | Category | Description | Opening Balance | Cash Inflow | Cash Outflow | Closing Balance |
| | 12-12-2023 | Income | | | | | | |
| | 12-12-2023 | Expense | | | | | | |
| | 12-12-2023 | | | | | | | |
| | 12-12-2023 | | | | | | | |
| | 12-11-2023 | | | | | | | |
| | 12-11-2023 | | | | | | | |
LinkedIn
Twitter
