Finally, math-free reconciliation with eCC Cloud

July 1, 2015

We’re always continuing to improve eCC Cloud to automate accounting for e-tailers and provide financial insights. Today we’re excited to announce that we’ve added another piece of the financial puzzle to eCC Cloud — payment processor automation! If you use PayPal, Stripe, or Shopify Payments, you’ll be able to see your fees in eCC Cloud and sync those fees with QuickBooks Online or Xero.

 

Get accurate profit margins

With all your fees accounted for, you now have an accurate view of how much you’re making — and how much you’re spending. You can also look at fees on a per-order basis to get additional insights into your bottom line.

Reconciliation is a snap, no math required

We know that reconciliation can be a headache, especially when you’re missing crucial information. You no longer have to do any annoying arithmetic to make sure you know where your money is.

Click here to learn how to set up payment processor integration.

The payment processor integration is the first of many steps down the road to delivering great financial insights and fully automating your accounting. We know you’ll enjoy it!

Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments

  • Avatar
    jhaynes

    We use Shopify Payments as our payments gateway. Shopify Payments batches transactions and pays out the total amount, net of fees, usually daily. (These payouts can be found on the Home Page of the Shopify Admin by clicking the button, View All Payouts.) This produces a page with the Payout date, Status (Paid of Pending) Charges, Refunds, Adjustments, Fees, and Total (the net amount of the payout deposited in our bank account). In the payout report you can find the Transaction Type, Transaction Date, Order number, Amount, Fee, and Net for each transaction in the payout.

    In order to correctly record the payout in Quick Books Online (QBO), we must daily in QBO create a bill, pay the bill, and transfer the amount of the Shopify Payments payout to our bank account. This permits us Match each downloaded payout transactions and reconcile out back statement each month.

    This new payment processor integration does net yet work for me, and I can not fathom how the reconciliation of our QBO bank register and our bank account statement can be math free.

  • Avatar
    jhaynes

    Ashish , Dharmendra has explained the new system to me and I now understand how fees are handled and the net payouts are downloaded to our Wells Fargo bank account.

  • Avatar
    jhaynes

    This new feature is not yet complete.

    After downloading a batched Shopify Payments payout that contains multiple transactions, we must Match these transactions to various unmatched Sales Receipts. In QBO we go to Transactions->Banking and click on the line with the Shopify Payments transfer. This opens up a line with a radio button Match. Clicking on this radio button opens up a page with a list of all unmatched Sales Receipts and Invoices. (We are only interested in matching sales receipts.)

    The open invoices have the invoice number in the reference column, but there is nothing in this column for the sales receipts. When there are many sales receipts, it is difficult to pick out and mark the sales receipts in the batch.

    I have requested that eCC Cloud sync the order number to the Reference Number field in each sales receipt. This will put the sales receipt number on this page where we select the sales receipts in the batch.
    I have tested this by manually adding the sales receipt number in the Reference no. field of a sales receipt and does then appear on this matching page.

Based on our last 100 reviews, online sellers Webgility

Powered by Zendesk