Artisan Interface with QuickBooks
Reference Number: AA-00311 Views: 4092 Created: 2013-10-14 14:18 Last Updated: 2014-10-06 09:21 0 Rating/ Voters

Artisan Interface with QuickBooks

Artisan sends daily sales summary information to QuickBooks via Intuit Interchange Files (.IIF). It sends sales summary information on a daily basis, but you can export for any time range you want. Often accountants choose to export once per week, but the information will still end up daily in QuickBooks.

The information sent is the COGS / Inventory Asset changes, Sales Totals (broken down by category, if you wish), deposit amounts go into UN-deposited funds where they can be automatically deposited or wait for you to manually approve each deposit. Deposits are broken down by deposit groups. Normal groups are Cash/Checks, Visa/MC, etc. 

You also get Sales Tax Payable, Accounts Receivable, and anything that is required to complete the accounting picture. You do not get individual inventory item records, as these are well maintained in Artisan.

The interface works well and is easy to maintain once setup. The file that is created can easily be emailed, sent over a network, or thumb drive. Setup usually takes about an hour and we can assist with this process with a scheduled appointment.

You will need to set up all the QB accounts in Artisan to be able to export correctly using the chart of accounts in QB.
System Administration=> Configuration Settings=> Business & Financial Settings=> Accounting Package Configuration (this site)



Below are images of all the screens for your accounting package setup. If you want to report by Category in QuickBooks you need to change the Allow Category Overrides to Y.

 



 

  







You can also find more useful information in both the Artisan POS Users Manual version 3.0 Chapter 10 and the Upgrade Manual Version 3.5 Chapter 3 starting on page 15. These can be found in the Help menu at the top of the screen in Artisan.


Please make a backup of QB before you do your first import, this will allow you to revert if the import is not correct.



To export from Artisan go to the File menu=>Export=>Export Sales Summaries to Accounting Package - try doing 1 day at a time, it is easier to find missing accounts or problems this way. Once you feel it is working correctly then you can do groups of days. 

Below is the navigation to the Export screen. You can select the date range for export in this screen, Artisan will remember the last day that you exported and will show the following date as the Start Date when you next go to export. The default location for the file is on your C:\ drive in the Artisan folder, you can change the location or file name but it is not necessary.


 

 

 




Quick Jump Menu