Shopify integration
Record each Shopify order, fee and payout in your books.
Orders record what was sold, fees record the cost of processing, and payouts move the remaining money to your bank. Tax, shipping, gift cards and returned stock are tracked at each step.
Shopify
ImprestHow it works
Three common scenarios, step by step.
Order with tax, shipping and a discount
Keeps sales, tax owed and processing costs separate and explains the net deposit.
Example: $100 of goods with a $10 discount, $5 of shipping, $7.20 of tax and a $3.20 fee.
Customer payment
$102.20 collected
$102.20 Amount paid
Order recorded
Sales and tax are recorded separately
$7.20 Tax payable
Balance line received
$102.20 charged, $3.20 retained by Shopify
$99.00 Net to the balance
Payout deposited
Imprest suggests the matching bank deposit for confirmation
$99.00 Bank deposit
Sales of $95 after the discount, $3.20 of processing expense and $7.20 of tax payable are recorded. Checking holds $99, and the Shopify Payments balance returns to its prior amount.
Gift card sale and payout
The cash reaches your bank while the store still owes goods to the gift card holder.
Example: a $25 gift card sold and a $25 payout, with the gift card still unused.
Gift card purchased
$25 paid to the store
$25.00 Amount paid
Liability recorded
The store owes $25 of goods
$25.00 Gift card outstanding
Payout deposited
$25 is transferred to checking
$25.00 Bank deposit
Unused gift card reviewed
The $25 obligation remains outstanding
$25.00 Gift card outstanding
Checking holds $25 and Gift Card Liability is $25. The Shopify Payments balance returns to its starting amount, and no goods revenue is recorded while the gift card remains unused.
Refund with one item returned
Returns the money and tax, and restores only the stock that was returned.
Example: two $50 items with $8 of tax and a $20 cost per item, a full $108 refund, and one item returned.
Original sale recorded
Two tracked items leave stock
$108.00 Amount paid
Refund issued in Shopify
One item is returned and the customer keeps the other
$108.00 Cash refunded
Sales and tax reversed
The amounts come from the original receipt
$8.00 Tax reversed
Returned item restocked
Recorded together with the refund
$20.00 Inventory restored
The sale and tax are fully reversed. One unit returns to inventory at its original $20 cost, and the other unit's $20 cost remains expensed because it was not returned.
Scope
Synchronized data and your controls.
Data synchronized
Paid orders, products and successful cash refunds. Your Shopify Payments balance is an account in Imprest, updated from the balance lines Shopify reports.
Your controls
New connections post orders automatically, subject to review rules, and your saved settings control posting. Each order records its own Shopify Payments fee. Payouts are recorded as transfers from the balance to your bank, with no sale recorded.
Set up
Setting up Shopify.
Requirements
- An owner, admin, accountant or bookkeeper role in Imprest.
- At an accounting firm, an assignment to the client.
- Approval of the Imprest app in your Shopify admin, which gives read-only access to orders, products, inventory, customers and Shopify Payments.
Connect your store
- Open Apps and choose Add a connection.
- Find Shopify under Sales and choose Connect.
- Pick your store in Shopify and approve the app.
- If you belong to more than one company, choose which company the store's sales belong to.
- Return to Imprest and look for the message Shopify connected.
Start from Shopify
- Install Imprest from your Shopify admin.
- Sign in to Imprest when asked.
Finish setup
- Open the Shopify page in Apps and choose Integration Settings.
- On the Shopify Payments balance banner, choose Answer.
- Link the balance to an existing account, or add it as a new account with a start date and opening balance.
- Under How customers pay, choose an account for each other way your customers pay.
- To bring in orders older than 60 days, open Order history, pick a date in Import orders from and choose Import older orders.
The first import can take a few minutes, and orders paid with Shopify Payments post once the balance is set up.
Full Shopify setup guide →All integrations →Shopify is a trademark of its owner, used here only to name the service Imprest connects to.