Skip to main content
Loan Wizard

Quickly incorporate loans into your budgets

Mick Devine avatar
Written by Mick Devine
Updated over 3 months ago

The Calxa Loan Wizard allows you to quickly and easily incorporate loans into your budgets. The wizard will do all of the complex calculations for you and will automatically update your budgets with principal and interest payments for the life of the loan.

Tip πŸ’‘to generate budgets as the lender, rather than the borrower, use negative figures and Calxa will do the rest.

  1. Browse to Budgets & Cashflow -> Budget Tools -> Loan Wizard.
    ​

  2. Select your organisation from the Selected Organisation drop down and click GET STARTED.​
    ​

    Loan Wizard Menu

  3. Set the destination budget or scenario as required and Business Unit properties.
    ​ ​

  4. Set the loan and interest accounts.
    ​
    ​Tip πŸ’‘Use Sub-Accounts to track multiple loans on separate lines in your Budget.
    ​ ​

  5. Choose Add to existing or Replace existing budgets then click NEXT STEP.
    ​

    ​

    Loan Wizard budget settings

  6. Set the Loan properties and click REFRESH PREVIEW.
    ​
    The interest or repayment option allows you to calculate the budgets given either the annual interest rate or the monthly payment amount.
    ​

    Loan Properties

  7. Review the displayed loan schedule, repeat step 6 if changes are required then click NEXT STEP.
    ​
    To export or print a report of the loan schedule click Print.
    ​

    Loan schedule
  8. Review the summary properties and click SAVE BUDGET.
    ​
    Note the destination years provides details about which destination years already contain budget data that will be updated or replaced.
    ​​

    Budget summary
Did this answer your question?