Setting Up Opening Balance
ENTERING OPENING BALANCE
Opening GL, Sales Invoices, Supplier Invoices & Stock
As you have not started your business yesterday, you are already operating with balances in your accounts. These need to be brought forward to system.
First you have to decide on a DATE to start using OCi system. E.g. 1st Apr 2015 Next, workout the Trial Balance from beginning of your financial year to 1st Apr 2015 i.e. from 1st Jan 2015 to 31st Mar 2015.
Location
Adjustment > Openings > Opening GL
Action
> Click ADJUSTMENT activity
> Click OPENING GL module
> Click NEW
Enter in all the Trial Balance items EXCEPT for Debtors, Creditors & Stock Accounts.
Location
Adjustment > Openings > Opening Invoice
Action
> Click ADJUSTMENT activity
> Click OPENING GL module
> Click NEW
Assuming if your Trial Balance indicate $50,000 of debtors, this means that you have this amount of Sales Invoices that your customer have yet paid you as at 31st Mar 2015.You have to enter them in Opening Invoice as it can them capture which Invoice No., Date, Customer and Amount.Note that total Opening Invoices must add up to debtor’s $50,000 value.
Location
Adjustment > Openings > Opening Supplier Inv.
Action
> Click ADJUSTMENT activity
> Click OPENING GL module
> Click NEW
Assuming if your Trial Balance indicate $30,000 of creditors, this means that you have this amount of Supplier Invoices that you have yet paid them as at 31st Mar 2015.You have to enter them in Opening Supplier Invoice as it can capture them which Supplier Invoice No., Date, Customer and Amount.Note that total Opening Supplier Invoices must add up to creditor’s $30,000 value.
Location
Adjustment > Openings > Opening Stock
Action
> Click ADJUSTMENT activity
> Click OPENING GL module
> Click NEW
Assuming if your Trial Balance indicates $10,000 of stocks, you have to enter them in Opening Stock.This is to capture the stock items code, quantity, unit price.Note that total Opening Stock must add up to $10,000 stock value.
Check if Opening entries are correct
Location
Adjustment > Opening > Opening Adj. Check
Action
> Click ADJUSTMENT activity
> Click OPENING
> Click OPENING ADJ CHECK module
> Click REFRESH
To check that you have correctly entered your opening, the Total amount add up from Opening GL, Invoices, Supplier Invoices Stock, Adjustments must equate to ‘0’ zero.If the Total is not zero, that means the entries are not balanced. The system will automatically post it to your Opening Adjustment Account.
Related Articles
Opening General Ledger
Reference the figures of the Trial Balance to enter the Debit/Credit balance of every account, except for Trade Debtors, Trade Creditors and Stock accounts. If users are performing Opening Entry after having passed the decided Opening Date, any ...Trial Balance/General Ledger values not matching with Ageing values.
When comparing the Trial Balance values against Ageing, we are looking at the Trade Debtor/Creditor accounts. Ageing Report In order for the report to generate values, the Trade Debtor/Creditor accounts needs to have the following information. 'Who' ...Opening Invoice & Supplier Invoice
These 2 modules are for entry of Outstanding Documents—documents which are currently making up the balances in Trade Debtors and Trade Creditors accounts, respectively. Accounts meant for Opening GL module only require a closing balance to proceed ...Opening Entry
Purpose of Opening Entry and when to do it Once the database has been handed over to your company, users may begin to perform Opening Entry for your company accounts. The purpose of Opening Entry is to: Bring forward operating balances into system ...How to enable selecting Account for Supplier Invoice
The following guide will help you if you are facing a problem that does not allow you to select an Account after selecting an Item in the Supplier Invoice section. (Do note that the Account column will be available for manual selection, but not as an ...