Module 24 · Advanced · 10 min read

Opening balances: accounts, bills, stock and cheques

You will be able to: Prepare the trial balance, ageing and stock listings for loading; Post opening balances in Accounting, Openings; Explain the Opening Balance ledger and how to correct postings.

  • Read not done yet
  • Self-check: not taken not done yet
  • Lesson complete not done yet

Opening balances bring the client's books into Zeyto as at the cut-over date. The Opening Balances screen has three tabs: Accounts, Customer / Supplier bills and Stock. Nothing reaches the books until you press the post button.

What you need from the client

  • A trial balance at the cut-over date, signed by the accountant.
  • An ageing listing by invoice for customers and suppliers, with invoice numbers, dates and due dates.
  • A stock valuation by item and warehouse with quantity and unit cost.
  • A list of post-dated cheques, received and issued, and VAT account balances.

How each part posts

TabWhat is enteredHow it posts
AccountsDebit or credit for each ledger: cash, bank, fixed assets, loans, capitalOne opening journal per currency
Customer / Supplier billsOne row per open invoice: party, invoice number, dates, amount, Dr/CrOne opening bill per invoice, so receipts can be matched later
StockWarehouse, item, quantity, unit, cost rate, plus batch, expiry and serialsOne Opening Stock document per warehouse

Every opening document is made to balance by one line on the Opening Balance ledger, 3900 in the standard chart. When your opening trial balance is complete, 3900 nets to exactly zero. Any other figure is the missing capital or ledger. The screen shows a tile Difference parked on Opening Balance (3900) and a downloadable reconciliation.

A balanced example, in AEDAccounts tab: cash 25,000, bank 180,000 and fixed assets 95,000 debit (300,000); VAT payable 12,000, loan 100,000, capital 200,000 and retained earnings 128,000 credit (440,000). Bills: customers owe 80,000 debit; suppliers are owed 60,000 credit. Entered debits are 300,000 + 80,000 = 380,000 and credits 440,000 + 60,000 = 500,000, so posting parks a debit of 120,000 on 3900. Stock of 120,000 is posted on the Stock tab and credits 3900 by 120,000, bringing it to zero. Do not also enter an Inventory balance on the Accounts tab or stock would be counted twice.

Rules to remember

  • The Opening Date must be inside an open fiscal year. Each part posts once per fiscal year.
  • Opening VAT balances are plain account lines; they do not enter the VAT return.
  • An old invoice dated before the first fiscal year is posted dated at the cut-over and ages by its due date.
  • Posting needs a user with access to all branches.
  • Use Validate (in More) to check lines without writing, and Resume if posting stops half way.

Cheques and corrections

The Openings screen has no cheque section. Post-dated cheques are registered through receipt and payment vouchers with the PDC cheque mode and tracked in PDC Management. Agree with the accountant how cheques in hand at the cut-over will be recorded, and rehearse it. To correct posted openings press Edit openings, change rows, press Preview changes and then Save changes. Blockers such as a bill already settled are shown in red. Cancel all openings reverses a year's openings.

Watch outA balance left parked on 3900 is not a rounding issue. It is a missing ledger, and it will confuse the first month-end if ignored.

Practise in the demo

  1. Open Accounting, then Openings in the demo. Read the header, the three tabs and the reconciliation card without posting.
  2. Find the Validate and Import Template actions in More.
  3. Open https://demo.zeyto.app/demo-app/ and sign in with the demo login. This is a public demo with sample data, so nothing you do there affects a real business.
Open the live demo

Public demo company, sign in as admin / demoAdmin123. Data refreshes nightly.

Key takeaways
  • Opening balances come from a signed trial balance, an invoice-level ageing and a stock valuation.
  • 3900 nets to zero when the opening trial balance is complete.
  • Edit with preview, or cancel all, and plan how cheques are handled.

Check yourself

5 questions on this lesson. Not timed, not the exam, and you can try again. Score 60% or more, and read the lesson, to complete it.

1. In the bill-by-bill opening, what does a Dr entry on a customer mean?

2. Which ledger does Zeyto use to balance every opening document?

3. You try to post the Accounts tab of the opening balances a second time for the same fiscal year. What happens?

4. The Opening Balances screen has its own section for post-dated cheques.

5. Accounts and bills entered total debits 380,000 and credits 500,000. Stock of 120,000 is posted separately. Which statement is right?

Practice questions for this module · Printable study sheet