Bank Account Reconciliation

account_banking_reconciliation · OCA/account-reconcile

    Repository
    OCA/account-reconcile · module folder · Try on Runboat
    Module version
    1.0.0
    Category
    Accounting and Financial Management
    Folder size
    0.25 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    https://github.com/OCA/account-reconcile
    Last tracking update
    2026-08-07 07:32:00
    Authors
    Odoo Community Association (OCA), NovaPoint Group LLC, Open Source Integrators
    Maintainers
    Odoo Community Association (OCA), NovaPoint Group LLC, Open Source Integrators
    Committers
    Miquel Raïch, Weblate, OCA Transbot, OCA-git-bot, oca-travis, Murtuza Saleh
    Odoo dependencies
    odoo/odoo:
    - account_voucher
    - account
    - base_setup
    - base
    - web
    - product
    - decimal_precision
    - mail
    - bus
    - web_tour
    - uom
    - analytic
    - portal
    - http_routing
    - digest
    Python dependencies
    None
    System dependencies
    None
    Required by
    l10n_us_account_profile
    Description
    
    
    

    


    

    Code Analysis ⓘ
    

    Views touched (9)
    


    

    
    
    XML IDNameModelTypeStatus
    
    
        
        
    
            report_bank_statement_detail
            report_bank_statement_detail
            ir.ui.view
            qweb
            
                
                New
                
            
        
    
        
        
    
            report_bank_statement_detail_doc
            report_bank_statement_detail_doc
            ir.ui.view
            qweb
            
                
                New
                
            
        
    
        
        
    
            report_bank_statement_summary
            report_bank_statement_summary
            ir.ui.view
            qweb
            
                
                New
                
            
        
    
        
        
    
            report_bank_statement_summary_doc
            report_bank_statement_summary_doc
            ir.ui.view
            qweb
            
                
                New
                
            
        
    
        
        
    
            view_account_move_line_bank_acc_rec_statement_id
            account.move.line
            account.move.line
            search
            
                
                Inherits account.view_account_move_line_filter
                
            
        
    
        
        
    
            view_account_move_line_bank_acc_rec_statement_id_form
            account.move.line.form
            account.move.line
            form
            
                
                Inherits account.view_move_line_form
                
            
        
    
        
        
    
            view_bank_acc_rec_statement_filter
            bank.acc.rec.statement.select
            bank.acc.rec.statement
            search
            
                
                New
                
            
        
    
        
        
    
            view_bank_acc_rec_statement_form
            bank.acc.rec.statement.form
            bank.acc.rec.statement
            form
            
                
                New
                
            
        
    
        
        
    
            view_bank_acc_rec_statement_tree
            bank.acc.rec.statement.tree
            bank.acc.rec.statement
            tree
            
                
                New
                
            
        
    
        
        

    

    



    HTTP endpoints (0)
    


    No HTTP endpoints found for this module.
    



    Models touched (3)
    


    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (3)
                
                
      
                    
                    
    • 
                        bank_acc_rec_statement_id
                        Many2one → bank.acc.rec.statement
                        
                        
      
                            
                            
                            
                            help='The Bank Acc Rec Statement linked with the journal item'
                            
                            string='Bank Acc Rec Statement'
                            
                            args: 'bank.acc.rec.statement'
                        
      
                        
                    
      • 
                    
                    
    • 
                        cleared_bank_account
                        Boolean
                        
                        
      
                            
                            help='Check if the transaction has cleared from the bank'
                            
                            string='Cleared? '
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        draft_assigned_to_statement
                        Boolean
                        
                        
      
                            
                            help='Check if the move line is assigned to statement lines'
                            
                            string='Assigned to Statement? '
                            
                            
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (0)
                
                
    No public methods.
    
                
            
    
        
    
    
    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (32)
                
                
      
                    
                    
    • 
                        account_id
                        Many2one → account.account
                        
                        
      
                            
                            
                            
                            domain="[('company_id', '=', company_id)]"
                            
                            help='The Bank/Gl Account that is being reconciled.'
                            
                            required=True
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'account.account', 'Account'
                        
      
                        
                    
      • 
                    
                    
    • 
                        cleared_balance
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total Sum of the Deposit Amount Cleared – Total Sum of Checks, Withdrawals, Debits, and Service Charges Amount Cleared'
                            
                            string='Cleared Balance'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        cleared_balance_cur
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total Sum of the Deposit Amount Cleared – Total Sum of Checks, Withdrawals, Debits, and Service Charges Amount Cleared'
                            
                            string='Cleared Balance (Cur)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        company_id
                        Many2one → res.company
                        
                        
      
                            
                            
                            
                            default=get_default_company_id
                            
                            help='The Company for which the deposit ticket is made to'
                            
                            readonly=True
                            
                            required=True
                            
                            args: 'res.company', 'Company'
                        
      
                        
                    
      • 
                    
                    
    • 
                        credit_move_line_ids
                        One2many → bank.acc.rec.statement.line
                        
                        
      
                            
                            
                            
                            copy=False
                            
                            domain=[('type', '=', 'cr')]
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'bank.acc.rec.statement.line', 'statement_id', 'Credits'
                        
      
                        
                    
      • 
                    
                    
    • 
                        debit_move_line_ids
                        One2many → bank.acc.rec.statement.line
                        
                        
      
                            
                            
                            
                            copy=False
                            
                            domain=[('type', '=', 'dr')]
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'bank.acc.rec.statement.line', 'statement_id', 'Debits'
                        
      
                        
                    
      • 
                    
                    
    • 
                        difference
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='(Ending Balance – Beginning Balance) - Cleared Balance.'
                            
                            string='Difference'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        difference_cur
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='(Ending Balance – Beginning Balance) - Cleared Balance.'
                            
                            string='Difference (Cur)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        ending_balance
                        Float
                        
                        
      
                            
                            
                            
                            digits=dp.get_precision('Account')
                            
                            help='The Ending Balance on your bank statement.'
                            
                            required=True
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'Ending Balance'
                        
      
                        
                    
      • 
                    
                    
    • 
                        ending_date
                        Date
                        
                        
      
                            
                            
                            
                            default=time.strftime('%Y-%m-%d')
                            
                            help='The ending date of your bank statement.'
                            
                            required=True
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'Ending Date'
                        
      
                        
                    
      • 
                    
                    
    • 
                        last_ending_date
                        Date
                        
                        
      
                            
                            
                            
                            help='The previous statement date of your bank statement.'
                            
                            args: 'Last Stmt Date'
                        
      
                        
                    
      • 
                    
                    
    • 
                        name
                        Char
                        
                        
      
                            
                            
                            
                            help='This is a unique name identifying the statement (e.g. Bank X January 2012).'
                            
                            required=True
                            
                            size=64
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'Name'
                        
      
                        
                    
      • 
                    
                    
    • 
                        notes
                        Text
                        
                        
      
                            
                            
                            
                            args: 'Notes'
                        
      
                        
                    
      • 
                    
                    
    • 
                        starting_balance
                        Float
                        
                        
      
                            
                            
                            
                            digits=dp.get_precision('Account')
                            
                            help='The Starting Balance on your bank statement.'
                            
                            required=True
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'Starting Balance'
                        
      
                        
                    
      • 
                    
                    
    • 
                        state
                        Selection
                        
                        
      
                            
                            
                            
                            default='draft'
                            
                            index=True
                            
                            readonly=True
                            
                            args: [('draft', 'Draft'), ('to_be_reviewed', 'Ready for Review'), ('done', 'Done'), ('cancel', 'Cancelled')], 'State'
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_credits
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = True'
                            
                            string='Checks, Withdrawals, Debits, and Service Charges Amount'
                            
                            type='float'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_credits_cur
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = True'
                            
                            string='Checks, Withdrawals, Debits, and Service Charges Amount (Cur)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_credits_lines
                        Integer
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            help='Total of number of lines with Cleared = True'
                            
                            string='Checks, Withdrawals,\n                                          Debits, and Service Charges # of\n                                          Items'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_debits
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = True'
                            
                            string='Deposits, Credits, and Interest Amount'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_debits_cur
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = True'
                            
                            string='Deposits, Credits, and Interest Amount (Cur)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_debits_lines
                        Integer
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            help='Total of number of lines with Cleared = True'
                            
                            string='Deposits, Credits, and\n                                         Interest # of Items'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_ucredits
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = False'
                            
                            string='Uncleared - Checks, Withdrawals, Debits, and Service Charges Amount'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_ucredits_cur
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = False'
                            
                            string='Uncleared - Checks, Withdrawals, Debits, and Service Charges Amount (Cur)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_ucredits_lines
                        Integer
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            help='Total of number of lines with Cleared = False'
                            
                            string='Uncleared - Checks, Withdrawals, Debits, and Service Charges # of Items'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_udebits
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = False'
                            
                            string='Uncleared - Deposits, Credits, and Interest Amount'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_udebits_cur
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total SUM of Amts of lines with Cleared = False'
                            
                            string='Uncleared - Deposits, Credits, and Interest Amount (Cur)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        sum_of_udebits_lines
                        Integer
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            help='Total of number of lines with Cleared = False'
                            
                            string='Uncleared - Deposits,\n                                          Credits, and Interest # of Items'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        suppress_ending_date_filter
                        Boolean
                        
                        
      
                            
                            
                            
                            help='If this is checked then the Statement End Date filter on the transactions below will not occur. All transactions would come over.'
                            
                            args: 'Remove Ending Date Filter'
                        
      
                        
                    
      • 
                    
                    
    • 
                        uncleared_balance
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total Sum of the Deposit Amount Uncleared – Total Sum of Checks, Withdrawals, Debits, and Service Charges Amount Uncleared'
                            
                            string='Uncleared Balance'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        uncleared_balance_cur
                        Float
                        
                        
      
                            
                            compute='_compute_get_balance'
                            
                            digits=dp.get_precision('Account')
                            
                            help='Total Sum of the Deposit Amount Uncleared – Total Sum of Checks, Withdrawals, Debits, and Service Charges Amount Uncleared'
                            
                            string='Unleared Balance (Cur)'
                            
                            
                        
      
                        
                    
      • 
                    
                    
    • 
                        verified_by_user_id
                        Many2one → res.users
                        
                        
      
                            
                            
                            
                            copy=False
                            
                            help='Entered automatically by the “last user” who saved it. System generated.'
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'res.users', 'Verified By'
                        
      
                        
                    
      • 
                    
                    
    • 
                        verified_date
                        Date
                        
                        
      
                            
                            
                            
                            copy=False
                            
                            help='Date in which Deposit Ticket was verified.'
                            
                            states={'done': [('readonly', True)]}
                            
                            args: 'Verified Date'
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (15)
                
                
      
                    
                    
    • 
                        action_cancel(self)
                        
      @api.multi
      
                        
      Cancel the the statement.
      
                    
      • 
                    
                    
    • 
                        action_cancel_draft(self)
                        
      @api.multi
      
                        
      Reset the statement to draft and perform resetting operations.
      
                    
      • 
                    
                    
    • 
                        action_process(self)
                        
      @api.multi
      
                        
      Set the account move lines as 'Cleared' and
Assign 'Bank Acc Rec Statement ID'
for the statement lines which are marked as 'Cleared'.
      
                    
      • 
                    
                    
    • 
                        action_review(self)
                        
      @api.multi
      
                        
      Change the status of statement from 'draft' to 'to_be_reviewed'.
      
                    
      • 
                    
                    
    • 
                        action_select_all(self)
                        
      @api.multi
      
                        
      Mark all the statement lines as 'Cleared'.
      
                    
      • 
                    
                    
    • 
                        action_unselect_all(self)
                        
      @api.multi
      
                        
      Reset 'Cleared' in all the statement lines.
      
                    
      • 
                    
                    
    • 
                        check_difference_balance(self)
                        
      @api.multi
      
                        
                    
      • 
                    
                    
    • 
                        check_group(self)
                        
      @api.multi
      
                        
      Check if following security constraints are implemented for groups:
Bank Statement Preparer– they can create, view and delete any of the
Bank Statements provided the Bank Statement is not in the DONE state,
or the Ready for Review state.
Bank Statement Verifier – they can create, view, edit, and delete any
of the Bank Statements information at any time.
NOTE: DONE Bank Statements  are only allowed to be deleted by a
Bank Statement Verifier.
      
                    
      • 
                    
                    
    • 
                        copy(self, default=None)
                        
      @api.multi
      
                        
                    
      • 
                    
                    
    • 
                        get_default_company_id(self)
                        
                        
                    
      • 
                    
                    
    • 
                        get_starting_balance(self, account_id, ending_date)
                        
      @api.multi
      
                        
                    
      • 
                    
                    
    • 
                        onchange_account_id(self)
                        
      @api.onchange('account_id', 'ending_date', 'suppress_ending_date_filter')
      
                        
                    
      • 
                    
                    
    • 
                        refresh_record(self)
                        
      @api.multi
      
                        
                    
      • 
                    
                    
    • 
                        unlink(self)
                        
      @api.multi
      
                        
      Check if the user is allowed to perform the action
      
                    
      • 
                    
                    
    • 
                        write(self, vals)
                        
      @api.multi
      
                        
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    
    
    
        
    
            
        
    
        
    
            
    
                New fields (12)
                
                
      
                    
                    
    • 
                        amount
                        Float
                        
                        
      
                            
                            
                            
                            digits=dp.get_precision('Account')
                            
                            help="Derived from the 'debit' amount from related Journal Item."
                            
                            args: 'Amount'
                        
      
                        
                    
      • 
                    
                    
    • 
                        amountcur
                        Float
                        
                        
      
                            
                            
                            
                            digits=dp.get_precision('Account')
                            
                            help="Derived from the 'amount currency' amount from related Journal Item."
                            
                            args: 'Amount in Currency'
                        
      
                        
                    
      • 
                    
                    
    • 
                        cleared_bank_account
                        Boolean
                        
                        
      
                            
                            
                            
                            help='Check if the transaction has cleared from the bank'
                            
                            args: 'Cleared? '
                        
      
                        
                    
      • 
                    
                    
    • 
                        currency_id
                        Many2one → res.currency
                        
                        
      
                            
                            
                            
                            help='The optional other currency if it is a multi-currency entry.'
                            
                            args: 'res.currency', 'Currency'
                        
      
                        
                    
      • 
                    
                    
    • 
                        date
                        Date
                        
                        
      
                            
                            
                            
                            help='Derived from related Journal Item.'
                            
                            required=True
                            
                            args: 'Date'
                        
      
                        
                    
      • 
                    
                    
    • 
                        move_line_id
                        Many2one → account.move.line
                        
                        
      
                            
                            
                            
                            help='Related Journal Item.'
                            
                            args: 'account.move.line', 'Journal Item'
                        
      
                        
                    
      • 
                    
                    
    • 
                        name
                        Char
                        
                        
      
                            
                            
                            
                            help='Derived from the related Journal Item.'
                            
                            required=True
                            
                            size=64
                            
                            args: 'Name'
                        
      
                        
                    
      • 
                    
                    
    • 
                        partner_id
                        Many2one → res.partner
                        
                        
      
                            
                            
                            
                            help='Derived from related Journal Item.'
                            
                            string='Partner'
                            
                            args: 'res.partner'
                        
      
                        
                    
      • 
                    
                    
    • 
                        ref
                        Char
                        
                        
      
                            
                            
                            
                            help='Derived from related Journal Item.'
                            
                            size=64
                            
                            args: 'Reference'
                        
      
                        
                    
      • 
                    
                    
    • 
                        research_required
                        Boolean
                        
                        
      
                            
                            
                            
                            help='Check if the transaction should be researched by Accounting personal'
                            
                            args: 'Research Required? '
                        
      
                        
                    
      • 
                    
                    
    • 
                        statement_id
                        Many2one → bank.acc.rec.statement
                        
                        
      
                            
                            
                            
                            ondelete='cascade'
                            
                            required=True
                            
                            args: 'bank.acc.rec.statement', 'Statement'
                        
      
                        
                    
      • 
                    
                    
    • 
                        type
                        Selection
                        
                        
      
                            
                            
                            
                            args: [('dr', 'Debit'), ('cr', 'Credit')], 'Cr/Dr'
                        
      
                        
                    
      • 
                    
                
    
                
                Public methods (2)
                
                
      
                    
                    
    • 
                        create(self, vals)
                        
      @api.model
      
                        
                    
      • 
                    
                    
    • 
                        unlink(self)
                        
      @api.multi
      
                        
                    
      • 
                    
                
    
                
            
    
        
    
    
    
    

    


    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
    
        
    Loading…
    
    
    
    
    
    
    
    
        
    
            
    Status
    
            
    Open migration PR — not merged yet for this version
    
            
    CI status
    
            
    
                no CI data
            
    
            
    Open since
    
            
    1375 days ago
    
            
    Last activity
    
            
    1144 days ago
    
            
    Repository
    
            
    OCA/account-reconcile
    
            
    Pull request
    
            
    [13.0][MIG] account_banking_reconciliation (#506)