The standard Lookup feature compares each transaction to one value, in column A:
The Two-Part Lookup option can compare transactions to two values for precise matching:
Deposit to Checking, Account #1234
Deposit to Checking, Account #5678
The Two-Part Lookup option can properly post these transactions to their respective accounts.
Many statements contain the entire transaction description in a single column, such as "Description". The program can examine that one column for two values.
If the Description contains "Deposit to Checking" and the Description contains "#1234", then assign Vendor name V and post it to account A.
Other statements have multiple columns of description, such as "Payee" and "Memo". The program can examine each column separately.
If the Payee contains "Deposit to Checking" and the Memo contains "#5678", then assign Vendor name V and post it to account A.
Enter the activation code in Overrides > Option at the bottom right
Copy and paste the following setting into SC_config_System.txt:
# set the two-part lookup option
You decide to have both lookup comparisons on the Payee. In your statement, Payee data is in column B, so you would enter:
Lookup_Comparison_Column_2 = B
You want lookups to be on the Payee and the Memo. Memos are in column F of your statement, so your setting for the second lookup would be:
Lookup_Comparison_Column_2 = F
Insert a new, empty column B by selecting column B and clicking Insert > Column
Enter your matching rules in columns A and B of the Lookup table
If you enter text in columns A and B, both items have to match.
If you enter text in only one column, A or B, only that one item has to match.
Convert your statement as usual.
If you have any questions, please submit a support ticket.
Complete instructions for the Lookup feature are here.