Shopify Accounting Automation
Bookkeep's integration with Shopify allows for seamless automation of accounting tasks on a daily basis. By consolidating sales and Cost of Goods Sold (COGS) into a single entry each day, Bookkeep provides a clear summary of the previous day's performance. Each payout is posted separately, facilitating easy reconciliation with bank statements. This streamlined approach simplifies the accounting process, allowing Shopify store owners to focus on growing their business.
Automated Journal Entries
The three journal entry postings we automate with Shopify are:
- Ecommerce (Sales)
- Payments Deposit (Payouts)
- COGS (Cost of Goods Sold)
In the Shopify Settings within Bookkeep on the Connections page (see image below), customers have the flexibility to choose how they want to breakdown gross sales and refund amounts - either by product name or product category. This is available on the Sales Summary as well as COGS Summary. This customization is crucial for tailoring accounting processes to fit the specific needs of each Shopify store owner. By default, the rollup method is set to be by Product Category, allowing for a more organized and detailed breakdown of sales data. With this feature, customers can map each category or product to a separate account in their accounting platform, providing a more granular level of reporting and analysis. This level of customization enhances the overall visibility and understanding of sales performance, enabling more informed decision-making for business growth and financial management.
In Bookkeep's Shopify Settings, customers can break down gross sales and refunds by product name or category for Sales and COGS summaries. By default, the rollup method is Product Category. This customization allows mapping each category or product to a separate account, enhancing visibility and analysis for better decision-making.
Sales Summary Automation
The Ecommerce journal entry posts the previous day's sales to your accounting platform daily. It captures the total sales amount, from gross sales to net sales after discounts, refunds, and other adjustments. This entry provides a breakdown of payments received by tender types such as Shopify payments, third-party gateways, PayPal, and gift cards, ensuring transparency and helping reconcile transactions. It also accounts for any pending payments, indicating fulfilled but unpaid orders (accounts receivable).
Deposit/Payout Automation
Another key journal entry we handle for Shopify is the Payments Deposit. This entry records any new deposits made to your bank account related to Shopify Payments on a daily basis. When sales are processed by Shopify, they contribute to an increase in your Shopify balance. Each time a deposit is made to your bank account, this balance decreases, and this transaction is captured in the journal entry. Additionally, this entry also includes any fees associated with the processing of these sales by Shopify. It may also detail other adjustments and any repayments of Shopify loans. See below for an example mapping:
The complexity of the payouts journal entry, including labeling adjustments as sales tax withheld and identifying Shop Cash adjustments, is further explained in these articles: Sales Tax Withheld and Shop Cash Adjustments.
Cost of Goods Sold (COGS) Automation
Our final journal entry for Shopify focuses on Cost of Goods Sold (COGS). In this entry, we record and post the cost of goods sold for the previous day's sales. This process reflects an increase in COGS and a decrease in Inventory, as sold items are transferred from inventory to COGS. Additionally, this journal entry accounts for changes in inventory and COGS when returns occur, as returned items are reintegrated into inventory and removed from COGS.
Any products/variants deleted or updated in Shopify may display the wrong unit cost, as Shopify only shows the latest cost and does not show the cost for a deleted item.
If you have any questions regarding our Shopify accounting automation, feel free to contact [email protected].