You are here: Ajera Help (A-Z) > Inquiries > Inquiry descriptions > Bank Account Statement inquiry

Bank Account Statement inquiry

Use this inquiry to see information for your bank account statements.

Using the inquiry

From the Inquiry menu, click Bank > Bank Account Statement.

Audience

Accounting staff

Inquiry conditions

The inquiry automatically contains a condition to show only data with a statement ending date within the last 366 days. You can always add, change, or delete conditions on an inquiry.

Groups

This inquiry is grouped by Bank Name. You can always group or ungroup columns, as needed.

Standard columns

Column	Links to this inquiry	Description
Bank Name	Bank Account	The name of the bank holding your account
Bank Description		The name of the bank
Statement Beginning Date		The first date of the reporting period for the bank statement
Statement Ending Date	Bank Entry	The last date of the reporting period for the bank statement
Is Closed		Indicates if you closed the bank statement.
Statement Balance		The balance of the statement
Beginning Balance		The balance of your account on the statement beginning date
Reconciled Payments	Bank Entry	The payments you made from the account
Reconciled Deposits	Bank Entry	The deposits you made to the bank account
Ending Balance		The balance of your account on the statement ending date
Remaining		The amount remaining to be reconciled on this statement

Predefined columns

You can add predefined columns to this inquiry. These columns are available:

Column	Links to this inquiry	Description
Statement Key	Bank Entry	Database identifier of the statement
Bank Account Key	Bank Account	Database identifier of the bank account
Bank Type		The type of bank
Bank Account Company Key		Multi-company only. The database identifier of the company associated with the bank account
Bank Account Company Name		Multi-company only. The name of the company associated with the bank account
Notes		Notes entered on the bank statement
Defined links:
Link - Bank Entry	Bank Entry	A link to the Bank Statement inquiry