As Woocommerce Book Keeper is set to your liking, you can export data for your Woocommerce store sales.

To do this, go to the export page: Book Keeper > export orders

export

Woocommerce Book Keeper will export orders according to the specified profile:

Period of time to export

The first requested info is of course the starting and ending dates of the orders which you want to export. The longer this period of time is, the longer can the processing time be. We always recommend that you keep your accounting up to date as possible to shorten the preocessing time. Click in the first text field and choose the starting date thanks to the calendar that appears.

date

Then do the same for the end date of the period.

Date

Now that the period of time for the sales is set up, choose which date is to be taken into account : the order date, the date the order was completed or the billing date.

date-taken-on account

Make sure you choose the same date (completed / order / billing) as chosen by your billing plugin.

Payment gateway to be displayed

You can choose to show the methods of payment in the label of your sales in 3 ways:

gateways

  • do not make it appear.
  • show up a standardized version of the initials of the payment method,
  • show up the labels previously set up in the “Payment Gateways” settings.

Document number

The default settings for the document number allows you to choose between the order number or the invoice number. Choosing the order number allows automatic lettering with the bank account in your accounting software, providing the bank statement has also been imported and holds the order number in the same field. If choosing this option, the invoice number will appear in the label.

numpiece-woocommerce-book-keeper

Export settings for customer / products / tax / shipping method

Choose to if you want to sort your export customer account by customer, country or payment method. See the settings of the corresponding sections to specify the detailed acconting codes.

customer select

For products, taxes and shipping methods, choose if you want a simple or detailed export. Simple export will take the general settings into account, while detailed will consider the accounting codes specified in the corresponding setting sections:

products

Separator

The separator is an important element, determined by your accounting software. The usual standard is the comma, but some accounting software will prefer to use the tab (useful if commas are used in the labels). Choose one between the three options:

separator

  • comma,
  • semicolon,
  • tab.

Once all settings for export are set, simply click on the export button.