I have read the guide and followed the forum threads on Start Dates bu the Guides are confusing on this matter.
I am transferring the accounting system from another. I have the FY2022 closing balances ( as at 30Jun2022) and therefore the FY2023 Opening Balances.
From what I read the depreciation calculations start from the date of entry of the asset and as today is 4May2023 it will only calculated depreciation for 57 days. How do I tell the system that I am entering FY Opening Balances?
You should have first searched the forum before posting a topic, see FAQ - Manager Forum more specifically:
Search before you post. Chances are good you are not the first person with a similar question. If you cannot find what you need in the Guides, thousands of topics with tens of thousands of postings make it likely the answer to your question is already here on the Forum. Before starting a new topic, tap into our huge, crowdsourced knowledge base.
The depreciation calculation worksheet calculated depreciation for the period you enter in that worksheet. Note the worksheet is Mangers starting point to support depreciation calculations. You may find in practice you need some external calculations also.
Are you saying that Fixed Asset entries from last years C.W.D.V. just exist as entries without any relationship to any point in time?
If so, does that mean that running the depreciation calculation worksheet assumes that the Fixed Asset balances entered are used to calculate the depreciation from that date; whether or not that start date is the start of the financial year?
Does the worksheet then post the depreciation to the Fixed Assets and Depreciation Expense accounts?
I think it would be clearer to add the acquisition cost and the accumulated depreciation when creating the fixed asset rather than just the closing written down value (7,500 in my example below)
In any case the depreciation calculation in Manager will be based on 7,500 and whatever % you enter
Any fixed asset acquired since the start of the year is added with 0 acquisition cost. The acquisition cost is then recorded using a Purchase Invoice, Cash Payment or Expense Claim depending on how it was paid for
Thanks Patch. I agree with the test and experiment idea but in this case there seem to be too many issue to make sense of the.
I created a Custom Date field and assigned it to Fixed Assets with position 3.
The Fixed Asset entry form shows this Custom Date Field at the bottom of the form at what would be Tab Sequence 10. Changing the Position in the Custom Date Field definition does not change anything on the Fixed Asset Entry form. I can live with that, it’s just annoying to cause such a waste of time fault finding.
Contrary to the Guide The Custom Date Field does not show on the Fixed Asset Report. I have ticked the box to show on report as column. Have I missed something?
The Fixed Asset Entry form has entries for Acquisition Cost and Accumulated Depreciation. However, on the Fixed Assets at Valuation report it shows the Acquisition Cost as the Opening Balance instead of in the Acquisition Cost column… This is plainly incorrect. The Accumulated Depreciation in the Opening Balance column would be correct.
Create a simple test for each issue on it’s own to see how Manager behaves with just one issue at a time. That way you can work out a solution for one issue at a time.
Doing so may result in a roadblock somewhere but at least you will know exactly what Manager does so be able to discuss sensibly possible a work around to a specific issue.
The depreciation work sheet only calculates depreciation using the declining balance method. So calculated the set percentage of book value at the start of the period. I have found Managers calculated result for part of a year is reasonable. The calculation for multiple years requires an exponential decay function which is not implemented in Managers worksheet, so I don’t trust the worksheet for that use case.