Light Mode

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Cross-currency reconciliation #340

Open
Open
Cross-currency reconciliation#340

Description

Is your feature request related to a problem? Please describe.

At the moment we can only match a Bank Transaction to vouchers in the same currency: either voucher currency or party account currency must match. However, it can also happen that a voucher in currency A is paid in some arbitrary other currency B. This case is currently not supported.

Describe the solution you'd like

We cannot readily know how much of the outstanding amount is paid by the Bank Transaction, since it's in a completely different currency. But we could easily allow to mark a voucher as fully paid for by the bank amount.

  • Add a checkbox Cross-Currency in the Bank Reconciliation Tool's Match Voucher tab. If this is enabled, show only vouchers with different currencies than usual (invert the currency condition in SQL queries).
  • As soon as a single vouchers is selected, show the full bank amount as Allocated Amount and 0.00 as To Allocate.
  • Before clicking reconcile, show a warning stating that the payment in B will offset the entire outstanding in A.
  • Ensure that payment entries are created correctly in he backend.

This principle can also work when reconciling multiple vouchers at once. In this case we create a Journal Entry (as usual) and use the bank amount to offset the outstanding from each selected voucher.

Describe alternatives you've considered

  • Instead of fully reconciling the voucher, we could also prompt the user to enter how much (in the voucher's currency) should be reconciled.
  • We could also use the payment day's exchange rate to determine the corresponding amount in the voucher's currency.

Additional context

Add any other context or screenshots about the feature request here.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions