Thanks for joining this thread, @acphoto71. Let me chime in and share information on how QuickBooks generates a mileage report.
When accessing a mileage report, QuickBooks Online automatically downloads all your trips based on the period you’ve set under the Tax Year dropdown menu. Thus, creating a statement that only shows business mileage isn’t possible.
You may consider modifying the data in Excel to exclude your personal mileage. This way, you can make a straightforward business mileage report.
These articles offer tips and tricks to keep your records organized and help you get the deductions you deserve:
Please let me know if there's anything else that I can do to help. We’ve got you covered, @acphoto71.
