How to Use Mint.com to Track Your Minimum Spending Requirements

This site is part of an affiliate sales network and receives compensation for sending traffic to partner sites, such as CreditCards.com. This compensation may impact how and where links appear on this site. This site does not include all financial companies or all available financial offers.

Thought this might be useful for peeps who need to meet minimum spending requirements AKA all of us.

This requires you to have:

  • An account at Mint.com with your bank info plugged into it
  • Excel (or some other software that supports .csv files)
My daily jam

My daily jam

Then, you can use simple tools on the website to show you clearly how much you’ve spent on a certain card, to the cent, including pending transactions.

What’s Mint.com?

Link: Mint.com

Mint.com is, quite simply, is a budgeting tool. It tracks multiple accounts from nearly every bank, and shows you your balance, updated daily (or more often, if you want).

I use it for so many things:

  • To track my savings
  • To keep an eye out for weird-looking transactions
  • To make sure my payments clear, and see when they’re applied
  • And to have an idea of how much I’ve spent in a given month (a sorta-budget)

But, I found an ingenious little trick whilst wondering how much I had left to spend on my new Citi Hilton Visa to get 75,000 Hilton points.

How to do it

Once you’re logged in and have it all set up, select the account you want to track, over on the left.

If it’s a new card, don’t worry about filtering for dates.

Or, if you have to meet a certain amount of spend within a time period, (like if you were targeted by Barclays to spend $1,250 on restaurants in Q4 like I was!), enter in the dates you want to track.

Enter in dates if you want, but it's not necessary for new cards

Enter in dates if you want, but it’s not necessary for new cards

Scroll allllll the way down to the bottom. You’ll see this:

See

See those tiny words? They say “Export all XX transactions

Click “Export all XX transactions.” Save the .csv file somewhere. Open the file.

Select the “E” column (“Transactions” – the whole column), then click “Sort.”

This'll alphabetize, and thus separate, debits from credits

This’ll alphabetize, and thus separate, debits from credits

Be sure to “Expand the selection,” otherwise, the other columns won’t sort correctly. This’ll divvy up credits and debits.

Select all the credits... then delete them

Select all the credits… then delete them

Delete the credits. 

(Or, if you have a $0 balance and no pending transactions, you could just add up the credits.)

But if you have pending transactions, and a small balance, like I do, get rid of them.

Delete!

Delete!

Then select the “D” column (“Amount”).

Hit Sum and Enter to see the damage

Hit Sum and Enter to see the damage

Hit “Sum” (the button that looks like a weird-looking “E”) and then Enter.

That’s it! It’ll let you know, to the cent, exactly what you’ve spent on the card so far.

And me?

Golden

Golden

I just completed the $2,000 minimum spending requirement on my new Citi Hilton Visa!

75,000 Hilton points, here I come!

A few notes

When it comes to meeting minimum spending requirements, I always like to go slightly over. And by slightly, I mean like $50, to account for any returns, or services like Paribus that credit money back to my card.

You do NOT want to be in the last month of minimum spending requirements and not get a sign-up bonus over $3 or $4. How much would that suck?

If you have another billing cycle, sure, cut it a little closer (if you’re not in a hurry). But I always like to be safe than sorry.

And, Citi already has a built-in tracker for minimum spending. Why they all don’t, I have no idea.

But it only updates at the close of each billing cycle, not after each posted transaction. Still, it’s handy to let you know how much more you have left.

It's under "View Your

It’s under “View Your Rewards Summary”

To find it, click “View Your Rewards Summary.”

Scroll down and you’ll see it:

Pretty cool, huh?

Pretty cool, huh?

It’s under “New Customer Bonus.”

See that $284 I had left to go? That’s what I wanted to track. And that’s where Mint.com came in handy.

So now I know I’ve met the minimum spending requirement, and when the statement closes again, I’ll look out for my 75,000 Hilton points.

And if there’s any delay, I still have another month to figure out the issue.

Bottom line

I like to use Mint.com for budgeting, tracking my finances, and… making sure I’ve met minimum spending requirements.

This is a handy little trick for when you want to make sure you’ve spent the required amount so you can keep an eye out for your sign-up bonus.

Just be sure if you’re going to cut it close, to leave yourself another billing cycle in case there’s any issue. I always recommend going a little over, $50 or so, to account for any returns/delays/funny business.

Editorial Note: Opinions expressed here are author's alone, not those of any bank, credit card issuer, hotel, airline, or other entity. This content has not been reviewed, approved or otherwise endorsed by any of the entities included within the post.

* If you liked this post, consider signing up to receive free blog posts via email (only 1 per day!) or in an RSS reader and you’ll never miss an update! And thanks for using my links to apply for new card offers!

About Harlan

Just a dude living in Dallas.

More articles by Harlan »

Comments

  1. You can also use Mint.com’s Trend feature. Select Spending over time, filter by just one credit card, during “all time” or Custom. It will auto-sum for you. No need to export to excel to calculate sum.

    • Amazing tip! You’re right – taught me something!

      I just got the same result with the Trends feature. Another great way to track minimum spending requirements!

      Thank you!

Leave a Reply

Your email address will not be published. Required fields are marked *