Do you have a spreadsheet with itemized expenses most used

Discussion in 'Trucker Taxes and Truck Financing' started by combo7, Jan 22, 2023.

  1. combo7

    combo7 Bobtail Member

    37
    11
    Jan 19, 2016
    Worcester MA
    0
    Do you have a spreadsheet sample with itemized expenses most use for tax reporting?
     
  2. Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.

  3. blairandgretchen

    blairandgretchen Road Train Member

    12,046
    60,639
    Dec 9, 2011
    South west Missouri
    0
    I use Profit Guages for $19/month.

    Because I don’t do spreadsheets.
     
  4. skallagrime

    skallagrime Road Train Member

    3,579
    9,115
    Apr 10, 2012
    Indiana
    0
    I do, but its a bit janky and i built it myself. Biggest single expense is fuel, so i enter those as i go on the road, use google sheets, makes things relatively swift for ifta and year end i just dig out receipts, i mark a code on them, wife enters on the spreadsheet, then i go do a few rounds of sorting to punch in numbers for taxes etc. Should i have a more up to date data entry, yes, do i NEED to? Not really
     
  5. briantrucker

    briantrucker Bobtail Member

    12
    40
    Feb 13, 2023
    0
    I use LibreOffice. There is also OpenOffice. It is the free version of Excel.

    I record every expense and try and sort out what I can call a business expense as I go, adding lots of notes when possible. It also helps me track my daily, monthly expenses. If you look at how others file their taxes (take a look at Trump's taxes: https://cryptome.org/2022/12/Trump-Taxes-2015-2020.zip ), you get a clear understanding of the work that goes into NOT paying taxes.

    If you go through Linux and their software applications, you can find many helpful tools. Always hunt for the nonprofit and open source resources when possible.
     
  6. NightWind

    NightWind Road Train Member

    2,319
    16,124
    Nov 11, 2006
    Sunny South, AL
    0
    I have several I built over the years. One is strictly for fuel each week and the others are for expenses. Having said all that, OOIDA has a free cost per mile sheet that you can download. They also have a lot of good information. Good Luck
     
    Metalicious and JolliRoger Thank this.
  7. krupa530

    krupa530 Light Load Member

    286
    1,115
    Dec 3, 2014
    Orem, UT
    0
    There’s a good excel spreadsheet from DieselBoss online that’s good. Yearly maybe $30. Just gotta make sure you keep inputting your costs.
     
  8. Metalicious

    Metalicious Road Train Member

    1,175
    1,226
    Sep 27, 2015
    0
    I have spreadsheets for everything, fuel, maintenance, parking fees, revenue, and one to estimate my net settlement each week. It is important to have, at least for me. Revenue spreadsheet I set to calculate my total miles, show me both rate per mile for loaded miles as well as miles for any load and the average for the year. And mine I can access from my phone using Windows Office 365. I do fuel mostly at the big truck stops, where I can get a mobile receipt and upload it to onedrive, change the name to just whatever the date is (e.g. today would be 042123) so they are all in order and input the date, truck stop name, and fuel receipt total to keep track with a total that automatically calculates every time something is added.

    Not sure how I would get them to you, email I suppose but can create a spreadsheet for anyone that needs it, either one with everything inclusive, or a separate one for all expense categories. Just may take up to a week for me to get it to you depending on how much time I have and when I get a chance to work on it. Free gratis, though. It is down right kind of foolish not to keep very good track of all of these things.
     
  9. Dave_in_AZ

    Dave_in_AZ Road Train Member

    49,754
    315,042
    May 4, 2015
    0
    Spreadsheet with every penny used.

    Not rocket science.

    Column for everything.

    Fuel, insurance(s), tolls, maintenance, office expenses, internet, phone, fuel tax, mileage tax, e log airtime, etc.

    Break it apart like that, then if your accountant wants to combine things, that's on him.
     
  10. xsetra

    xsetra Road Train Member

    4,925
    6,584
    Aug 21, 2011
    0
    I expense every category. Subtotal all and give that to theTax preparer.
    I use a 2015 version of Quickbooks. It's the last time I purchased the software. No need to update. Nothing really changes each year. All information is
    kept on my PC, no online cloud for me.
     
  • Truckers Report Jobs

    Trucking Jobs in 30 seconds

    Every month 400 people find a job with the help of TruckersReport.