Matching Deposits Across Multiple Selling Channels Can Be Reconciled
Many of our customers sell on Amazon, eBay, and have their own e-commerce store. For example, they might sell their products using Magento, Shopify and Woocommerce.
Normally, you would need to manually enter all the orders onto your selling channel and Quickbooks. This can cause errors in customer data, sales numbers and inventories.
Connex can separate orders by payment method, even if you have multiple selling channels. Thus, you can place refunds and sales into separate asset accounts. In addition, you can make a deposit by subtracting amounts from the account.
Reconciling Refunds Through Multiple Selling Channels
Example with Stripe and Paypal
- Orders are paid by Stripe and Paypal
- You need to sync refund to Quickbooks
- You have at least 100 sales per day
- The settlement report for your payment processor contains no list of order numbers in Quickbooks
Sources of Errors in QuickBooks Desktop
- QuickBooks Desktop’s undeposited funds account has no support for negative deposits. This means no refunds can sync directly.
- You have several hundred orders to match. Probably, you have no desire to check 100 – 150 sales one by one per day.
- You need a way separate the orders by payment method.
How do you separate orders by payment method?
You need to create a bank account in QuickBooks for each payment method:
Step 1: In QuickBooks, press CTRL + A.
Step 2: Click account.
Step 3: Click new.
Step 4: Choose bank as the type.
Step 5: Enter the payment method name, such as PayPal.
Next, add rules:
Step 1: Login to Connex.
Step 2: Click rules on the right.
Step 3: For each payment method, add a rule to change the deposit account. Here is the one for PayPal:
How do you sync the refunds?
Create a bank account called refunds. Instruct Connex to create checks for refunds:
1: Login to Connex.
2: Click manage.
Expand refunds.
Click create checks.
As check deposit account, choose the refunds asset account.
Click save.
The checks will subtract an amount from the refunds account that you created.
How do you match the deposits?
Now that Connex is syncing data to the proper accounts, the last step is to match deposits:
Step 1: On the QuickBooks home page, click bank deposits on the bottom right.
Step 2: Close the popup window.
Step 3: Enter the amount of the sales from your settlement report.
Step 4: Enter the merchant fees.
Step 5: Enter the amount of refunds.
Step 6: Click save.
The End Result with Reconciled Books
$1,000 is credited from the PayPal account and its value will drop to $0. The refunds account has a negative balance of $200. By subtracting $200, the balance will say $0.
Can Connex Help Your Business To Reconcile Sales and Inventory with QuickBooks?
We know that choosing the right tools for managing your sales and inventory is essential for the growth of your business.
Click here to schedule an introductory 15 minute call with a member of our sales team.Schedule a Call with Sales
Why Our Customers Choose Sync with Connex
- Developed specifically e-commerce business owners
- You can scale your business by automatically syncing sales & inventory from multiple e-commerce platforms to QuickBooks Desktop or Online.
- You don’t have to spend your resources manually entering sales, inventory, and customers into your website and QuickBooks accounts.
Recommended by Intuit itself, Connex for QuickBooks will give you peace of mind that your inventory will be updated. You will be free of the frustration of oversells and missed items.
- When your inventory is up-to-date, you can achieve higher customer satisfaction, leading to more positive reviews, and increased sales.
- For phone orders, we can sync sales from QuickBooks to your shipping solution.
- If you sell on multiple channels, you can simplify by using our solution instead of multiple tools.
- Connex integrates QuickBooks with all major e-commerce platforms, such as Woocommerce, Shopify, Magento, Amazon, and e-commerce shipping solutions such as Shipworks, Ordoro, ShipStation and ShippingEasy.
–Click here for a full list of our ecommerce, shipping, and payment integrations
How can you decide whether Connex is right for your business?
The easiest way to tell whether Connex is right for your business is to speak with our sales team
During this introductory call, you will discover how Connex can help you to:
- Eliminate manual data entry into QuickBooks Online or QuickBooks Desktop
- Automatically update your inventory and prevent oversells and refunds
- Manage sales from multiple channels in one app
- Connect your shipping solutions to QuickBooks
- Have accurate financial information in your QuickBooks every day
Are you unsure whether Connex is right for your business?
Click here to schedule an introductory 15 minute call with a member of our sales team.Schedule a Call with Sales