Ir al contenido
Menú
Se marcó esta pregunta

Odoo Online

My opening balance has posts to a Bank account which is recorded as the bank for Bank Reconciliations and syncing of transactions from the Bank.

But I can't do a Bank Reconciliation because the transactions don't have the Open journal's entries.

How do I correct this?


Avatar
Descartar
Autor Mejor respuesta

I worked the solution out myself.

Here's what I did.

1. Create Bank account entry for the opening bank balance.
2. Allocate the cash received to a Suspense Account
3. Posted the Bank entry

Which means now the Bank Balance shows correctly in the Reconciliation area, but the General Ledger balance is wrong as the opening balance is doubled up.

So Part 2.
1. Go to Opening Balance Journal Entry (probably a MISC journal)
2. Add 2 new lines
3. Credit to Bank account of the opening balance amount (to remove the double counted opening balance)
4. Debit to the Suspense Account used in the bank entry (which wipes out the amount inserted by the Bank entry)
5. Repost the Opening Journal.

Now the correct bank balance shows in both the GL and the Bank Reconciliation area.

Avatar
Descartar
Mejor respuesta

There is another way to do this. 

Edit the opening journal entry, remove the opening "bank account balance" by removing from the entry and modify the balancing account as well.

Then create a bank statement for 31.12.20XX with such opening balance amount.

Reconcile statement against, the balancing account. Bingo, the issue is solved:

Eg:

Opening JE
31.12.2022 Cash        500.00
Loan  18,000.00
Bank  50,000.00
Suspense A/c  68,500.00
Edit as
31.12.2022 Cash        500.00
Loan  18,000.00
Bank  50,000.00
Suspense A/c  68,000.00
Create a Bank Statement
31.12.2022 Open Balance        500.00
Reconcile with Manual Operations
31.12.2022 Open Balance        500.00
With  Suspense A/c


Avatar
Descartar
Mejor respuesta

You can use this app which is easy to use and has been appreciated by accountants https://apps.odoo.com/apps/modules/17.0/quickbooks_manual_reconcile/



Avatar
Descartar
Mejor respuesta

Hello Community

I agree with Mark Phillips  - there is a issue with the opening entries and the journal informations in Odoo 16.

The current situation is that the dashboard-journals does not reflect the real account entries in therms of opening entries.

https://prnt.sc/DxkHZeewl9Tt

By definition, an accounting journal must display the current(real) data of the underlying accounts (like the general ledger does) -- otherwise it is wrong. If a journal does not show the opening entries - it must be defined as a feature or configuration setting like we have with the general ledger report, where you can set: include Initial Balances in Odoo.


The opening entries have already a counter booking with the account 999999 in the opening entries -- it is already balanced see the screenshot above. No additional balancing (reconcile) process with a Bank-Journal or Cash-Journal is required to show up in the journal dashboard view. If you go now with additional statement and book this as 'reteined erarnings' or something else, you create duplicate entries that are only necessary because the basic function is wrong.


So I think the function is wrong here. What does the community think?

Avatar
Descartar
Mejor respuesta

You don't need to make it that complicated.  

Simply put -- whatever your starting balances are should be reflected as "retained earnings" or some equity account.

So all you need to do is: 

  1. Keep the opening balance operation on your bank import (i.e. the first entry to be reconciled)
  2. Navigate to the reconciliation dashboard and find your opening entry and click on it
  3. Next, navigate to the "Manual Operations Tab" in the bottom section of the reconciliation GUI (it's next to the Match Existing Entries/Batch Payments tabs)
  4. Change the Account to "Retained Earnings" (or whatever equity account you want) and ensure the balance is the entire amount
  5. Click validate to create the matching entry

Now you have the "counterpart" to your opening statement -- which reflects retained earnings/losses or owner equity/cash infusion or whatever you want to call it.

Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
1
jul 22
4809
1
ene 24
2118
0
mar 23
2919
1
nov 22
2564
0
feb 22
1970