IFTA Report

I have a Excel Spreadsheet that I have done up I use for filing my IFTA reports. It is an Excel "template" file format. You open it and when you save it, it prompts the user for a new file name automatically. This one remains blank so you can start all over next quarter.

Rather easy to use and I have "modified" it to be user friendly. I highlighted the cells that need to be filled in, locked the cells that don't or should not be changed.

It's pretty straight forward.

If there is a way the mods can help post it, I am willing to share it here on TTR.

 

No, I haven't done a SQL for updating rates. I might do it once a year. I go onto the MN site for reporting my IFTA and they have then on there already for me.

Feel free to PM me your email and I'll send it to you. Be nice to have some critique on it how it works for others.

 

pretty much.

I did mine tonight.

The spreadsheet said I owed $1.78 or something like that.

When I went online, the state said I owed like $4.72. I didn't go in to figure out the actual difference. I know there are states that have updated their IFTA rates, but I did not put that into MY report. The state has the current rates and that's where I am concerned with them.


The cells for the individual rates are editable for entering the correct rates in. 3rd qtr 2012 when I used it first, my reports matched perfectly with the state.

I have a company that is willing to charge me $60 and take 15 minutes to enter in the information. Or I can log in myself and do it for free.

 

yop, so long as you have a MN IFTA account.

https://mnec.exploredata.com/loginex.asp

I would think that IL has a similar set-up.


ETA:

You'd file here in ILL

https://mytax.illinois.gov/_/#1