<a class="reference external image-reference" href="http://www.gnu.org/licenses/agpl-3.0-standalone.html"><img alt="License: AGPL-3" src="https://img.shields.io/badge/licence-AGPL--3-blue.svg"> </a> <a name="bank-statement-reconciliation-summary"></a> <h2>Bank Statement Reconciliation Summary</h2> <p>The Bank Reconciliation Summary shows how your actual bank statement balance and the balance of the bank account in Odoo match, after taking into account any unreconciled items.</p> <p>This report is useful if your bank account's statement balance and balance in Odoo do not match, and you need to check for duplicate or manually created transactions that might cause the discrepancy.</p> <p>This report was created, inspired by Xero’s bank reconciliation summary, <a class="reference external" href="https://help.xero.com/Report_BankRec">https://help.xero.com/Report_BankRec</a>, and from a basic explanation of the bank statement reconciliation summary: <a class="reference external" href="http://www.accountingcoach.com/bank-reconciliation/explanation">http://www.accountingcoach.com/bank-reconciliation/explanation</a>.</p> <a name="usage"></a> <h3>Usage</h3> <a name="define-accounts"></a> <h4>Define Accounts</h4> <p>There are three accounts associated to a bank account: * Bank account view * Bank Account. Matches the statement * Bank Clearing Account. Is used for uncleared payments and receipts. The</p> <blockquote> Bank Clearing Account is a reconcilable account.</blockquote> <p>In the definition of the bank account that is used to match with the bank statement, define what will be the GL account used to record the uncleared payments and receipts.</p> <a name="define-account-journals"></a> <h4>Define Account Journals</h4> <p>Create the following journals: * Journal for Bank Statement reconciliation * Journal to enter Payments and Receipts that have not yet cleared to the bank</p> <a name="enter-payments-and-receipts"></a> <h4>Enter payments and receipts</h4> <p>Every time an invoice is paid, use the Journal to enter Payments and Receipts. It will generate: Dr. Accounts Payable Cr. Bank Clearing Account</p> <a name="create-a-bank-statement"></a> <h4>Create a bank statement</h4> <p>Create a bank statement and select the Journal defined for bank statement reconciliation.</p> <p>If you do not use a tool to integrate automatically the bank statement feed into Odoo, you can press press the button “Import Payments and Receipts” in order to add to the statements the payments and receipts that have been generated, but that have not yet cleared the bank.</p> <p>Use the “Reconcile” button to reconcile the entries in the bank statement with the payments and receipts that have already cleared the bank.</p> <p>If you chose to import the statement lines from uncleared payments and receipts, this will be the moment where you will visually compare with the online/paper bank statement, and reconcile the items that truly cleared the bank.</p> <p>The Odoo Bank Reconciliation Wizard will be used by the user to specifically create the Bank Account entries by linking the Bank Statement lines with the Bank Clearing Account items.</p> <p>Dr. Bank Clearing Account Cr. Bank Account</p> <p>Once you have completed this process, some statement lines may be left unreconciled (because they were truly not present in the online/physical statement). In that case you can press the button “Remove Unreconciled”.</p> <a name="print-bank-statement-reconciliation-summary"></a> <h4>Print bank statement reconciliation summary</h4> <p>It will report on the current balance of the Bank Account, and will show the unreconciled entries of the Bank Clearing Account, classifying the them between Outstanding Payments (that is, credits in the Bank Clearing Account) and Outstanding Receipts (that is, debits in the Bank Clearing Account).</p> <p>The application will also show the bank statement lines that have not yet been reconciled yet, if any exists.</p> <p>Once the user has fully processed the reconciliation with the bank clearing account, all the entries in this bank clearing account should be reconciled, and the bank account (used to match with the Statement) will truly reflect the same information as the bank statement balance.</p> <p>From a bank account perspective, the total amount held in the bank is the sum of the balances of the bank clearing account (which should normally show undeposited checks, for example) and the bank account used to match with the statement.</p> <a class="reference external image-reference" href="https://runbot.odoo-community.org/runbot/91/8.0"><img alt="Try me on Runbot" src="https://odoo-community.org/website/image/ir.attachment/5784_f2813bd/datas" /></a> <a name="known-issues-roadmap"></a> <h3>Known issues / Roadmap</h3> <ul class="simple"> <li>For Odoo v9 there will be no need to use the clearing account.</li> </ul> <a name="bug-tracker"></a> <h3>Bug Tracker</h3> <p>Bugs are tracked on <a class="reference external" href="https://github.com/OCA/account-financial-reporting/issues">GitHub Issues</a>. In case of trouble, please check there if your issue has already been reported. If you spotted it first, help us smashing it by providing a detailed and welcomed feedback <a class="reference external" href="https://github.com/OCA/account-financial-reporting/issues/new?body=module:%20account_tax_report_no_zeroes%0Aversion:%208.0%0A%0A**Steps%20to%20reproduce**%0A-%20...%0A%0A**Current%20behavior**%0A%0A**Expected%20behavior**">here</a>.</p> <a name="credits"></a> <h3>Credits</h3> <a name="contributors"></a> <h4>Contributors</h4> <ul class="simple"> <li>Jordi Ballester Alomar &lt;<a class="reference external" href="mailto:contact&#64;eficent.com">contact&#64;eficent.com</a>&gt;</li> </ul> <a name="maintainer"></a> <h4>Maintainer</h4> <a class="reference external image-reference" href="https://odoo-community.org"><img alt="Odoo Community Association" src="https://odoo-community.org/logo.png" /></a> <p>This module is maintained by the OCA.</p> <p>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.</p> <p>To contribute to this module, please visit <a class="reference external" href="http://odoo-community.org">http://odoo-community.org</a>.</p>