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()**
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	(SuiteTax & Legacy) 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	(SuiteTax & Legacy) Tax Code (supported only when creating a Journal entry)	To create a Journal, make sure the preference is enabled on the Bank Account configuration
13	Payment to a vendor upon open Journal Entries	Vendor	Journal	Debit	In the name column, select a vendor. In the popup that opens, select the open Journals. If the selection includes both positive and negative journals, first select the credit entries, followed by the liability entries.	Name, Transaction(s)		A Journal will be created representing a payment
14	Transaction without customer, vendor or employee	N/A	Journal	Both	In the Select Account column, select an account.	Select Account	(SuiteTax & Legacy) Tax Code
15	Transaction with customer, vendor or employee	N/A	Journal/Customer deposit*	Both	In the Select Account column, select an account.	Select Account	(SuiteTax & Legacy) Tax Code (supported only when creating a Journal entry)	To create a Customer Deposit, make sure the preference is enabled on the Bank Account configuration
16	Transaction with a Hybrid entity (a customer and a vendor)	Hybrid entity	Journal	Both	In the name column, select a hybrid entity; in the Select Account column, select a GL account; in the Specified Type of Hybrid Entity column, set the entity relationship the Journal should be created with	Name, Select Account, Specified Type of Hybrid Entity	(SuiteTax & Legacy) Tax Code	A Journal will be created representing a payment

Known Limitations and Alternate Solutions

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	Create an invoice or vendor bill for each payable/receivable line.
Process an Advanced Intercompany Journal entry with a (SuiteTax & Legacy) Tax Code	Use a clearing account under 'Select account'. The system will create a journal entry using the clearing account and the bank account accordingly. As an additional step, you must manually create a second entry outside of ZoneReconcile.
Checks (SuiteTax) Tax Code	Create the Check manually outside of ZoneReconcile and link it to the Bank Statement line as a closed transaction.
Check and a Vendor Credit as a Vendor Prepayment with a (SuiteTax & Legacy) Tax Code	Key is to enable the 'Create vendor prepayment as journal' checkbox on the corresponding Bank Account configuration and create Journal entries instead of the recommended NetSuite prepayment process.