Supported scenarios for open transactions

1 What is possible
2 Known limitations and alternate solutions

What is possible

In the scenario column, find the one most applicable to the line in the bank statement. In the Description column is written how to configure the bank statement line to get the required result. In Mandatory Fields a summary is given of which fields need to be populated, next to the Select checkbox and the pre-populated fields.

No.	Scenario	Counterparty (Name)	Transaction created	Debit/Credit	Description	Mandatory Fields	Optional Fields	Notes ( * )

No.	Scenario	Counterparty (Name)	Transaction created	Debit/Credit	Description	Mandatory Fields	Optional Fields	Notes ( * )
1	Invoice payment from customer	Customer	Customer payment	Credit	In the Name column, select a customer. In the popup that opens, select an invoice.	Name, Transaction(s)
2	Invoice payment from customer with deduction of credit	Customer	Customer payment	Credit	In the Name column, select a customer. In the popup that opens, select first credit memo and then the invoice(s).	Name, Transaction(s)
3	Payment from customer without invoice	Customer	Customer Deposit/Journal/Customer payment*	Credit	In the Name column, select a customer.	Name		To create a Journal or Customer Payment instead of Customer Deposit, make sure either of the preferences is enabled on the Bank Account configuration
4	Refund a credit memo	Customer	Customer Refund	Debit	In the Name column, select a customer. In the popup that opens, select a credit memo or Journal*.	Name, Transaction(s)		The Journal Entry must have certain GL impact similar to credit memo, thus: DEBIT: Other Asset Account CREDIT: Account Receivable
5	Payment from customer without invoice, book on specific GL account	Customer	Journal	Credit	In the Name column, select a customer; in the Select Account column, select a GL account.	Name, Select Account	Tax Code
6	Expense report payment to employee	Employee	Bill Payment	Debit	In the Name column, select an employee. In the popup that opens, select an expense report.	Name, Transaction(s)
7	Bill payment with deduction of credit	Vendor	Bill Payment	Debit	In the Name column, select a vendor. In the popup that opens, select a bill and a vendor credit.	Name, Transaction(s)
8	Bill payment to vendor	Vendor	Bill payment	Debit	In the Name column, select a vendor. In the popup that opens, select a bill.	Name, Transaction(s)
9	Receive a payment on a vendor credit	Vendor	Journal	Credit	In the Name column, select a vendor. In the popup that opens, select a vendor credit.	Name, Transaction(s)
10	Receive a payment from vendor without credit	Vendor	Journal / Deposit*	Credit	In the name column, select a vendor.	Name, Select Account		Deposit is created when no Account is selected
11	Prepay a vendor	Vendor	Check&Vendor credit/Journal*	Debit	In the name column, select a vendor.	Name		To create a Journal, make sure the preference is enabled on the Bank Account configuration
12	Payment to vendor without bill	Vendor	Check/Journal*	Debit	In the name column, select a vendor; in the Select Account column, select a GL account.	Name, Select Account, Tax Code		To create a Journal, make sure the preference is enabled on the Bank Account configuration
13	Transaction without customer, vendor or employee	N/A	Journal	Both	In the Select Account column, select an account.	Select Account	Tax Code

Known limitations and alternate solutions

Not-supported scenario	Alternate solution

Not-supported scenario	Alternate solution
Process a combination of vendor credit and vendor bill, resulting in a payment from a vendor	Key is to first apply the credit to the bill, and only process the remainder of the credit: Edit the Vendor Credit in a separate tab. On the Apply subtab, select the bill(s). Go back to the bank statement and open the popup again. Now you should be able to only select the vendor credit.
Process a combination of credit memo and invoice, resulting in a refund to the customer	Key is to first apply the credit memo to the invoice, and only process the remainder of the credit memo: Edit the Credit memo in a separate tab. On the Apply subtab, select the invoice(s). Go back to the bank statement and open the popup again. Now you should be able to only select the credit memo.
Process a payment upon a Customer Deposit, resulting in a Customer Refund	The Customer Deposit originally Credits the “Customer Deposits” GL account. To offset the balance, use the “Customer Deposits” GL on the statement (Select Account) and the name of the Customer (Name column). The resulting transaction will be Journal Entry offsetting the balance of both - the “Bank” and the “Customer Deposits” GL accounts.
Process a payment for a manually created Journal with multiple AR/AP lines for the same entity (multiple payable/receivable lines listed in 1 Journal Entry for the same customer/vendor)	Create an invoice or vendor bill for each payable/receivable line.