# Opening Balance

**URL:** <https://forum.manager.io/t/opening-balance/54997>\
**Category:** Uncategorized\
**Created:** [July 18, 2024, 8:20pm UTC](https://forum.manager.io/t/opening-balance/54997 "2024-07-18T20:20:32Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![roxbuilders](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@roxbuilders](https://forum.manager.io/u/roxbuilders)\
**Post date:** [July 18, 2024, 8:20pm UTC](https://forum.manager.io/t/opening-balance/54997/1 "2024-07-18T20:20:32Z")

</div>

Hi! I’m new to Manager IO. I’m trying to figure out how/where i can set start date for books and how to add the opening balance to my bank accounts.

Also, is there a way to upload excel statement files to Manager for easier reconciliation ?

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 18, 2024, 9:30pm UTC](https://forum.manager.io/t/opening-balance/54997/2 "2024-07-18T21:30:43Z")

</div>

> [@roxbuilders](#):
>
> how to add the opening balance to my bank accounts

See [Starting balance for bank account - #8 by Indinfer](https://forum.manager.io/t/starting-balance-for-bank-account/54821/8)

> [@roxbuilders](#):
>
> is there a way to upload excel statement files

See bank import [https://www2.manager.io/guides/9240](https://www2.manager.io/guides/9240)

---

<div class="post-metadata">

**Author:** ![roxbuilders](https://avatars.discourse-cdn.com/v4/letter/r/da6949/32.png) [@roxbuilders](https://forum.manager.io/u/roxbuilders)\
**Post date:** [July 18, 2024, 9:57pm UTC](https://forum.manager.io/t/opening-balance/54997/3 "2024-07-18T21:57:37Z")

</div>

Thank you! I wasn’t able to find beginning balance under cash / bank accounts. Maybe it’s not there in new version/desktop? but i was able to get a debit set in Journal which created a beginning balance!

---

<div class="post-metadata">

**Author:** ![sgarri](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@sgarri](https://forum.manager.io/u/sgarri)\
**Post date:** [July 19, 2024, 6:42am UTC](https://forum.manager.io/t/opening-balance/54997/4 "2024-07-19T06:42:05Z")

</div>

I also had a similar question. I want to open a new financial year, but I have 4 years of data in one company. Overtime this will grow in size so I figured the best option would be to keep at least one previous years data and capture current transactions, however, by deleting the previous transactions, wont that interfere with the balances in the Balance Sheet? Is there a way to maybe add the opening balances to these accounts?

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 19, 2024, 6:54am UTC](https://forum.manager.io/t/opening-balance/54997/5 "2024-07-19T06:54:24Z")

</div>

> [@sgarri](#):
>
> I want to open a new financial year, but I have 4 years of data in one company

Manager is a continuous accounting system. It is designed to grow with time.

End of financial period is handled as described here [Close an accounting period](https://www2.manager.io/guides/7470)

> [@sgarri](#):
>
> I figured the best option would be to keep at least one previous years data and capture current transactions, however, by deleting the previous transactions, wont that interfere with the balances in the Balance Sheet

deleting the previous transactions is the incorrect approach

---

<div class="post-metadata">

**Author:** ![Joe91](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.manager.io/joe91/32/35781_2.png) [@Joe91](https://forum.manager.io/u/Joe91)\
**Post date:** [July 19, 2024, 6:55am UTC](https://forum.manager.io/t/opening-balance/54997/6 "2024-07-19T06:55:06Z")

</div>

Manager is a perpetual accounting sgstem - there is no need to delete any of the historical data

Why do you want to do this?

---

<div class="post-metadata">

**Author:** ![sgarri](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@sgarri](https://forum.manager.io/u/sgarri)\
**Post date:** [July 19, 2024, 7:15am UTC](https://forum.manager.io/t/opening-balance/54997/7 "2024-07-19T07:15:59Z")

</div>

Because the file is currently growing and to save on space, I felt it was necessary. If you have another way I can go about doing this please let me know. 🙂

---

<div class="post-metadata">

**Author:** ![Patch](https://avatars.discourse-cdn.com/v4/letter/p/a183cd/32.png) [@Patch](https://forum.manager.io/u/Patch)\
**Post date:** [July 19, 2024, 7:36am UTC](https://forum.manager.io/t/opening-balance/54997/8 "2024-07-19T07:36:58Z")

</div>

> [@sgarri](#):
>
> the file is currently growing and to save on space

Transaction details take up minimal storage.  
Attachments can be large, and there was a plan to allow saving without old attachments. Removing all attachments and history can be done readily [Backup, restore, import, and transfer businesses](https://www2.manager.io/guides/8890)  
The data file can be internally compacted using [Reduce data file size](https://www2.manager.io/guides/17974)

Have you looked at the actual size of your Manager data file and worked out about how many copies you can fit in your available storage?

For my system the convenience of have all data at my finger tips outweighs the small gain in storage.

---

<div class="post-metadata">

**Author:** ![eko](https://avatars.discourse-cdn.com/v4/letter/e/a8b319/32.png) [@eko](https://forum.manager.io/u/eko)\
**Post date:** [July 19, 2024, 8:35am UTC](https://forum.manager.io/t/opening-balance/54997/9 "2024-07-19T08:35:50Z")

</div>

> [@sgarri](#):
>
> Because the file is currently growing and to save on space

Even with attachments, history, etc. it would be extremely difficult to imagine. One of our largest businesses existing since 2019 on Manager has just over 300 Mb of data (yes less than 1 Gb). Even if we would upload hundreds of images, etc it will not go beyond anything even a small memory stick or SD card can use.

So don’t be worried about size used by Manager data.

Maybe you have another reason such as messed up accounting system and a deep desire to start afresh and escape the trouble. However, this usually brings more problems and it is always better to correct whatever needs correcting, even if moving to other applications, etc.

The GiGa principle (Garbage in = Garbage out) can only be mitigated by working through the existing issues before carrying forward. Wish you the best.

---

<div class="post-metadata">

**Author:** ![sgarri](https://avatars.discourse-cdn.com/v4/letter/s/51bf81/32.png) [@sgarri](https://forum.manager.io/u/sgarri)\
**Post date:** [July 19, 2024, 10:47am UTC](https://forum.manager.io/t/opening-balance/54997/10 "2024-07-19T10:47:17Z")

</div>

Thank you for your replies guys!

---

<div class="post-metadata">

**Author:** ![vatwoman](https://avatars.discourse-cdn.com/v4/letter/v/f475e1/32.png) [@vatwoman](https://forum.manager.io/u/vatwoman)\
**Post date:** [January 31, 2025, 7:50pm UTC](https://forum.manager.io/t/opening-balance/54997/11 "2025-01-31T19:50:32Z")

</div>

Simple answer (works for desktop version): scroll down to the bottom of the page - click on Settings (left hand menu). There’s an option called “Starting Balances”. If you haven’t used it before, it will be shaded out and under the line. If you have used it it will be full colour and above the line. You need to have first created your accounts. Now choose the relevant type of account (e.g. Bank and Cash Accounts), then choose the specific account, then enter your starting balance. Thereafter, import data from your bank account or (if you prefer, but why would you?) enter it manually.
