Create Customer Payment from Bank Statement Import

When money is transferred directly to a bank account as payment for an open order or invoice, you can create the customer payment record during the bank statement import. This prevents you from having to manually apply the payment to the order or invoice as a separate process.

Create the Receivable Transaction Type

You can tag a cash book transaction type to an existing or new receivable transaction type. To configure the receivable transaction type to apply to a cash book transaction:

1. Click the Receivable Transaction Types link from the Main Menu. The Receivable Transaction Types screen opens.
2. Select the receivable transaction type adjustment to use for the cash book transaction.
3. Right-click and select Edit. The Edit Receivable Transaction Types screen opens.
4. Expand the Additional Information section.
5. Select Yes from the Create Cash Book Transaction drop-down. This drop-down is available if Payment or Deposit is selected from the Type drop-down and Check, Cash or Wire is selected from the Indicator drop-down.
6. Select the corresponding cash book transaction from the Cash Book Transaction Type drop-down. You must configure the corresponding cash book transaction as a deposit transaction type with the  GL Transfer check box unchecked.
7. Click OK.

Process AR Transactions from a Bank Statement Import/Cash Book Transaction Import

When Bank Statement Imports occur, you can manually match items to an order or invoice and ensure the customer payment gets created against the order or invoice.

1. Click the Bank Statement/Cash Book Transaction Imports link from the Main Menu. The Bank Statement/Cash Book Transaction Imports screen opens.
2. Import the bank statement or select the import with the transaction to match to an order or invoice.
3. Right-click and select Edit. The Edit Bank Statement Import screen opens.
4. Expand the Bank Statement Detail section.
5. Select the transaction to match to an order or invoice.
6. Right-click and select Edit. The Edit Bank Statement Transaction Detail screen opens.
7. Expand the Additional Details section.
8. Check the Customer Payment check box.
9. Select the receivable transaction type configured in Create the Receivable Transaction Type from the Payment Type drop-down.
10. Select the order from the Order Number drop-down or the invoice from the Invoice drop-down.
11. Click OK. Return to the Edit Bank Statement Import screen.

After posting the transaction or bank statement, a payment is created against the assigned order/invoice. You can then generate the payment journal entry using your organization's usual process:

• If you usually batch the cash receipts to generate the journal, this process also creates the journal entry for the transaction.
• If you manually pull the AR entries from the Journal Entries screen, it also flows through as expected.