Table of Contents

    Do I need to upload mileage to QuickBooks?

    Sole Proprietor or Single Member LLC

    If you don’t have an employee other than yourself, you probably just need to claim mileage deduction on your personal tax return.  In US, this is on Form 1040 Schedule C.  In this case, you do not need to upload mileage to QuickBooks.  Instead, you would only need to run TripLog reports for the year and copy a few numbers to TurboTax, or an equivalent tax software, or give the reports to your tax preparer.  You will still need to keep TripLog reports as supporting documents for this record.

    Small Business with Employees 

    If you have employees and reimburse them for business use of their personal vehicles, you will need to upload TripLog data to QuickBooks as Expenses or Bills. Or, if you charge your clients for mileage, you would need to upload as Invoices.  Please see below for more details.

    Connect to QuickBooks Online

    Using the TripLog web dashboard, you can connect and upload data to Intuit QuickBooks Online. You would need:

    1. A QuickBooks Online Plus account
    2. TripLog Enterprise Plan (once you connect to QuickBooks Online, you will be automatically placed in the Enterprise Plan)
    To connect to QuickBooks Online, please follow these instructions:
    1. please log in to TripLog web dashboard and navigate to QuickBooks page from the top menu bar. Then, on the top right portion of the page, click “Connect to QuickBooks”.
    2. You will then be reconnected to QuickBooks. Please enter in your QuickBooks Online credentials to verify the connection with QuickBooks, then press ‘Sign In’.
    3. After signing in to QuickBooks Online, you may be prompted to verify your account using a code that will be sent to your phone or email. Please follow the prompts to verify your account.
    4. After verifying your account, you will then need to choose which QuickBooks Online company you would like to integrate with TripLog. Once you have selected the company to integrate with, please click ‘Connect’.
    5. All done! Your TripLog is now connected with your QuickBooks account!

    Upload trips to QuickBooks as mileage reimbursement Expenses

    1. Log in to your TripLog web account, click “QuickBooks > Expenses” under the Connect tab on the menu bar.
    2. You can then filter which trips and business expenses you would like to upload by date range, activity and/or driver by using the search section on the right side of the page. Note that only the data you see on the page will be uploaded to QuickBooks.
    3. If this is your first time uploading TipLog mileage to QuickBooks, click the “Connect to QuickBooks” button and then log in to your QuickBooks account (see ‘Connect to QuickBooks Online’ above).
    4. You will also need to set up the connection between your employees on QuickBooks and your users on TripLog. To do so, please click “QuickBooks Settings > Link Users” in the top right portion of the page to review and link existing TripLog Users to QuickBooks Employees. The mileage the TripLog User records in TripLog will be associated to the paired QuickBooks Employee once uploaded to QuickBooks. When you have paired each user on TripLog with the appropriate Employee on QuickBooks, please press ‘close’.
    5. Create a “Mileage” Bank/Credit Account on QuickBooks Online if you have not created one yet. If you would prefer mileage and expenses to be uploaded to a different expense account, you can configure this setting via “QuickBooks Settings > Link Expenses> pair the appropriate Expense Accounts > Close”.
    6. Create a “Mileage” Expense Account on QuickBooks Online if you have not created one yet. If you would prefer mileage and expenses to be uploaded to a different expense account, you can configure this setting via “QuickBooks Settings > Link Expenses> pair the appropriate Expense Accounts > Close”.
    7. Create a reimbursement Expense for each mileage line item and expense Account line item shown above payable to the Employee (only if that TripLog user has been linked to a QuickBooks Employee already).
    8. On the TripLog QuickBooks Expense page, please click ‘Upload to QuickBooks’ > Upload. This will upload the mileage as a reimbursement expense to QuickBooks. You can choose an upload date for your mileage if you wish.
    9. You can then log in to QuickBooks Online to review the uploaded expenses.

    Upload trips to QuickBooks as mileage reimbursement Bills

    To upload your TripLog trips as mileage reimbursement bills payable to your employees through QuickBooks, please follow this process:

    1. Log in to your TripLog web account, click “QuickBooks > Bills” under the Connect tab on the menu bar.
    2. If this is your first time uploading TipLog mileage to QuickBooks, click the “Connect to QuickBooks” button and then log in to your QuickBooks account (see ‘Connect to QuickBooks Online’ above).
    3. You can then filter which trips and business expenses you would like to upload by date range, activity and/or driver by using the search section on the right side of the page. Note that only the data you see on the page will be uploaded to QuickBooks.
    4. You can also set up the connection between your Vendors on QuickBooks and your users on TripLog. To do so, please click “QuickBooks Settings > Link Users” in the top right portion of the page to review and link existing TripLog Users to QuickBooks Vendors. The mileage the TripLog User records in TripLog will be associated to the paired QuickBooks Vendor once uploaded to QuickBooks. When you have paired each user on TripLog with the appropriate Vendor on QuickBooks, please press ‘close’.
    5. Review the mileage, rate, and total payment amount, then click “Upload to QuickBooks”.
    6. TripLog sets up a “Mileage Reimbursement” expense account in the Chart of Accounts, a “Mileage” item in Products and Services, and a Vendor account for each driver/employee (if they have not already been paired as per step 4) who receives reimbursement. If you would prefer mileage and expenses to be uploaded to a different expense account, you can configure this setting via “QuickBooks Settings > Link Expenses> pair the appropriate Expense Accounts > Close”.
    7. TripLog then creates a Bill for each driver (as a Vendor) with line items of the mileage, rate, and total amount.
    8. You can then log in to QuickBooks Online to review the bills and then make payment.

    Upload trips to QuickBooks as Customer Invoices and/or Billable Expenses

    1. Log in to your TripLog web account, click ” QuickBooks > Invoices” under the Connect tab on the menu bar.
    2. If this is your first time uploading TipLog mileage to QuickBooks, click the “Connect to QuickBooks” button and then log in to your QuickBooks account (see ‘Connect to QuickBooks Online’ above).
    3. You can then filter which trips and business expenses you would like to upload by date range, activity and/or driver by using the search section on the right side of the page. Note that only the data you see on the page will be uploaded to QuickBooks.
    4. You will also need to pair your business activities to existing QuickBooks Customers or import your QuickBooks Customers as business activities. More information and instructions for this task will be presented when you click QuickBooks Settings in the top right portion of the page.
    5. Review the mileage, rate, and total payment amount, then click “Create Invoices”, “Create Billable Expenses”, or “Create Both”.
    6. TripLog then sets up a “Mileage Service Income” Account and/or a “Mileage Invoice” Product/Service item for the Account, if either one is not created yet.
    7. TripLog then creates a Mileage Invoice for each customer.
    8. You can then log in to QuickBooks Online to review the invoices.