Carrier and trucking TMS · Accounting

QuickBooks for trucking: export invoices from Tezify

Open Reports, stay on the Financial tab and press Export to QuickBooks. You get an invoices CSV with one row per billable load, a bills CSV for outside carrier pay, and a write-offs CSV when there are any.

Updated Open this in Tezify

When to use the export

Many fleets keep QuickBooks because their accountant lives in it. The trouble is getting each load into it without retyping. The export turns your delivered loads into files QuickBooks can import, so revenue in the books matches revenue in Tezify.

If you want invoices to flow on their own, connect QuickBooks Online instead. The CSV route suits QuickBooks Desktop, an accountant who imports once a month, or anyone who wants to check a file before it lands.

Export your loads

  1. Open Profit and choose Per truck, driver, lane. This is the Reports page.
  2. Stay on the Financial tab.
  3. Press Export to QuickBooks. The files download to your computer.
  4. Open the invoices file and spot-check a few loads against Billing.
  5. Import it into QuickBooks as invoices. Import the bills file as vendor bills.
  6. If a write-offs file came down, import it as credit memos.

What each file holds

FileOne row perKey columns
quickbooks-invoicesBillable delivered loadCustomer, invoice date, due date, invoice number (the load number), description, amount, service date, memo
quickbooks-billsOutside carrier payable on a loadVendor, bill number, bill date, due date, account, amount, memo with lane and MC
quickbooks-write-offsWritten-off invoiceCustomer, credit memo number, date, invoice number, Bad Debts account, amount

The amount is what the customer was billed: line haul, fuel surcharge and approved billable extras, less any credit memo. A TONU load carries only its TONU and extra charges. The memo names the truck, the driver and the miles so your bookkeeper can trace it.

The due date comes from the invoice Tezify issued. If the load was not invoiced yet, it comes from the customer's terms in Companies, and Net 30 when there are none.

Common mistakes

  • Importing the same file twice. QuickBooks will make duplicate invoices. Keep the dated file names and import each one once.
  • Expecting brokered loads in a carrier export. When your carrier and brokerage sides are separate companies, each side exports only its own loads.
  • Fixing amounts in QuickBooks. Fix the load or the invoice in Tezify, then export again, so both systems agree.

Common questions

The export was refused.

Loads or extras could not be read, so the file would have been short. Nothing was exported. Wait a moment and try again.

Does it work with QuickBooks Desktop?

The files are plain CSV, so any QuickBooks version that imports invoices and bills from CSV can take them. Map the columns once on the first import.

Can I export fuel and other expenses?

Not in these files. Download fuel transactions from the Data page and enter them in QuickBooks.

Which loads are included?

Earned loads: delivered, billed, invoiced, paid, completed and TONU loads with charges. Archived loads are left out.

Ready to do it? This lives at /admin/reports in Tezify.

Open this in Tezify

Still stuck?

Inside Tezify, press the ? at the top of any page to file a ticket with that page attached. Not a customer yet? Ask us anything.