PSA: How to ensure your Arc card is not over-charging you

I just went through my own history and I was wondering why I had a $1 charge. I then noticed that my monthly spend month to date was much more than $100.

“What is going on?”

Then I noted how awful the data capture is.

My recommendation is to download your history for month to date in Excel from the Arc website, format the data as a table, filter “Action” by “Usage”, delete any duplicates (WHY ARE THERE DUPLICATES), which are actually not duplicate charges, and add up the “Amount” column.

Ta-da! It adds up to $100 and the $1 charge was just the partial charge associated with me hitting my Arc monthly cap.

Should it be this hard to figure out? No. But I confirmed it was working from a financial perspective as intended.

That being said this is terrible website and data export for a layperson to figure out.