Bank Statement
setTimezone(new DateTimeZone(date_default_timezone_get()));
$start_of_month = $dt_start->format('Y-m-d');
$dt_end = new DateTime("$selected_year-$selected_month-01 +1 month -1 day", new DateTimeZone('UTC'));
$dt_end->setTimezone(new DateTimeZone(date_default_timezone_get()));
$end_of_month = $dt_end->format('Y-m-d');
// Retrieve transactions for the selected account number and period
$query = "SELECT trndate, docno, amount, remark, recfrm FROM bank_trn WHERE accno = '$selected_accno' AND trndate >= '$start_of_month' AND trndate <= '$end_of_month' ORDER BY trndate";
$result = mysqli_query($conn, $query);
// Set initial balance to 0
$balance = 0;
// Calculate bring forward balance
$query1 = "SELECT SUM(amount) AS total_amount FROM bank_trn WHERE accno = '$selected_accno' AND trndate < '$selected_year-$selected_month-01'";
$result1 = mysqli_query($conn, $query1);
$row1 = mysqli_fetch_assoc($result1);
$total_amount = $row1['total_amount'] ?: 0;
$bf = $total_amount;
$balance = $bf;
?>
Bank Statement for Account Number for
| Date |
Document No |
Remark |
Receipt From/Payment To |
Money In |
Money Out |
Balance |
| B/F Balance |
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total |
|
|
|
|
|
|