Check if there are multiple reconciliations open at once for the same or overlapping period. Delete any reconciliations that are not needed and reconcile one period at a time.  

Check if the transaction is part of a grouped transaction. If receipts or payments were grouped via a lodgment or batch ref, they will appear as a single entry on the reconciliation screen. If the transaction is part of a group, it can be removed as follows:  

• Identify the relevant group transaction using the date range. To open the group, click the + symbol and remove the transaction. The transaction will still appear in the bank reconciliation but will be a stand-alone transaction.  

Check the transactions in the bank GL. Use the Transaction Browser to verify: 

• the dates on the transaction fall within the bank reconciliation date. 
• the transaction is indeed posted to the bank account being reconciled.

Check if the transaction has been matched in a prior reconciliation.

• Use the Bank Reconciliation Report (type name into the Report Manager search)  to identify if the transaction has been matched in a previous month’s bank reconciliation. See Reports Glossary. Check the field ‘Matched’ to view previously reconciled transactions. 

Check that the previous bank reconciliation closing balance matches the opening balance of the current bank reconciliation.

Check that all the transactions in the bank GL (for the dates of the bank reconciliation) are included and ticked in the bank reconciliation.

Check if the imbalance is caused by a transaction being created and posted in different periods. Transactions appear in the reconciliation by transaction creation date, but are only be added to the GL Closing Balance once posted. 

For example, if a transaction was created in June but posted in July, it will appear in the reconciliation screen with a June date, but its balance will be added to July’s GL Closing Balance.

If you have such transactions, check the System Closing Balance against the reconciliation balance instead. 

Click Synchronise Transactions to manually synchronize transactions from the Bank Feed.

This button is relevant when an automatic bank feed has been set up. The bank feed will refresh automatically until the consent expires or is revoked. However, the synchronize transactions button can be used at any point to refresh the feed. If the bank statement transactions are not updated automatically, use 'synchronize transactions' to update. This will not duplicate the bank feed. 

If transactions are still not coming through from the feed; then check the Bank Feed Status as follows:

• Check if the bank feed is showing as active on the bank feed page in AIQ. If it is not showing as active on the bank feed listing page:  
  • 90-Day Timeout: Due to Plaid's security procedures (Open Banking Standards), connections often time out every 90 days. Customers will need to log in to their bank account again through AIQ to reactivate the feed. 
  • Authentication Error: If you have changed login credentials with their bank. Plaid (the third-party service AIQ uses for bank feeds) needs to reauthenticate the account details.