# Depreciation - Opening balances for Manager

**URL:** <https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739>\
**Category:** Uncategorized\
**Created:** [February 6, 2020, 3:39am UTC](https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739 "2020-02-06T03:39:25Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grandpa](https://avatars.discourse-cdn.com/v4/letter/g/cc9497/32.png) [@Grandpa](https://forum.manager.io/u/Grandpa)\
**Post date:** [February 6, 2020, 3:39am UTC](https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739/1 "2020-02-06T03:39:25Z")

</div>

Is this correct.  
The closing balance in the Asset Summary is correct, however the book value in the Depreciation Worksheet has the aquisition cost ( $42607.70) value not the book value ($25401.20), although the header indicates Book Value. The book value should be $25401.20 in the worksheet, I would have thought.

I have attached pics of 3 screens which may be of help.

I guess the solution is obvious, but not to me, maybe Ive confused myself with all the searching Ive been doing.

 ![Depreciation Entries](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/b/3/b3b39cbe066ff0e044856018460de7f40b9112bc.jpeg)

 ![Depreciation worksheet](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/a/c/ac257ee951b79687f9e1477af0aac500b281d4d5.jpeg)

 ![Fixed Assets](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/7/7/77ad87cdd811bddb92392a18c019aed996fe8fce.jpeg)

 ![Fixed Asset Summary](https://us1.discourse-cdn.com/flex019/uploads/manager1/original/3X/9/8/98afcb41b638c85abfac629701762d300b2139d4.jpeg)

Any helpful comments would be appreciated.

Many thanks  
Grandpa

What I have found is that if I change the date on the depreciation worksheet to 2/4/19 the correct book value balance is shown ($25401.20)

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [February 6, 2020, 1:06pm UTC](https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739/2 "2020-02-06T13:06:17Z")

</div>

Your narrative and screen shots are a little confusing. So, here are both comments and questions:

- Your worksheet is for the period from 1/4/2019 to 6/2/2020. But your depreciation entries are dated 1/4/2019. In other words, you made entries on the first day of the period rather than the last. The depreciation calculated by the worksheet has not occurred as of the first day, so why did you enter the depreciation on that date?
- Your depreciation entries were entered manually rather than using the New Depreciation Entry button on the worksheet. So why did you use the worksheet at all?
- Book value shown on the worksheet is the book value of the asset on the first day of the calculation period.
- Automatic depreciation entries are not entered until the final date of the worksheet period arrives.
- In what order did you do things? It looks like you (1) made manual depreciation entries on 1/4/2019, (2) calculated a worksheet that ends on 6/2/2020 (which has not arrived), then (3) created a Fixed Asset Summary with an end date even further in the future.

In short, I suspect your trouble comes from mixing manual and automatic depreciation entries with future dates on the automatic entries.

---

<div class="post-metadata">

**Author:** ![Grandpa](https://avatars.discourse-cdn.com/v4/letter/g/cc9497/32.png) [@Grandpa](https://forum.manager.io/u/Grandpa)\
**Post date:** [February 7, 2020, 6:50am UTC](https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739/3 "2020-02-07T06:50:04Z")

</div>

Hi Tut

Again many thanks for your help.  
I guess its a problem Im facing while trying to incorporate one accounting system into another. And unsure how depn was shown in the old one. I suspect it looks like depn in the old system is showing until 31/3/20 (if that makes sense.) So i’ll see what happens 31/3/20 at the end of the current financial year.  
Again many thanks

Grandpa

---

<div class="post-metadata">

**Author:** ![Tut](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/tut/32/3286_2.png) [@Tut](https://forum.manager.io/u/Tut)\
**Post date:** [February 7, 2020, 2:28pm UTC](https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739/4 "2020-02-07T14:28:04Z")

</div>

When migrating to Manager, the balance of the _Accumulated depreciation_ (or whatever it was called) at the end date of the old system should be entered as the starting balance for _Fixed assets - accumulated depreciation_ for that asset in Manager. No depreciation entries should be entered, as those would have been made in the old system. Follow the Guide: [Enter starting balances | Manager](https://www.manager.io/guides/15718). There is an explicit example on entering accumulated depreciation.

---

<div class="post-metadata">

**Author:** ![Grandpa](https://avatars.discourse-cdn.com/v4/letter/g/cc9497/32.png) [@Grandpa](https://forum.manager.io/u/Grandpa)\
**Post date:** [February 8, 2020, 6:14am UTC](https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739/5 "2020-02-08T06:14:12Z")

</div>

Hi Tut

Again soooo many thanks for your help. I have followed prety much word for word, and now convinced I have it right.

Once again many thanks.

Cheers Grandpa

---

<div class="post-metadata">

**Author:** ![Ealfardan](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/ealfardan/32/63166_2.png) [@Ealfardan](https://forum.manager.io/u/Ealfardan)\
**Post date:** [January 18, 2023, 2:56pm UTC](https://forum.manager.io/t/depreciation-opening-balances-for-manager/26739/6 "2023-01-18T14:56:47Z")

</div>

Closed on January 18, 2023, 2:56pm UTC


