Insights: see why a transaction was flagged, and what each merchant paid back
Every flagged transaction says why, and merchants show money in and out.
The Insights tab now tells you why it flagged a transaction, shows what each merchant was paid and what they sent back, and keeps the client's own transfers out of the income figure. The duplicates list has also moved.
Every outlier now says why it was flagged
The Outliers section of Anomalies is now a single list of transactions. A row is listed for one of three reasons, and the Reason column says which:
Largest in. One of the 25 largest amounts coming into the project's accounts.
Largest out. One of the 25 largest amounts going out.
One-off large payee. A row of $10,000 or more, in or out, with a payee that appears at most twice in the whole project.
A move out of one project account that lands in another, same amount, within a few days, is left out. A line under the Outliers heading tells you how many of those were left out and what they add up to. Rows on investment and retirement accounts are left out too. The list sorts largest first, and the export carries the Reason.
See money in and money out for each merchant
The Merchants table now has Money in and Money out alongside the net amount. A payee who was paid $40,000 and sent back $38,000 nets to $2,000, which looks small. The two columns show both figures.
Names are also joined more carefully. Two spellings become one merchant only on proof: the same letters and digits, for example, or the same words once filler like "The," "Inc" or "LLC" is dropped, or a name the bank cut off. Names that only look alike stay apart.
See how much income came from outside the client's accounts
The monthly table on Income splits each month into two more columns. Between project accounts is deposits matched to a transfer from another account in the project: the same amount, within a few days, where the bank's description names the other account. From outside is the month's income with those matched transfers taken out.
Duplicates are now under the Actions menu
Duplicate transactions now have their own page. Open the project's Actions menu and choose Possible duplicates.
On plans with reconciliation, the list also leaves out a charge that really did post twice. When every copy of a charge sits in one statement cycle that CounselPro reconciled without help, and the cycle balances with all the copies counted, the charge really did post more than once, so the group is left off. A group the balance cannot prove, including one in a cycle reconciled by hand, stays on the list for you to judge.
Click Regenerate Insights on older projects to get these changes
A project whose insights were built before this release keeps its old layout. Open the Insights tab and click Regenerate Insights in the project header to get the new Outliers list, the Merchants columns, and the Income split. See when insights update.