QuickBooks Desktop: Instructions on Exporting Invoices and Transactions from Clio to QuickBooks

! This export process uses the default accounts created in QuickBooks Desktop under the Legal Service set up. If you have re-named those accounts or modified their status you will need to re-map the exports in order for QuickBooks to know where the data is supposed to be going.  The re-mapping instructions can be found here, under Advanced Settings.  

Backup your QuickBooks files before starting this process. If you do not perform the backup you will NOT be able to undo this action if you discover that you missed an item in the date range or included an incorrect transaction in your data. You will be stuck with it.

Contents

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

Step 1:  Export your Invoices from Clio

To export your Bills from Clio, go to the Bills tab and click "Export Transactions". Next, choose your date range* and the IIF format:

Step 2:  Import your Invoices into QuickBooks

**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:

Step 3:  View your Import

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:

Step 4:  Export your Operating Account Transactions from Clio

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 Transactions". Next, choose the appropriate account, your date range* and the IIF format:

Step 5:  Import your Operating Account Transactions into QuickBooks

To import your account transactions, from within QuickBooks, click File > Utilities > Import > IIF Files:

Step 6:  View your Import

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.

2012-02-29_0921.png

When you import your Operating Account transactions, you will see Payments noted under the Invoice:

Step 7:  Link the Payments to the Invoices

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:

link_payment.png

after_added.png

Step 8:  Export your Trust Account Transactions from Clio

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:

Step 9:  Import your Trust Account into QuickBooks

To import your Trust account transactions, from within QuickBooks, click File > Utilities > Import > IIF Files:

Step 10:  View the Import

*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.  

qb_disclaimer.png