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.
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
- Open Profit and choose Per truck, driver, lane. This is the Reports page.
- Stay on the Financial tab.
- Press Export to QuickBooks. The files download to your computer.
- Open the invoices file and spot-check a few loads against Billing.
- Import it into QuickBooks as invoices. Import the bills file as vendor bills.
- If a write-offs file came down, import it as credit memos.
What each file holds
| File | One row per | Key columns |
|---|---|---|
| quickbooks-invoices | Billable delivered load | Customer, invoice date, due date, invoice number (the load number), description, amount, service date, memo |
| quickbooks-bills | Outside carrier payable on a load | Vendor, bill number, bill date, due date, account, amount, memo with lane and MC |
| quickbooks-write-offs | Written-off invoice | Customer, 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.
Related articles
- Carrier and trucking TMSHow to run reports per truck, driver and lane
- Carrier and trucking TMSTrucking accounting in Tezify: your weekly P&L
- Carrier and trucking TMSHow to handle short pays, disputes and write-offs
- IntegrationsQuickBooks Online integration: sync invoices and bills
- Carrier and trucking TMSHow to add insurance, truck payments and office pay
- Carrier and trucking TMSHow to compare your cost per mile with the benchmark