Hi guys,
we would like to reconcile the Open Balance per Currency from A/R Aging to Balance Sheet Report.
Within preferences we use 'Report by Period' for all Reports.
We are testing this on particular account for particular currency. The A/R Aging is correct and when we run it we see Open Balance 13 148 EUR (our Base Currency) in foreign currency it is 315 372.09 CZK.
We've also checked the Revaluation and all seems correct.
When we customize the Balance Sheet we would like to include only accounts marked for system reval (we have a custom field for this), exclude Currency Revaluation and exclude those transactions without name as those are not revaluated.
When I run such Balance Sheet I get different total amount in EUR and CZK. We found out it's caused because in A/R Aging only 'Open' Balance are showing which are also further revaluated which is correct.
The issue is that the Balance sheet is showing full amounts for all transactions (invoice, payment,journals) however the Aging is showing only 'not applied' amounts.
I believe that if we would clear to journals through Accept Payment it will be cleared and the whole thing will match, correct?
Is there a way to get these 'Open Amounts' figures to Balance Sheet Report as well? Or to achieve this in other report?
The ultimate goal is to have summary of 'Open' AR/AP in base currency and foreign currency 'as of Period' for each account per currency.
Thanks a lot for your help!
A.