MYsql Error 1136

[Adhwaith S]

Operation failed: There was an error while applying the SQL script to the database.
Executing:
INSERT INTO `adhwaith`.`expenses` (`ID`, `category`, `amount`, `on_date`) VALUES ('40', 'Temple Expense', '500', '2023-08-10');

ERROR 1136: 1136: Column count doesn't match value count at row 1
SQL Statement:
INSERT INTO `adhwaith`.`expenses` (`ID`, `category`, `amount`, `on_date`) VALUES ('40', 'Temple Expense', '500', '2023-08-10')

The column count is 4 and the values are for the 4 columns but am still getting the error. Can someone please help me on how can I resolve this error since the column count is actually correct.