Unexplained difference in reconciliation report
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
If you have an unexplained difference (missing statements) in a reconciliation report, one of the reason could be the date you use to look at your report.
For instance I have a difference of 300€.
The balance of the account 5120025 at the date of the 22/02/2019 is 4156.92. When I looked at the journal items on this account the total balance was 4456.92 because one entry was booked on the 01/03. When I changed the date to the 1st of March, I got the unexplained amount back to 0
Additionally, from the V12 code:
If the amount is non-zero, it could be due to
- some bank statements being not yet encoded into Odoo
- payments double-encoded""")
#NOTE: anyone trying to explain the 'unexplained difference' should check
# * the list of 'validated payments not linked with a statement line': maybe an operation was recorded
# as a new payment when processing a statement, instead of choosing the blue line corresponding to
# an already existing payment
# * the starting and ending balance of the bank statements, to make sure there is no gap between them.
# * there's no 'draft' move linked with a bank statement
Hello Edoardo, thanks for the info, but i have tried [V13] to generate the list of "validated payments not linked with a statement line" and i did not make it, ¿would you like to say me how do i do it please?
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
2
Feb 23
|
3176 | ||
|
1
Apr 21
|
4267 | ||
How to deal with lock dates?
Solved
|
|
1
Aug 23
|
16082 | |
|
3
Aug 23
|
2826 | ||
|
2
May 24
|
4681 |