Creating Shopify Customers and Suppliers

Follow

Your Shopify account functions like any other bank account. Customers make deposits when they buy an item. Shopify withdrawals funds when they charge you fees. And hopefully there is enough money left over for funds to be transferred from your Shopify account to your bank account (a Shopify payout). 

This guide walks you through the process of creating the customers and suppliers needed so that you can automatically categorize your Shopify transactions.

 

1. After you have imported your Shopify transactions you can click Banking and then Download and select your Shopify account from the list.

 

2. You should see your transactions that are imported and waiting to be categorized if your date range is set correctly.

 

 

3. If you have any transactions where the description is "Shopify fee" click in the payee box and click Add New Payee.

4. Leave the supplier name as "Shopify Fee" and change the Expense Account to "Bank Fees." Leave everything else alone and then scroll to the bottom and click Save.

Note: Now all of the withdrawals from your Shopify account that contain the word "Shopify" will have the expense account set to Bank Fees. You can always change it if you need to, but this will save you a lot of time.

5. If you have any transactions where the description is "Shopify payout" click in the payee box and click Add New Payee.

6. Leave the supplier name as "Shopify Fee" and change the Expense Account to "Primary Checking." Leave everything else alone and then scroll to the bottom and click Save. This is a bit of a trick to make any Shopify payouts default to your primary check account where the Shopify fees are transferred.

Note: For specific customer payments where the description is something like "Amy Wilkinson #1071" you can either track income for each of your Shopify customers or you can track all of your Shopify income as a single customer called "Shopify Customer." 

7. To track income from customers using a single generic customer select the Payee box and click Add New Payee on one of the transactions that is a customer purchase. It will have a description like "Bob Jones #2729."

7a. Change the customer name to "Shopify Customer." Leave everything else alone and click Save.

7b. For each of the Shopify customer purchases select "Shopify Customer" in the Payee box.

8. To track income for each individual Shopify customer select the Payee box and click Add New Payee on one of the transactions that is a customer purchase. It will have a description like "Bob Jones #2729."

8a. Leave the customer name as "Bob Jones" and leave everything else alone and click Save.

8b. For each of the Shopify customer purchases made by Bob Jones in the future the correct payee will automatically be suggested.

9. For any transactions with the description Shopify Refund select the Payee box and click Add New Payee

10. Leave the customer name as Shopify Refund and change the Expense Account to Sales Income. this is a bit of a trick that will automatically reduce your income when you issue a refund.

11. You're done! You have now created suppliers and customers so that your Shopify transactions will be automatically categorized with the correct payee and income or expense account.

 

 

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk