The New ShopKeep.com Help Center

The ShopKeep.com Quickbooks Export File

Last Updated: Jan 24, 2012 09:58AM EST
ShopKeep.com has a .csv export file which is created for each register shift.  The file is set up to be used for importing into QuickBooks on the PC using the Dynamic Ventures QB Journal Import Tool.



The Export File contains the following information for EACH register:
  1. Total Gross Sales (not broken down by department and does not include sales tax)
  2. Total Sales Tax Collected
  3. Separate totals for credit card tenders received broken down by Amex, Visa, MasterCard, and Discover, Mercury Gift Card, and Other Tenders
  4. Total cash tenders received
  5. Individual line entries for each cash drop out of the cash drawer which maps to your deposit window
  6. Individual line entries for each payout with the attached note
  7. individual line entries for each inventory purchase with the attached note. 
 
Very Important:
We do not have a way to map our accounting buckets to yours in QuickBooks.  This means you need to either 1. change the names of your accounts in QB or 2. make a sub-account using the names we use in the export file.  The best way to do this is to try to import a QB Export file and look at the errors and then make adjustments to your accounts until the file imports properly.  
 
The export file is the best place to find this information on each shift.  If you do not want to import you can open the file in excel and see the totals. Below is a screen shot of where to find the files:
  1. Not Posted - is all your new files which you have not yet downloaded
  2. Posted - Are the list of already downloaded files which you can download again if needed.   

Contact Us

  • Submit a Feature Request
  • Email Us
  • Call Us @ 800.820.9814

Recent Discussions

Ajax-loader-small