Child pages
  • Loans and repayments

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

HTML Wrap
classsection group
HTML Wrap
classcol span_3_of_5

ANSWER ID:11136

ImageImage Removed

This support note explains how You can use AccountRight to record the receipt of money derived from a loan and also how to record the loan repayments.

Here's what's involved:

1. Create a liability account for the loan.

2. Record a Receive Money transaction for the loan amount.

3. Record Spend Money transactions for the loan repayments.

Task 1 -

Because there's lots of loan types, interest rates, terms and conditions, you might need help from your accounting advisor (or the MYOB Community) to determine the best way to set this up for your loan.

To accurately track your loan balance, you'll need to know:

  • the initial loan amount
  • the value of your repayments, and
  • the repayment breakdown (how much of the repayment reduces the principal, and how much relates to interest charges).

Let's step you through setting up a basic loan:

 

UI Expand
title1. Create a liability account for the loan
This task involves setting up a

You need a liability account

which will

to represent the loan

, in other words when

. When the loan

money

is received you'll allocate it

can be allocated

to this account.

  1. Go to the Accounts command centre and click Accounts List.
  2. Click the Liability tab then click New.
The Edit Accounts window is displayed.
  • Choose Other Liability in the Account Type field as highlighted below (not applicable for BusinessBasics).
  • Give the account a number which suits your accounts list and enter an Account Name of your choice. ImageImage Removed
  • Click OK.
  • Task 2 - Record a Receive Money transaction for the loan amount

    This task involves recording a Receive Money transaction to deposit the loan into the liability account created in the previous task.
    1. For the Account Type, choose Other Liability.
    2. Specify an Account Number that suits your account list.
    3. Enter a suitable Account Name. Here's our example:
      Image Added
    4. Click OK.
    UI Expand
    title2. Record the receipt of the loan

    When you receive the loan, use a Receive Money transaction to enter it into AccountRight. Here's how:

    1. Go to the Banking command centre and click Receive Money.
    In BusinessBasics go to the Command Centres menu and choose Banking then choose Receive Money. The Receive Money window is displayed.
    1. In the Deposit to field, select the bank account
    where the loaned funds will be held (see image below).Enter the Date and the Amount Received (the loan value)
    1. that the loan money was deposited into.
    2. In the Amount Received field, enter the loan amount.
    3. In the Acct
    #
    1. No. column, select the liability account created in the previous task.
    2. In

    [Australia only]

    1. the Tax
    column

    [New Zealand only]

    the
    1. /GST column, specify the N-T (No Tax/Not Reportable) tax/GST code
    (see image below).

    [Australia only]

    ImageImage Removed

    [New Zealand only]

    ImageImage Removed
    1. . Here's our example:
      Image Added 
    2. Click Record.
    Task 3 - Record Spend Money transactions for
    UI Expand
    title3. Record the loan repayments
    This task represents the

    Loan repayments can be recorded using Spend Money transactions

    which will need to be recorded each time a loan repayment is made

    . Our example below is for a fixed repayment with the interest portion allocated to an expense account. This allows the loan interest to be tracked separately. For your loan, you might need to seek clarification from your accounting advisor about the best way to enter the repayments.

    1. Go to the Banking command centre and click Spend Money.
    In BusinessBasics go to the Command Centres menu and choose Banking then choose Spend Money. The Spend Money window is displayed.
    1. In the Pay from Account field, select the account you
    want to make the payment
    1. 're making the repayment from.
    Enter the Date and the Amount of the payment
    1. In the Amount field, enter the total value of the repayment.
    2. In the Acct
    #
    1. No. column, select the liability account created
    in Task 1
    1. earlier.
    2. In

    [Australia only]

    1. the Tax
    column

    [New Zealand only]

    the
    1. /GST column, specify the N-T (No Tax/Not Reportable) tax/GST code.
    [Australia only]ImageImage Removed

    [New Zealand only]

    ImageImage Removed Click Record.
    1. Specify bank interest/charges on a separate line and use the applicable tax/GST code for your needs. Here's our example:
      Image Added
    2. Click Record.

    As you record loan repayments,

    you will see

    the balance of the liability account

    reduce reflecting

    will be reduced to reflect a reduction in that liability.

    Tip:
    UI Text Box
    typetip

    If your loan repayments are

    on a

    fixed

    schedule

    , save this

    spend money

    Spend Money transaction as a recurring transaction.

     

    Referring to the example Spend Money transaction above:

    • The fixed amount of the repayments in this example is $550.00, comprised of $500 allocated to the bank loan liability account (to repay the loan) and $50.00 allocated to the Bank Charges expense account (for interest accrued on the loan).
    • It is possible to reflect the Bank Interest and Charges in the liability account by means of the initial receive money transactions.

      [Australia only]

      Our support notes Hire purchase setup - GST cash basis and Hire purchase setup - GST accrual basis contain information on this.

    See the AccountRight help for more info (Australia | New Zealand).

    HTML Wrap
    width15%
    classcol span_1_of_5
     
    HTML Wrap
    floatleft
    classcol span_1_of_5
    Panelbox
    namegreen
    titleRelated topics
    HTML Wrap
    classsidebarlinks

    Recurring transactions (Australia)

    Recurring transactions (New Zealand)