Setting An Opening Balance If You Have Added Previous Transactions
Last modified:
The opening balance assumes that there are no previous transactions, so it just adds or subtracts to the balance. Here is what to do if you have some transactions in from before your start date.
1. Go to Reports > All Reports > Balance Sheet, set 'To Date' to your Landlord Vision start date and click Apply to update the report. Write down the balance against the bank account. For the purposes of this example, let's assume that the balance is £10,000.
2. Using your actual bank statements, check the opening balance of your bank account on the same day. Write down the balance. Let's assume the bank balance was £25,000.
3. Go to Banking > Accounts > click the vertical ellipsis (3 dots) and choose Edit Account from the cog menu. Enter the difference between the actual bank account balance (see step 2) and the Property account balance in Landlord Vision (see step 1). If the difference is positive then enter the opening balance as a 'Debit'. If the difference is negative then enter the opening balance as a Credit. Using the sample figure the difference is £25,000 - £10,000 = £15,000 and therefore we will enter the opening balance as a £15,000 Debit. Now the bank account balance in LV should match the actual bank account balance as at your start date, eg 5th April. Now your Account balance should match your bank balance on the day you have reconciled your transactions up to
4. Go to the Account Transactions page of the bank account and place your cursor over the Opening Balance entry and each of the earlier transactions in turn and select Ad Hoc Reconciliation from the icon menu that comes up. Landlord Vision will write these as entries on the Bank Statements tab and will adjust the Statement Balance accordingly. Once you have reconciled them all, then the Statement Balance will match the Account Balance, minus any unreconciled transactions you have entered.
*Remember that the Debit and Credit options in the balance type follow the golden rules of accounting. Therefore, a Debit will add an amount on to the balance and a Credit will take it off.
1. Go to Reports > All Reports > Balance Sheet, set 'To Date' to your Landlord Vision start date and click Apply to update the report. Write down the balance against the bank account. For the purposes of this example, let's assume that the balance is £10,000.
2. Using your actual bank statements, check the opening balance of your bank account on the same day. Write down the balance. Let's assume the bank balance was £25,000.
3. Go to Banking > Accounts > click the vertical ellipsis (3 dots) and choose Edit Account from the cog menu. Enter the difference between the actual bank account balance (see step 2) and the Property account balance in Landlord Vision (see step 1). If the difference is positive then enter the opening balance as a 'Debit'. If the difference is negative then enter the opening balance as a Credit. Using the sample figure the difference is £25,000 - £10,000 = £15,000 and therefore we will enter the opening balance as a £15,000 Debit. Now the bank account balance in LV should match the actual bank account balance as at your start date, eg 5th April. Now your Account balance should match your bank balance on the day you have reconciled your transactions up to
4. Go to the Account Transactions page of the bank account and place your cursor over the Opening Balance entry and each of the earlier transactions in turn and select Ad Hoc Reconciliation from the icon menu that comes up. Landlord Vision will write these as entries on the Bank Statements tab and will adjust the Statement Balance accordingly. Once you have reconciled them all, then the Statement Balance will match the Account Balance, minus any unreconciled transactions you have entered.
*Remember that the Debit and Credit options in the balance type follow the golden rules of accounting. Therefore, a Debit will add an amount on to the balance and a Credit will take it off.
