This post will explain how to get out the basic information your accounting system will need from ShopKeep:
Most of the data is available in the QB Export file which can be imported into QB for the PC or you can manually key in the information. The rest is found by running export files:
Sales
Total sales by shift is exported in the QB Export file for each register shift. This is totaled only and is net of discounts.
Returns
Total returns is a line item in the QB Export and has its associated returned Sales Tax.
Sales Tax
The total sales tax collected by shift is found in the QB export file. This is net of discounts
Credit Card Tenders
Each credit card tender amount is found in the QB export file. This includes Visa, MasterCard, Amex, Discover and is totaled by shift. This balances with the net sum of the sales, returns, and sales tax.
Gift Tenders
The total tendered to gift cards is also found in the QB Export file. We do not activate cards at the register and sales for gift cards are part of the sales total. We do not split it out yet.
Cash Drops
Amounts dropped out of the drawer into the drop safe will show up as individual drops with a note in the QB export file.
Cash Payout
Amounts paid out for expenses (petty cash) are itemized with the note in the QB export file
Inventory Purchase
Money used to purchase inventory from cash in the cash drawer is separately itemized in the QB export file with the attached note
Cost of Goods Sold
We currently do not put cost of goods sold (COGS) in the QB export file. This number you will need to calculate in a spreadsheet by running a SOLD ITEMS EXPORT and summing the COGS column for the date range in question. Then you can make a journal entry for this in your accounting package.
Current Inventory Value
In order to calculate your current inventory value you will run a STOCK ITEMS EXPORT then create a column to multiply cost x quantity on hand then sum that column to calculate the current value of your inventory.
Inventory
ShopKeep does not export inventory received into ShopKeep. The process to track that is you need to enter a bill into your accounting system putting the total dollars purchased into the INVENTORY account. You will want to do this anyway to manage your payables.
