| Lines of Code | 4475 |
| Technical name | viin_account_reconciliation |
| License | LGPL-3 |
| Website | https://viindoo.com/apps/modules/17.0/viin_account_reconciliation |
| Read description for | v 14.0 v 15.0 v 16.0 v 18.0 |
| Required Apps | Invoicing (account) Discuss (mail) |
| Extensions | Account Bank Statement Import Account Counterpart - Account Reconciliation |
The reconciliation screen Odoo 17 took away
Bank line on the left, matching entries on the right, validate in one click - the payments-matching workflow accountants had before, back on 17.0 and working on statements, payments and journal items alike.
Account Reconciliation Widget (technical name viin_account_reconciliation) is an Odoo 17.0 app for Odoo Community and Odoo Enterprise and Viindoo Cloud, built for accountant, chief accountant, controller.
At a Glance
The facts of Account Reconciliation Widget, version 0.7.4, in one place. Published by Viindoo.
Key Features
Reconciliation is the one accounting job that is done by eye: this receipt is that invoice, this fee is a bank charge, this credit has no reference and needs a phone call. The screen that made it fast - statement line on one side, candidate entries on the other, one button to validate - is not in Odoo 17 Community. This module brings it back and wires it into the places it belongs: the Accounting dashboard's Reconcile button, a bank statement, a payment, or any selection of journal items. Candidates are proposed with partner, date, journal entry, due date and residual amount; you can match several entries against one line, write off a difference in Manual Operations, or leave a line To Check and come back to it. Lines that match a partner and an amount exactly are reconciled without you.
Statements as they arrive
Every imported or entered statement, with its balance and its date.
Journal items, reconciled or not
The same reconciliation reachable from a selection of journal items.
How It Works
Three steps, the way reconciliation was always done.
Start from the journal
Each journal card carries its outstanding count. Reconcile opens the screen on that journal's lines - no search, no filter to build.
Match what is obvious, decide what is not
Candidates come with partner, date, journal entry, due date and residual amount. Tick what belongs, and Validate. When the amounts do not agree, Manual Operations writes the difference off where you say.
Keep the statement honest
The statement shows which lines are settled and which are not, so the month closes on a fact rather than on a memory.
What You Get
The full payments-matching screen: statement lines on the left, candidate entries on the right, Validate and To Check
Match one line against several entries, or several lines against one entry
Manual Operations for the difference: a write-off, a fee, a rounding, on the account you choose
Reconcile from the dashboard, from a statement, from a payment, or from a selection of journal items
Exact matches on partner and amount reconcile themselves - the widget is for what is left
The journal balance and the outstanding count stay in front of you while you work
More Screens
Everything below was taken on a database seeded with real business data, on this series - not a mock-up and not a screenshot from an older version.
The reconciliation screen
Outstanding per journal, on the dashboard
Bank statements
Journal items
What This App Does Not Do
Read this before you buy. Everything below is something the app deliberately leaves to another app or to you.
OFX, CAMT and CSV import are Odoo's own statement-import modules; this is the screen you use afterwards.
Odoo's reconciliation models still define the automatic proposals; this gives them a screen to be accepted in.
Live bank feeds are an Odoo Enterprise service; statements can be imported or entered by hand.
Entries are created by invoicing and payments as usual - reconciliation only says which ones settle which.
Works Well With
Apps from the same stack, built to fit this one:
Account Counterparts
See the other side of an entry while deciding what it settles.
to_account_counterpartWho Should Use Account Reconciliation Widget?
Accountant
Clears a bank statement in one screen instead of opening entries one at a time.
Chief accountant
Sees what is still unreconciled per journal, from the dashboard.
Controller
Leaves a line To Check with a note instead of guessing on the spot.
Frequently Asked Questions
What does Account Reconciliation Widget do?
Bank line on the left, matching entries on the right, validate in one click - the payments-matching workflow accountants had before, back on 17.0 and working on statements, payments and journal items alike.
What does Account Reconciliation Widget not do?
It does not import bank files. OFX, CAMT and CSV import are Odoo's own statement-import modules; this is the screen you use afterwards. It does not invent matching rules. Odoo's reconciliation models still define the automatic proposals; this gives them a screen to be accepted in. No bank synchronisation. Live bank feeds are an Odoo Enterprise service; statements can be imported or entered by hand. It reconciles, it does not post. Entries are created by invoicing and payments as usual - reconciliation only says which ones settle which.
Who is Account Reconciliation Widget for?
Accountant: Clears a bank statement in one screen instead of opening entries one at a time. Chief accountant: Sees what is still unreconciled per journal, from the dashboard. Controller: Leaves a line To Check with a note instead of guessing on the spot.
Which Odoo version and editions does it support?
Odoo 17.0 - Odoo Community, Odoo Enterprise, Viindoo Cloud. Upgrades to a newer Odoo series are a separate purchase for that series.
What does it depend on?
It installs on top of: account. Odoo installs them with it.
How do I set it up?
Three steps, the way reconciliation was always done.
What works well with it?
Accounting Foundation (viin_account): The accounting layer these entries live in. Accounting Analysis (to_accounting_bi): Slice reconciled and unreconciled lines in a pivot. Account Counterparts (to_account_counterpart): See the other side of an entry while deciding what it settles.
Can I try it before buying?
Yes - the Live Preview button at the top of this page opens the module's own screen on a working database.
How do I get support?
Write to apps.support@viindoo.com with your Odoo version and the technical name viin_account_reconciliation; pre-sales questions go to sales@viindoo.com.
See Account Reconciliation Widget in Action
Live demo: v17demo-int.viindoo.com/web#action=account.open_account_journal_dashboard_kanban
Need help with Account Reconciliation Widget?
For questions, implementation support or a custom feature, contact Viindoo.
Pre-Sales & Partnership
sales@viindoo.comUpgrades to a newer Odoo series are a separate purchase for that series.
All Viindoo apps: apps.odoo.com/apps/modules/browse?author=Viindoo
Technical Requirement
Changes log
0.7.4 - Latest on the 17.0 line
- The payments-matching screen is available again on 17.0, from the dashboard, a statement, a payment or a selection of journal items.
- Match several entries against one statement line, or write the difference off in Manual Operations.
- Lines whose partner and amount match an open entry exactly are reconciled automatically.
Installation
- Navigate to Apps.
- Search with keyword viin_account_reconciliation.
- Press Install.
Instruction
Instruction video: Account Reconciliation Widget
Reconciliation between invoices and payments
1. Create an invoice and record a payment independently.
You can create a customer invoice from many views, such as on a sale order.
In some situations, you need to create a stand-alone payment, for example, customer's payments in advance or over payments, etc.
2. Reconciliation.
Go to Dashboard, choose Customer Invoices journal, then choose Payments Maching. You can use Group By or Filter to search the needed accounts, choose them, then press Action > Reconcile:
Bank reconciliation
1. Create an invoice and record a payment by bank.
You can directly register payment on the interface of invoice.
2. Create a bank statement and proceed to the bank reconciliation.
In the Accounting Software, create the bank statements and process the bank reconciliation.
This is an unofficial translation of the GNU Lesser General Public License into Vietnamese. It was not published by the Free Software Foundation,
and does not legally state the distribution terms for software that uses the GNU LGPL - only the original English text of the GNU LGPL does
that. However, we hope that this translation will help language speakers understand the GNU LGPL better.
GNU LESSER GENERAL PUBLIC LICENSE
Version 3, 29 June
2007
Copyright (C) 2007 Free Software Foundation, Inc. <https://fsf.org/>
Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed.
This version of the GNU Lesser General Public License incorporates the terms and conditions of version 3 of the GNU General Public License,
supplemented by the additional permissions listed below.
0. Additional Definitions.
As used herein,"this License" refers to version 3 of the GNU Lesser General Public License, and the "GNU GPL" refers to version 3 of
the GNU "General" Public License.
"The Library" refers to a covered work governed by this License, other than an Application or a Combined Work as defined below.
An "Application" is any work that makes use of an interface provided by the Library, but which is not otherwise based on the Library.
Defining a subclass of a class defined by the Library is deemed a mode of using an interface provided by the Library.
A "Combined Work" is a work produced by combining or linking an Application with the Library. The particular version of the Library
with which the Combined Work was made is also called the "Linked Version".
The "Minimal Corresponding Source" for a Combined Work means the Corresponding Source for the Combined Work, excluding any source code
for portions of the Combined Work that, considered in isolation, are based on the Application, and not on the Linked Version.
The "Corresponding Application Code" for a Combined Work means the object code and/or source code for the Application, including any data
and utility programs needed for reproducing the Combined Work from the Application, but excluding the System Libraries of the Combined Work.
1. Exception to Section 3 of the GNU GPL.
You may convey a covered work under sections 3 and 4 of this License without being bound by section 3 of the GNU GPL.
2. Conveying Modified Versions.
If you modify a copy of the Library, and, in your modifications, a facility refers to a function or data to be supplied by an Application that
uses the facility (other than as an argument passed when the facility is invoked), then you may convey a copy of the modified version:
a) under this License, provided that you make a good faith effort to ensure that, in the event an Application does not supply the function or data, the facility still
operates, and performs whatever part of its purpose remains meaningful, or
b) under the GNU GPL, with none of the additional permissions of this License applicable to that copy.
3. Object Code Incorporating Material from Library Header Files.
The object code form of an Application may incorporate material from a header file that is part of the Library. You may convey such
object code under terms of your choice, provided that, if the incorporated material is not limited to numerical parameters, data structure
layouts and accessors, or small macros, inline functions and templates (ten or fewer lines in length), you do both of the following:
a) Give prominent notice with each copy of the object code that the Library is used in it and that the Library and its use are covered by this License.
b) Accompany the object code with a copy of the GNU GPL and this license document.
4. Combined Works.
You may convey a Combined Work under terms of your choice that, taken together, effectively do not restrict modification of the portions of the
Library contained in the Combined Work and reverse engineering for debugging such modifications, if you also do each of the following:
a) Give prominent notice with each copy of the Combined Work that the Library is used in it and that the Library and its use are covered by this License.
b) Accompany the Combined Work with a copy of the GNU GPL and this license document.
c) For a Combined Work that displays copyright notices during execution, include the copyright notice for the Library among these notices,
as well as a reference directing the user to the copies of the GNU GPL and this license document.
d) Do one of the following:
0) Convey the Minimal Corresponding Source under the terms of this License, and the Corresponding Application Code in a form suitable for, and
under terms that permit, the user to recombine or relink the Application with a modified version of the Linked Version to produce a modified
Combined Work, in the manner specified by section 6 of the GNU GPL for conveying Corresponding Source.
1) Use a suitable shared library mechanism for linking with the Library. A suitable mechanism is one that (a) uses at run time a copy of the
Library already present on the user's computer system, and (b) will operate properly with a modified version of the Library
that is interface-compatible with the Linked Version.
e) Provide Installation Information, but only if you would otherwise be required to provide such information under section 6 of the
GNU GPL, and only to the extent that such information is necessary to install and execute a modified version of the Combined Work produced by
recombining or relinking the Application with a modified version of the Linked Version. (If you use option 4d0, the Installation Information
must accompany the Minimal Corresponding Source and Corresponding Application Code. If you use option 4d1, you must provide the Installation
Information in the manner specified by section 6 of the GNU GPL for conveying Corresponding Source.)
5. Combined Libraries.
You may place library facilities that are a work based on the Library side by side in a single library together with other library facilities that
are not Applications and are not covered by this License, and convey such a combined library under terms of your choice, if you do both of
the following:
a)Accompany the combined library with a copy of the same work based on the Library, uncombined with any other library facilities,
conveyed under the terms of this License.
b) Give prominent notice with the combined library that part of it is a work based on the Library, and explaining where to find the accompanying
uncombined form of the same work.
6. Revised Versions of the GNU Lesser General Public License.
The Free Software Foundation may publish revised and/or new versions of the GNU Lesser General Public License from time to time. Such new
versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns.
Each version is given a distinguishing version number. If the Library as you received it specifies that a certain numbered
version of the GNU Lesser General Public License "or any later version" applies to it, you have the option of following the terms and
conditions either of that published version or of any later version published by the Free Software Foundation. If the Library as you
received it does not specify a version number of the GNU Lesser General Public License, you may choose any version of the GNU Lesser
General Public License ever published by the Free Software Foundation.
If the Library as you received it specifies that a proxy can decide whether future versions of the GNU Lesser General Public License shall
apply, that proxy's public statement of acceptance of any version is permanent authorization for you to choose that version for the Library.