Pular para o conteúdo
Odoo Menu
  • Entrar
  • Experimente grátis
  • Aplicativos
    Finanças
    • Financeiro
    • Faturamento
    • Despesas
    • Planilhas (BI)
    • Documentos
    • Assinar Documentos
    Vendas
    • CRM
    • Vendas
    • PDV Loja
    • PDV Restaurantes
    • Assinaturas
    • Locação
    Websites
    • Criador de Sites
    • e-Commerce
    • Blog
    • Fórum
    • Chat ao Vivo
    • e-Learning
    Cadeia de mantimentos
    • Inventário
    • Fabricação
    • PLM - Ciclo de Vida do Produto
    • Compras
    • Manutenção
    • Qualidade
    Recursos Humanos
    • Funcionários
    • Recrutamento
    • Folgas
    • Avaliações
    • Indicações
    • Frota
    Marketing
    • Redes Sociais
    • Marketing por E-mail
    • Marketing por SMS
    • Eventos
    • Automação de Marketing
    • Pesquisas
    Serviços
    • Projeto
    • Planilhas de Horas
    • Serviço de Campo
    • Central de Ajuda
    • Planejamento
    • Compromissos
    Produtividade
    • Mensagens
    • Inteligência Artificial
    • Internet das Coisas
    • VoIP
    • Conhecimento
    • WhatsApp
    Aplicativos de terceiros Odoo Studio Plataforma Odoo Cloud
  • Setores
    Varejo
    • Loja de livros
    • Loja de roupas
    • Loja de móveis
    • Mercearia
    • Loja de ferramentas
    • Loja de brinquedos
    Comida e hospitalidade
    • Bar e Pub
    • Restaurante
    • Fast Food
    • Hospedagem
    • Distribuidor de bebidas
    • Hotel
    Imóveis
    • Imobiliária
    • Escritório de arquitetura
    • Construção
    • Gestão de Imóveis
    • Jardinagem
    • Associação de proprietários de imóveis
    Consultoria
    • Escritório de Contabilidade
    • Parceiro Odoo
    • Agência de marketing
    • Escritório de advocacia
    • Aquisição de talentos
    • Auditoria e Certificação
    Fabricação
    • Têxtil
    • Metal
    • Móveis
    • Alimentação
    • Cervejaria
    • Presentes corporativos
    Saúde e Boa forma
    • Clube esportivo
    • Loja de óculos
    • Academia
    • Profissionais de bem-estar
    • Farmácia
    • Salão de cabeleireiro
    Comércio
    • Handyman
    • Hardware e Suporte de TI
    • Sistemas de energia solar
    • Sapataria
    • Serviços de limpeza
    • Serviços de climatização
    Outros
    • Organização sem fins lucrativos
    • Agência Ambiental
    • Aluguel de outdoors
    • Fotografia
    • Aluguel de bicicletas
    • Revendedor de software
    Navegar por todos os setores
  • Comunidade
    Aprenda
    • Tutoriais
    • Documentação
    • Certificações
    • Treinamento
    • Blog
    • Podcast
    Empodere a Educação
    • Programa de educação
    • Scale Up! Jogo de Negócios
    • Visite a Odoo
    Obtenha o Software
    • Baixar
    • Comparar edições
    • Releases
    Colaborar
    • Github
    • Fórum
    • Eventos
    • Traduções
    • Torne-se um parceiro
    • Serviços para parceiros
    • Cadastre seu escritório contábil
    • Referral Program
    Obtenha os serviços
    • Encontre um parceiro
    • Encontre um Contador
    • Agende uma Demonstração
    • Serviços de Implementação
    • Referências de Clientes
    • Suporte
    • Upgrades
    Github YouTube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Faça uma demonstração
  • Preços
  • Ajuda
É necessário estar registrado para interagir com a comunidade.
Todas as publicações Pessoas Emblemas
Marcadores (Ver tudo)
odoo accounting v14 pos v15
Sobre este fórum
É necessário estar registrado para interagir com a comunidade.
Todas as publicações Pessoas Emblemas
Marcadores (Ver tudo)
odoo accounting v14 pos v15
Sobre este fórum
Ajuda

What is Reconciliation in OpenERP

Inscrever

Seja notificado quando houver atividade nesta publicação

Esta pergunta foi sinalizada
accountinginvoicev7reconciliationpayment
2 Respostas
18023 Visualizações
Avatar
Cameron

From Wiki "Reconciliation refers to a process that compares two sets of records (usually the balances of two accounts) to make sure they are in agreement" - Ok!

For our Sins we used to use Sage! We would 1. Create an Invoice in the system (purchase or sale) 2. The client would send us a remittance saying they'd paid or we would pay our supplier 3. We would reconcile the bank statement balance and entries against all the bank entries in the system, to check that the payments had cleared and balances match. Ok so far!

With Openerp when we come to reconciling the bank statement (currently just manually importing the Invoices) we find the transactions aren't their, it appears this is because they have already been reconciled! We ASSuME this has something to do with when we make the payment e.g. following the clients remittance the reconciled box has been ticked?

We also use the "account_transfer" module for bank to bank transfers, these also don't appear on the import list - we ASSuME this has something to do the stages "Confirm" and "Done"

So my question please... Is Reconciliation in OpenERP "marking invoices as paid" or "matching paid and unpaid invoices to the bank statement"?

2
Avatar
Cancelar
Mustufa Rangwala (mra)

Hi Cameron,

If I am not getting wrong you want to reconcile your existing payments with bank statement ?

Regards,

Cameron
Autor

Yes you are not wrong, you are right!

Daniel Reis

The title "What is Reconciliation in Accounting" looks more adequate (and that's still on topic IMHO)...

Avatar
Mustufa Rangwala (mra)
Melhor resposta

When you import invoices in bank statement means you are importing only unpaid invoices on it and which will be paid after validating your bank statements.

So basically whatever accounting entries/ Journal entries created by Invoices will be linked with bank statements. (You can find bank statement reference on journal items.)

Hope this help.

Regards, Mustufa Rangwala

3
Avatar
Cancelar
Cameron
Autor

Cheers, So! My thinking is!
We Validate the Invoice And when a customer pays us, we acknowledge the payment (using Customer Payments) but do NOT Validate it?.. Same with Suppliers! Then hopefully we use the Bank Reconciliation process to Validate!

Mustufa Rangwala (mra)

That flow is also correct.. but in OpenERP 6.1 version OpenERP allow to select you the Payment (Your draft customer/supplire payments) on bank statement lines but now in 7.0 its not possible so it create customer/supplier payment new does not link your existing draft payments.. Need to check this case ..

Cameron
Autor

Thanks again!

You say "That flow is ALSO correct."

What flow would you use?

Mustufa Rangwala (mra)

Cameron, I am not accountant but I can say how normally accountant can do.. They create invoice and once end of day/week/month they received bank statement and find the payment from customer they import the invoice and reconcile/paid it.. But some time it may happen accountant has to create customer payment before receiving bank statements (Cheque given and deposited) so they just create customer payment again that invoice and validate it, after receiving bank statement they can directly reconcile bank statement with existing payment (Bank Statement reconciliation..) ..

Cameron
Autor

Many many thanks!

I will proceed with the knowledge and report back how I get on!

Cameron
Autor

I know believe my problems stems from not being an accountant!

Any skills or methods that I have come from using "Sage 50" which although is a DEBKeeping package its tailored for muppets like me!

Sage's version of "reconciliation" is a wizard type module where you select every entry against the statement.

Being a muppet I was trying to replicate this, when all I needed to do was 'with a pencil' tick every entry on the bank statement that appeared in the Journal, and ensure closing balances match! KISS

Avatar
Kevin
Melhor resposta

Hi Cameron,

I too have reached this point having come from the world of Sage (currently parallel running).  I have tried to understand what we need to do here to be able to reconcile a bank statement and looked for an answer but am still struggling to understand the process in Version 7.

We have started to 'pay' our customer invoices so the aged debtors on sage and Open ERP can be reconciled, this process is going well.  The next logical step on from here (in the sage world) is to look at bank statement and to match the paper statement to the transactions in Sage.  Similar to you I presumed the creation of a bank statement in Open ERP would ‘pull’ in all of the payment transactions etc. for the period requested so we could tick off the transaction and find and enter any missing bank transactions, this is not what is currently happening.

Did you find a way to allow from a fellow sage user point of view?

Many thanks,

Kevin

 

 

0
Avatar
Cancelar
Está gostando da discussão? Não fique apenas lendo, participe!

Crie uma conta hoje mesmo para aproveitar os recursos exclusivos e interagir com nossa incrível comunidade!

Inscrever-se
Publicações relacionadas Respostas Visualizações Atividade
How to make a partially payment on multiple Invoices for a single customer
accounting invoice reconciliation payment payments
Avatar
Avatar
1
jan. 25
8659
Reconcile VAT to payment in bulk
accounting invoice reconciliation
Avatar
0
set. 24
2966
Reconciliation problem "The journal entry reached an invalid state relative to its payment".
accounting reconciliation payment
Avatar
0
nov. 22
5096
Paid Invoice In Odoo
accounting invoice payment
Avatar
0
jan. 17
5091
Odoo 9.0: Invoices reconciled but not marked as paid
invoice reconciliation payment
Avatar
Avatar
4
jan. 17
2802
Comunidade
  • Tutoriais
  • Documentação
  • Fórum
Open Source
  • Baixar
  • Github
  • Runbot
  • Traduções
Serviços
  • Odoo.sh Hosting
  • Suporte
  • Upgrade
  • Desenvolvimentos personalizados
  • Educação
  • Encontre um Contador
  • Encontre um parceiro
  • Torne-se um parceiro
Sobre nós
  • Nossa empresa
  • Ativos da marca
  • Contato
  • Empregos
  • Eventos
  • Podcast
  • Blog
  • Clientes
  • Legal • Privacidade
  • Segurança
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk Slovenščina Español (América Latina) Español Svenska ภาษาไทย Türkçe українська Tiếng Việt

Odoo é um conjunto de aplicativos de negócios em código aberto que cobre todas as necessidades de sua empresa: CRM, comércio eletrônico, contabilidade, estoque, ponto de venda, gerenciamento de projetos, etc.

A proposta de valor exclusiva Odoo é ser, ao mesmo tempo, muito fácil de usar e totalmente integrado.

Site feito com

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now