Tenant.php

				SELECT
					*,
					(@runningTotal := @runningTotal + t1.amount) AS balance
				FROM
					(SELECT *
					FROM `transaction` AS t
					WHERE t.company_id = :companyId
						AND t.tenant_id = :tenantId
						AND t.created_at > :startDate
						AND t.deleted_at IS NULL
					) AS t1
				ORDER BY t1.id, t1.created_at /*must be ascending for calculating balance*/';