Accounting for your e-commerce sales can get tricky, especially when you support multiple payment methods. This guide will help you streamline your accounting and turn a complicated process into a simple and automated one.
Note: Using multiple payment providers can lead to duplicate sales transactions being created across clearing accounts. Greenback can enable Transforms that will disable duplicate transactions from being exportable to your accounting program. To enable Transforms, please reach out to email@example.com for assistance.
Step 1 - Connect Accounts
First, sign-in to your Greenback account and connect the marketplaces and e-commerce platforms you sell on. When you connect your accounts, Greenback will automatically pull in your sales transactions and make them available for you to review across each store.
Step 2 - Are you using branded payments?
Some platforms have their own payment products, such as Amazon Seller, Etsy Payments and Shopify Payments. We call these integrated payment options Branded Payments. If you rely strictly on Branded Payments provided by your marketplace or e-commerce platform, we'll be able to pull in your payment processing fees along with your sales without having to connect any additional accounts.
If however you use 3rd party payment providers separate from, or in conjunction with Branded Payments, be sure to read on.
Step 3 - Are you using 3rd Party Payment Providers?
If you rely on 3rd party payment providers, be sure to connect those accounts in addition to your store account. For example, if you manage a Shopify store and support payments via Shopify Payments and PayPal, you'll want to connect both Shopify and PayPal within your Greenback account. In this example, Greenback will fetch sales and sales related expenses (for those transactions paid for by your customers using Shopify Payments) from your Shopify account. Greenback will also fetch sales related expenses from PayPal for those customers that paid using PayPal as a payment method.
Note: if you do not wish to track expenses related to payment processing fees, you would not need to connect PayPal in this example.
Step 4 - Configuring your accounting program
Seller marketplaces and Payment Providers maintain a balance of funds on their platforms for your products/shop. They act like any other bank account for your business. As a best accounting practice, you'll want to use clearing accounts within your accounting program to manage your sales transactions. A clearing account is no different than a bank account within your accounting program.
Create clearing accounts for each payment provider
To manage your sales properly, we recommend that you create a clearing account for each payment provider you support within your shop. For example, if you sell on Shopify and you use both Shopify Payments and PayPal, you will want to create two clearing accounts, one for "Shopify Payments" and one for "PayPal Payments".
Why a clearing account?
Rather than have a dedicated "Undeposited Funds" account for sales, we recommend configuring a dedicated Bank->Checking Account instead. This will act as a clearing account for your sales. The reasoning is that bank account types are typically the only account types in your accounting program that can hold the varying transaction types necessary (sales transactions, expense transactions, refunds and reimbursements). Because you'll be paying expenses, issuing refunds, getting reimbursed referral fees, etc. all from this specific account, it acts more like a real bank account as opposed to an undeposited funds account.
What if I only accept payments from a 3rd party provider?
If you are only accepting payments from a 3rd party payment provider, and are not using Branded Payments from your marketplace or e-commerce platform, you will only need to create a clearing account for the payment provider. For example, if you sell on Shopify and you only accept payments via PayPal, you will only create one clearing account, such as "Shopify PayPal Payments".
Step 5 - Exporting your transactions
Exporting transactions to your clearing accounts
Exporting is easy. Simply work within each connected account in Greenback and export your transactions to the appropriate clearing account. For example, if you sell on Shopify and you use both Shopify Payments and PayPal, you will export all of your Shopify transactions to the "Shopify Payments" clearing account, and your PayPal transactions to your "PayPal Payments" clearing account. **Note: **Using multiple payment providers can lead to duplicate sales transactions being created across clearing accounts. To address this, be sure to read more below.
A word about duplicate transactions
Using multiple payment providers can lead to duplicate sales transactions being created across clearing accounts. Greenback can enable Transforms that will disable duplicate transactions from being exportable to your accounting program. To enable Transforms, please reach out to firstname.lastname@example.org for assistance.
Step 6 - Reconciling Deposits
Reconciling deposits from your payment providers or marketplaces is easy now that we have clearing accounts configured. To reconcile deposits made to your actual bank account, you'll simply "transfer" those funds from the appropriate clearing account to your checking account.