Question: I have been struggling immensely to change the label of "Subtotal" in the email sent to users after they make a purchase.

I was able to remove everything BUT the sub total column, and I want to replace sub total with "Grand Total". I tried modifying the `Mage_Sales.csv` in `app/locale/en_US`, to no avail.

Does anyone have an idea on how or where I can change this?

I have a hunch it is in an .xml file, but I honestly don't know.

This image shows what I want changed as well. Thanks!

<http://img836.imageshack.us/img836/3865/fe1v.png>

Answer: 
There are several places where the "subtotal" translation can be found. I did a quick grep over the files in the `app/locale/en_US` to find them.

```
find . -iname '*.csv' -exec grep -Hin '"subtotal"' {} \; | awk -F: '{print $1":"$2}'

```

Running the command returned the following results:

```
./Mage_Reports.csv:143
./Mage_Checkout.csv:293
./Mage_Sales.csv:717
./Mage_Api2.csv:187
./Mage_Paypal.csv:371
./Mage_Adminhtml.csv:905
./Mage_SalesRule.csv:105
./Mage_Rss.csv:47
./Mage_Usa.csv:238

```

My best guess it's either in `Mage_Sales.csv` or `Mage_Checkout.csv`. You can overwrite them in those files but as @Tim pointed out, with the next update you would overwrite them. 

So it's better to do the translation in your template directory. When using the Default template and package that would be the file `app/design/frontend/default/default/locale/en_US/translate.csv`.

Also I've noticed in your screendump, +1 for attaching that, that it says 'points' instead of a regular currency. My guess is that this is a 3th party extension with it's own translation file. You can use the SSH command I specified before to see if the `subtotal` label is also specified in there. Also make sure this 3th party extension (if it is) actually offers a translatable label or maybe it's hardcoded in that extension.

If it's the case that it is hardcoded please run the `subtotal` label through the `sales` helper translation function

```
Mage::helper('sales')->__('subtotal');

```
There is `"Subtotal"` and `"Subtotal:"` in `en_US/Mage_Sales.csv`. Are you sure you modified the one w/o colon? Also the Magento cache had to be flushed afterwards.

P.S. This is not the prettiest way to modify the translation instance as it will be overwritten with the next Magento version which is suppose to come in the end of September.