QuickBooks desktop is a desktop-based accounting software. You can export payment and trust funds transactions and bills from Clio to QuickBooks Desktop for accounting purposes.
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.
- In Clio Manage, go to Accounts > Export transactions.
- Under Export Format, click QuickBooks Export Options.
- Optional: Change which accounts you want Clio to use with exports.
- Click Update QuickBooks Export Options.
- 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.
- Go to Accounts > Export transactions.
- Select the bank account you want to export transactions for.
- Select the date range for transactions.
- Select the QuickBooks export format.
- Click Export Transactions.
- 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.
- Go to Billing.
- Optional: Select the appropriate bill state.
- Select the bills you want to export.
- Scroll to the bottom of the page and click Export.
- Select the output format.
- Click Export.
- Import the file into QuickBooks Desktop.
- Go to Clio's export page.
- Click QuickBooks CSV & IIF next to Bank Transactions or Bills.
- Select the relevant export parameters.
- Under Format, select Quickbooks IIF.
- Click Export Transactions or Export Bills.
Perform trust funds reconciliation
If you are performing trust funds account reconciliation in QuickBooks Desktop, you can do so by exporting trust funds transactions from Clio to QuickBooks Desktop, running the trust funds ledger report in Clio, and then matching transactions in QuickBooks Desktop.
- Follow the steps above in Export account transactions to export trust funds transactions and then import them into QuickBooks Desktop.
- In Clio Manage, go to Reports > Reports.
- Click Client under Categories.
- Select the Trust Funds ledger report.
- Choose your parameters
- Select Generate report.
- Go to QuickBooks Desktop and compare the amounts.