The Depreciation schedule has simplified the process of processing journal entries and preparing a schedule for your depreciable assets.
It is recommended to have a unit recorded against the purchase transaction to utilise the schedule. However, non-unitised investments are also supported in the schedule.
To include an asset in the schedule please follow the steps outlined below:
| On the Main Toolbar, select the Investments Icon. |
|
| Navigate to Property Dashboard |
|
| Select Tools. |
|
| Select Depreciation |
|
Tip Click |
The program allows you to post depreciation for an existing asset individually or register assets for depreciation in Worksheet under a property account from the Depreciation Screen without creating an asset account in the chart of accounts.
1 Select
2. Search for the asset by either the Account Code or Name.
3. Purchase Date/Opening Cost will be automatically calculated and will include any cost base adjustments if applicable. This field is editable and open for on-screen adjustments.
4. Business Use Percentage - This field will only be applicable for Trusts, Companies or Individual entities. This is not a compulsory field.
5. Accumulated Depreciation - This field will only display when setting up a fund. By default, the software will calculate total balance posted to the investments linked depreciation account. This field is editable and open for on-screen adjustments.
Info
The Assets Contract Date must be before the System Start date for the Accumulated Depreciation field to display.
6. Select a Depreciation Method. The schedule supports:
- Diminishing Value Method
- Prime Cost
- Low-Value Pool
- Capital Works Deduction
7. Input a Depreciation Rate.
8. The software will automatically calculate the Opening Written Down Value.
The Closing Written Down Value will update once depreciation has been posted in the current period.
9. Select Save.
When calculated depreciation for an asset purchased during the current financial year, the program will use the Purchase Date for the calculation which is located in the Depreciation Schedule.
1. Select
2. Select a Property.
Properties created under 77200, 77250, 77300, and 77350 accounts can be selected from the drop-down list.
3. Enter an asset, inputting the details where relevant. Select to allow an asset to be added to the asset register.
4. Alternatively select Import CSV to upload a CSV file to import relevant transactions, without entering the fields on the screen.
Note: a CSV Template can be downloaded by selecting Download CSV Template from the drop-down arrow.
5. Assets added will be listed in the Asset Registry, where the system will calculate the Residual Cost automatically.
6. Select to finalise posting depreciation. The journal would be posted to the property account, instead of the particular assets added to the Registry from the screen.
1. Select the checkbox next to the Asset(s).
2. From the Depreciation Menu click Post Depreciation.
3. Input the Depreciation Date and select Post.
IMPORTANT: By changing the Depreciation Date, the depreciation amount will be Pro-Rated based on the date.
Note
1. To preview the transactions, navigate to the Transaction List and Select the Depreciation Filter.
Using the Property Worksheet, the depreciation would be posted to the property account, instead of the depreciable assets.
2. The investment reports will not show a breakdown of each individual asset within the worksheet, but only show the main property for which an account exists. Though the depreciable assets would be listed under the property in the Depreciation Schedule.
The Depreciation Schedule is divided into two sections Incomplete and Reviewed. Assets will remain in the Incomplete section even if depreciation has been posted.
- To update the status of the asset(s) from Incomplete to Reviewed, from the depreciation Schedule screen SF360 users will need to select the asset(s) and click on Mark as Reviewed Once this has been actioned, the program will automatically update the security price as of the 30/06/20XX for any unitised asset(s) to equal the closing written-down value.
- To ensure that the asset rollovers into the next financial year, the asset must be marked as Reviewed when closing the financial year.
- Note - Depreciation needs to be posted before you can move the asset to Reviewed.
From the depreciation screen, you can now post an instant asset Write Off. Follow the steps below to process an instant asset Write Off.
1. Add the asset to the Depreciation Schedule.
2. From the Action Column select the 3rd Icon.
3. Input a date.
4. Select Write Off.
5. The following popup message will display. If you wish to immediately dispose of the asset, click Yes:
Info
To preview the transactions, navigate to the Transaction List and Select the Depreciation Filter.
1. How do I generate the Depreciation Schedule?
To generate a schedule, select the Depreciation Schedule button.
2. How to remove an asset from the Depreciation Schedule
To remove an asset from the depreciation Schedule, from the actions column select the trash icon.
3. Error when posting depreciation. "Cannot find the depreciation account for Asset"
When trying to add a depreciation asset I receive an error that I cannot find the depreciation account. To Resolve this error please follow the steps below to create a linked depreciation account for the investment.
- Navigate to the Chart of Accounts.
- Edit on the Asset Account
- Select to display More Details
- Click Add Link Account.
- Select Expense
- Select the Account Code as 34400 - Depreciation
- Select Save
4. I have edited the opening balance, will the software post any adjustments to the ledger?
The software provides you with the flexibility to adjust the Accumulated Depreciation and Opening Written Down Value. When making any adjustments from the depreciation schedule no transactions will be posted to the fund ledger.
5. Why didn't the Depreciation Schedule carry over from the previous Financial Year?
The Depreciation Schedule will not roll over to the next year unless the Asset or Worksheet has been marked as 'Reviewed' from the Depreciation screen. Please ensure the depreciation must be posted in order to mark the Asset as Reviewed.
Depreciation Pools
360 simplifies managing your depreciation compliance by giving you the ability to post multiple similar depreciation journals simultaneously through the use of Depreciation Pools.
Low Value Pool
To add an asset to a low value pool:
- Click Low Value Pool
- Search for the asset by typing into the Asset Search field
- Change the Pool Date to reflect the date that the asset will be allocated to the pool.
The program will automatically determine the depreciation rate to use by looking at the Pool Date. If the Pool Date is prior to the current financial year, the full depreciation rate will be used, otherwise if the Pool Date is within the current year, the half rate will be used.
In subsequent financial years, the full rate will be used when depreciating assets in the low value pool. - If required, edit the Opening Cost, Opening Written Down Value, or Closing Written Down Value.
- Click Add to Pool.
Once the pool is added, it will be visible in the Depreciation Schedule. The rate used to depreciate the low value pool in the current financial year is displayed within the low value pool name.
Custom Pool
Post depreciation entries for multiple assets that use the same depreciation method and rate by placing them in a custom pool.
To create a new custom pool:
- Click Custom Pool
- Type a name for the custom pool under Pool Name.
- Select the Deprecation Method that will be used to depreciate all assets in the pool.
Available methods are Prime Cost Method or Diminishing Value Method. - Enter the Depreciation Rate that will be used to depreciate all assets in the pool.
- Enter the Purchase Date for the asset.
The purchase date will be used to pro rata depreciation amounts for the first year of asset ownership. - Enter the Opening Cost of the asset being added to the pool.
- If required, edit the Opening Written Down Value or Closing Written Down Value.
- Click Add to Pool.
To view the assets belonging to a given pool, select the + icon in the pool to reveal all assets in that pool.
Edit pool
To edit an existing pool, select the Edit Pool icon next to the pool:
Delete pool
To delete an existing pool, select the Delete Pool icon next to the pool:
Adding all assets to pool
To add all assets currently in the depreciation schedule to any type of pool, please complete the following steps:
- Create an empty custom pool
- Remove all assets from the depreciation schedule
- Add the assets to the required pool. This can be either the pool created in step 2, or a completely different pool
If the empty custom pool is not needed, please feel free to remove it.
Depreciation Schedule Report
Note that you can also generate the Depreciation Schedule Report using the Reports screen:
By selecting settings you can toggle the option to sort assets by their purchase date:
Additional References
.