Accounting export

To speed up your document entry and make it easier for your accountant to process your data, you'd like to add your accounting codes to your export?

Set up your accounting codes for third parties (customers, suppliers), income and VAT, expense accounts, bank accounts, and export entries corresponding to your invoicing and purchases, in accounting format, such as a journal, in cvs or excel versions.

Activating the"Export Comptable" application adds the following new elements to your application:

• An"accounting code" field in product files, product categories, third parties and bank accounts.
• An accounting data export configuration menu in the shortcut block of your export page. It allows you to configure your VAT account numbers and expense accounts, and to set the export format for your data.
• New export options :
  • Invoice (accountantPlus)
  • Purchasing (accounting)
  • Purchase (accountantPlus)
  • Payment (CollectionBank)
  • Settlement (DisbursementBank)
     

1. Add product and third-party accounts

To add accounting codes to your products or third parties, open a product or customer file.

In the"accounting code" field, enter the accounting number to be attached to your product or customer.
For third parties, you can assign a customer and/or supplier accounting code to each, depending on the nature of your transactions.

Example: if the accounting class of your product, defined with your accountant, is 708000 for example, complete this number in the "accounting code" field. Similarly, if your customer falls into accounting class 411000, enter this number in the "accounting code" field. If it's a supplier, you can enter the number 401000.

2. Definition of VAT accounts

To set up your VAT accounting code(s), go to the export configuration menu.

To do this, click on the"export" link at the top of each page. In the shortcut block on this page, click on the"Config accounting fields" link.

On the new page that appears, click on the" VAT accounting codes" link, to set up your VAT accounts. The VAT table lists all the VAT values used in the application. You can define your VAT on sales and your VAT on purchases.

3. Recording expense accounts

Accounting accounts for purchases are set up according to the financial categories to which they belong.

To define your expense accounting codes by financial category, in the settings section, click on the"Financial category accounting codes" link. Assign a more precise class or account number to each financial category.

4. Bank account entry

To export your incoming and outgoing payments with the accounting entries corresponding to the bank movements, go to the "Bank account" menu and click on "Modify" on one of your bank accounts. 

In the"accounting code" field, enter the accounting number to be attached to your bank account and save. This information will be taken into account in the following exports: 

• Payment (CollectionBank)
• Settlement (DisbursementBank)

In these two exports, find for each entry the cash movements for: the third party and the bank.

The bank line is only exported when the payment is marked "seen on account" on the incoming or outgoing payment in the application.

5. Set export format 

This accounting export application also lets you set the format of the accounting data to be included in your export.

You may simply choose the format initially entered in your "accounting code" fields, or you may wish to supplement it with additional information, such as date or product reference.

To compose and customize your format, click on"Invoice accounting export" or"Purchase accounting export" in the"Accounting fields setup" menu. Click on"modify" to set your "accounting code" export field, and enter your format.

Examples:

• Indicate (TIERSACC)(YY)(MM) on the customer line, to display an export format 4110001203 (for an invoice dated March 2012).
• Enter (TIERSACC)(YY)(MM)(DD) on the supplier line, to display an export format 401000120315 (for an invoice dated March 15, 2012).