- Created by admin, last modified by AdrianC on May 03, 2016
You can use AccountEdge to record the receipt of a loan and to record the repayments. Because there's lots of loan types, interest rates, terms and conditions, you might need help from your accounting advisor 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:
You need a liability account to represent the loan. When the loan is received you'll allocate it to this account.
- Go to the Accounts command centre and click Accounts List.
- Click the Liabilities tab then click New.
- For the Account Type, choose Other Liability.
- Specify an Account Number that suits your account list.
- Enter a suitable Account Name. Here's our example:
- Click OK.
When you receive the loan, use a Receive Money transaction to enter it into AccountEdge. Here's how:
- Go to the Banking command centre and click Receive Money.
- In the Deposit to field, select the bank account that the loan money was deposited into.
- In the Amount Received field, enter the loan amount.
- In the Acct No. column, select the liability account created in the previous task.
- In the Tax/GST column, specify the N-T (No Tax/Not Reportable) tax/GST code. Here's our example:
- Click Record.
Loan repayments can be recorded using Spend Money transactions. 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.
- Go to the Banking command centre and click Spend Money.
- In the Pay from Account field, select the account you're making the repayment from.
- In the Amount field, enter the total value of the repayment.
- In the Acct No. column, select the liability account created earlier.
- In the Tax/GST column, specify the N-T (No Tax/Not Reportable) tax/GST code.
- Specify bank interest/charges on a separate line and use the applicable tax/GST code for your needs. Here's our example:
- Click Record.
As you record loan repayments, the balance of the liability account will be reduced to reflect a reduction in that liability.
If your loan repayments are fixed, save this Spend Money transaction as a recurring transaction. See the AccountEdge help for more info (Australia | New Zealand).