CROSS ACCOUNT TRANSFERS
Sometimes we want to drill down into the details. Other times, we want to take a step back and look at the big picture. These two reports do that.
The Account Report summarizes the transactions for all accounts in the case.
The Cross Account Transfers summarizes the inter-account transactions that we saw in other reports.
Wouldn’t it be great if you could highlight transactions based on content? Selective Formatting lets you select transactions based on relevant criteria in any field. I often use it to highlight debits and credits over $1,000. Note that you have a choice of 16 colors for the font and 16 colors for the background.
The first example shows debits greater than or equal to $1,000. I chose white for the text and navy for the background.
Starting with the example above, I added credits greater than or equal to $1,000. This time, I used navy for the text and silver for the background.
Earlier, I showed you how Pattern Manager can isolate individual payees. However, there may be instances where the payee’s name is not exactly the same every time. For example, Insurance Company of America might also appear as Ins Co of America. Or there may be OCR errors from the conversion to Excel that renders the same name differently. Description Grouping addresses these issues. This feature uses “Fuzzy Matching” to group similar transactions together.
Here are 3 views of Description Grouping:
Groupings – Summary
Groupings – Detail
Groupings – Charts
If you like this post and want to see more, subscribe to this blog.
BALANCE OVER TIME
Would it be helpful to have a visual represention of all account transactions over time? You could quickly see any unusually large debits or credits and drill down to the detail of the transactions. The Balance Over Time feature displays a graph of the account balances over the history of the account. It also lists the balances by date. When you spot an spike in the chart, you can go to the date in question and click to drill down to the individual transactions.
The added value with this feature is the automatic creation of a Pivot Table for further analysis.
Here is an example of how we use Balance Over Time:
In this case, you’ll notice a big spike prior to October 1, 2012. If you scroll down to 9/25/12 and click the balance, the individual transactions are displayed and there is one deposit for $296,000.
Our software is used across the United States by law enforcement at all levels of government, forensic accountants, litigation support professionals, attorneys as well as health insurance companies.
All data is stored locally on your workstation or server and all processing is done locally. Nothing is done in the cloud. You are always in possession and control of your own data.
We have no “per page” charges. We license our software on an annual basis. You can choose to purchase a workstation license, a multi-user server license or a plan that meets your budget.