Recording Loan Repayments in Strata Master
A Strata Plan or other type of Strata Corporation may take out a loan from a financial institution and need to make repayments. If you have a loan and need to process a repayment deducted from your trust account, this article may assist you to determine how the loan has been set up in your data.
For issues where you have a Balance on the Balance Sheet once the loan has been fully paid, please see below "Balances on Balance Sheet"
Important Notes - Must Read
Note that Strata Master Support is supporting and assisting with the software. We do not provide Accounting advice, so the suggestions here are simply a guide as to how you can record loan repayments in Strata Master, created in response to queries.
- You will need to consider your own individual requirements, which may not be fulfilled by the suggestions made here.
- We recommend you seek advice and set up assistance from a suitably qualified Accountant or BAS Agent.
- Support is not able to set the loans up for you, as how you set it up is your decision and is essentially an Accounting query.
- This article is not a step by step and assumes a knowledge of both Strata Master and basic bookkeeping processes and navigation of Strata Master.
Components of a Loan
- The initial loan funds deposited to the trust account. This requires a loan liability account in Chart of Accounts.
- The deduction of an instalment from the trust account. This requires a loan liability account in Chart of Accounts.
- The application of interest accrued to the loan. This requires an interest expense account in Chart of Accounts.
The Chart of Accounts
Go to Formatted Reports > Chart of Accounts. Check to see whether there are existing loan liability and loan interest expense accounts that can be used.
If not, go to Configure > Chart of Accounts and add suitable accounts. Keep the Naming convention as generic as possible to allow it to be useable for other Plans. For example, Loan - Roof New/Repair - Capital Works is more useful than Loan PX6047893896 - Capital Works, as the Latter cannot be used by any other Plan.
You need to check your Chart of Accounts in Formatted Reports to find a suitable account number that is free/not in use.
Here is an example of an account being created -
The Initial Funds
Receipted to the Liability Loan Account for the purpose. The funds are technically not Revenue or Income and if applied as such, will inflate the income figure and affect taxation if the Plan pays income tax. You can do so if you wish, however the steps in this article would not apply. As mentioned above, seek a recommendation from your Accountant to suit your circumstances.
The Repayment Deduction from the Trust Account
Journal debit the liability account (to reduce the loan liability as a premium has been made) and credit cash at bank (to reduce cash at the bank)
The Interest Applied to the Loan Account
For this you would be required to check the loan statement.
Journal debit the expense account for Loan Interest (to record the interest expense on the I&E report) and credit liability account (to increase the loan amount owing on the Balance Sheet)
Cannot be entered in the Bank Reconciliation screen as this transaction does not involve cash at bank.
Reports
Balance Sheet at end of January shows the loan funds received
Balance Sheet at end of February shows reduction of loan balance as $315 was deducted and interest of $121.11 was added
I&E report for just the month of February shows the interest expense of $121.11 for that month
Variations
As mentioned above, and we reiterate, we have provided a common method of recording and reporting loans in the above steps, however the method you choose is entirely your decision, and that suits your needs.
If you wish, you can use sub accounts, and show the repayments figure, in addition to the loan amount, with a nett figure.
Bear in mind that variations that are widely different to the above can make it difficult for Support to assist you with queries, if you have errors. Your query may be referred to a Consultant as chargeable support.
Balances on Balance Sheet
The Balance of the loan in Strata Master should be checked regularly to the Bank Loan Statement and ensure it matches.
If you use the above method, there should not be a figure for this loan on the Balance Sheet once the loan is fully paid. If you have a balance on the Balance Sheet, then -
- Repayments have not been entered and the Balance of the loan account not balanced with the Bank Statement from time to time
- Interest amounts entered have been duplicated or overstated and once again, the Balance of the loan account not balanced with the Bank Statement from time to time
- Another method of recording the loan has been used. Please note that it is not Strata Master Supports role to check for accounting/entry errors, however if you find an error, we can assist you to fix it ensuring you use approved methods for the platform.
- If another method has been used, check the Accounting > Adjustments > Search/edit transactions to see how previous instalment entries have been made. Note the debit account used in instalment payments. That is the account where the repayments are recorded, and if different to the Loan liability account, we suggest you discuss with your accountant to clear the balances.
Useful Links
https://kb.rockend.com/help/search-for-a-transaction