View transactions in a budget or forecast

The ability to view all transactions is limited by your access to financial data. If you have permission to manage custom statements, you can restrict users from accessing transactions in specific accounts.

You can drill down into comparison data of any budget (or forecast) to view the underlying transactions that make up each value in the comparison row, similar to how you can in the Analytics and Financial Statements modules. The transaction level is the most granular detail you can see in the underlying database.

The ability to view transactions is particularly helpful in the following situations:

  • If you identify any anomalies in the budget values, you can analyze the transactions to identify the root cause.

  • In deciding whether last year’s value is made up of transactions that are likely to recur in the budget period.

  • When you carry out the re-forecasting validation process and need to ask your cost centers to justify differences between the original budget and actuals, you can use specific transactions as reference points.

Expand the comparison row, then right-click a value in that row and click Transactions.

The transactions window displays all the transaction values associated with the selected value; the sum of these transaction values equates to the value you see in the worksheet cell. This is the same data that you see when you view the transactions in the database, via either Financial Statements or Analytics, as applicable. Regardless of the starting point, the transactions display in Analytics > Transaction mode. In the top-left corner, you can see the period followed by the filters that are applied. In the grid, there are columns for all the properties, along with the value, which corresponds to the selected measure. There’s a count of rows at the bottom. If a row limit is applied in Analytics, it is carried through into Budgets and Forecasts transaction window, as identified by the warning symbol in the top-right corner.

You can then:

  • Click a column header to sort the transactions in that order.

  • Click the full-screen button in the top-right corner to get a better view of the transaction grid.

  • Click outside the transaction window to close it and return to the worksheet.