Process incoming bank transactions

Match the incoming bank transaction to outstanding invoices or credit notes in Accounting. Once matched, the transaction is recorded in bank account, allocated to the invoice or credit note, and marked as cleared. Once cleared, it cannot be downloaded again. If the transaction was allocated to an invoice, the invoice status is also updated to Paid (or Partially Paid).

Section 1 - Select the transaction (or transactions) that make up the amount

You can match a transaction to one or more invoices, as a partial payment, or as an overpayment. Use the search and filters to locate specific transactions. For example, enter a keyword to find specific contacts. You can also filter the list by transaction type; vendor bills or sales invoices (outstanding, partially paid) or receipts and payments or by period. If you already recorded the transactions from Banking, you can still match an incoming transaction to it. If you do not find a transaction, you can edit the filters or select Reset on the Search window to clear all filters.

Panel 2 - Review the selected transactions     

• Less than the remaining balance, you can make partial payments by adjusting the amount to pay against each invoice. For example, if the customer did pay their invoice in full but your bank charged a fee, which resulted in a transaction that is less the fee amount on your bank statement. You can click Make Adjustment to create an Other Payment to record the expense incurred while still paying the invoice in full.
• More than the remaining balance, you can add transactions to use the remainder and or create an Other Receipt or Payment, or create a payment on account to allocate to an invoice later.

If you still have some unmatched incoming transactions, click Match again and then click Find a Match to search for possible matches from a list of uncleared (or unreconciled) payments, receipts, outstanding invoices, and credit notes. The list of transactions is from your current fiscal year both before and after the date of the incoming transactions. If you do not have a set fiscal year, the transactions are from the current calendar year. The oldest transactions display at the top of the list, though you can filter the list as needed.

You can split a bank transaction by selecting multiple transactions from one or more customers or vendors on the list to match it to. Select a transaction in the first list to move it to the Review the chosen transactions section. When you are done selecting transactions, verify what you have added to the section.

Enter the amount to apply to each selected transaction from the bank transaction. The total amount of the matched transactions must be equal to the total amount of the bank transaction. If the total of your selected transactions is less than the bank transaction total, click New Transaction to create a new payment, transfer, or other type of transaction to account for the balance. If the matched transaction is an invoice or credit note, you must also select the payment method for the receipt (or refund) that will be created.

Click Match when you are ready to match the transactions. If you matched a bank transaction to an invoice or credit note, they will be marked paid and the matched transactions will be marked Cleared or Reconciled in your bank account.

• Create transaction for. If necessary, enter the contact's name. As you type, a list of your contacts appears. Choose the applicable contact.
• What. Choose the ledger account you want to record this payment or receipt against.
• Reference. This is the same as the reference on your statement, but you can change it.
• Tax rate. Select the relevant tax rate.