Enter a reconciled opening balance plus unreconciled transactions

Find this screen

Open: Settings > Opening Balances > Cash Book > Reconciled Opening Account Balance.

How to

Enter a reconciled opening balance

  1. Select the bank account's Code.
  2. Enter the details of the reconciled balance:
    1. Date - Enter the date on which the opening balance applies.
    2. Reference - add you own reference for the transaction.
    3. Balance - the reconciled balance amount.
    4. For a foreign currency bank account:
      1. Enter the balance in the currency of the bank account.
      2. Your current exchange rate is displayed. Click to change it.
  3. Enter the details of the unreconciled transactions:
    1. Value - the amount in the bank's currency.
    2. Date - the date from your bank statement.
    3. Reference - your reference to identify it.
    4. Exchange Rate - (foreign currency accounts only) the exchange rate applied by your bank. Click Exchange rate to change this.

    Repeat step 3 for each unreconciled transaction you want to add.

  4. The Book Balances shows the total value of the opening balance transaction in your base and the banks currency.

Useful info

Setting a reconciled opening balance

Opening balances represent the financial position of your organisation on the day you start entering live transactions for your bank account. Whatever date you choose you are likely to have opening balances, whether your organisation is just starting up or changing from another accounting system.

In Sage 200 you can enter an opening balance for your bank account in two ways:

  • As a single transaction representing the actual balance on the account.

    We recommend that you use this if your bank balance is a single value. This would be the case if:

    • You have reconciled the bank account outside of Sage 200 and there are no unreconciled transactions sitting on your bank account when you bring its details into Sage 200.
    • You are using a new bank account and it contains only an opening balance.

    In this case, we recommend that you reconcile the opening balance within Sage 200 before you start normal bank reconciliation matching.

  • As a reconciled balance and unreconciled transactions.

    We recommend that you use this when your existing bank account has been reconciled in a previous system and the balance of the account includes unreconciled transactions.

    Entering an opening balance this way makes sure that:

    • The statement balance for the bank account in Sage 200 matches the reconciled value of your bank account.

    • The book balance for the bank account in Sage 200 matches your actual bank balance.

Some things to remember when setting an opening balance

You cannot amend a posted opening balance transaction

When you have posted an opening balance transaction you cannot amend it directly. If you make a mistake when entering an opening balance you must post a payment or receipt (as appropriate) to adjust the opening balance.

Setting the opening balance on a non base currency account

If you are specifying an opening balance for a bank account that operates in a currency that is different to your base currency, you need to know the exchange rate that is to be applied to the opening balance transaction. Sage 200 will automatically use the exchange rate specified in the currency and exchange rate settings but you can overwrite it if required.


What happens when I

Post the opening balance transaction?

When you post a bank opening balance transaction

For both single value and reconciled opening balance transactions:

  • An opening balance transaction (OP) is entered for the bank account. This is not posted to the nominal ledger.
  • The bank account balance is updated.

For single value opening balance transactions only:

  • The opening balance transaction is not reconciled.

  • The Statement opening balance on the bank reconciliation window is 0 (zero).

For reconciled opening balance transactions only:

  • Individual cash book transactions (BR and BP) are entered for the unreconciled value.

    They are not posted to the nominal ledger.

  • The Statement opening balance on the bank reconciliation window is updated.