Hello, I am trying to use the accounting module but I am running into a problem. I have no jounal entries as of yet but am going to input all my past transaction which were done outside of openerp. I am entering past bank statements from 11/2011 to now and this is my problem. When I enter my statements and there are transaction that are transfers, I receive two of the same transaction in the journals. For example, I have a checking account and a savings account, I have a transfer from Checking t

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

Bank Statement Duplicate Entries

accounting journal bank_statement bank

3 Vastaukset

9775 Näkymät

Sam

Hello,

I am trying to use the accounting module but I am running into a problem. I have no jounal entries as of yet but am going to input all my past transaction which were done outside of openerp.

I am entering past bank statements from 11/2011 to now and this is my problem.

When I enter my statements and there are transaction that are transfers, I receive two of the same transaction in the journals. For example, I have a checking account and a savings account, I have a transfer from Checking to savings and when I enter both statements in the system, there is two journal entries from the transfer because it appears on both statements (checking and savings).

I would like to know how to enter the items and input the bank statements without having duplicate entries of the transfers between my accounts.

I am using Openerp V7.

I am not sure if this is because I have not entered in the journal entries prior to inputting the statements. I have tried to add the journal entries first, then adding the statements but that causes more duplicate entries because there are the journal entries and bank statement entries.

Any help would be appreciated. Thank you

Gregoire Huet

Hello

I think that the accounting best practices propose to get through a 'transfer account' for this type of transaction.

Bank Account 1 -> Transfer Account Transfer Account -> Bank Account 2

You can create this transfer account according to your accounting plan.

Sam

Tekijä

Thank you for your help. Just to clarify, do you mean I should create a new account called "Transfer Account"?
Also, what do you mean by "accounting plan"?

As an Example: Checking1 transfer 100 to Savings1 - In the journal entries, I enter the transaction in Checking1 Journal - When Entering transaction, I input debit $100 from account Checking1 - Then add item, I input credit $100 to Transfer Account

Please elaborate if you can regarding your answer. Thank you

Gregoire Huet

To make transfers between bank accounts, you need a transfer account, that you can call the name you want. I think it has to be a asset account.

Merrie Summey

ooooohhhhh

Paweł Kostrzewa

but, this is the theory, not IT solutions. Let's learn theory! ;)

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
reconciliation issues first try accounting reconciliation bank_statement bank	0 toukok. 24	2806
Problem In Bank Reconcilation, which is very generic accounting reconciliation bank_statement bank	1 maalisk. 15	5054
How to handle partial payments in Bank Statements accounting reconciliation bank_statement bank	1 maalisk. 15	6286
Ajout de compte sur une facture / How to add an banking account for an invoice accounting bank	1 heinäk. 25	2533
Am I supposed to fetch transaction each month? accounting bank	1 heinäk. 25	2537

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!