Setting up an Advanced Budget

Setting up an Advanced Budget

Setting up an Advanced Budget

Cashbook Platinum

The budgeting process in Cashbook Platinum is based on the completion of various sections that build on each other to produce a complete budget for a farming enterprise

These sections are:
  • Enterprises - an enterprise is a component of a farm business. For example, a farm may include a cattle enterprise and a sheep enterprise. This section is used to set up trading and gross margin details for required enterprises
    • Crop Enterprises with Trading Account - Trading details including production, sales & stock on hand and Direct Costs
    • Livestock Enterprises with Trading Account - Trading details including natural increase, purchases, sales, losses & stock on hand and Direct Costs
    • Other Enterprise with no trading account eg. where there is no breeding or stock on hand activity. Income & Direct Costs
  • Farm Income and Overheads - sundry farm income and expenses that are not part of any enterprise
  • Capital - capital receipts & expenditure such as loans received and paid, plant sales and purchases, etc
  • Proprietor Funds - receipts and payments relating to proprietorship such as advances from personal funds, owners drawing and personal superannuation contributions
  • Off Farm Income and Expenses - income and expenses relating to off-farm investments and non-farming activities
  • GST
    • GST Paid amounts applicable to all expenditure amounts in the budget
    • GST Received amounts applicable to all income amounts in the budget
    • Note: Where budget is prepared 'GST Inclusive', GST Paid and Received will be blank, as the GST amounts will be embedded in the expenditure and income amounts
    • Note: All amounts in this section are calculated automatically by the systems base on amounts entered in a particular month against expense/payment type account in other sections of the budget
    • GST Net BAS - this is the 'balancing' account and represents the net BAS amount payable/receivable for the month or quarter, depends on BAS frequency set in the GST setup area
    • Note: this line is calculated automatically by taking the GST Paid from the GST Received for the relevant BAS period
  • Bank Accounts - used to setup the relevant details relating to bank accounts. This includes provision for automatic calculation of debit and credit interest on an operating account
  • Net Worth - shows the monthly budgeted net worth position over the budget period. It is laid out in 3 parts: Assets, Banks/Funding Lines and Liabilities

Before Starting

  1. Make sure that the Chart of Accounts has been correctly set up with all required income, expense, asset & liability accounts
  2. Ensure that any required non-cash accounts, such as depreciation expense are set up 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 and Other Expense type accounts eg. purchase & sale of assets
    Note that other Income/Expense accounts that are not linked to a balance sheet account, will appear in cashflow and profit and loss figures. Accounts that are linked will appear in cashflow and net worth but not Profit and Loss
  4. Check that all required enterprises have been set up with all necessary information and required options selected
  5. Add all required products/items to the register, under the Registers > Product & Items menu Option and check pricing information

Setting up a Budget in Cashbook Platinum

Step 1: Budgets

  • Click Budgets icon on the main toolbar

ii. Click File
iii. New menu option
 
iv. Enter a name for the new budget
v. Select to either use enterprises (All or selected) or a Non-enterprise Budget
vi. Click OK

 The following confirmation message will appear:

Step 2: Bank Accounts

  • Click Yes if wanting to automatically add all accounts and banks to their relevant sections
  • Click No if wanting to select accounts and banks for each relevant section
  • The user will be prompted to enter opening values for enterprises in this new budget.
    Note that the default values will be taken from the enterprise setup area and can be changed or revised later as required
  • Click OK

 Automatic setup in complete

Step 3: Date Range

The date range for the budget setup will always default to the next financial year

If the dates of the budget need changing:
  1. Click on the budget name
  2. Click on the up or down arrow to change budget to the dates required. eg 07/2015 to 06/2016
  3. Click Apply

iv. Click Yes to confirmation message 'Making the budget start earlier can cause issues with opening balances. Are you sure you want to proceed?'
If this message doesn't apply to you, you may need to change the opening balances
v. Click Yes to confirmation message 'WARNING: Changing the date range requires saving the budget and reloading it. Any data outside the new date range will be lost. Proceed?'
vi. Click OK to warning message 
  • Wherever there is budget sections that contain Income and Expenses, all income and expense accounts may have been automatically added, depending on the selection at the time. Therefore,  it may be required to go through and delete all accounts not related to that section, see Step 4

Example: <Farm Inc/O'heads> <Income>

Step 4: Delete Account 

  • Click Delete Account
  • Click on all accounts that do not belong in this income account e.g. Farm income accounts are sundry farm income that are not related to an enterprise
  • Hold down the Ctrl key and click on each account that needs deleting
  • Click OK

Repeat this in each section where this occurs


Article ID CBP1203