View & Export Bank Transactions

Overview

To work your bank feed, open Financials → Bank Feeds → click Request refresh to pull in new transactions → move between the To Review, Reconciled, Held and Archived tabs → filter and sort from each column header, then use the Actions button → Export Transactions to download a CSV.

Refresh the bank feed

Open the Bank Feeds page

From the left menu, open Financials and click Bank Feeds. For finance users the page opens on the To Review tab.

Open the refresh panel

On the To Review tab, click Request refresh in the sidebar. A Refresh bank feeds panel opens.

Choose how far back to pull

Set Import from — it defaults to Last 4 days, or pick Today, Yesterday, Last 7 days, Last 14 days, Start of month, or a Custom date.

Confirm the refresh

Click Confirm refresh. Keyhook pulls in the new transactions and then tells you how many were added, or shows No new transactions available.

Note: If your agency uses trust-balance sign-off, you can't pull new transactions while the balance is unsigned — the panel shows Balance not signed off with a Sign off now link. Sign the balance off first, or tick Skip validation to override. A custom import date can only go back 60 days.

Switch between transaction groups

Know what each tab holds

The tabs across the top group your transactions: To Review (imported but not yet reconciled), Reconciled (matched to a payment), Held (placed in holding) and Archived.

Open a group

Click a tab to view that group — the table and the sidebar totals update to match.

Note: Only finance users (a finance person or the principal) can work the To Review and Reconciled tabs — for other managers those two appear greyed out. The Archived tab isn't greyed, but clicking it bounces a non-finance manager straight back to Held. The Archived tab is hidden entirely for agencies in strict accounting mode.

Filter and sort the transactions

Open a column's menu

Each of the Amount, Date and Details columns has a settings icon in its header. Click it to open that column's sort and filter menu.

Sort the column

Under Sort, choose Asc or Desc (or Clear Sort to remove it).

Set up a filter

Under Filter, pick a rule — Amount offers Equals, Less Than, Greater Than and so on; Date offers Date Is, Date Before, Date Between; Details offers Contains, Starts With, Ends With — then type a value.

Apply and clear filters

Click Apply. Active filters appear as chips above the table — remove one with its x. The Clear all link only appears once two or more filters are active.

Check the totals and expected payments

Read the totals

The sidebar shows the Incoming, Outgoing and Net totals for the tab you're viewing. On the To Review tab it also shows a System Balance breakdown.

See expected outgoing payments

On the To Review tab, in the Payments box click View payments to open the breakdown of unreconciled outgoing payments.

Download a reconciliation report

If your agency has reconciliation reports enabled, use Daily report or Monthly report in the sidebar to download one.

Export transactions to a CSV

Open the export window

Click the Actions button (top right) and choose Export Transactions.

Set the date range

Pick a Start Date and an End Date — both are required and can't be in the future, and the end date must be on or after the start.

Export

Click Export. Keyhook downloads a CSV file named for the date range you chose.

Note: The export covers every transaction in the date range you pick — it ignores which tab you're on and any column filters applied to the table.

Good to know

The Bank Feeds page opens on To Review for finance users and on Held for everyone else.
When Keyhook imports transactions newer than what's on screen, a banner reads New transactions have been imported! — click it to refresh the list.

Frequently asked questions

Why can't I open the To Review or Reconciled tabs?

The To Review and Reconciled tabs are limited to finance users (a finance person or the principal) and appear greyed out for other managers. The Archived tab looks clickable but bounces a non-finance manager back to Held. Either way, without finance permissions you effectively stay on the Held tab.

How do I find only outgoing payments?

Outgoing transactions show as negative amounts, so open the Amount column filter, choose Less Than, enter 0 and click Apply. The sidebar Outgoing total and View payments also summarise money going out.

How far back can I pull transactions when I refresh?

The Import from presets run up to Start of month. For anything older, choose Custom date — it can go back at most 60 days.

Does the CSV export use my current tab and filters?

No. The export includes every transaction in the Start Date to End Date range, regardless of the tab you're viewing or any column filters you've set.

What are the Reference, Particulars and Code columns?

They're the extra bank-statement fields. If your agency has extended columns enabled, switch on Display extended columns in the sidebar to show Reference, Particulars and Code alongside Amount, Date and Details.