freightline

Export

QuickBooks export

freightline does not sync with QuickBooks directly yet. What you get today is a transactions file that QuickBooks Online imports as bank transactions, and period reports in CSV your bookkeeper can work from.

Last updated

What you get

  • QuickBooks transactions: every money movement of the period in one three-column file: date, description, amount. Money in is positive, money out is negative.
  • What is in it: each delivered load at its rate (the adjusted rate when there is an adjusted rate confirmation), driver pay per settlement, office pay, expenses with their category and vendor, and fuel purchases. A company running under another carrier’s authority also gets the carrier’s fee and deductions as rows of their own.
  • Period CSVs for loads and revenue, driver settlements, expenses and fuel.
  • Settings → Data export downloads everything in the account as one ZIP of CSV files.

How to get the file into QuickBooks

  1. Open Reports & export and pick the period.
  2. Download QuickBooks transactions.
  3. In QuickBooks Online, upload the file where bank transactions are imported and map the three columns.
  4. Categorize the rows as you would any bank feed. Each description names the load, the driver or the vendor.

What it doesn’t do

  • Nothing is pushed to QuickBooks automatically: you download a file and import it.
  • It is a bank-style list of transactions. It does not create customers, invoices, bills or 1099 vendor records in QuickBooks.
  • A load is dated by its delivery date, driver pay by the end of the settlement period.

Frequently asked questions

Does freightline integrate with QuickBooks Online?

Not as a direct sync yet. Today you export a transactions file from Reports & export and import it into QuickBooks Online as bank transactions. A direct connection is in the works; this page will say so when it is live.

What does the QuickBooks transactions file contain?

Three columns: date, description and amount. Each delivered load is money in; driver pay, office pay, expenses and fuel are money out. Descriptions name the load and broker, the driver, or the expense category and vendor.

Does the same file work with Xero or Wave?

Yes. It is the plain date, description, amount layout those tools also import as bank transactions.

Can I get all my data out, not only the accounting rows?

Yes. Settings → Data export downloads everything as one ZIP of CSV files.

Related

Sources

freightline details come from our help articles and the app itself.

Motive, Samsara, Swift ELD, TT ELD, EVO ELD, QuickBooks, Xero, Wave, Telegram and Google Maps are trademarks of their owners. freightline is an independent product and is not affiliated with or endorsed by them.

Try freightline with QuickBooks

Start a 30-day free trial, no credit card, and set it up from Settings.

Start free trial