Bank register report

Use the Bank register report to perform the following activities:

  • View all bank transactions for an account or all available accounts.

  • View the reconciliation status of a transaction (in Detail mode).

    Transactions that are In Transit have not been reconciled. Transactions that are Cleared have been included in a reconciliation.

  • Debit and credit totals (in Summary mode).

  • Void payments.

    Void payments in the entity in which they were created.

  • Reverse other types of transactions (such as payments made by record transfer or deposits).

To drill down and view checks, use the Check register report report instead.

Check to see if your account has been inactivated. Inactive accounts do not appear for selection in dropdowns.

Treasurers, accountants, and controllers who need to see the transactions for a specific bank or range of banks.

Subscription

Accounts Payable

User type

Business, Employee, Project Manager
Permissions

Bank Register: Run

View a monthly report

  1. Go to Cash Management > All > Reports > Registers > Bank.

  2. On the report settings page, select View.

    The report includes all results for the default reporting period.

  3. To refine the report, select Customize.

Customize and run

Before running the report, you can select the time period and types of items to include and specify how you want the report to appear.

Use trial-and-error to get the precise results you want.

Fill in the desired boxes, and select View to see the report. If after viewing the results you want to refine the report further, select Customize to return to the report setup page.  Repeat this process until you're satisfied. For complex financial reports you plan to run regularly, select a reporting period and memorize the report when you're done setting it up. Just change the As of date before running the report next time.

  1. Select the reporting period from the dropdown menu, or enter the start and end dates you want the report to cover.

    If you do not specify a reporting period, the current month to date is used. You can specify either the reporting period or the start and end dates, but not both.

  2. Set the filters to get the specific data you want.

    Filters enable you to include or exclude specific types of data in the report, such as location and department. To get fewer and more precise results in your report, set more filters.

    When running at an entity level, enter a location to display all transaction types.

  3. Format the report.

    Format options vary from report to report. Generally, you can set the layout of the report and arrange how to group and display the data contained in the report.

  4. Enter a title, subtitle, and footer text for your report.

  5. View, process, memorize, export, or customize the report or add it to the dashboard by selecting one of the following:

    To...

    ...select

    View the report now, in your browser.

    View

    Display the report now, in printable PDF format.

    Print

    Generate the report and store it for later access. Reports can be either stored in the My Stored Reports list or delivered to a cloud storage location, such as Dropbox. Learn more about processing and storing reports.

    Process & store

    Add the report to your dashboard

    Add to dashboard

    Memorize (that is, save) the report so that later you can refer back to it or modify and re-run it.

    Memorize

    Export the report to a separate file that you can then distribute or save to your local drive. File formats to which you can export the report data vary among reports.

    Export

    Return to the main report page and refine the report further.

    Customize

Time period

You can use one of the pre-defined reporting periods available from the Reporting period and As of date boxes. Or, create your own reporting period using the Start date and End date boxes.

  • In the Time period section do one of the following:

    • Select the Reporting period down arrow, and then select the time period you want.
    • Enter an As of date (the date used as a baseline for the period that you select. Leave blank for today's date).

    OR

    • Enter a specific Start date and a specific End date.

    If you complete all the time period boxes (if you fill in the Reporting period and As of date boxes in addition to the Start date and End date boxes), Intacct bases your report only on the specified start and end dates. It ignores the Reporting period and As of date specified.

The following table describes each item in the Time period section of this report settings page:

Time period Description Limitations

Reporting period

These periods are relative to the As of date.

All periods begin on the first day of the period, such as the first day of the month, quarter, or year that you select.

Only works with As of date. Does not apply if you select a Start date or an End date.

As of date

The date used as a baseline for the reporting period you select. Leave this box blank to use today's date.

Only works with Reporting period. Does not apply if you select a Start date or an End date.

Start date, End date

Leave the Start date blank to include all information from the earliest date you entered data into your company up to and including the end date. Leave the End date blank to include all information from the start date up to today.

The format must be MM/DD/YYYY.

Prompt on run

Select this checkbox to force Intacct to wait for you (or anyone using this report) to enter a time period before it runs the report.

  

Report filters

You can set up any combination of filters to isolate and assemble the data you want in your report.

Filter Description

Bank

Select the bank account for which to view transactions. This field might default to a preselected account if your administrator has set a Default bank account on the Configure Cash Management page.

If your administrator has not preselected a default account for you, this field displays All bank accounts. In this case, when you select View, the list is sorted in order of accounts if you selected All bank accounts.

Location, Department

Individual report

If you use departments and locations, you can use them to filter by selecting the appropriate combinations in their respective fields. You can also select pre-defined groups of departments and locations. For example, you select the group ENG, which includes hardware and software engineering along with the QA department. The report includes the data for those departments only. In multi-entity shared companies, location groups also include entities.

When running at an entity level, enter a location to display all transaction types.

Individual report. If this checkbox is cleared, the data is summed in a single report. However, if you select the Individual report checkbox, each department and location combination has its own report page. The order you shuffle the groups determines the order in which their pages are printed. Due to their potentially large size, reports with departments and locations on individual pages can be run offline only.

For multi-entity shared companies with multiple base currencies: Reports that you run at the top level require a location to determine the appropriate currency.

Show for

Appears only for multi-entity shared companies. The following choices cause the report to display transactions for certain locations regardless of the location you have chosen in the Location field. For example, you have the following structure: USA > California > Bay Area > Los Gatos.

  • All locations: Shows transactions for California > Bay Area > Los Gatos
  • This location: If you are in the California entity, shows transactions for California, regardless of what you select in the Location field.
  • Child locations: If you are in the California entity, shows transactions for Bay Area and Los Gatos only.

Show details

Select to run the report in Detail mode and only show columns for the:

  • account
  • transaction date
  • description
  • transaction number
  • reference number
  • the reconciliation status (Cleared)

    Transactions that are In Transit have not been reconciled. Transactions that are Cleared have been included in a reconciliation.

  • currency
  • debits and credits

Learn more about what appears in this report in Summary and Detail mode.

Show only voided and reversed

Include only transactions that are voided or reversed.

Show reconciliation status

Select this checkbox to view the Cleared column in the register report. There, you can view the Reconcile State of the transaction (see description below).

Reconcile state

Displays the reconciliation status for a transaction in the Cleared column of the register report.

  1. All: show transactions that are both in transit and cleared
  2. In transit: show only transactions that haven't yet been reconciled.
  3. Cleared: show only transactions that have cleared reconciliation. Transactions appear with their reconciliation date in the Cleared column.

Hide bank accounts with no transactions

Displays only bank accounts with transactions. This is useful in removing clutter from the report by hiding bank accounts that have no transactions for the period.

Report by

Choose either Transaction date or GL posted date:

  • Use Transaction date to see a report based on when the transactions were created. This report will not match the closing balance of the general ledger, which is based on when the transactions were posted.
  • Use GL posted date to see a report that matches the general ledger.

Formatting

Use this section to change the page layout and specify the sort order for this report.

  1. To change the page layout, from the Page orientation dropdown list select either Portrait or Landscape.
  2. To sort the report results, from the Sort by dropdown list select the category to sort by.

The following table describes each item in the Format section of this report settings page:

Format option Description

Sort by bank field

Display the results for each account by the ID or the name of the bank account.

Sort by

Determines the sort order of the list. If the Bank filter is set to All bank accounts, the list is first sorted by bank, and then by the sort order you choose here. The sort order can be by description, document number, debit amount, credit amount, or reconciliation state, along with the same choices in descending order.

Page orientation

Portrait is the default layout.

Portrait: display or print the report pages vertically

Landscape: display or print the report pages horizontally

Titles and footer

Titles, subtitles, and footers apply only to the .pdf version of this report. (Select Print to get the .pdf version).

  1. Enter the title in the Report title 1 box.

    • This title displays in large type at the top of the page, directly under your company name,
    • You can type over any default name that the system may have automatically supplied in this box.  

  2. Enter the subtitle in the Report title 2 box.

    • The subtitle displays in smaller type, directly beneath the main title.
  3. Enter the footer text in the Footer text box. Footer text displays at the bottom center of the report.

You can use up to 80 characters, including spaces, in each title, subtitle, and footer.

What's in this report?

The Bank register report in details mode (Show details is checked) consists of the following columns:

Report column heading Description

Account

The ID or the name of the bank account.

Transaction date

The date of the bank transaction.

Description

A description for the bank transaction.

Transaction number

The check number for a customer's payment (for example, the Check no. entered on the Select invoices for Payment page when you received a customer's payment).

Or, the check number for your payment to a vendor (for example, the Check no. on the Print checks page).

Ref number

The reference number entered on the transaction.

Cleared

The date on which the transaction cleared in the account reconciliation process. Transit indicates transactions that have not yet been cleared.

Currency

For multi-currency companies, the currency for the transaction.

Txn debit, Debit

The amount received for the transaction. (Txn debit appears only for multi-currency companies and is the same as Debit.)

Txn credit, Credit

The amount paid for the transaction. (Txn credit appears only for multi-currency companies and is the same as Credit.)

Balance

The running total of the bank account balance.

Void

Void the selected transaction. Void the transaction in the entity in which it was created.

Void is available only if you have permissions for voiding that type of transaction.

Required permissions: To be able to void AP payments, you need permissions in Accounts Payable to void posted payments and optionally, posted advances. If you use Expenses, there are separate permissions in Expenses to void posted reimbursements and posted advances.

You can void top-level bank register transactions from Posted payments. Otherwise, as a restricted user, you must provide a location to run the Bank register report, which gives you the entity-level view of top-level transactions. This means you cannot void those transactions from this report.

Reverse

Reverse the selected transaction.

Reverse is available only if you have permissions for reversing the transaction.

Required permissions: Permissions for reversing transactions can be found in Accounts Payable, Accounts Receivable, Cash Management, and Expenses. Learn more about reversing a transaction.

Owner/entity

This column appears only at the top level for multi-entity companies. Shows the entity in which the transaction was created.

The Bank register report in summary mode (Show details is unchecked) consists of the following columns.

Report column heading Description

Bank name

The name of the bank account.

Currency

For multi-currency companies, the currency for the transaction.

Beginning balance

The beginning balance of the account for the period specified in the Time period section.

Debit

The total debits for the account.

Credit

The total credits for the account.

Balance

The balance of the account at the end of the period specified in the Time period section.