QuickBooks Desktop and Clio

Have more questions? Submit a request

QuickBooks desktop is a desktop-based accounting software. You can export payment and client funds transactions and bills from Clio to QuickBooks Desktop for accounting purposes.

Tip: Check out the QuickBooks Community Knowledge Base for more information about using QuickBooks, including how to resolve specific error codes.

Set up QuickBooks Desktop

Since QuickBooks Desktop does not integrate directly with Clio, the setup process is done by setting up a Chart of Accounts in QuickBooks Desktop and then mapping Clio IIF exports to QuickBooks ledger accounts. Once this is done, you can begin exporting transactions and bills out of Clio and importing them into QuickBooks Desktop.

Important: Changing the default settings is not recommended unless you are very familiar with QuickBooks Desktop and accounting.
  1. In Clio Manage, go to Accounts > Export transactions.
  2. Under Export Format, click QuickBooks Export Options.
  3. Optional: Change which accounts you want Clio to use with exports.
  4. Click Update QuickBooks Export Options.
  5. To reset the options to default mappings, delete the fields and then click Update QuickBooks Export Options.


Export account transactions

You can export account transactions in Clio in either QuickBooks IIF or QuickBooks CSV format. Once exported, go into your QuickBooks Desktop account, and import the file.

  1. Go to Accounts > Export transactions.
  2. Select the bank account you want to export transactions for.
  3. Select the date range for transactions.
  4. Select the QuickBooks export format.
  5. Click Export Transactions.
  6. Import the file into QuickBooks Desktop.


Export bills

You can export account transactions in Clio in PDF or CSV format, or as IIF files. Once exported, go into your QuickBooks Desktop account, and import the file.

  1. Go to Billing.
  2. Optional: Select the appropriate bill state.
  3. Select the bills you want to export.
  4. Scroll to the bottom of the page and click Export.
  5. Select the output format.
  6. Click Export.
  7. Import the file into QuickBooks Desktop.


Perform client funds reconciliation

Tip: Clio offers full client funds account reconciliation right in Clio Manage. Learn more here.

If you are performing client funds account reconciliation in QuickBooks Desktop, you can do so by exporting client funds transactions from Clio to QuickBooks Desktop, running the client funds ledger report in Clio, and then matching transactions in QuickBooks Desktop.

  1. Follow the steps above in Export account transactions to export client funds transactions and then import them into QuickBooks Desktop.
  2. In Clio Manage, go to Reports > Reports.
  3. Click Client under Categories.
  4. Select the Client funds ledger report.
  5. Choose your parameters
  6. Select Generate report.
  7. Go to QuickBooks Desktop and compare the amounts.


Need more help?

Was this article helpful?
0 out of 0 found this helpful