How to Manually Book Shopify Sales and Deposits
Manually recording Shopify sales and deposits in QuickBooks can be tricky — especially when locating the right reports. This guide walks you through where to find your Shopify data and how to accurately book your daily sales, liabilities, and payouts in QuickBooks.
Step 1: Find and Run Reports in Shopify
The key report you’ll need is your Finance Report, located in your Shopify admin under:
Analytics → Reports → Finances Summary
You can also bookmark the direct link below (replace “YOURSTORE” with your store domain): https://YOURSTORE.myshopify.com/admin/analytics/reports/finance_summary
Bookkeep recommends booking sales daily, not weekly or monthly.
Daily booking helps you catch mistakes early — for example, if you book sales under the “Manual” payment type but forget to collect payment, you’ll spot it the next day instead of weeks later when it’s harder to fix.