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 | Debit/Credit | Description | Mandatory Fields | Optional Fields |
|---|
| Invoice payment from customer | Customer | Invoice payment | Credit | 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 | Credit | In the Name column, select a customer. |
Debit/Credit is set to Credit.| | Name |
|
| Invoice payment with deduction of credit | Customer | Invoice payment | Credit | 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 | Debit | 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 | Credit | 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 | Debit | 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 | Debit | 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 | Credit | 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 | Debit | 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 | Credit | In the name column, select a vendor. |
Debit/Credit is set to Credit.| | Name |
|
| Prepay a vendor | Vendor | Check & Vendor credit | Debit | In the name column, select a vendor. |
Debit/Credit is set to Debit.| | Name |
|
| Payment to vendor without bill | Vendor | Check | Debit | 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
...