Forecasting

Forecasting

Forecasting is the window in the system where you can set a sales forecast by location by period and can enter daily values.  This forecast can be referenced in the Business Analytics module in the Daily Sales Summary data set to compare to actual values (steps to create this view are listed later in the training).  Since forecasting is commonly looked at weekly, this window is designed to work for companies that have their Operational Year setup as 13-4 week periods or 4/4/5 periods so that it can be based on weeks.  Calendar periods don’t work well in this screen … Continued
Trailing 12 Month Report

Trailing 12 Month Report

Displays the previous 12 months profit and loss in columns as of the date chosen to run the report.  May filter by location(s), legal entity(s), or concept(s).  Can expand the columns to show % of net sales for each month
Bank Balance vs GL Account Balance

Bank Balance vs GL Account Balance

To make sure your bank balances to the GL, you should verify that the “Statement Balance + Uncleared” value on the reconciliation report (circled in red in image below) and the GL account balance for that bank account as of the same date match.  There are a few reasons these values may not match.  When you approve a bank rec it takes a snapshot of the system as of that time so the “Statement Balance + Uncleared” value on the reconciliation report is showing the balance according to that snapshot. Reasons You Might Not Balance Example 1 “Entered a transaction after … Continued