ClearCheckbook Money Management
Money Management Made Easy
ClearCheckbook Knowledge Base

ClearCheckbook Knowledge Base

Help Sections

Knowledge Base Search:
Would you like to see something added to, or do you have a contribution for, the Knowledge Base? If so, let us know!

The Transaction Register

The Transaction Register is where you can view all of the transactions you've entered into ClearCheckbook. This page will explore the functionality of the transaction register and how to use the various account options.

Account Overviews

The Account Overviews box at the top left side of the Transaction Register shows the balance of the transactions based on the View and Account options selected in the Register Options box.

Different information will be displayed here based on a few different things:

Information What it is When it shows up
Credit Limit How much you have remaining toward the credit limit for the credit card you're viewing If you're viewing a credit card account that you've set up a credit limit for.
Today Balance The balance excluding any post-dated / future transactions. If you've added transaction(s) to the register with a date in the future. You can disable this separation from the Settings Manage Your... General Settings page.
View Specific The balance based on a View setting in the Register Options If you change the view to only show a specific type of transaction such as only Jived, Un-Jived, Deposits, Withdrawals or Transfers.

Register Options - View

The view options let you choose what type of transactions you want to see in your register. By default, all transactions are shown. The different view options are as follows:

Option Description
All This option shows all transactions for the selected account (or all accounts).
Jived Only transactions that have been Jived or reconciled will show up.
Un-Jived Only un-jived transactions will show up in the transaction register
Withdrawals This option will only show withdrawals, including the withdrawal portion of a transfer.
Deposits This option will only show deposits, including the deposit portion of a transfer.
Transfers The Transfers option shows only transfers. If you are viewing All Accounts, it will show both sides of the transfer (deposit and withdrawal). If you're viewing a specific account, it will only show the side of the transfer associated with the selected account.
Future Select this view option if you only want to see transactions for today and future dates.
Past Select this option if you only want to see past transactions in the transaction register.

If you select a specific view option you will see a yellow alert above the view options letting you know which one is active. When you select an option, this selection will persist until you change it.

Transaction Register - View Option Alert
View options and alert

Register Options - Account Selection

Account selection will look slightly different based on your ClearCheckbook Premium status. Free members will have the ability to select between All Accounts or a single account. ClearCheckbook Premium members can select multiple accounts to appear in the register at once.

Transaction Register - Account Option Default
Account selection for free members
Transaction Register - Account Option Premium
Multiple account selection for premium members

When you select an account or accounts other than All Accounts, only the transactions for the selected account will appear in the Transaction Register. The Account Overviews will also update to show the balances for just the selected account.

Register Options - Number of Transactions

ClearCheckbook Premium members have the option of changing the number of transactions that appear per page in the register and in the Search results. 30 transactions is the default for both free and premium members. The other options are 50, 75 and 100. Whichever option is selected will remain until it's changed.

Register Options - Tools

There are various tools related directly to transactions that can be found at the bottom of the Register Options box. The different links are as follows:

Tool Description
 Reconcile Reconcile takes you to the `Zero-Out Reconciliation` page where you can reconcile your transactions based on account starting and ending balances. Learn more here: Zero-Out Reconciliation
 Credit Card You can manage your credit card transactions and easily handle identifying credit card payments and which transactions were included in that payment. Learn more here: Credit Card
 Search This is a quick link that takes you to the Search tool. You can learn more about using the Search tool here: Searching
 Export Clicking this link will create a CSV file and export the transactions that currently appear in the transaction register. For a more robust export tool, see the Export Transactions tool

Toggling Account Balances

You can toggle your account balances list on the Transaction Register by clicking on the `Show / Hide Account Balances` link that appears below the Account Overviews and Register Option boxes and above the With Selected box.

Transaction Register - Toggle Account Balances
Click to expand account balances

When clicked, the Account Balances list will appear and show all of your accounts and associated Jived and Overall balances.

Transaction Register - Expanded Account Balances
Example of expanded account balances list

If you have accounts with currencies that differ from your global currency, those account balances will appear with an italicized font and an alert will appear below the list letting you know the individual account balances are shown in their own currency but the overall balances are converted to your default currency.

Transaction Register - Multiple Currencies in Account Balances
Example of multiple currencies

You can hover over the italicized balances to see some more information, including which currency the account is using and what the balance is when it's converted to the global default currency.

Selected Transaction actions

You can perform different actions when selecting transaction(s) from the transaction list. Below is a list of the various buttons that appear in the `With Selected` box at the top and bottom of the transaction list.

Button Description
Jive All the selected transactions will be marked as Jived when clicked.
Un-Jive All selected transactions will be un-jived when clicked.
Edit This will bring up a form that lets you edit all selected transactions. For ClearCheckbook Premium members
Delete All selected transactions will be deleted when clicked.
 Duplicate All selected transactions will be copied and pasted into the register. For ClearCheckbook Premium members
 Make Transfer If you select two transactions this button will appear. When clicked, it will make those two transactions into a transfer. For ClearCheckbook Premium members
 Merge If you select two transactions, one of which was synced from your bank, this button will appear. When clicked, it will merge the two transactions together. Learn more...

Changing Page Numbers

If you have more transactions than can appear on the page, a page number selection bar will appear directly above and below the transaction list. To navigate to a different page, simply select the page number you would like to view.

Sorting Transactions

You can change the sorting method of the transaction list by clicking on the column header you want to sort by. The column that's currently being sorted will have a darker background and an up or down arrow identifying the sorting method. Clicking that column again will switch between ascending and descending. Not every column can be sorted. Below is a list of all the columns and whether or not you can sort on them.

Column Able to select
Date   Yes
Amount   Yes
Jived   No
Account   Yes
Category   Yes
Description   Yes
Check #   Yes
Memo   Yes
Payee   Yes
Jived / Overall   No

Re-Arranging Columns

ClearCheckbook Premium members have the ability to re-arrange how the columns in the transaction register appear. To learn more about how to do this, check out our Settings Premium Membership Re-Arrange Transaction Columns Knowledge Base article

Clicking on Transactions

Depending on which part of the transaction you click on, different actions will take place. Clicking just about anywhere on the transaction will bring up an Edit Transaction form for that specific transaction. You can then edit or choose to delete the transaction from this form.

Clicking on the checkmark icon in the Jived column will toggle the transaction's Jive status.

Selecting the checkbox on the far left side of the transaction will let you perform any actions in the `With Selected` boxes at the top and bottom of the transaction list.

Merging Transactions

ClearCheckbook Premium members have the ability to merge synced transactions with those manually entered into your register.This is useful if you enter transactions manually or you use the Recurring Transactions tool to post transactions but also have your bank connected and transaction syncing enabled. With the Merge feature, you can combine the manually entered and the synced transaction together.

Merging transactions will keep all information from the manual transaction but replace the date and amount with that of the synced transaction. If the manually entered transaction doesn't have a description, payee or category associated with it, those will be taken from the synced transaction as well.

To merge two transactions, find one that has synced and one that was manually entered (or posted via the recurring transactions tool) and select them.

Transaction Register - Merging Transactions Selection
Two transactions to merge

When you select one synced and one manually entered transaction, a new Merge button will appear in the With Selected box. Click the button to merge the two transactions together.

Transaction Register - Merging Transactions Button
Merge button

When the two transactions are successfully merged, a new transaction containing the merged details of the two transactions will appear at the top of your register with a yellow background. The two original transactions are removed when they are successfully replaced with the merged transaction.

Transaction Register - Merged Transactions
Transactions merged into one

Additional Transaction Details

Some transactions will have special icons or data associated with them. Here's what those icons mean:

Icon Description
This transaction is one side of a transfer. Click on the icon to redirect to a Search results page that shows the other side of the transfer.
This transaction was a credit card purchase that has been paid off. Click on this icon to see the credit card payment details.
This transaction has a file attachment. Click on the icon to see the file attachment.
If you see this icon instead of the Jive checkmark, Jive Lock is enabled and this transaction cannot be modified in any way. You can adjust the Jive Lock settings here: Settings Manage Your... General Settings
« # Splits » This transaction has split children. The # sign will be the number of splits this transaction has. Click on the link to see those split children.
This transaction has been automatically synced from your bank.
This synced transaction might be a duplicate of an existing transaction you entered into your register.