The Art Storefronts platform allows you the ability to export your orders for use with Quickbooks and other programs. This can be used by Artists, Galleries and Print Studios.
Before you actually complete this process you absolutely MUST read this entire article to make sure you are doing everything correctly. If you complete the steps and it does not work, you have done something incorrectly and will need to reread this article completely and follow it exactly.
Warning: Furthermore, we strongly suggest you back up your Quickbooks or Accounting Software before importing any file at all.
You also need to EXPORT ONE ORDER AT A TIME IN ORDER TO CONDUCT AN IMPORT TEST. THIS WILL ALLOW YOU TO CONFIRM THAT EVERYTHING IS WORKING BEFORE MASS IMPORTING YOUR ORDERS.
Please Note: The following points should be read carefully and followed completely or your Export will not work properly.
The only orders that will be exported are the ones that have an order status of "Completed - Export to a File". You must set this status for each order.
We recommend that you always save every export file, just in case you need to reference the file at a later date. Our system will not be able to go back and change nor reference anything related to the export, after you have performed an export.
Given the above, we highly recommend testing only two orders and verifying that it is working according to your expectations. One order should be marked as "Paid", and the other as "Unpaid". These two transactions will export with slightly different information -- a "Paid" order will export as a "CASH SALE", and an "Unpaid" order will export as an "INVOICE". Orders with a payment status of "Refunded" will not be exported.
For each order, we provide 3 critical lines of data. First, the "discounted subtotal" of the order (this is the order total, minus shipping and taxes). Next, the shipping total. Last, the tax total. This will allow you to track each of these key revenue elements separately.
Exporting Your Orders
Reviewing Orders In Quickbooks
Quickbooks Troubleshooting
Reviewing Orders In Software Other Than Quickbooks
Since the export file is a CSV file, it should be usable with other accounting software. Because all software is different, you will need to map the fields from our export file into your own software. We recommend contacting your accounting software provider to find out exactly how this should be done.