Journal entry performance improvement

SET @running_balance := 0;
SET @account_id := 0;
update acc_gl_journal_entry as je
SET
		organization_running_balance = if(@account_id = je.account_id,
			@running_balance := @running_balance + IF(type_enum = 1, IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount * -1, amount), IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount, amount * -1)),
			@running_balance :=  IF(type_enum = 1, IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount * -1, amount), IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount, amount * -1))),
			account_id = IF(@account_id <> je.account_id, @account_id:=account_id, account_id)
order by account_id, entry_date, id;

COMMIT;
UNLOCK TABLES;
SET @running_balance := 0;
SET @account_id := 0;
SET @office_id := 0;

UPDATE acc_gl_journal_entry as je SET office_running_balance =
if( @office_id = je.office_id AND @account_id = je.account_id,
@running_balance := @running_balance + IF(type_enum = 1, IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount * -1, amount), IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount, amount * -1)),
@running_balance :=  IF(type_enum = 1, IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount * -1, amount), IF(je.account_id IN (SELECT id from acc_gl_account where `account_usage` IN (1,5)), amount, amount * -1))),
account_id = IF(@account_id <> je.account_id, @account_id:=account_id, account_id),
office_id = IF(@office_id <> je.office_id, @office_id:=office_id, office_id)
order by office_id, account_id, entry_date, id;
COMMIT;
update acc_gl_journal_entry set is_running_balance_calculated = 1;