Skip to main content

Legal

Tax & Accounting

Trade & Supply

Risk & Fraud

News & Media

Books

Developers

Trial Balance screen

Set up budgets

Enter budget amounts in the
Actions
 >
Enter Trial Balance
 screen for a trial balance where the budget columns have been created. The Trial Balance grid enables you to add columns for each budget type and can be customized to display a selected period or the total year budget. Follow these steps to add budget columns in the trial balance.
  1. Select
    Actions
     >
    Enter Trial Balance
     and select the
    View Maintenance
     link.
  2. Select the
    Add
     button to customize the settings for the selected
    Trial Balance view
    .
  3. Select the last blank row in the
    Column Order
     grid to add a new row, and then select Amount from the field in the
    Column Type
     section.
  4. Select the budget type from the dropdown list in the
    Amount type
     field.
  5. Select the period and year from the available fields and select
    Enter
     and then
    Done
     to create the column in the selected trial balance.
If you enter an amount in the [CY] Current YTD column, the application spreads the amount equally among all periods and creates a budget amount in each period. If the amount can't be divided evenly between all periods, the application adds the remaining amount to the 1st period's budget amount.
If the budget amount is $50 and is to be divided over 12 months, the application calculates the monthly amount as 4.166666. However, if you enter $4.16 for each month, the total amount is short by 8 cents. To correct this, Accounting CS adds the 8 cents to the first-month amount, resulting in $4.24 in the C1 column and $4.16 in the remaining columns.
If you want the extra amount to be included in a different month (for example, in the 7th month), set up the Enter Trial Balance screen to display the C1 and C7 columns, and then manually override the amounts in those columns. (Enter $4.16 in column C1 and $4.24 in column C7.)

This article applies to:

  • Product: Accounting CS, Workpapers CS
  • Subject: Chart of Accounts, Journal entries