Join our ecommerce accounting newsletter   

Shopify accounting automation software

How to Allocate Multiple Shopify Store Payouts to Different Bank Accounts

A commonly-requested feature in Shopify doesn’t exist unfortunately, and it affects larger businesses who sell across multiple Shopify POS locations, and who run their operations using a single Shopify Account.

The issue is this: Shopify only allows one bank account per Shopify Account.  

This means that multi-location businesses utilizing Shopify POS cannot choose to have each store’s net revenue payout allocated to its own separate bank account. Instead, the payout for all their stores comes into one central bank account and it’s up to the accounting team to manually calculate and move each store’s net payout revenue to the appropriate bank account.  (The other way to do it is to create separate Shopify Accounts, one per store, but this is usually not chosen due to the extra complexity in managing products, discounts, and sales tax, etc).

It can be time consuming to manually track the payouts per store, to say the least. Accounting teams will need to track per-location sales, sales tax, returns, gift cards and discounts, and then total that up each day.  Then, when each payout arrives (typically covering several days of sales) it needs to be reconciled to each day’s sales per location, and then split manually so that a transfer can be made to each location’s bank account. A lot of spreadsheets will be needed.

The Bookkeep team has been working on a feature that is tailor-made to solve this issue for multi-location, multi-channel Shopify Sellers.

 

Shopify Payout Splitting is coming soon within the Enterprise offering.

Here’s how it works: 

  1. Bookkeep’s secure software accesses each day’s payouts and allocates all the details to the appropriate locations in a neat and detailed GL entry, as part of our normal Shopify accounting automation software integration
  2. Then, when the payouts arrive, those are segregated by location and/or channel as well, giving the accounting team a neat summary of Daily Payouts by Store or Location.
  3. From there, a manual transfer between the master bank account and the per-store bank accounts can be made easily that is net of fees, chargebacks and any other per location adjustment

To learn more about this powerful feature, book a discovery call:


Start a trial or book a demo.