Capital expenditures are entered through the Manage Capex.
Dashboard tab:
At the top of the screen are
the "Search" criteria. The "Advanced" Search functionality is
available.
The Search criteria are:
a) CompanyDB - this is a required
field;
A specific AccountNum may be unavailable to budget because the Chart of Accounts synchronization and related processes need to be completed (Synchronize Chart of Accounts).
Standard functionality is available including Saving, Print, Exporting to Excel, Print to PDF, Auto-fit Columns, Column Data Sort - Ascending/Descending, Confirm Not Saved Popup, and Expand/Reduce Column Width.
The Save default is to refresh the screen on saving and this can be changed to skip the refresh by selecting from the above drop-down menu.
The format of the on screen data can be customized by using the Display Level, Row Format, Show Roll-up Sub-Totals and Expand/Collapse Rows functionality.
Please note that the Cell Math Functions and Copy and Paste functions are available for data entry. Cells that are white can be edited. Cells that are grey in color have a Row Lock.
Below is an example of a Define Custom Budget Entry forms that has been setup for Budget Entry in column 6.
Data Entry columns when setup defaults to "Month" and in the above example December was selected as the Fiscal Period. This mean that data entered on the Dashboard tab will default to the month of December on the Account Details tab. Data that is entered in other months will therefore not be reflected in the December data entry column on the Dashboard tab. It is recommended that an additional Year-to-Date column is setup to reflect the data entered for all months (see column 7).
And this is how the Custom Budget Entry screen looks like for the above definition:
Please note that there is a $500 difference between the December and 12 months columns for account number 000-4117-01.
The Account Details tab is
accessed by Drilling down into the required
AccountNum on the Dashboard tab. And in our example, you can see that
$500 was entered in January, and that the December total on the Account Details
tab equals the December column amount on the Dashboard tab, namely, $1,005,000.
Please note that if Columns have been setup with on-screen calculations (for example, VarianceValues) and when a new entry is made, please" Save" your work to refresh the calculation.
In addition to the above mentioned, Drill-Formatted Columns functionality, the below "Right-Click" menu is available:
The Accounts Details tab
This screen only displays the data related to a single AccountNum.
The screen has two sections. The top half is the Assumptions tab and the bottom half is the Budget Summary section.
A) Assumptions tab
The standard Saving, Edit Status and Account Approval, Attachments, Confirm not Saved Popup, Expand/Reduce Column Width and Print to PDF functionality is available.
Data can be copied to/from Excel using the Copy and Paste feature. Comments and Spread can be viewed on clicking on the below button outlined in red.
This is what the screen will look like when the above "View Comment" and "Show Spread" buttons are clicked.
Comments can be entered by typing in the 'Comments" box and then clicking "Submit". The "View comments" button will change color from white to light beige to indicated that a comment has been saved.
Data can be entered using the Show Spread Calculation-Expanded Spread Method, Simple Spread Methods, Row to Row Calculations, Cell Math Functions, Lookup, Copy and Paste, Apply Number Formatting and Exclude Row Function.
In addition data can be entered using the Import Budget Assumptions, Import Budget Assumptions Multi Company, and Copy Bulk Assumptions functionality.
When Lookup data is changed, the Refresh Lookup Syn Status functionality together with the Budget Summary-Lookup Sync Status can be used to view the change against the original Lookup data. Refresh Spread Method Source Values functionality is available.
B) Budget Summary section.
There are five tabs which provide the following information:
1) Acct History;
2) Monthly Variances;
3) Lookup Sync Status;
4) Main Acct History; and
5) View Save History
Please note that appropriate data from the above tabs can be Copy and Pasted. If example, information on a View Save History row could be copied to replace the newest version of the same data in Accounts Details.
Please see related article: How Do I Add/Delete BudgetIDs Displayed on the BudgetSummary?
Per below the view of the Budget Summary section: 1) Can be made larger/smaller by dragging the solid black line; and 2) Be hidden or revealed by clicking the double arrows.
The following
"Right-Click" menu is available: