Hike offers built-in integration with QuickBooks Online, a seamless connection between your point of sale solution and accounting software.
By pairing Hike and QuickBooks Online, retailers can forgo laborious manual data entry, with precise accuracy of your data, that goes directly from Hike to your QuickBooks Online account.
Hike offers seamless integration with QuickBooks Online to automatically sync following records:
Note: If you’re using Hike on multiple outlets, you can link those outlets to separate QuickBooks Online organisations. Get accurate sales history and more automatically posted to QuickBooks Online for all your outlets.
Before you start the integration, we strongly recommend you speak to your accountant to discuss the accounts you’d like to post data from Hike to QuickBooks Online. Please ensure that QuickBooks Online’s Chart of Accounts has all the accounts that you require for mapping, especially in relation to:
Disclaimer: Throughout this article, we’ve made some suggestion regarding account types selection in QuickBooks Online, Chart of Accounts. However, those suggestions are only for tutorial purposes only. We strongly recommend you speak to your accountant to obtain professional advice before deciding on the accounts mapping criteria and selections for your business account.
You’ll setup the integration in 3 main steps:
Note: If you want to make sure that your QuickBooks Online integration with Hike has successfully been activated, Close the settings screen, and you’ll land back on Hike’s Integrations page. You’ll notice that next to the QuickBooks Online Integration row, the Connect option has been replaced with Manage, which means you have successful activated the Hike + QuickBooks Online connection.
The first thing you’ll need to do is enable certain options in Hike, before you can start the creating and mapping of accounts.
To enable these options, we’ll need to access the Accounts and Settings page on QuickBooks Online, which can be reached by clicking on the Gear Icon, located on the top left of the page.
Your Purchase Orders will read as OFF, but as we’ll be tracking our POs to and from our Suppliers, it’s important to have this enabled.
Once you’ve reached the Accounts and Settings page, select Expenses from the menu on the left, and select the Purchase orders row.
Tick the box, located next to Purchase Orders, to have the row read ON and click Save.
Staying on the Accounts and Settings page, select Sales from the menu on the left to enable your shipping and discounts.
Select anywhere on the Sales Form Content box to open expanded options for your Shipping fields.
Tick the Shipping box, to enable it on to your sales forms.
Tick the Discount box, to enable it on to your sales form.
Click Save to finalise the process.
Set up your GST by going back to your Dashboard, and selecting GST from the menu.
From there, click on the Set-up GST button.
This will open a new dialog box for you to create your GST in. Do as per your own requirements and click Next once done.
Before we can start mapping the relevant payment, liabilities and expenses accounts into Hike, we will first need to create the accounts that we will need.
There are two main steps to do this on QuickBooks Online:
Note: For convenience, it’s best to establish all your accounts before you begin mapping, as you will need to refresh Hike in order to see the relevant accounts appear.
Here is an example of how you would complete both steps in lieu of creating a Store Credit account.
From the Chart of Accounts page, you will see a list of all your accounts, of which you’ll be able to filter through Assets, Liabilities, Expenses etc. You can also use the search bar to find the account you want by name.
As we are creating an account for Store Credit, the category type will be a Current Liability.
What type of liability is the account? In this case, we’ve labelled it as Other Current Liability.
The name you want to give your account.
You can add a short description of the account here.
Select this box if the account belongs to parent account - which you’ll select using the drop-down box.
Is there a tax rate attributed to this account?
The name of the product, Store Credit.
You can leave this field blank.
Select this box if the account belongs to parent account - which you’ll select using the drop-down box.
Select this box for all your new accounts
This is where you will link your Product Service to your Chart of Accounts. Enter or search for the corresponding name of your Chart of Accounts here. This will be what you map in Hike as well.
Leave this blank. This will only be applicable to select for your shipping accounts.
To complete, click on Save and Done
You will repeat the above steps for all your accounts, attributing the right account types – Liability, Expense, Income to each.
Once you have each, refresh your Hike Store and begin mapping.
This is where we’ll map relevant account types in Hike to define how your data will be posted to QuickBooks Online.
For example, if you are selling gift cards in Hike, by mapping a QuickBooks Online liability account for it, you will be able to track the increase and decrease in your liability relating to gift cards sales.
Select the outlet to sync data to/from QuickBooks Online.
If you’re using Hike on multiple outlets, you can link those outlets to separate QuickBooks Online organisations by setting up connection for each outlet separately. Get accurate sales history as Hike automatically posts to QuickBooks Online for all your outlets.
This is where you will select how you’d like to sync your sale transactions from Hike to QuickBooks Online.
This option is suitable if you prefer to sync each individual sale as an invoice in QuickBooks Online. It provides you more visibility options into your transactions, however it also adds many more transactions into QuickBooks Online’s sales transactions list.
Sync your total sales summary for the day by simply posting totals to relevant accounts. The total transaction summary is sent to QuickBooks as one big sale invoice at the end of the day when you close your cash register in Hike.
Please note: Hike will always sync 'on account' sales as individual transaction even if 'Send summary by account' is activated. Also, when this option is enabled, Hike will not sync product & inventory with QuickBooks. Thus, the initial stock of products and any stock adjustment performed in Hike won't trigger any journal creation in QuickBooks.
It depends on your industry, business size and what you wish to achieve from this integration. For example, some of our customers who run coffee shops, prefer to sync by sale summary as there are so many small transactions – mostly walk-ins with no customer details on the sale. There is little purpose for them to sync invoice details at it would unnecessarily clutter their Sales section in QuickBooks.
However, our users in the furniture industry, do prefer to sync with detailed invoices for each sale, as almost every sale has a customer associated with it, and the invoices sizes are comparatively large.
Select a common customer name for walk-in sales. All cash/walk-in sales will be sync’d to QuickBooks online under this customer profile. Even though you won’t receive customer information to engage with them further if a generic name is used, you can still identify shopping trends, for all your walk-in customers.
This is your default cost of goods sold (COGS) account for inventory products. Your cost-of-goods-sold (COGS) refer to the expenses involved in creating or purchasing the products that your store sells.
Select a default sales/revenue account for your inventory products.
PLEASE NOTE: Hike also lets you set product specific Revenue and COGS accounts for each of your product. However, if nothing is specified at a product level, the above default accounts will be used to post revenue and COGS amounts.
Select an asset account in QuickBooks Online for your inventory. This is where inventory movement will get recorded because of a sale, purchase, stocktake or returns.
Select one of the revenue accounts from QuickBooks’ Chart of Accounts, to be populated here. This is the account you will allocate revenue/income generated, from the sales of products or services with inventory tracking disabled.
When you sell a non-inventory item, the costs associated with that item will be recorded to this account.
PLEASE NOTE: Hike also lets you set product specific Revenue and COGS accounts for each of your product. However, if nothing is specified at a product level, the above default accounts will be used to post revenue and COGS amounts.
Refunds are automatically posted to your Sales as negative values, using the ‘sales – refunds = net sales’ formula. However, when sales totals are less than the refunded amounts, it will result in the posting of a negative sales total for the day. QuickBooks Online does not allow for the creation of negative invoices. Therefore, anytime that the daily sales are LESS than the refund totals, Hike will post the refunds to the account you have specified here.
Small cash rounding can occur with decimal values, tax calculations and cash payments. For example, if an invoice total is $10.12 and customer is paying with cash, it will result in a rounding of $0.02.
Please specify a corresponding account in QuickBooks Online for the discounts given to customers. You can either use a QuickBooks Online Revenue or an Expense account here.
Hike lets you create credit notes. Here you can map customer credits to the corresponding liability account in QuickBooks Online. Whenever store credit is redeemed by a customer, your liability will be reduced in QuickBooks Online.
Using Hike’s gift card feature? Gift card sales are different from other products because they do not result in an income, unlike other products. With gift cards, you accept payments in exchange for the promise of providing goods and services later. As such, gift cards are recorded and posted to QuickBooks Online as a liability when sold. Your liability amounts are reduced when a customer redeems the gift certificate.
Here you will be mapping for cash movements in Hike so that they will be posted into QuickBooks Online. Please note, incorrect mapping may result in wrong amounts posting or QuickBooks Online may decline to sync the transaction.
Create an account to post additional cash that you add to or remove from your cash register.
Your opening and closing cash float will be recorded to this QuickBooks Online account.
When you close your cash register at the end of the shift/day, Hike will prompt you to enter ‘actual’ counted amounts against amounts ‘recorded’ as received. This account will be used to record any cash discrepancies between your actual cash takings and expected cash takings in Hike.
Suggested account type: Liability or Income
Do you accept tips? If so, here is where you will define its corresponding account in QuickBooks Online. The type of account will depend on how tips are processed in your business.
Here on the left are all the tax options available in Hike. Use the pull-down menus on the right to map corresponding sales and purchase tax rates in QuickBooks Online.
To update/change tax rates in Hike, go to Store Setup > Tax Rules.
To update/change tax rates in QuickBooks Online, go to Settings (Gear Icon)> Chart of Accounts
Every payment type in Hike must have a corresponding account in QuickBooks Online for transactions to sync properly. Normally, most Hike users would use a ‘Bank’ account type in QuickBooks Online as a corresponding account for payments. However, some retailers prefer to send payments to a Clearing Account first before reconciling.
This is where you’ll select how your data is synced, and managed between Hike and QuickBooks Online.
There are 5 types of data that can be synced: Customers, Products & Inventory, Sales, Supplier & Purchase Order.
We’ll explain how each can be synced to and from Hike, with examples, below:
Select this option will allow you to sync your data to and from Hike and QuickBooks Online. For example, by selecting 2-way for Customers, all you customer information will be shared between the two platforms. A new customer added in QuickBooks Online will be automatically synced with Hike, and vice-versa.
Select this option if you want your data to be ONLY sent from Hike to QuickBooks Online. For example, by selecting Hike -> QuickBooks Online for Products & Inventory, all your Products & Inventory data WILL be shared from Hike to QuickBooks Online, but NOT from QuickBooks Online to Hike. Adding a new product in Hike will automatically sync and appear in your QuickBooks Online dashboard but creating a new product in QuickBooks Online will not appear in Hike.
Select this circle if you want your data to be ONLY sent from QuickBooks Online to Hike. For example, by selecting QuickBooks Online -> Hike for Sales, all your sales information WILL be shared from QuickBooks Online to Hike but not the other way around.
Hike uses product (Stock-Keeping Unit) as a unique identifier for your products. This is a standard practice for most leading accounting, POS and eCommerce platforms within the retail industry. However, some accounting applications do not require products with SKUs, thus leading to some products without SKUs. To solve this discrepancy Hike lets you choose one of the following two options:
Selecting this option will trigger Hike to automatically create SKU numbers for products that are being added, but do not have an existing SKU.
Selecting this option will NOT add products that do not have SKUs. Enabling you to manually create them first in your integrated platform.
Once you’ve completed all the necessary steps, it’s time to save and start syncing. Click on the Continue button either at the top or bottom of the page, to go on.
Hike Tip: If the Continue button is greyed out, it means you have not completed a step. Ensure you have completed everything on the page, before moving on.
While setting up accounts mapping for QuickBooks, if you need to edit an existing or create a new account within QuickBooks Online’s Chart of Accounts, it is accessible via QuickBooks Online’s Gear icon.
From the Chart of Accounts page, you will see a list of all your accounts, of which you’ll be able to filter through Assets, Liabilities, Expenses etc. You can also use the search bar to find the account you want by name.
Note: Anytime you create an account in QuickBooks Online you will need to give it a name. This name will be what you correspond to in Hike, during the integration.
Hike Recommends: If you haven’t already spoken to your accountant, Hike strongly recommends that you do before commencing preparation of your QuickBooks Online account for Hike integration. QuickBooks Online requires a complete integration when connecting the two applications. That means, if any piece of data is incorrect, all will be rejected. For example, if you performed the end-of-day sync, and one item had an error syncing, all data would be rejected.