Attempting to reconcile bank transactions. Able to upload transactions for bank account using .csv file and the transactions show up correctly with debit and credit and amounts in the correct currency.
However when I attempt to reconcile a Bank Debit Transaction (payment received) with a payment entry of funds received from a customer (on Chart of Accounts - Accounts Receivable - Debtors) - it gives an error message: The selected payment entry should be linked with a creditor bank transaction. Customers are debtors to the company and the transaction has been imported correctly under the Debit Column.
The same for a Bank Credit Transaction (amount paid to supplier). Error message: The selected payment entry should be linked with a debtor bank transaction. Suppliers are creditors and the transaction has been imported correctly under Credit.
Is this is a reconciliation process bug? Somehow are Debit Transactions being recognized as Credit during the reconciliation process?
Or is this somehow a data import error? Does the order of the columns matter in the CSV file? The header row for the column is being correctly recognized / imported under same title of the column and the transactions correctly show up as mapped (in the data import setup for the bank) under debit for Bank Debit and credit for Bank credit.
Appreciate any guidance. Thanks.