After you have imported bank statements, this form shows the details of the statements.
Matching lines to open items
The Matched column shows whether the bank statement line matches an open item:
Matched: The statement line has been matched with an invoice.
Partly matched: An invoice with the correct reference was found, but its amount does not match the amount of the bank statement line. You can select a different invoice, post the difference as a payment difference, or leave the difference as is.
Not matched: No corresponding invoice was found for the bank statement line. While on a line in the Invoice/reference column, open the open items list to manually match the line with an open item, or, in the Account column, select a ledger account to which the line can be posted.
Not applicable: The line will not be matched with open items. This status will be assigned, for example, if you have made the summarized payments yourself. In that case, you match the entry with the in-transit account.
In the bottom-right corner of the form, the match message is displayed, showing the match result. If there was no match, the reason is shown here.
Tasks
If a line relates to multiple invoices, you can split the line and select the corresponding invoice for each newly created line. Bank statement lines that have not been matched can be matched manually. If the amount of an entry differs from the amount of the open items, you can choose to post the payment difference to a ledger account. Once all bank statement lines have been dealt with, you can process the bank statement. All entries will then be processed.
Using a different exchange rate
If payments are made in a foreign currency, you can use an exchange rate that differs from the rate defined on the Currencies form. Due to an exchange rate difference, the actual amount paid may differ from the amount of an open item in the company currency. You can enter one amount in the invoice currency and the other in the bank account currency. If during this entry a rate other than the invoice rate is used, the exchange rate difference will be journalized automatically. To display the rate, drag the column on the form.
A company sends a $100 invoice to its foreign customer. When entering the invoice in the sales day book, the invoice amount is translated into the company currency in euro, based on the rate defined: 1 euro=1.112 dollars. The transaction amount amounts to $ 100 / 1.112- = € 89.93.
The debtor pays the invoice amount in full, but the company only receives € 82.58 from the bank, because the bank uses a rate of 1.211 ($ 100 / 1.211 = € 82.58). In the cash/bank day book, the company registers the amount in dollars and the amount received in euros. The corresponding rate will be calculated automatically. Instead of making an adjustment in the cash/bank day book, it is also possible to make an adjustment in the bank statement.
Sales invoice has been created
Day book line in sales day book (LDGR 1300/Debtor in euro)
A company sends a $100 invoice to its foreign customer. When entering the invoice in the sales day book, the invoice amount is translated into the company currency in euro, based on the rate defined: 1 euro=1.112 dollars. The transaction amount amounts to $ 100 / 1.112- = € 89.93.
The debtor pays 25% of the full invoice amount. Instead of € 22.48, the company only receives € 20.64 from the bank, because the bank uses a rate of 1.211 ($ 100 / 1.211 = € 82.58).
Sales invoice has been created
Day book line in sales day book (LDGR 1300/Debtor in euro)
LDGR
Invoice/reference
Currency
Currency amount
Transaction amount
Rate
8400/Turnover
20194444
Dollar
$ 100
€ 89.93
1.112
Journal
LDGR
Invoice/reference
Currency amount
Transaction amount
Invoice amount
Invoice currency
1300/Debtor
20194444
€ 89.93
€ 89.93
$ 100
Dollar
8400/Turnover
20194444
€ -89.93
€ -89.93
Open item
Invoice/reference
Currency
Debit currency amount
Outstanding currency amount
Debtor amount
Outstanding transaction amount
20194444
Dollar
$ 100
$ 100
€ 89.93
€ 89.93
Invoice amount was paid using a different rate
Day book line in cash/bank day book (linked LDGR 1200/Bank in euro)
Posting exchange rate differences in case of partial payment after exchange rate change