Process a Bank Statement

Navigate to the Banking tab and then the Bank Statement Import tab.

• Bank account: Bank Account of the statement.
• Start date: The date of the earliest transaction.
• End date: The date of the latest transaction.
• Import date: The date you imported the file into AccountsPortal.
• Statement lines processed: Current status of the statement.
• Delete statement: The option to delete a statement only exists if there are 0 lines processed (see Delete Bank Statement).

Click on a bank statement line to open the statement for processing

• Date: The date the transaction cleared at the bank or appeared on the statement.
• Amount: The amount provided in the statement.
• Payee: This is the payee or payer. The text in this field is used to search for the relevant Import Rule. It will also be used as the basis for creating new rules automatically if activated in your organisation's settings.
• Reference: Any relevant information provided by the bank that you assign to the Reference field in the bank transaction.
• Transaction Memo: Any relevant information provided by the bank that you assign to the Memo field in the bank transaction.
• Line Item Description: Any relevant information provided by the bank that you assign to the line item Description field in the bank transaction.
• Status:
  
  • P : Click this button to initiate a new bank transaction using Spend Money for negative amounts and Receive Money for positive amounts.
  • R : This button is only active if an Import Rule is found matching the value in the Payee field. Click the R button to create a Spend Money or a Receive Money bank transaction using the rule.
  • M : This button is only active if an existing unreconciled bank transaction has been entered which matches the statement line item on Amount. An example might be a cheque you received and banked which was already saved as a bank transaction. The cheque has now cleared in your bank account. Avoid creating a new Receive Money which would be a duplicate. Click the M button to match the items (see below for more information on using M).
• Delete line: Any unprocessed statement line can be deleted.

Once you have completed the creation of a new bank transaction or matched a statement line item to an existing bank transaction, the status will be updated to reflect the bank transaction (saved bank transactions will be visible in the Bank Transactions tab). There will also be a V and a U button visible.

• Status:
  
  • V : This button is only active for statement line items already processed. Click the V button to view or edit the saved transaction.
  • U : This button is only active for statement line items already processed. Click the U button to unlink statement line items and saved bank transactions. This action will mark the saved bank transaction as unreconciled but does not delete it. The bank transaction can only be deleted in the Bank Transactions screen.
• Delete line: Processed statement lines can no longer be deleted.

M - Matching statement lines to bank transactions

You can only match one bank transaction to a statement line. Select the appropriate bank transaction and click on Use Selected to create the link.