How to export your WooCommerce orders to EBP Accounting with “Accounting for WooCommerce”

Do you have a WooCommerce online store and want to export your completed orders to your accounting software? Here’s how to do it!

Prerequisite: install the “Accounting for WooCommerce” extension

Download and install “Accounting for WooCommerce”, in Freemium or Professional version (premium)

1. Configure your account codes on WooCommerce

General settings for your chart of accounts in WooCommerce

If you are using the free version of “ Accounting for WooCommerce “, you can only set generic codes.

  • In the WordPress administration interface, go to “WooCommerce> Settings”, then to the “Accounting” tab

You can then define your accounting codes for each type of accounting information: products, taxes, shipping costs, payment methods, accounting book, cost accounting, depending on the payment methods, the status of orders etc.

Accounting For WooCommerce : General settings
Click on the image to enlarge
  • Status of orders to be exported: for each order status, you can define a different Accounting Account (Pending payment, In progress, Pending, Completed, Canceled, Refunded, Failed)
  • For Products, define an Accounting Account and an Analytical Code by default
  • For Customers, define a default Accounting Account
  • For taxes and shipping methods, define a default accounting account, as well as an analytical code for shipments
  • For your Promos, define an Accounting Account and an Analytical Code
  • For your Sales Journal Code
  • For exceptional credits and charges, define an Accounting Account

5 tabs are available, to allow you to edit the specific accounting codes for the different parameters that you have defined in WooCommerce:

  • the countries
  • taxes (types of VAT)
  • shipping charges
  • payment methods
Accounting For WooCommerce : Taxes settings
edit accounting codes for each type of VAT
Accounting For WooCommerce : Shipping settings
define your accounting codes for each delivery method
Accounting For WooCommerce : Gateways settings
establish different accounting codes for each payment method offered

In the Pro version

First, define general account codes, as explained above.

Then, for each of your products, you can enter an accounting code and a analytical code .

Your accounting in detail

Integrate your detailed chart of accounts.
Define detailed account codes for each product, taxes, shipping costs, payment methods, account book, analytical account codes

We recommend that you use import software if you want to fill in all the values ​​quickly – especially if your product catalog is large. You can easily do this by using extensions to import / export your data, such as WP All Import.

2. Configure the data to export to EBP accounting

Go back to the settings of the “Accounting for WooCommerce” extension, from the WordPress administration: “WooCommerce> Settings”, then in the “Accounting” tab

At the bottom of the general settings page, you can define the column headers of your export file, as well as their order .

Export what you want to what you want!

3. Export your entries from WooCommerce

To export your orders to your accounting software (EBP, Ciel or other), simply go to “WooCommerce> Export Accounting”.

Vous pouvez alors choisir ce que vous souhaitez exporter : You can then choose what you want to export:

Define the parameters of your accounting export

Here are all the export criteria that you can configure:

  • Start and end date of export, by choosing the date format
  • Date: order, validation, payment, invoicing
  • See the payment method, or not
  • Part number (invoice or order number)
  • Customers (by customer or by means of payment)
  • Products (simple or detailed)
  • Taxes (simple or detailed)
  • Shipping methods (simple or detailed)
  • Fill in the opposite amount with: empty box or “0” (according to your import preferences in your accounting software)
  • Decimal separator type (period or comma)
  • CSV separator (comma, semicolon, or tab [used for TSV format])

Export your assets

You can also export your credit notes to your accounting software, by clicking on the “Credit notes” tab (at the top of the page)

4. Import your file into EBP Accounting

On EBP Accounting , you can then import your file.

To do this, simply follow this tutorial on the EBP.com site . If you are on Mac, follow this tutorial .