The Register

The Register

Overview

The Register in CustomBooks™ serves as a ledger for recording your bank and credit card transactions. It provides a clear and organized view of all your financial activities, helping you keep track of your income and expenses. It provides an interface similar to a check register, making it user-friendly and intuitive.

It allows you to manually enter various types of transactions including Expenses, Deposits, Checks, and Transfers. Each entry requires details such as date, account, customer/vendor, payment/deposit amount, and class. It also shows if the transaction is approved in Cloud Banking or if it's been reconciled.

The Register provides a clear view of all transactions related to bank and credit card accounts. This includes cash receipts, cash sales, bill payments, and journal entries.



Benefits of Using the Bank Register

The Bank Register offers several advantages for managing your financial accounts:
  1. View all account activity in a single location.
  2. Enter transactions directly into the register.
  3. Monitor running balances in real time.
  4. Review and manage deposits, payments, transfers, and adjustments.
  5. Simplify the reconciliation process.
  6. Maintain accurate and up-to-date cash records.

Accessing the Bank Register

From the CustomBooks™ application Home Page, click the Register button under the Accounting & Banking module; or go to Bank → Register (under Tools category).



Understanding the Bank Register

The Bank Register displays account activity in a transaction grid. Depending on your configuration and account type, the register may include information such as:
  1. Transaction Type
  2. Transaction Date
  3. Reference Number
  4. Customer/Vendor
  5. GL Account
  6. Memo
  7. Payment Amount
  8. Deposit Amount
  9. Cleared/Reconciled Status
  10. Running Balance
The running balance updates automatically as transactions are entered, edited, or deleted, providing an accurate view of the account's current balance.

Common Tasks in the Bank Register

1. Entering a New Transaction

You can enter transactions directly from the Bank Register when needed. This includes:
  1. Expense
  2. Check
  3. Deposit
  4. Bank Transfer
After saving the transaction, the account balance updates automatically.

How to enter a New Transaction

  1. Open the Register.
  2. Select the bank account in the Bank Account drop-down button.
  3. Select the Presets and Period.
  4. Click the Add button.
  5. Select which type of transaction you are entering on the Document column drop-down menu.
  6. Enter the Date.
  7. Enter the Ref #, if applicable.
  8. Enter the Customer/Vendor, if applicable.
  9. Enter the G/L Account.
  10. Add a Memo (optional).
  11. Enter the Payment or Deposit amount.
  12. Add a Class and a Project (optional).

Tips on Entering Data

  1. Use the Enter key to navigate between fields.
  2. To easily enter an account number, start typing either the Account Name or the Account Number. It will appear in a list and may be chosen.
  3. Data saves automatically! There is no need to click a Save button.
  4. Fields underlined in red are required fields.
  5. Click on the document hyperlink (Document column) in the line to view details about that transaction.
Info
The register module includes several automations that save keystrokes and speed up the entry of transactions.
Included:
  1. Date field is copied from the previous line.
  2. Check number is automatically incremented and entered automatically for those payments that are checks.

2. Review Transaction Activity

Use the register to review historical transactions for an account. This can help when researching discrepancies, verifying account activity, or preparing for reconciliation.

3. Edit Existing Transactions

If a transaction requires correction, you can update it by either clicking the document hyperlink to open and edit the transaction or by making changes directly from the Bank Register list view. Any changes you save are immediately reflected in the account balance and related records.

4. Delete Transactions

Transactions that were entered incorrectly can be deleted, provided they are not restricted by system settings or linked to other transactions.

To delete a transaction:

  1. Select the transaction you want to delete.
  2. Click More Actions > Delete, or right-click the transaction and select Delete.
  3. Confirm the deletion when prompted.

5. Reconcile Bank Accounts

The Bank Register works alongside the reconciliation process by displaying cleared and uncleared transactions. This allows you to compare the recorded account activity against your bank statement and identify any outstanding items.

To begin reconciling the bank account:

  1. Click the Reconcile button.
  2. The Begin Reconciliation window will open.
  3. Enter the required reconciliation information. Follow the reconciliation process instructions provided in the Creating a Reconciliation knowledge base article.

For a quick overview of the process and guided steps, please watch the video below.



Cleared and Reconciled Transaction Indicators

The Bank Register also includes a Status Indicator column, identified by a bank icon, that provides a quick visual indication of each transaction's status.


  • C (Cleared) – A "C" appears when the transaction has been accepted or approved in Cloud Banking, indicating that it has been confirmed by your financial institution.
  • R (Reconciled) – An "R" appears when the transaction has been reconciled using the Bank Reconciliation module, indicating that it matches a transaction on your bank or credit card statement.
Note: If a transaction has been both approved in Cloud Banking and reconciled in the Bank Reconciliation module, the Status column still displays "R", indicating that the transaction has been reconciled.

Register Settings

The Register Settings allow you to customize the information displayed in the Bank Register.
You can configure the following options:
  1. Preset – Select a predefined view for the register.
  2. Period – Specify the date range of transactions to display.
  3. Bank Account – Choose the bank or credit card account to view.
  4. Class Column – Show or hide the Class column.
  5. Project Column – Show or hide the Project column.


Filtering and Searching Transactions

To quickly locate transactions within the register, you can use available filtering and search options, such as:

  • Date ranges
  • Transaction types
  • Reference numbers
  • Customer/Vendor
  • Amounts


These tools make it easier to find specific transactions and investigate account activity.

Best Practices

  • Regularly review the Bank Register to ensure transactions are recorded accurately.
  • Reconcile bank accounts on a consistent schedule.
  • Investigate discrepancies promptly.
  • Avoid deleting transactions that have already been reconciled unless necessary.
  • Use meaningful descriptions and reference numbers to improve transaction tracking.

If you need any further help or assistance, don't hesitate to reach out to our support team. You can contact us via live chat, email, or by submitting a support request ticket through our Help and Support page.