Reconciling the bank register

About the first bank statement and your balances

Ajera automatically creates the first bank statement when you enter beginning balances for the bank account or the first time you select the bank account when working in > Manage > Bank Register. The first bank statement uses the Beginning Balances Date ( > Setup > Company > Preferences > General tab) as the statement date.

Multi-company only. The first bank statement uses the Beginning Balances Date from the > Setup > Company > Companies > General tab.

To view statement transactions

  1. From the > Manage menu, click Bank Register.
  2. Click the Reconcile tab.
  3. Select the bank account for the statement you want to reconcile.
  4. In the Bank Statement table to the right:
  1. Enter the date of the statement.

To view entries for a closed, reconciled statement, click the statement date in the table. Entries for that statement appear in the transaction table.

  1. Enter the ending balance from your bank statement.
  2. Add any notes about the statement.

  3. Click the attachments icon and add attachments, by linking to related files. A linked file must be in a shared location for other people to open it (for example, on a shared network or a website).

  1. The transaction table contains all outstanding items not reconciled on previous statements.

Ajera automatically marks all items through the statement ending date as reconciled. You can unmark items marked as reconciled for the statement ending date, and you can mark any items later than the statement ending date as reconciled.

If Bank Feed is enabled, these boxes are not automatically checked. You can reconcile and match bank entries to bank feed items using the Match Bank Feed button.

Note:

If you open a statement that you marked as closed, the table contains all reconciled items for the statement. If you open a statement that has not yet been closed, the table contains all reconciled and outstanding items for the statement.

If you need to add transactions, enter transactions to your register by clicking the Register tab.

  1. Change the sort order or the appearance of columns, as needed.
  2. If Bank Feed is enabled, select a bank feed item to manually match that bank feed item to the bank entry and automatically mark the bank entry as cleared and reconciled.
Note: If you are using Bank Feed, you can use the Match Bank Feed button and Bank Feed column to reconcile.
  1. If Bank Feed is enabled, view and match bank feed items.

To reconcile statement transactions

  1. Mark the transactions that have cleared the bank for the statement date or do not appear on your bank statement:
  • Clear the Cleared check box if a transaction has not cleared the bank.
  • Clear the Reconciled check box if a transaction does not appear on the bank statement.
  • Click the Unclear All button if none of the transactions have cleared the bank.
  • Click the Clear All button if all of the transactions have cleared the bank.
  1. Select the Closed check box for the statement in the Bank Statement table if you are finished reconciling and the remaining amount is zero.
Note: After closing a statement, you can enter and reconcile the next statement. You can also reopen a closed statement and make adjustments; however, you must carry an adjustment through to any later statement.
  1. To view or adjust transactions from another bank statement, click the row for that bank statement.
  2. Click to refresh the bank register.
  3. Click Save.
  4. Click the Print button to run the Bank Statement report. Use this report to:
  • Print a file copy of your bank register if a printout is needed.
  • Verify that the bank register balances to the cash account balance in the Trial Balance. The Balance As Of amount on the Bank Statement report should equal the Trial Balance cash account balance for the statement date.
Note: If you are missing deposits in your bank register, check > Manage > Client Receipts for any outstanding pending deposits.
  1. If you make changes to the bank statement, click Save and click the Print button to view your changes in the report.