Add Accounts to various sections of budget

Add Accounts to various sections of budget

Add Accounts to Various Sections of Budget


The setup of the Cashbook Platinum system is very important before starting budgets.  Check the following items in the main program before entering the Budget Module:
  1. Make sure Chart of Accounts has been correctly setup with all required income, expense, asset & liability accounts
  2. Ensure that any required non-cash accounts such as depreciation expense are setup in the chart with the "non-cashbook" account checkbox ticked
  3. Check that the "Balance Sheet Link" has been set for any relevant Other Income or Other Expense type accounts e.g. purchase & sale or assets
-  Other Income/Expense accounts not linked to a balance sheet account will appear in Cashflow and Profit & Loss figures.
-  Accounts that are linked will appear in Cashflow and Net Worth but not Profit & Loss
Make sure that all required enterprises have been set up with all necessary information and required options selected

Step 1: Budgets

Click the Budgets toolbar icon



When creating a budget it is possible to automatically add all accounts and banks to their relevant sections. These sections basically follow the structure of the Chart of Accounts:
  • Enterprises

  • Farm Income/Overheads - includes sundry farm income and overhead expenses that are not part of any enterprise

  • Capital - includes capital receipts and payments such as loans received & paid, plant sales & purchases etc

  • Proprietor Funds - includes receipts and payments relating to proprietorship such as advances from personal funds, owners drawings and personal superannuation contributions

  • Off Farm Income/Expenses - includes income and expenses relating to off-farm investments and non-farming activities

  • GST - consists of 3 calculated lines in a month/year grid as follows:
    • GST Paid - amounts applicable to all expenditure amounts in budget. These are calculated using the relevant GST category for each account as per the Chart of Accounts setting. Where the budget is prepared GST Inclusive, this line will be blank as the GST amounts will be embedded in the expenditure amounts
    • GST Received - amounts applicable to all income amounts in budget. These are calculated using the relevant GST category for each account as per the Chart of Accounts setting. Where the budget is prepared GST Inclusive, this line will be blank as the GST amounts will be embedded in the expenditure amounts
    • GST Net BAS - this is a balancing account and represents the net BAS amount payable/receivable for the month or quarter, depending on BAS frequency set in the GST setup area.
    • The GST amounts will automatically update as figures are changed in the budget
  • Bank Accounts - used to setup the relevant details relating to banking accounts

  • Net Worth - used to budget asset & liabilities to give a monthly budgeted net worth position over the budget period. It is laid out in three parts; Assets, Banks (which may be in credit or overdrawn) and Liabilities

Step 2: Account Groups 

This function allows the user to define the range of accounts that will be available for use with the Add Accounts buttons in various sections of the budget. This is used to keep the list to a manageable level and to ensure that only accounts from the appropriate section of the chart are used. (See Below)

To Check Account Groups are Setup:
  • Click on the Setup
  • Account Groups menu option


 
  • Each Account Group i.e. Variable Costs, Farm Income, Farm Expenses, Capital, Proprietors Funds, Off Farm Inc/Exp and Net Worth should have certain associated reporting groups selected.
For example
  • Click on the account group e.g. Variable Costs on the left side of the screen
  • Highlight the associated reporting groups on the right side of the screen. e.g. 2-200, 2-220,2-240, 2-280. See below
  • Selecting associated groups: Note: Selection will be highlighted blue
    • To select a block of associated groups i.e. in a contiguous group, hold down the Shift key then click on the first group to add then click on the last group. All associated groups in between will also be selected
    • Individual groups may be selected or deselected by holding down the Ctrl key and clicking on the group
    • If only wanting to select one group, then just click on that group
  • Click OK

 
  • Make sure to select associated reporting groups for each Account Group. For example:

Step 3: To Add Accounts to the Various Section of the Budget

  • An account can be added to or deleted from the following sections of the budget tree:
    • <Direct Costs> section of each enterprise. Note: A Direct Cost is an expense that can be traced directly to or identified with a specific enterprise
    • <Farm Inc/O'heads>
      • <Farm Income> This includes sundry farm income that is not part of any enterprise
      • <Overheads>  Operating expenditure which cannot be conveniently traced to or identified with any particular enterprise
    • <Capital> This includes capital receipts and payments such as loans received and paid, plant sales and purchases, etc.
    • <Proprietor Funds> This includes receipts and payments relating to proprietorship such as advances from personal funds, owners drawings and personal superannuation contributions
    • <Off Farm Inc/Exp> This includes off-farm investments and non-farming activities
    • <Bank Accounts> 
    • <Net Worth>  This section is used to budget assets & liabilities to give a monthly budgeted net worth position over the budget period

  • See how these sections are depicted in the budget below:


  • Open to the section of the budget to which you are wanting to add accounts e.g. <Direct Costs> of enterprise Cattle Trading
    • Click the + button beside the budget name e.g. Budget 2009-10. Note: + button becomes a - after you click on it
    • Click the + button beside <Enterprises>
    • Click the + button beside the specific enterprise, e.g. Cattle Trading
    • Click <Direct Costs>
    • Click the Add Account button

  • Select an account/s to add: Note: Selection will be highlighted blue
    • To select a block of accounts i.e. in a contiguous group, hold down the Shift key then click on the first account to add then click on the last account. All accounts in between will also be selected
    • Individual accounts may be selected or deselected by holding down the Ctrl key and clicking on the account
    • If only wanting to select one account, then just click on that account
  • Click OK
 
  • All accounts selected above will be added to the Direct Costs that are specific to the Cattle Breeding enterprise

 
To delete an account, click on the Delete Account button, click on the account/s that need deleting, so they are highlighted blue, then click OK
 

Article ID CBP892