Module 7 · Advanced · 8 min read

Cash, bank and petty cash checks

You will be able to: Read the Cash & bank book for the month; Reconcile a bank statement using Zeyto's Bank Reconciliation screen; Count a petty cash float and understand where a difference is posted.

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

Cash is the first thing to prove at month-end, because the other side of the proof is outside your software: a bank statement and a box of notes. Zeyto holds your side. You compare it with theirs.

The Cash & bank book

The Cash & bank book report (find it from the Reports search) lists every cash and bank ledger for the period with its opening balance, money in, money out, number of entries and closing balance. Click a ledger to open its day book: each entry with the party or other accounts, Receipt (Dr), Payment (Cr) and the running balance. Closing balance at the month end is your book figure.

The Cash and Bank Book report showing opening balance, receipts, payments and closing balance for each cash and bank account.

Reports, Cash & bank book: each account with its closing balance.

Reports, Cash & bank book: each account with its closing balance.

Bank Reconciliation

Accounting, Bank Recon lists the movements on your bank accounts. You tick the ones that appear on the statement, enter the Statement Date (and, if you like, a Statement Ref) and press Mark Cleared. What stays Uncleared is what the bank has not shown yet.

The Bank Reconciliation screen with the bank account picker and the uncleared entries ready to be ticked.

Accounting, Bank Recon: tick what appears on the statement.

Accounting, Bank Recon: tick what appears on the statement.
Watch outMark Cleared only records the statement date. It posts nothing and changes no balance. Zeyto does not import a statement file, match rows for you, or ask for the statement closing balance, so you do the final comparison yourself. The tiles add up only the rows loaded by your filters (the newest 500), so they are not a closing balance.
  1. Choose the Bank Account, set From and To to cover the statement and keep Status on Uncleared.
  2. Click each row that appears on the statement, then enter the Statement Date.
  3. Press Mark Cleared. Rows become CLEARED and leave the list.
  4. Look at what is left. Each remaining row is a timing difference or a mistake.
ItemAmount (AED)
Bank statement closing balance, 31 October52,300
Less: cheque issued, not yet presented (still Uncleared, a payment)-3,000
Add: deposit made on 31 October, not yet on the statement (still Uncleared, a receipt)+1,500
Equals: book balance in Zeyto50,800
Checking the answerIn Zeyto the two Uncleared rows have a net value of 1,500 (money in) minus 3,000 (money out) = minus 1,500. The statement balance of 52,300 plus that net of minus 1,500 gives 50,800, which must equal the Cash & bank book closing balance for the bank ledger. If it does not, something on the statement is missing from the books, for example a bank charge of AED 45. Record it in the books first, then tick it. This check only works if the Uncleared list covers every uncleared row, not just the newest 500.
  • A voucher whose bank line is ticked cannot be cancelled or amended. Select the line, press Unreconcile, then cancel or amend.
  • A cancelled voucher shows its bank line and the reversing line, which cancel each other out. Tick them together.
  • Post-dated cheques: Day End warns about cheques whose due date has come and that are still registered or deposited. Clear or bounce them before you reconcile.

Petty cash count

Accounting, Petty Cash, Cash Count compares the cash you physically counted in a float with the books. Post every voucher and advance first, because money spent but not yet recorded shows up as a shortage. Enter the Physical count and press Record Count. If the count differs, Zeyto posts the difference at once to Cash Short & Over (account 5910), dated today with no date box. A short box debits Cash Short & Over and credits the float; an over box does the opposite. A count cannot be undone: correct a wrong count by counting again.

The Petty Cash Cash Count screen with the system cash from the books, the physical count box and the variance.

Petty Cash, Cash Count: counted cash against the books.

Petty Cash, Cash Count: counted cash against the books.

Try it in the demo

  1. Open the Cash & bank book from the Reports search. Pick this month and press Run. Which ledgers have the most movement?
  2. Click one ledger and read its running balance.
  3. Open Accounting, Bank Recon. Keep Status on Uncleared and read the four tiles. Do not press Mark Cleared in the shared demo.
  4. Open Accounting, Petty Cash and read the Cash Count page. Do not record a count.
Open the live demo

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

Key takeaways
  • Your book balance comes from the Cash & bank book; the statement and the box are the outside proof.
  • Bank Recon marks rows cleared and posts nothing; you compare the closing balances yourself.
  • Statement balance, less outstanding payments, plus deposits in transit, should equal the book balance.
  • A petty cash difference posts to Cash Short & Over (5910) the moment you record the count.

Check yourself

3 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. What does Mark Cleared do in Bank Reconciliation?

2. Where does a petty cash count difference post?

3. The bank statement closes at AED 40,000. A cheque of AED 2,500 you issued has not been presented, and a deposit of AED 1,000 is not yet on the statement. What should the book balance be?

Practice questions for this module · Printable study sheet