Table of Contents

Reckon Ecommerce

The below help information is related to the integration between Reckon Ecommerce and Reckon One.

For help regarding the Reckon Customer Portal click here. For help regarding Reckon One click here.

Connecting to Reckon One

You can connect Reckon Ecommerce to Reckon One and sync sales and tax information from ecommerce orders to your Reckon One accounts as journals.


  1. To connect to Reckon One, you can either select ‘Enable’ via the dashboard setup task or go to Settings > Reckon One.
    The book specific integration settings will now appear.

  2. Select which Reckon One book you would like to use. This will include a list of all books you have access to.
  3. Select the ledger account you would like ‘Sales’ information to post to, followed by which tax codes to use for sales with and without tax.
    If you want to create a new income/expense account in Reckon One, simply create the account in Reckon One under Day to day > Chart of accounts. 
    Then come back to Reckon Ecommerce and select Refresh and you should now see the new account appear in the list as an option.
  4. Select the ledger account you would like ‘Freight’ information to post to, followed by which tax codes to use for freight income with and without tax.
  5. Select the ledger account you would like ‘Merchant Fees’ information to connect with, followed by which tax code to use for all merchant fee expenses. In most cases AU merchants should use GST, NZ and UK merchants should use the relevant tax free code. Please check with your provider.
  6. Click Save and you are done. All future orders will now be posted to Reckon One as a journal. 

Explanation of journals

Rather than duplicate sales information in two systems, we post all Ecommerce orders as journals in Reckon One. Journals show the underlying accounting ledger transactions for an order.

Whilst journals are well understood by your accountant or bookkeeper, we understand they may be new to you as a business owner.

However fear not, as all you need to know is best achieved through your sales and tax reports in Reckon One. You should not need to understand or even open a journal other than ensuring your Reckon Ecommerce orders have been created in Reckon One.

Each ecommerce journal is broken into 4 parts:

Sales

Income from any products sold as part of an order. Sales information will be broken out per product of an order i.e. if an order contains a pair of shoes and a t-shirt, these will appear as separate journal line entries in your Reckon One journal. 

Freight

Income from the customer for shipping of physical products. Digital products will not have freight income.

Merchant Fee

Expense of the processing fees for the order.

Clearing Account

The clearing account is a ‘pseudo’ bank account created automatically for you and is used to reconcile your orders and transfers to your bank account. The total money expected from each order goes into your clearing account as a debit and actual transfers to your bank account go in as credit, allowing you to confirm you have received all funds owing.

If you would like to connect to a new ledger account you will need to first create a new ledger account (aka Chart of account) in Reckon One, then refresh the Select your book setting in the Reckon One Integration page. Note ‘Sales’ and ‘Freight’ values post to income accounts and ‘Merchant Fees’ post to expense accounts.

Syncing orders

Orders will be synced as soon as you connect your Reckon Ecommerce account to Reckon One. You cannot sync orders that occurred prior to you making the connection.

Disputes

A dispute occurs when one of your customers questions your charge with their bank or credit card company. Below is an explanation of how disputes are handled in your Reckon One journals. For general information on disputes, please see the Disputes FAQ

Once an order has been disputed, the funds in question will be held by our payment provider Stripe. At that point, a reversal journal will be created, effectively reversing the original sales journal so that your accounts balance. If the dispute is resolved in your favour, the funds will be sent back to you and a new sales journal will be created for the amount refunded to you. 

Discounts

You can offer a range of discounts to increase sales. These include item discounts, whole order discounts and free shipping (for physical items). 

For whole order discounts, the discount amount will be proportionally deducted from each order line item in, ensuring your tax is accurately recorded for each journal entry. 

For general information on discounts go to Adding discount codes and sharing discounted products.

Refunds

If you need to issue a refund to a customer you can easily do so by following these steps: Issuing a refund. 

Refunded orders will create a reversal journal for the amount of the refund. If the order is refunded in full, the reversal journal will be for the full amount of the original order. If a partial refund is issued, the amount refunded will be applied proportionally to the order line items.

Rounding

Occasionally you might see a journal entry for ‘rounding’ with a few cents as the amount. This is required to balance very slight discrepancies with rounding of decimal places between your Reckon Ecommerce and Reckon One accounting platforms, where accepted yet differing accounting methods have been applied. It is critical that your Reckon One journal totals match your Reckon Ecommerce orders, and we use a rounding entry to achieve this. 

Need more help?

Ask the Reckon Community at: https://community.reckon.com/

How did we do?

Related Articles

Reconciling External Merchant Fees
Creating a Reckon account
FAQ - Reckon Ecommerce
Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)