The default matching rules are built for the way most clients keep their books, and most engagements never need a change. Matching Rules is for the exceptions: the client whose bookkeeping is unusual enough that the defaults leave real pairs unmatched, or pair items that don't belong together. For those clients you have the final say over how matching works: turn a rule on or off, widen or narrow its window, and see how many matches each rule made on the last run. For how matching works overall, see Cash Transaction Matching: How It Works and Why It Matters.
Before you change anything
- Start with the defaults. Change a rule only when the same kind of item keeps going unmatched, or keeps being matched wrongly. For example, a client who holds customer checks for two months and then deposits them in one batch: turning on Grouped items, 90 days (catch-all) matches those deposits.
- For one or two items, a manual match is quicker. See Creating a Manual Match.
- Settings belong to the entity. They apply in every Cash Proof request that includes the entity.
- Your other work is safe. Your manual matches, deleted matches and timing differences are kept every time matching reruns, whatever the rules say. A match you deleted stays deleted.
The Matching Rules screen
Go to Matching > Matching Rules and choose the Entity. The line under the entity says whether the rules are the defaults ("Matching rules: default" or "Matching rules: 2 changed from the defaults") and when matching last ran with these settings.
- Rules are listed in the order they run, numbered in the # column. Each row shows the rule's name and a short description. Hover over a rule to see an example.
- The switch beside each rule turns it on or off.
- The Window, Direction, Shape, Sister GL accounts and Other settings columns hold the rule's settings.
- Changed marks rules whose settings differ from the system defaults. Hover over the badge to see the defaults.
- Matched last run counts the matches each rule made, with a Total at the bottom.
- The All, Changed and Off buttons filter the list.
The rules
| Rule | What it matches | Example | On by default |
|---|---|---|---|
| Check number | A check that clears for the number and amount the books recorded | Check 4468 for $2,150.00 clears 12 days after the books recorded it | Yes |
| Exact 1:1 | One bank transaction to one GL line for the same amount | An $18,400.00 ACH credit to the $18,400.00 customer payment entry | Yes |
| Daily sums | A day's bank items that add up to one GL line, or the reverse | Three card settlements on 9/8 that add up to that day's sales entry | Yes |
| Day leftovers | A day's leftover bank items and GL lines that net to the same amount on both sides | After the other rules, Tuesday's two unmatched deposits and three unmatched entries both net to $1,250.00 | Yes |
| Grouped items (same day, 3, 6, 12, 20 and 31 days) | Several items on one side that add up to a single item on the other, within the days set | Three card settlements to one daily sales entry; one deposit to two customer payments | Yes |
| Grouped items, 90 days (catch-all) | The same, over a long window, for whatever is still unmatched | A deposit that covers payments recorded two months apart | No |
| Late match | A bank item that clears well after the books recorded it | A check recorded in September that clears in December | Yes |
| Remainder tie | What is left on both sides within the window, tied when the remainders agree | After everything else, the month's leftover bank items and GL lines both add up to $4,310.00 | Yes |
Two more rows appear in the list without a switch:
- Summary entries come first. When the books record bank activity in periodic summary entries, such as one entry a week, the bank transactions since the previous summary entry are matched to it when the totals agree exactly. Summary entries run again on whatever the rules leave.
- Manual comes last and counts the matches people created on Unmatched Records.
Late match and Remainder tie run last, on whatever the other rules leave, so on many entities they make few matches.
The settings
Hover over any setting to see its system default and its limits. A value outside its limits is refused, and nothing is saved until you fix it.
| Setting | What it does |
|---|---|
| Window (Days) | How many days apart the bank date and the book date may be. Check number calls it Days apart allowed. Late match uses From and To: the bank item must clear between those numbers of days after the book date. |
| Direction | Both, Inflows or Outflows: which bank activity the rule matches. |
| Shape | For Grouped items: Both, Several bank to one GL, or One bank to several GL. |
| Sister GL accounts | Allowed lets a match use GL lines from any GL cash account that your mapping connects to the bank account. Not allowed keeps each match to a bank account and the GL account it's mapped to. |
| Include $0 items | For Exact 1:1: also matches $0.00 items. |
| Inflows | For Daily sums: adds up a day's inflows. |
| Outflows and net-of-fees sums | For Daily sums: Off, Same day or Up to N days. Also adds up outflows, and deposits and fees that net together. |
| Min items per day | For Daily sums: the fewest items a day's sum can hold. |
| Day-balance pass | For Day leftovers: when on, also matches all of a day's remaining items as one group when the bank total and the GL total agree. |
| Smallest amount considered | For the catch-all: smaller items are left out. |
Note: a Grouped items rule keeps its name when you change its days. For example, "Grouped items, 3 days" set to 5 days still reads "3 days".
Change a rule and rerun
- Change a switch, a number of days or a choice. The row turns blue and shows Edited, and a bar at the top lists your edits, for example "1 edit, not yet run".
- reset on a rule's row sets that rule back to the system defaults, including changes saved in an earlier run. Discard in the bar drops only the edits you haven't run yet. Reset all to defaults sets every rule back to the system defaults. Nothing is saved until you click Rerun Matching.
- Click Rerun Matching. Your edits are saved and matching starts at once.
You'll see "Saved, and matching is rerunning." When matching finishes, the Matched last run counts update, and the Overview, the Cash Proof and the workpaper follow.
Use the same settings for every entity
To copy one entity's settings to the other entities in the request, click Apply to all entities in this request…, check the list, and click Apply. The settings are copied as edits. When you click Rerun Matching, Audit Sight asks once, then saves and reruns each entity.
Things to know
- You can turn every rule off. Rerun Matching asks first, because only summary entries and manual matches would remain.
- If you leave the screen with edits that haven't been run, Audit Sight asks whether to discard them.
- The Overview shows which entities have changed rules, such as "Matching rules: 2 changed". See Cash Transaction Matching: How It Works and Why It Matters.