Admin Panel: Bank Settings

Admin Panel: Bank Settings

Overview

The Bank Settings page in CustomBooks™ allows you to configure default accounts, automate categorization, and manage how the system interacts with your downloaded or imported bank transactions. Correctly setting these options ensures smoother reconciliation and more accurate reporting.


How to Access Bank Settings

There are two ways to navigate to this page:
  1. Via Admin Panel: Go to Admin Panel → Bank Settings.
  2. Via Bank Menu: Go to Bank → Bank Settings.


Configuration Sections

Default Accounts

This section defines which general ledger accounts CustomBooks™ uses automatically for specific banking functions.
  1. Bank account: Select the default account for primary banking transactions (e.g., "1000 Business Checking").
  2. Undeposited funds: Choose the holding account for payments received but not yet deposited into the bank (e.g., "1100 Undeposited Funds").


    Action: Double-click the pencil icon next to an account to change the default selection.

Duplicate Check Numbers

  1. Allow duplicate check numbers: Check this box if you need to reuse check numbers.
    Note: If "allow duplicates" is turned off, the functionality to default transaction types to "expense" when reference numbers are outside of the below range is disabled.
  2. What parameters do you want to allow duplicates outside of?: Reference or check numbers outside of the range specified will be set as "expense" transaction types.



Categorization

This section controls how CustomBooks™ automatically processes imported cloud banking transactions.
  1. Use Categorization Rules: Check this box to enable automatic sorting of transactions based on your pre-defined rules.
    1. "Go to categorization rules" button: Click this to view, create, or edit your Categorization Rules.
  2. Force transactions under a certain amount:
    1. Use Amount threshold: Check this to automatically route small transactions to a specific "Miscellaneous" account.
    2. Amount: Enter the dollar limit (e.g., 5.00). Transactions below this amount will be auto-categorized.
    3. Account code: Select the specific account (e.g., Misc Expenses) where these small amounts should be booked.
    4. Auto-approve: Check this to post these transactions immediately without manual review.


Matching

These settings determine how the system suggests matches between your bank feed and existing records.
  1. Matching document limit: Define how far back the system should search for a matching document (e.g., "2 years"). The system will not suggest matches for documents older than this limit relative to the bank transaction date.


Online Bank Accounts

Manage the status indicators for your connected bank feeds.
  1. Threshold of unrefreshed online account: Set the number of hours (minimum 30) before an account is considered "unrefreshed" or stale. If a feed hasn't updated within this window, it will be flagged.
  2. Color of unrefreshed online account: Choose the visual indicator color (e.g., Red or Yellow) for accounts that have connection errors or haven't refreshed within the threshold time.


Saving Your Changes

There is no "Save" button on this page. Changes made in the Bank Settings save automatically. Whenever you modify a field, a notification popup will appear in the lower-right corner of the application confirming that your changes were successfully saved.