Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 10 Next »

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.

No.ScenarioCounterparty (Name)Transaction createdDebit/CreditDescriptionMandatory FieldsOptional FieldsNotes ( * )
1Invoice payment from customerCustomerCustomer paymentCreditIn the Name column, select a customer. In the popup that opens, select an invoice.Name, Transaction(s)

2Invoice payment from customer with deduction of creditCustomerCustomer paymentCreditIn the Name column, select a customer. In the popup that opens, select first credit memo and then the invoice(s).Name, Transaction(s)

3Payment from customer without invoiceCustomerCustomer Deposit/Journal/Customer payment*CreditIn 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
4Refund a credit memoCustomerCustomer RefundDebitIn the Name column, select a customer. In the popup that opens, select a credit memo. Name, Transaction(s)

5Payment from customer without invoice, book on specific GL accountCustomerJournalCreditIn the Name column, select a customer; in the Select Account column, select a GL account.Name, Select AccountTax Code
6Expense report payment to employeeEmployeeBill PaymentDebitIn the Name column, select an employee. In the popup that opens, select an expense report.Name, Transaction(s)

7Bill payment with deduction of creditVendorBill PaymentDebitIn the Name column, select a vendor. In the popup that opens, select a bill and a vendor credit.Name, Transaction(s)

8Bill payment to vendorVendorBill paymentDebitIn the Name column, select a vendor. In the popup that opens, select a bill.Name, Transaction(s)

9Receive a payment on a vendor creditVendorDeposit/Journal*CreditIn the Name column, select a vendor. In the popup that opens, select a vendor credit. Name, Transaction(s)

10Receive a payment from vendor without creditVendorDepositCreditIn the name column, select a vendor. Name

11Prepay a vendorVendorCheck&Vendor credit/Journal*DebitIn the name column, select a vendor. Name
To create a Journal, make sure the preference is enabled on the Bank Account configuration
12Payment to vendor without billVendorCheck/Journal*DebitIn 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
13Transaction without customer, vendor or employeeN/AJournalBothIn the Select Account column, select an account.Select AccountTax Code


Known limitations and alternate solutions

Not-supported scenarioAlternate solution
Receive a payment from employeeDo 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 vendorKey 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 customerKey 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.
  • No labels