QuickBooks® Integration: Advanced Topics

With QuickBooks Integration set up, now learn about using ShopKeep with QuickBooks. Change account mapping, properly account for liabilities, and view reports.

Table of Contents

Change Account Mapping

Advanced users can change which QuickBooks account receives each piece of ShopKeep data. Do this before any data syncs to QuickBooks to avoid potential issues.

  1. In BackOffice, click 'Settings', then 'QuickBooks'.
  2. Choose 'Update Account Mapping'.
    Click to Enlarge
  3. Use the drop-downs to select new QuickBooks accounts.
    Click to Enlarge
  4. Press 'Submit' to save changes.
    Click to Enlarge

QuickBooks Reporting

Sales data syncs to QuickBooks daily at 4 am only after shifts are closed. Check out the journal entries that post and explore some other useful reporting options.

Having problems with your sales information syncing to QuickBooks? Visit our QuickBooks Integration Troubleshooting guide for help.

Journal Entries

ShopKeep creates two journal entries for every shift: the tenders entry and cash drawer entry.
  1. Log into QuickBooks the day after your shift was closed.
  2. Click 'Reports'. Then, search for and click 'Journal'.
  3. Click to view an entry.

    Tenders Entry | Begins with TE, R# (register), S# (shift), and the date. It posts if there are sales or returns in the shift. The tenders entry includes: total amount tendered, sales tax, totals for each tender, and credit card gratuity.

    Click to see a sample Tenders entry.

    Cash Drawer Entry | Begins with CD, R# (register), S# (shift), and the date. It posts if there are drops/payouts in the shift. The cash drawer entry includes: safe drops, payouts, buy inventory payouts, and credit card gratuity payouts.

    Click to see a sample Cash Drawer entry.

Sales Receipt

The sales receipt shows a breakdown of sales by department.

  1. Navigate to the Journal report.
  2. Click 'Sales Receipt' to view.

    Sales Receipt | Begins with SR, R# (register), S# (shift), and the date. It posts if there are sales or returns in the shift. The sales receipt includes: sales totals for each department, returns, and discounts.

    Click to see a sample Sales Receipt.

Check out some other frequently used reports like: Profit and Loss, Balance Sheet, and Sales by Product/Service Summary.

Profit and Loss | This report shows total income (sales, returns, and discounts) and expenses (payouts).

Click to see a sample Profit and Loss report.

Balance Sheet | This report shows total assets (cash drawer cash, undeposited funds, ‘buy inventory’ payouts) and liabilities (sales tax, total outstanding gift card balance, and credit card tips).

Click to see a sample Balance Sheet.

Sales by Product/Service Summary | This gives a breakdown of sales by department over a period of time.

Click to see a sample Sales by Product/Service Summary report.

  1. Click 'Reports'. Search for and click on a report.
  2. Select a predefined or custom date range and click 'Run Report'.

Gift Cards & Liabilities

Extra steps need to be taken in both ShopKeep and QuickBooks to ensure that sales of gift card / gift certificate liabilities are tracked properly.

Gift Cards & Liabilities in ShopKeep

Put gift card / gift certificate liabilities in their own department to make tracking in QuickBooks easier.

  1. In BackOffice, click 'Items' and 'Items List'.
  2. Search for and click on your gift card / gift certificate item.
    Click to Enlarge
  3. Set its department to 'Gift Card'.
    Click to Enlarge
  4. Press 'OK' to save changes.
  5. 'Get Updates' on each iPad.

Gift Cards & Liabilities in QuickBooks

Update the accounts that liabilities post to so they’re accounted for correctly in QuickBooks.

  1. Log into QuickBooks the day after closing your first shift.
  2. Click 'Report's. Then, search for and click 'Product/Service List'.
  3. Click 'GIFT CARD'.
  4. Change the 'Income Account' to 'SK-Gift Card Liability'.

    Or, if you edited your account mapping, select the QuickBooks account used for gift card tenders.

    Click to Enlarge
  5. Check 'Also update this account in historical transactions' and press 'Save and close'.
    Click to Enlarge