How to read this page
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.
| Scenario | Counterparty | Transaction Type | Description | Mandatory Fields | Optional Fields |
|---|---|---|---|---|---|
| Invoice payment from customer | Customer | Invoice payment | In the Name column, select a customer. In the popup that opens, select an invoice | Name, Transaction(s) | |
| Payment from customer without invoice | Customer | Customer Deposit | In the Name column, select a customer. Debit/Credit is set to Credit. | Name | |
| Invoice payment with deduction of credit | Customer | Invoice payment | In the Name column, select a customer. In the popup that opens, select first credit memo and then the invoice. | Name, Transaction(s) | |
| Refund a credit memo | Customer | Customer Refund | In the Name column, select a customer. In the popup that opens, select a credit memo. Debit/Credit is set to Debit. | Name, Transaction(s) | |
| Payment from customer without invoice, book on specific GL account | Customer | Journal Entry | In the Name column, select a customer; in the Select Account column, select a GL account | Name, Select Account | Tax Code |
| Expense report payment to employee | Employee | Bill Payment | In the Name column, select an employee. In the popup that opens, select an expense report | Name, Transaction(s) | |
| Bill payment to vendor | Vendor | Bill payment | In the Name column, select a vendor. In the popup that opens, select a bill. | Name, Transaction(s) | |
| Receive a payment on a vendor credit | Vendor | Deposit | In the Name column, select a vendor. In the popup that opens, select a vendor credit. Debit/Credit is set to Credit | Name, Transaction(s) | |
| Bill payment with deduction of credit | Vendor | Bill Payment | In the Name column, select a vendor. In the popup that opens, select a bill and a vendor credit | Name, Transaction(s) | |
| Receive a payment from vendor without credit | Vendor | Deposit | In the name column, select a vendor. Debit/Credit is set to Credit. | Name | |
| Prepay a vendor | Vendor | Check & Vendor credit | In the name column, select a vendor. Debit/Credit is set to Debit. | Name | |
| Payment to vendor without bill | Vendor | Check | In the name column, select a vendor; in the Select Account column, select a GL account | Name, Select Account, Tax Code | |
| Transaction without customer, vendor or employee | Journal | In the Select Account column, select an account | Select Account | Tax Code |
Known limitations and alternate solutions
| Not-supported scenario | Alternate solution |
|---|---|
| Receive a payment from employee | Do not select a value for Name. Select a value for Select Account. This will create a journal. After processing, open the journal and manually add the employee in the journal line. |
| 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. |