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?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilidad
- Inventario
- PoS
- Project
- MRP
Se marcó esta pregunta
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.
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 | |||
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 |
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/
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.
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?
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:
- Keep the opening balance operation on your bank import (i.e. the first entry to be reconciled)
- Navigate to the reconciliation dashboard and find your opening entry and click on it
- 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)
- Change the Account to "Retained Earnings" (or whatever equity account you want) and ensure the balance is the entire amount
- 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.
¿Le interesa esta conversación? ¡Participe en ella!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
InscribirsePublicaciones relacionadas | Respuestas | Vistas | Actividad | |
---|---|---|---|---|
|
1
jul 22
|
4809 | ||
|
1
ene 24
|
2118 | ||
|
0
mar 23
|
2919 | ||
|
1
nov 22
|
2564 | ||
|
0
feb 22
|
1970 |