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.
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:
What it is
When it shows up
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.
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 SettingsManage Your...General Settings page.
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:
This option shows all transactions for the selected account (or all accounts).
Only transactions that have been Jived or reconciled will show up.
Only un-jived transactions will show up in the transaction register
This option will only show withdrawals, including the withdrawal portion of a transfer.
This option will only show deposits, including the deposit portion of a transfer.
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.
Select this view option if you only want to see transactions for today and future dates.
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.
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.
Account selection for free members
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:
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
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
This is a quick link that takes you to the Search tool. You can learn more about using the Search tool here: Searching
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.
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.
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.
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.
All the selected transactions will be marked as Jived when clicked.
All selected transactions will be un-jived when clicked.
This will bring up a form that lets you edit all selected transactions. For ClearCheckbook Premium members
All selected transactions will be deleted when clicked.
All selected transactions will be copied and pasted into the register. For ClearCheckbook Premium members
If you select two transactions this button will appear. When clicked, it will make those two transactions into a transfer. For ClearCheckbook Premium members
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.
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.
Able to select
Jived / Overall
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 SettingsPremium MembershipRe-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.
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.
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.
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.
Transactions merged into one
Additional Transaction Details
Some transactions will have special icons or data associated with them. Here's what those icons mean:
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: SettingsManage 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.