MySQL Statement not displaying some values
Your query is just plain invalid, as you have included values in the column list that are not part of the GROUP BY.  MySQL lets you do this (unfortunately), but the results will be indeterminate.  Consider setting sql_mode=TRADITIONAL in my.cnf (and SET GLOBAL sql_mode=TRADITIONAL)

A valid query would like like this, though I'm not sure it will get you the results that you want.   

SELECT `Group Transaction No`,`Receipt No`, `Transaction No`, `Actual Cost`,
`CErr`,`Resource Units`, `Meter Serial No`, `Token`, `Transaction Timestamp`,
ROUND(SUM(`Transaction Amount`),0) as Amount FROM `efulusi_acc`
GROUP BY 1,2,3,4,5,6,7,8,9
ORDER BY 8 
LIMIT 5


Also, it's a really bad idea to include spaces in your column names.  It's just plain difficult to work with and can cause a lot of edge case bugs.