Advantages over Standard Odoo Balance Initialization

Compared to the standard Odoo method of initializing balances (usually through a single journal entry or importing opening balances), this module offers several key advantages:

• Incremental Synchronization: Unlike a static import, this module allows you to see the current Odoo balances versus external balances and post only the differences.
• Support for Storno Accounting: Automatically handles negative debit or credit values by marking them as “storno” transactions, ensuring compliance with Romanian accounting standards.
• Partner-Level Detail: Balances can be synchronized at the partner level, allowing for a much more granular initialization of accounts receivable and payable.
• Workflow Management: Provides a clear workflow with ‘Draft’ and ‘Posted’ states. You can generate lines, review them, and if something is wrong, reset to draft which automatically deletes the generated journal entries.
• Traceability: Maintains a direct link between the synchronization record and all generated journal entries, making it easy to audit the initialization process.

Key Features

• Import functionality for chart of accounts through a dedicated action () action_import_chart_of_accounts
• Extended account move line functionality to handle storno operations (negative debit and credit values)
• Automatic detection and marking of storno transactions in accounting entries
• Integration with Romanian accounting standards

Technical Implementation

The module extends the account.move.line model to implement storno accounting functionality. When a debit or credit amount is set to a negative value, the transaction is automatically marked as a storno transaction, along with its parent move. This implementation ensures proper handling of corrective accounting entries in compliance with accounting standards.

Module Structure

The module follows the standard Odoo addon structure with:

• Models directory containing the business logic
• Views directory for UI components
• Security settings for access rights
• Documentation in README format

Integration

This module is part of the Bitshop collection of addons and is designed to work seamlessly with the Odoo accounting system, particularly for Romanian localization.

Table of contents

Step-by-Step Guide

1. Access the Synchronization Menu

Go to **Accounting > Configuration > Accounts > Synchronization Chart of Accounts**.

2. Create a Synchronization Record

• Click New to create a new synchronization session.
• Name: Give it a descriptive name (e.g., “Opening Balances 2024”).
• Date: The date at which you want to calculate the balances.
• Partner Detail: Check this if you want to synchronize balances at the partner level (useful for AR/AP accounts).
• Account: (Optional) Select a specific account to synchronize, or leave empty to process all accounts.
• Journal: Select the journal where the adjustment entries will be posted.
• Equity Unaffected Account: Specify the account used to balance the entries (usually an opening balance or retained earnings account).

3. Generate Comparison Lines

* Click the **Generate lines** button.
* Odoo will calculate the current debit, credit, and balance for the selected accounts up to the specified date.
* These values will be populated in the **Debit**, **Credit**, and **Balance** fields of the synchronization lines.

4. Enter External Values
~~~~~~~~~~~~~~~~~~~~~~~~
* Click the **Show** button to view the generated lines.
* In the list view, you will see the Odoo balances alongside "External" fields.
* Fill in the **Debit External** and **Credit External** fields with the values from your external system or trial balance.
* Lines where the Odoo balance differs from the external balance will be highlighted.
* You can also use the Odoo import feature to upload these external values from a CSV or Excel file.

5. Post Differences
~~~~~~~~~~~~~~~~~~~
* Once all external values are entered and reviewed, click the **Post difference** button in the lines list view.
* The module will calculate the difference for each line and generate the necessary journal entries:
    * It creates standard journal entries for positive adjustments.
    * It creates **Storno** journal entries for negative adjustments (if the company is configured for Storno accounting).
* The synchronization record's state will change to **Posted**.

6. Review and Audit
~~~~~~~~~~~~~~~~~~~
* After posting, you can view the generated journal entries in the **Journal Entries** tab of the synchronization record.
* The system maintains a direct link between the synchronization session and the accounting moves for full traceability.

7. Reset to Draft (If needed)

• If you discover an error after posting, click the Reset to draft button on the synchronization record.
• This will:
  • Cancel and delete the generated journal entries.
  • Reset the synchronization record’s state to Draft.
  • Re-generate the lines so you can correct the external values and post again.

Authors

• Terrabit
• Dorin Hongu

Maintainers

Current maintainer:

This module is part of the terrabit-ro/bitshop project on GitHub.

You are welcome to contribute.