Recording Opening Balances
Recording opening balances is the process of entering your starting financial data when you first begin using Kezi.
Recording General Account Balances
- Go to Accounting > Journal Entries > Create.
- Select an Opening Balance Journal (or use Miscellaneous).
- Set the Date to the day before your go-live date.
- Add lines for each account in your Trial Balance:
- Assets (Cash, Bank, Fixed Assets): Enter in Debit.
- Liabilities (Loans, Taxes Owed): Enter in Credit.
- Equity (Retained Earnings, Capital): Enter in Credit.
- Balance the entry against the Opening Balance Equity account if you are entering balances incrementally.
Recording Partner Balances (AR/AP)
To maintain a sub-ledger for customers and vendors, do not just enter a lump sum in the GL.
For Outstanding Customer Invoices:
- Go to Sales > Invoices > Create.
- Select the Partner.
- Enter the details of the original invoice.
- Set the Account to the "Opening Balance Counterpart" account instead of a Revenue account to avoid double-counting income in the current year.
- Validate the invoice.
For Outstanding Vendor Bills:
- Go to Purchases > Vendor Bills > Create.
- Select the Vendor.
- Enter the bill details.
- Set the Expense Account to the "Opening Balance Counterpart" account.
- Validate the bill.
Recording Inventory Opening Stock
- Go to Inventory > Stock Adjustments > Create.
- Select the Location (Warehouse).
- Add products and their Starting Quantities.
- Set the Valuation Price to the cost at which you purchased them.
- Set the Counterpart Account to "Opening Balance Equity".
- Validate the adjustment to update your stock levels and accounting.
Troubleshooting
Entry is not balancing
Ensure that Total Debits = Total Credits. If you are missing one side of the equation, use the Opening Balance Equity account as a temporary placeholder.
Duplicate Revenue/Expense
When recording old invoices or bills, ensure the line items point to the Opening Balance account, not your standard Sales or Expense accounts, so your current year's Profit & Loss stays accurate.