There isn't a statement transaction for a payment or deposit that has been made. Why?

In this situation, we anticipate that you are referring to either a bank deposit transaction or an expenditure transaction listed in the right-hand table of the bank-matching screen, where there isn't a corresponding statement transaction in the left-hand column.

Firstly, ensure that your statement uploads are up-to-date and therefore, all transactions from your bank accounts are in the system. Note that ExpensePlus doesn't upload transactions from the day of upload.

Secondly, please check that the payment or deposit has actually been made. For example:

• The Bank Deposit may have been recorded but not yet banked. Is it still sitting around in a safe, tray, or desk drawer somewhere? 
• Has it been paid in so recently (including on the day of upload) that it hasn't appeared on your statement yet
• Has the payment been incorrectly marked as paid, but not actually paid by the bank?
• Has it been paid by cheque, and although the cheque has been sent it hasn't been presented yet, so no funds have cleared?

Once you have established that none of the above scenarios are relevant, the following may be true:

• The payment or deposit may have been recorded as a duplicate by error. Search your statement to see whether a duplicate entry has already been matched elsewhere.

• The payment or deposit may have been recorded against the wrong bank account by error. You can edit this by clicking on the pencil icon to the right of the transaction in the bank matching screen.

  

  

• You may find that the bank statement transaction has been manually reconciled instead of matched to its corresponding payment transaction. This would occur where a user has ignored the suggested match, hasn't clicked the corresponding transaction, and instead has clicked on the statement to enter a new transaction. This can also happen where a transaction has been previously matched, is then unmatched, and then re-matched manually. Where this is the case, you will now have 1 statement transaction and 2 payment transactions, and one of these payment transactions will need to be deleted. For best practice, keep the transaction that has the attached receipt or invoice and has been through the approvals process correctly.

To better understand the Bank Reconciliation module, please view the module overview video here.