Account Move Cut-off
by Pierre Verkest <pierreverkest84@gmail.com> https://github.com/OCA/account-closing , Odoo Community Association (OCA) https://github.com/OCA/account-closing| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Invoicing (account)
• Discuss (mail) |
| Community Apps Dependencies | Show |
| Lines of code | 779 |
| Technical Name |
account_move_cutoff |
| License | AGPL-3 |
| Website | https://github.com/OCA/account-closing |
Account Move Cut-off
This module allows to generate cu-toff entries automatically when posting former entries.
This module is based on account_invoice_start_end_dates which allows to define start end end dates on invoice line (account.move.line).
Following assumption have been made before developing this module:
- New method to compute cutoff amounts can be add by business modules
Note
This module as been developed with some opinionated design do not depends on account_cutoff_base. Because:
- we don't want rely on user nor async task at the end of each month (period) - link entries to understand the history without merging amounts in order to be able to keep details on deferred account move line (analytics, partners, accounts and so on)
Table of contents
Configuration
Deferred journal(s)
In accounting configuration you should set Deferred Revenue and Expense journal to be used on generated entries.
Note
Journal will be used according the kind of journal used by the former entry: sale or purchase
Deferred account(s)
On each Revenue/Expense account you can set the deferred Revenue/Expense account.
Only invoice lines linked to account with a deferred account set will generate deferred Revenue/Expense.
Cut-off Method
In the first version of this module, two cut-off computation methods are supported and can be configured using the account_move_cutoff.default_cutoff_method key. The currently possible values are monthly_prorata_temporis or equal.
Before defining these values, let’s provide some context by using an example to illustrate the definitions. Consider a sales invoice that is posted on January 16th for a service that spans from the 8th of January to the 15th of March. So, there are 24 days in January, 1 full month in February, and 15 days in March. The product is sold for 1000 for a month, so the invoice line amount (excluding VAT) is calculated as follows:
24/31 * 1000 + 1000 + 15/31 * 1000 = 2258.06
- monthly_prorata_temporis (the default if not set): This method splits amounts
over the rate of the month the product has been used. The results would be as
follows:
- January: 774.19 (2258.06 - 1000 - 483.87) (Subtraction is used here to avoid rounding discrepancies.)
- February: 1000.00 (1 * 2258.06 / (24/31 + 1 + 15/31))
- March: 483.87 (15/31 * 2258.06 / (24/31 + 1 + 15/31))
- equal: With this method, the same amount is split over the months of service.
- January: 752.68 (2258.06 - 752.69 - 752.69)
- February: 752.69 (2258.06 / 3)
- March: 752.69 (2258.06 / 3)
Please note that this information is subject to change based on updates to the module. Always refer to the latest documentation for accurate details.
Usage
To handle deferred accounting, follow these steps:
- Set the start and end date, where the end date is at least set to the month after the current entry posted date.
- Ensure that the account (the account.account configuration) in use is linked to a deferred account.
- Post the entry.
- After posting, check deferred entries have been generated, posted, and reconciled if needed.
Note
This module only defers amounts in periods subsequent to the accounting period date. For example, if an invoice is posted on March 2nd for a service from January 1st to March 31st at 1000€ per month, the deferred amount will be only 1000€ for March, leaving 2000€ in February. We never add accounting items in periods previous to the current entry date.
Known issues / Roadmap
- Make the is_deferrable_line a storable field to allow end user to not deferred a given line while posting entry. (but should raise if it’s not possible to force the value to true)
- allow to change/configure cutoff frequency (weekly/monthly/…) today only monthly is implemented
- allow to configure cutoff computation method in different place (product / invoice lines /…)
Bug Tracker
Bugs are tracked on GitHub Issues. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us to smash it by providing a detailed and welcomed feedback.
Do not contact contributors directly about support or help with technical issues.
Credits
Authors
- Pierre Verkest <pierreverkest84@gmail.com>
Maintainers
This module is maintained by the OCA.
OCA, or the Odoo Community Association, is a nonprofit organization whose mission is to support the collaborative development of Odoo features and promote its widespread use.
Current maintainer:
This module is part of the OCA/account-closing project on GitHub.
You are welcome to contribute. To learn how please visit https://odoo-community.org/page/Contribute.
Please log in to comment on this module