ClearCheckbook Knowledge Base

ClearCheckbook Knowledge Base

Help Sections

General

Tools

Reports

Settings

Permanent Actions

Apps

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!

Synced Transaction Settings

These settings determine how transactions synced from your bank are added to your account. You can set some global settings as well as set up text and category replacements. An example would be if you normally fly on Southwest Airlines and the keyword Southwest shows up regularly in your synced transactions, you can match that keyword to your Travel category so that transaction will automatically be categorized properly.

You can also set up text replacement for the description, memo or payee field in your synced transactions. For example, if you purchase something on Amazon, the text on your statement will show up as AMAZON.COM*276809AZ3 AMZN AMZN.COM/BILL WA 98109 US but you can set up a match to replace that string with Amazon.com

You can find the Synced Transaction settings by clicking on Settings at the top right side of the page, then click on Synced Transaction Settings under the Syncing Transactions header.

Global Settings

There are two settings you can change that affect the way your transactions are added to your account. The global settings are as follows:

Setting Description
Assign details to this field You can choose which field the transaction details (the short description associated with the transaction, such as Uber 072515 SF**POOL**) will be applied to. The choices are Description (default), Memo, Payee
Use pre-assigned categories? The transactions that are synced from your bank come pre-categorized. These categories most likely won't exactly match the ones you've already set up in ClearCheckbook. You can turn off auto-categorization by selecting the No, Do not use pre-assigned categories option. This will leave the category field empty and you can assign a category later.
Set posted transactions as jived? When your transactions are synced each day, transactions are received as Pending or Posted. By default, any transaction flagged as Posted is marked as jived. If you would prefer to manually jive your transactions, you can change this option to No - Do not jive any transactions.
Note: this setting only affects regular daily transaction syncing and not the initial historical download.
Check for duplicate transactions? If you manually enter transactions in an account that's also set up for syncing, setting this option to Yes will flag any synced transactions that appear as a duplicate of those you manually entered. See the section below for an explanation of the duplicate flagging

Duplicate Transaction Setting Explained

If you enable the Check for duplicate transactions setting, all transactions that sync from your bank are compared against those you manually entered and checks to see if there might be a duplicate.

The duplicate filter checks for any transactions that match all of the following criteria:

  • Transactions belong to the same account
  • Transactions have the same amount
  • Transactions have a date within 3 days of each other

If a possible duplicate is found, a small alert is shown in the synced description.

Synced Transaction Settings - Duplicate Transaction Flag
Sample of a duplicate transaction flag

When a duplicate flag is shown, you can choose to delete the manually entered transaction, delete the synced transaction or remove the alert flag. To remove the flag, click on the transaction to edit it and click on the Not a Duplicate link. This will remove the flag from the transaction.

Synced Transaction Settings - Remove Duplicate Transaction Flag
Edit a transaction to remove the duplicate flag

Adding a Match

The form at the top of the page lets you add new matches. Whenever transactions are synced from your bank, ClearCheckbook will search the description, memo or payee field for the matching keyword and automatically assign the category you choose. The various fields are shown in the screenshot and explained in the table below.

Synced Transaction Settings - Add Match form
Sample Add a Match form
Field Description
Text to Match Enter a simple keyword contained in the data for your imported transaction. We will look for this keyword when you import a file and match it to the appropriate category.
Category to Assign Which category you want the matched keyword assigned to.
Text to Replace Optional. If the text from the Text to Match field is found in the field, it will be replaced with this value.
Reassign Field Optional. If you want this text applied to a different field from your global setting, you can choose that field here. You can choose from the Description, Memo or Payee fields.

Viewing Existing Matches

When you've added some matches, you will see them in the Existing Matches list. The matches are sorted alphabetically by keyword. The Text, Category and which Field the match will be applied to are all listed.

Synced Transaction Settings - Existing Matches list
Sample of Existing Matches list

Editing a Match

You can edit a match by clicking the icon at the top right side of the match you want to edit.

Synced Transaction Settings - Edit an Existing Match
Click to edit an existing match

When you click on the edit icon, an Edit Match form will appear where you can modify the details of the match.

Synced Transaction Settings - Edit an Existing Match
Edit Match form

Deleting a Match

You can delete a match by clicking the icon at the top right side of the match you wish to remove. When removed, this match will no longer trigger when your transactions are synced.

Synced Transaction Settings - Delete an Existing Match
Click to delete an existing match

Contact ClearCheckbook

If you have a question about the site, please check the Support Forums, Tutorials and Help section to see if it's already answered there.

Your message has been sent.

Thank you for reaching out to us. We work hard to respond as quickly as possible to our emails. You'll receive a response soon.