Finance Register β Exact Metric-to-Column Accuracy
When you ask the AI Business Advisor a question about register cash activity, the answer reflects the specific metric you asked about β not a similar or related one. This article explains how the Advisor maps register-related questions to the correct finance register columns, what to expect when a period has zero activity, and how to phrase questions to get precise results.
Audience: Business owners and managers who review register cash activity and want to understand how the AI Business Advisor interprets register-related questions.
Before you begin
The AI Business Advisor must be enabled for your organization, and your employee profile must have the AI Business Advisor allowance turned on.
Permission: View (on the AI Business Advisor security object) β Required to access the AI Business Advisor.
You must be in the Analytics area. Navigate to Analytics and open the AI Business Advisor.
Questions about register cash activity work in both Fast mode and Thinking mode. Fast mode answers cover day-level summarized data current through the previous complete day. Thinking mode provides deeper analysis over detailed transaction data and may require a subscription or upgrade.
Steps
Understand how register columns map to questions
The AI Business Advisor maps each register-related question to a single, specific column in the finance register. It does not substitute one column for another, even when columns might seem related.
The following table shows how common question topics map to register columns:
| What you ask about | Column the Advisor uses | What that column measures |
|---|---|---|
| Cash added | Cash added | Cash physically added to a register |
| Petty cash / cash moved to petty cash / cash transferred to petty cash | To petty cash | Cash moved out of a register to petty cash |
| Register over/short / cash discrepancy | Adjustments | Expected cash minus actual cash at register closure |
Important: These columns are distinct. The Adjustments column measures register cash over/short at closure and is unrelated to petty cash movement or cash added. Asking about "adjustments" and asking about "petty cash" return different data from different columns.
Ask about cash added to a register
To find out how much cash was added to registers during a period, ask directly:
- In the AI Business Advisor, type your question using the phrase cash added β for example, "How much cash was added to registers last week?" or "Show me cash added by center for last month."
- The Advisor queries the cash added column for the period you specified and returns the total.
- Review the answer. The result reflects only cash-added activity β not deposits, closures, adjustments, or other register columns.
Note: The Advisor does not substitute the cash-in-register total, deposit amount, adjustment value, or closure count when you ask about cash added.
Ask about petty cash
To find out how much cash was moved to petty cash during a period, use any of the following phrases β they all map to the same column:
- In the AI Business Advisor, ask your question using one of these phrases: "petty cash," "to petty cash," "cash moved to petty cash," or "cash transferred to petty cash" β for example, "What was moved to petty cash last quarter?" or "Show petty cash by center for this month."
- The Advisor queries the to petty cash column for the period you specified and returns the total.
- Review the answer. The result reflects only petty cash movement β not the adjustments column or any other column.
Important: Even though "adjustments" and "petty cash" are both related to cash management, they represent different things and the Advisor keeps them separate. Never interpret an adjustments answer as a petty cash answer, or the reverse.
Ask about register over/short or cash discrepancy
To find out how much registers were over or short at closure, ask using register discrepancy language:
- In the AI Business Advisor, ask your question using phrases like "register over/short," "cash discrepancy," or "over and short" β for example, "What were the register over/short amounts last month?" or "Which centers had the largest cash discrepancy this quarter?"
- The Advisor queries the adjustments column for the period you specified. This column records the difference between expected cash and actual cash at register closure.
- Review the answer. The result reflects register closure discrepancies only β it does not include petty cash transfers or cash added.
Interpret a zero result for a period
When the Advisor finds no activity in the requested column for the date range you specified, it reports that result directly β it does not suppress the zero or broaden the date range to return an all-time total.
- Ask your question with a specific date range β for example, "How much cash was added to registers last Tuesday?"
- If no cash was added during that period, the Advisor returns an answer such as "No cash was added to any register during [period]" rather than "No data found" or a total from a wider date range.
- Treat a zero result as a valid, complete answer for that period. If you want to check a different period, ask a follow-up question with the new date range.
Tip: If you receive a zero and want to see activity across a longer window, ask a follow-up question β for example, "Show me cash added for the past 30 days." See Ask follow-up questions.
Note: A zero-total result and a "No data found" message have different meanings. A zero total means the Advisor ran the question against your data for that period and found no activity in that column. "No data found" may indicate a data-access or configuration issue. If you see "No data found" unexpectedly, contact your administrator.
Worked example
Example: A manager at a three-center organization wants to check petty cash activity for last week. She asks: "How much was moved to petty cash across all centers last week?"
The Advisor queries the to petty cash column for last week across all centers in her view and returns: "A total of $340.00 was moved to petty cash last week β $180.00 at the Downtown center, $120.00 at the Midtown center, and $40.00 at the Airport center."
She then asks: "How much cash was added to registers last week?" The Advisor queries the cash added column β a separate column β and returns a different total reflecting only cash-add activity, not petty cash.
Finally she asks: "What were the register over/short amounts last week?" The Advisor queries the adjustments column and returns the closure-discrepancy totals β again a separate result from the previous two answers.
Tips
- Phrase your question using the exact metric name β "cash added," "petty cash," or "register over/short" β so the Advisor maps to the right column without ambiguity.
- If you are unsure which term to use, ask in a natural way that describes what you are looking for (for example, "How much cash left registers to cover small expenses?" maps to petty cash).
- When comparing register metrics side by side, ask each question separately so you can see the column breakdown clearly.
- Narrow your question to a specific date range. The Advisor always honors the date filter you provide and reports zero if no activity occurred β it does not silently expand to a wider range.
- Use Thinking mode for multi-center comparisons or cross-topic register questions that combine register data with other business areas. Thinking mode may require a subscription or upgrade.
Troubleshooting
The answer mentions "adjustments" but I asked about petty cash.
The adjustments column and the to petty cash column are different. If you asked using the word "adjustments," the Advisor returned register over/short data. Rephrase your question using "petty cash," "to petty cash," "cash moved to petty cash," or "cash transferred to petty cash" to get petty cash data.
The Advisor returned "No cash was added" but I know cash was added that day.
Check that the date range in your question matches the day you are thinking of. The Advisor's Fast mode data is current through the previous complete day, so activity from today is not yet included. If the date is correct and the result is still zero, ask the same question for the broader week to confirm whether the activity appears in a different time window.
I asked about register over/short and got a zero, but I expected a discrepancy.
A zero in the adjustments column means registers closed exactly at the expected amount for that period, which is a valid result. If you believe a discrepancy should exist, verify in your register closure records and then ask with a more specific date or center name to narrow the result.
I see "No data found" instead of a zero.
"No data found" is different from a zero total. A zero total means the Advisor found your data and the activity was zero. "No data found" may indicate an access, configuration, or sync issue. Confirm that the AI Business Advisor is enabled for your organization and your center, and that your role has access to the relevant view. If the issue continues, contact your administrator.