Dashboard

⚠️ DB not ready: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'type' in SELECT is ambiguous (Connection: mysql, SQL: select accounts.name, accounts.currency, ROUND(COALESCE(SUM(CASE WHEN type="income" THEN amount*exchange_rate WHEN type="expense" THEN -amount*exchange_rate ELSE 0 END),0) + accounts.opening_balance,3) as balance_omr from `accounts` left join `expenses` on `accounts`.`id` = `expenses`.`account_id` group by `accounts`.`id`, `accounts`.`name`, `accounts`.`currency`, `accounts`.`opening_balance` order by `accounts`.`name` asc)
Totals (OMR)

Expense: 0.000

Income: 0.000

Transfer: 0.000

Net: 0.000

Top Categories (spend)
Accounts
Monthly (last 12)