Scroll

Exporting Accounting Data from MacPractice / Importing into QuickBooks

This article will walk you through how to export your Accounting financial data from MacPractice into a QuickBooks file, and how to import that file into QuickBooks.

You'll need to be running MacPractice Gen 9 in order to export your financial data to QuickBooks.

For a video on the complete workflow, please check out this video

If you run into any issues exporting your data in MacPractice, please contact MacPractice Support for additional information.
For assistance with importing the Accounting Data into QuickBooks, please contact Intuit Support.

Exporting Accounting Data from MacPractice
Exporting data is an easy process within MacPractice. First, you'll need navigate to the Accounting Ability. From there, click on the "Journal" node in the sidebar.

Switching_to_Accounting_and_Journal.gif

From the Journal node, you'll want to set an appropriate date range that you want to export. We recommend exporting on a month-by-month basis. Once you've entered in the desired date range, click on the "Apply" button in the upper right corner.

Once the results have been generated, click the Export button.

Screen_Shot_2017-11-14_at_12.19.22_PM.png

The file will by default be saved as a .csv file, which QuickBooks can import. Be sure you name the file something clearly recognizable, and save it in an easily accessible place by clicking the "Where" drop down. Click "Save" when you've named and selected a location for your Export.

Screen_Shot_2017-11-14_at_12.19.10_PM.png

Importing Accounting Data Into QuickBooks
Once you've gotten your Accounting Data exported out of MacPractice, we can now begin to import that same data. Follow the steps outlined below.

First, log in to QuickBooks. You'll be taken to the QuickBooks dashboard. On the left sidebar, click the "Banking" node.

Screen_Shot_2017-11-14_at_1.40.22_PM.png

From here, click on the "File Upload" option, seen in the upper right corner of the above screenshot by the Add Account button.

Screen_Shot_2017-11-14_at_9.12.37_AM.png

Click the "Browse" button by "Select the file to upload". This will bring up a file selection window. Select the file you had just exported and saved from MacPractice's Accounting Ability.
Once the file is selected, click the "Next" button in the lower right corner.

Screen_Shot_2017-11-14_at_9.12.41_AM.png

After selecting the exported file, you can choose a QuickBooks Account to import the information into. You'll need to determine which of your QuickBooks Accounts you'd like to use.
Once you've selected the desired Account, click the "Next" button in the lower right corner.

Screen_Shot_2017-11-14_at_9.10.30_AM.png

Now you'll tell QuickBooks how to handle the data you're trying to import. We recommend the configuration displayed above for the best results.
For Date, ensure that "Column 1: Transaction Date" is selected. For the formatting drop down, select "MM/dd/yyyy".
For Description, select "Column 3: Description".
Change the "CSV file has amounts in:" selection to "2 Column".
For Amount, change the Debit selection to "Column 6: Debit". Change the Credit selection to "Column 7: Credit".

Once you have followed these steps, click the "Next" button in the lower right corner.

Screen_Shot_2017-11-14_at_9.12.24_AM.png

You'll next be presented with a list of all the CSV transactions that you can import. 0.00 transactions cannot be imported into QuickBooks. Review the list to ensure the data looks accurate, then click Next.

Screen_Shot_2017-11-14_at_9.12.59_AM.png

A confirmation prompt will appear, telling you how many transactions will be imported. Click "Yes" if you wish to proceed. Once the import completes, you should see a green circle with a checkmark inside of it. Click "Let's Go" in the lower right corner to continue.

Screen_Shot_2017-11-14_at_9.13.27_AM.png

The newly imported transactions will now be present in the "For Review" tab of the Banking node.
You can easily approve these transactions by using the selection boxes on the left margin of the transactions table. The top selection box by the "Date" column header will select all Transactions.
Once you've selected the transactions you wish to approve, click on the "Batch Actions" drop down menu then click "Accept Selected".

And that covers the basics of how to import your Accounting Data from MacPractice into QuickBooks! For more information regarding QuickBooks functionality, you'll need to contact Intuit QuickBooks for Support.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments