Matching does the routine work, but you know the client. When a bank transaction and the entry that recorded it clearly belong together and the rules didn't pair them, such as a wire the books recorded a dollar short, or one deposit covering three customer payments booked weeks earlier, you can match them yourself in a few clicks. The match shows on Matched Records straight away, any difference stays visible all the way to the proof, and your match is kept every time matching reruns. For how matching works overall, see Cash Transaction Matching: How It Works and Why It Matters.
When to create a match
Every automatic match is exact to the cent and falls within its rule's window of days, so some pairs need you. For example:
- A keying error: the books recorded $50,022.00 for a $50,023.00 wire.
- One deposit for several payments recorded weeks apart: a $7,480.00 deposit that covers three customer payments recorded more than a month earlier.
- A payment the books split or combined in a way that no rule covers.
If the same kind of item goes unmatched again and again, check the matching rules first. A wider window may match all of them for you. See Matching Rules: Choosing How Transactions Are Matched.
The Unmatched Records screen
Go to Matching > Unmatched Records. Unmatched bank transactions are on the left and unmatched GL cash lines are on the right. Choose the Entity at the top, and set a Period to narrow both lists.
- Each list shows the Date, Description, Amount, Reason, Timing and Account. Inflows and debits to cash are green; outflows and credits are red.
- Filter any column with the box under its name, and sort by clicking the column name.
- The All and Timing buttons above each list switch between everything unmatched and only the timing differences.
- Bank transactions that a banking-only reconciling item explains aren't listed. A note above the bank list says how many there are, with a link to Banking Recon Items.
The Reason column says why an item didn't match:
| Reason | What it means |
|---|---|
| No match | Matching found nothing on the other side that fits. |
| No GL data | The books have no activity that month for this bank account. |
| No bank data | There's no bank activity that month for this GL account. |
| Timed out | There were too many possible combinations to check. Worth a manual look. |
| Not run yet | The item came back from a deleted match. Matching gives it a reason when it reruns. |
Create a match
- Tick the bank transaction. The GL list moves the closest amounts to the top, shaded and marked Closest amounts first, so the likely partner is usually near the top.
- Tick the GL cash line or lines that record it. You can tick several items on either side, and change filters without losing your ticks.
- Check the bar at the top of the screen. It shows Bank picked, GL picked and the Difference (bank less GL). A green check mark means the totals agree.
- Click Create match…, review the figures and any warnings, then click Confirm match.
The match shows on Matched Records straight away, as Manual with today's date. The Overview, the Cash Proof and the workpaper update once matching reruns. See "When your changes show up" in Cash Transaction Matching: How It Works and Why It Matters.
Tip: while items are ticked, the Matching tabs fold away and the entity can't be changed. Click Clear picks to start over.
When the totals don't agree
A manual match can carry a difference, such as a keying error of a few cents or dollars. The difference in the bar turns red, and the dialog says "The totals differ: the difference goes to the proof."
- The difference stays visible. It shows in the Difference column on Matched Records, and in the Difference column of the workpaper's Matched Transactions tab.
- In the proof, the difference goes with the match's GL lines: it shows on the workpaper tab that includes those lines, or in the proof's Variance if no tab does.
Warnings you may see
These warnings ask you to double-check. They don't stop the match.
- "The picked items are on bank and GL accounts that are not mapped to one another." The bank account and the GL account aren't linked in your mapping. Check that the items belong together.
- "The picked items' dates are … days apart." The items are far apart in time. Check that they belong together.
- "… picked items carry a timing difference a person added." The timing difference is set aside while the items are matched, and comes back if the match is deleted.
- "… picked bank transactions are no longer listed, so the match leaves them out." Something changed since you ticked them, such as a new reconciling item. The match includes only the items that are still unmatched.
If nothing was saved
If an item was matched or changed after the lists loaded, for example by a teammate or by a rerun, you'll see "Nothing was saved: some picked items were matched or changed since the lists loaded." Those items are unticked and the lists reload. Tick the items again and create the match.
Manual matches and later reruns
- Your manual matches are kept every time matching runs, and the rules never override them.
- If a transaction in a manual match is later corrected or removed in the client's data, for example by a new upload, that match no longer applies. Its other items are matched again from scratch.
- To undo a manual match, delete it on Matched Records. See Deleting a Match.