Step 1: Export your Invoices from Clio
Step 2: Import your Invoices into QuickBooks
Step 3: View your Import
Step 4: Export your Operating Account Transactions from Clio
Step 5: Import your Operating Account Transactions into QuickBooks
Step 6: View your Import
Step 7: Link the Payments to the Invoices
Step 8: Export your Trust Account Transactions from Clio
Step 9: Import your Trust Account into QuickBooks
Step 10: View the Import
To export your Bills from Clio, go to the Bills tab and click "Export Transactions". Next, choose your date range* and the IIF format:
**Remember to backup your QuickBooks files prior to this step if you have not done so already.**
To import your invoices, from within QuickBooks, click File > Utilities > Import > IIF Files:
If using Quickbooks Desktop 2019/2020, select the Import it for me. I'll fix it later link (under the Import without review (not recommended) text).
You will see in this example that Seth's information was brought into QuickBooks. Any clients that do not already exist in QuickBooks will be brought over through the import.
If you click on a client's name you will see their invoices:
Your Operating account will include your invoice payment receipt activity. To export these account transactions from Clio, go to the Accounts tab and click Export transations. Next, choose the appropriate account, your date range and the IIF format:
To import your account transactions, from within QuickBooks, click File > Utilities > Import > IIF Files:
To View your import, you need to go into the Customer center and choose the Transactions tab. Once in the Transactions tab select either "Invoices" to view Bills or "Received Payments" to view payments, then choose the date range that encompasses your import.
When you import your Operating Account transactions, you will see Payments noted under the Invoice:
QuickBooks Desktop will attempt to link payments to the appropriate invoices but you will be required to confirm that link. To confirm that payments have been appropriately applied, double click on each Payment and check off the box to the left of the payment details. Once you save and close QuickBooks it will formally link those two transactions, applying payment to the invoice:
To export your Trust Account transactions from Clio, go to the Accounts tab and click "Export Transactions". Next, choose the appropriate account, your date range* and the IIF format:
To import your Trust account transactions, from within QuickBooks, click File > Utilities > Import > IIF Files:
*QuickBooks will recognise duplicate transactions numbers and will notify you if you are bringing over a duplicate transaction; however, it’s not completely perfect so you should be very rigid about the dates that you choose. Most practices follow a monthly accounting cycle which minimizes the risk of duplicate entries. This is why we also suggest that you backup your QuickBooks information prior to an import as there is no rollback function within QuickBooks Desktop.