{"id":32242,"date":"2023-07-04T09:35:04","date_gmt":"2023-07-04T09:35:04","guid":{"rendered":"https:\/\/www.erplybooks.com\/juhendid\/how-to-make-sure-your-opening-balances-stay-the-same-in-erply-books\/"},"modified":"2023-07-04T09:35:04","modified_gmt":"2023-07-04T09:35:04","slug":"how-to-make-sure-your-opening-balances-stay-the-same-in-erply-books","status":"publish","type":"page","link":"https:\/\/www.erplybooks.com\/et\/juhendid\/how-to-make-sure-your-opening-balances-stay-the-same-in-erply-books\/","title":{"rendered":"How to make sure Your opening balances stay the same in ERPLY Books?"},"content":{"rendered":"

Opening balances<\/h1>\n

\u00a0 In ERPLY Books you can add opening balances if you go to \u2018\u2019<\/span>Settings -> Initial Data -> Opening Balances<\/b>\u2019\u2019. You then have to select a transaction date for the opening balances.\u00a0<\/span> \u00a0 \"\" \u00a0 Now write your balances in the relevant cells and click on the green Save button in the bottom right-hand corner.\u00a0<\/span> \u00a0 \"\" \u00a0 After entering the opening balances, lock the period to ensure that the opening balances remain the same. You can do this under <\/span>\u201cSettings\u201c -> \u201cConfiguration\u201d -> \u201cPeriod Locked to\u201d.<\/b> \u00a0 \u00a0<\/p>\n

Changes in the earlier period<\/span><\/h2>\n

\u00a0 Now we are going to see how to maintain your opening balances in case you have to make some changes to the period before setting up the opening balances. <\/span>For example you want to add another purchase invoice with a date before the opening balances but you need to make sure that the opening balances don\u2019t change together with the changes you make.<\/span> First, save your existing opening balances as an Excel file. Please note that you need to get the bookkeeping accounts in the right order. You can get them if you open \u2018\u2019<\/span>Reports\u201d -> \u201cAccount Balances\u2019\u2019<\/b>. Remember, if you get them from Account Balances you also have the summaries (Total row) here. Just take the correct balance date and click on <\/span>\u2018\u2019Search\u2019\u2019<\/b>. Now Books will show your balances.\u00a0<\/span> \u00a0 \"\" \u00a0 The easiest way to copy your account balances is to click on one row to activate it, then the CTRL + E combination (on a Mac keyboard Command+E), followed by CTRL+A in an opened window (on a Mac keyboard Command + A) and in an Excel file paste the balances with the CTRL+V (on a Mac keyboard Command+V) shortcut.\u00a0<\/span> If you have a period locked, then you have to unlock it under Configuration (<\/span>Settings -> Configuration<\/b>). See the \u2018\u2019<\/span>Period Lock to\u2019<\/b>\u2019 option.\u00a0<\/span> \u00a0 \"\" \u00a0 Let us now take the example where you need to add a new purchase invoice to the earlier period. Create a new purchase invoice (<\/span>Purchases -> Purchase Invoice (Add New<\/b>)). Fill in the information about the invoice and save it. <\/span>As adding the purchase invoice to the earlier period changed the balances, you need to add correct opening balances again. For this, open <\/span>\u2018\u2019Settings -> Initial Data\u2019\u2019 -> Add Opening Balances\u2019\u2019<\/b>. Pick the correct date for entering opening balances again and click <\/span>OK<\/b>.\u00a0<\/span> If you want to change the opening balances in the future, you can do it in the same place as mentioned before (Add opening balances). You just have to pick a date and enter the balances. Every new input rewrites the previous balances and the system uses the most recently added\/edited balances.<\/span> \u00a0 \"\" \u00a0 Now copy the balance column from the Excel file and in the Books in the Opening Balances module make the first balance column row blue (press Enter on keyboard) and paste the copied values (command + V in Mac or in Windows the operation CTRL+V). Then click on the Save button below and your balances are saved.\u00a0<\/span> The following video will explain how to maintain your opening balances. For when you want to add new information to the time previous to the opening balances.<\/p>\n