Reckon Ecommerce

The below help information is related to the integration between Reckon Ecommerce and IPA Books+.

For help regarding the IPA Books+ Customer Portal click here. For help regarding IPA Books+ click here.

Connecting to IPA Books+

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


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

  2. Select which IPA Books+ 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 IPA Books+, simply create the account in IPA Books+ 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 IPA Books+ as a journal. 

Explanation of journals

Rather than duplicate sales information in two systems, we post all Ecommerce orders as journals in IPA Books+. 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 IPA Books+. You should not need to understand or even open a journal other than ensuring your Reckon Ecommerce orders have been created in IPA Books+.

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 IPA Books+ 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 IPA Books+, then refresh the Select your book setting in the IPA Books+ 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 IPA Books+. 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 IPA Books+ 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 IPA Books+ accounting platforms, where accepted yet differing accounting methods have been applied. It is critical that your IPA Books+ journal totals match your Reckon Ecommerce orders, and we use a rounding entry to achieve this. 

How did we do?

Zapier

Related Articles

Powered by HelpDocs (opens in a new tab)