With QuickBooks Integration already 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, select QuickBooks.
2 Choose Update Account Mapping.
3 Use the drop-downs to select new QuickBooks accounts.
4 Press Submit to save changes.
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.
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.
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.
Other Recommended Reports
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).
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).
Sales by Product/Service Summary | This report shows a breakdown of sales by department over a period of time.
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 in ShopKeep
Put gift card / gift certificate liabilities in their own department to make tracking in QuickBooks easier.
1 Log into QuickBooks the day after closing your first shift.
2 Click Reports. 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.
5 Check Also update this account in historical transactions and press Save and close.