Tally & Accounting Systems

Chapter 7
Banking and Cash Management

Certificate in Accountancy
Tally & Accounting Systems   •   Certificate

Banking and Cash Management

Introduction

Cash is the most liquid asset of a business and the resource most immediately required to settle wages, suppliers, taxes, loan instalments and operating expenses. Banking and cash management therefore connect accounting records with actual financial resources. In a computerized accounting system such as Tally, the quality of cash information depends on accurate voucher entry, proper classification of bank transactions, timely reconciliation and effective internal control.

A bank statement and an organisation’s cash book may show different balances even when both are correct. Differences arise because transactions may be recorded at different times, bank charges or interest may be known first by the bank, and errors may occur in either record. Bank reconciliation identifies and explains these differences. Good cash management also requires control over deposits, withdrawals, cheques, electronic payments, digital banking access and daily cash positions.

This chapter presents the practical foundations needed to record and monitor banking transactions in an accounting system. It assumes that learners understand debits, credits, ledgers and basic voucher types.

Learning Objectives

After studying this chapter, you should be able to:

  1. Explain the role of cash and bank accounts in accounting systems.
  2. Record deposits, withdrawals, transfers and payment instruments correctly.
  3. Prepare and interpret a bank reconciliation statement.
  4. Use Tally-style accounting workflows for banking transactions.
  5. Apply controls to cheques, cards, online transfers and digital banking.
  6. Calculate and monitor cash and bank positions.
  7. Identify risks, errors and ethical issues in cash management.

1. Cash, Bank and Cash Equivalents

Cash includes physical currency and funds available on demand in a current or savings bank account. A cash equivalent is a short-term, highly liquid investment that can be converted into a known amount of cash with insignificant risk of changes in value. The precise accounting definition may depend on the applicable reporting framework and the permitted maturity period.

Businesses commonly maintain:

  • a cash-in-hand ledger;
  • one or more current bank accounts;
  • a petty cash fund;
  • a card or payment-gateway account;
  • a foreign-currency bank account; and
  • short-term deposits or other permitted cash equivalents.

The accounting system should not treat all these accounts as one undifferentiated balance. Separate ledgers improve reconciliation, authorization and reporting.

The basic cash position may be expressed as:

Closing cash position = Opening cash position + Cash inflows − Cash outflows

Here, the opening cash position is the amount available at the beginning of the period, cash inflows are receipts during the period and cash outflows are payments during the period. The equation applies to a defined period and must use consistent dates and currency. It may be applied to cash alone, a bank account alone or a combined cash-and-bank group.

A broader position is:

Total liquid funds = Cash in hand + Bank balances + Eligible cash equivalents

This is a management measure, not automatically a financial-reporting definition. Restricted balances, overdrafts and investments that do not meet the relevant accounting definition should be shown separately.

2. Banking Transactions and Their Accounting Treatment

A transaction should be recorded when the business has sufficient evidence that it occurred and when the accounting policy requires recognition. The source document may be a receipt, deposit slip, bank advice, cheque counterfoil, card settlement report, electronic transfer confirmation or bank statement.

Receipts and deposits

When a customer pays directly into the business bank account:

  • Debit Bank.
  • Credit the customer’s receivable or the appropriate income account.

When cash is deposited into the bank:

  • Debit Bank.
  • Credit Cash-in-hand.

This is a transfer between assets, not income. In Tally, it is normally recorded through a contra voucher, because both the cash and bank ledgers belong to the cash/bank group.

Withdrawals and payments

When cash is withdrawn from the bank for office use:

  • Debit Cash-in-hand.
  • Credit Bank.

When a supplier is paid by cheque or electronic transfer:

  • Debit Trade payable or expense account.
  • Credit Bank.

A payment should not be recorded merely because a cheque has been prepared. The treatment of an issued but uncleared cheque depends on the accounting system and policy. In a conventional cash-book system, the bank column may be reduced on issue while the bank statement remains unchanged until presentation. This timing difference is then reconciled. In systems using payment clearing accounts, the entry may first move the amount to a cheques-issued or payment-clearing account and later clear it when settlement is confirmed.

Bank charges and interest

Bank charges are expenses of the business:

  • Debit Bank charges expense.
  • Credit Bank.

Bank interest received is normally income:

  • Debit Bank.
  • Credit Interest income.

The exact treatment of loan interest, withholding tax, service taxes and foreign-exchange differences must follow applicable law and the entity’s accounting policy.

Contra transactions

A contra transaction transfers funds between cash and bank or between two bank accounts. It does not change total liquid funds. For example, depositing CU 8,000 cash into the bank creates:

AccountDebitCredit
BankCU 8,000—
Cash-in-hand—CU 8,000

The transaction changes the location of the funds, not the total amount available.

3. Payment Instruments

Payment instruments are methods through which an organisation authorizes and settles a payment. Each instrument has different evidence, timing and risk characteristics.

InstrumentMain evidenceCommon riskControl response
CashReceipt and cash countTheft or lossCustody limits and surprise counts
ChequeCheque, authorization and bank recordForgery or alterationDual authorization and secure storage
Debit cardCard slip or digital recordUnauthorized useIndividual limits and alerts
Credit cardStatement and supporting invoicePersonal or unsupported spendingMonthly review and approval
Bank transferPayment instruction and confirmationWrong beneficiary or fraudCallback verification and maker-checker control
Direct debitMandate and bank adviceUnauthorized collectionMandate register and periodic review
Mobile wallet/payment gatewaySettlement reportAccount compromise or timing errorReconciliation and access controls

A cheque register should record cheque number, date, payee, amount, purpose, approving officers, date of presentation and clearance status. Unused cheque books should be secured. Voided cheques should be retained and marked clearly rather than destroyed without a record.

Electronic payments require careful beneficiary verification. A genuine-looking email is not sufficient evidence of a changed bank account. Changes should be independently confirmed using a trusted contact method. Passwords, one-time passwords and authentication devices must never be shared.

4. Bank Reconciliation

Meaning and purpose

Bank reconciliation is the systematic comparison of the bank ledger or cash book with the bank statement for the same account and period. Its purposes are to:

  • identify timing differences;
  • record transactions known first by the bank;
  • detect errors and omissions;
  • confirm the completeness of the accounting records; and
  • establish a reliable reconciled balance.

Reconciliation is not merely a clerical exercise. It is a control procedure that can reveal duplicate payments, unauthorized withdrawals, altered cheques, missing deposits and posting errors.

Common reconciling items

  1. Deposits in transit: Recorded by the business but not yet credited by the bank.
  2. Unpresented cheques: Recorded by the business but not yet paid by the bank.
  3. Bank charges: Deducted by the bank but not yet recorded in the books.
  4. Direct credits: Deposits such as customer receipts or interest recorded by the bank first.
  5. Standing orders and direct debits: Payments made automatically by the bank.
  6. Errors: Incorrect amounts, duplicate entries or postings to the wrong account.
  7. Returned items: Customer cheques or transfers rejected by the bank.

Timing differences normally require explanation and later follow-up, but not necessarily an accounting adjustment. Bank-originated transactions and book errors usually require journal or voucher entries.

Reconciliation logic

A reconciliation can begin with either the bank statement balance or the book balance. The signs depend on the starting point.

Starting from the book balance, a simplified approach is:

Adjusted bank balance = Book balance + Deposits in transit − Unpresented cheques

This version assumes that the book balance has already been adjusted for bank charges, direct credits, direct debits and book errors, and that no other reconciling items exist. If starting from the bank statement balance, the treatment is reversed:

Adjusted book balance = Bank statement balance − Deposits in transit + Unpresented cheques

These formulas are special cases, not universal rules. Errors, returned cheques, bank credits and overdrafts must be incorporated according to their effect on the selected starting balance. The objective is that the adjusted book balance and adjusted bank balance agree.

Worked example

On 31 March, the bank ledger of Aster Traders showed CU 52,400. The bank statement showed CU 49,850. Investigation found:

  • a deposit of CU 6,000 recorded in the books but not yet credited by the bank;
  • cheques totaling CU 4,200 issued and recorded but not yet presented;
  • bank charges of CU 350 not yet recorded in the books; and
  • interest of CU 200 credited by the bank but not yet recorded in the books.

First update the books:

Adjusted book balance = 52,400 − 350 + 200 = CU 52,250

Now adjust the bank statement balance:

Adjusted bank balance = 49,850 + 6,000 − 4,200 + 350 − 200 = CU 51,800

The results do not agree, so the information must be rechecked. The difference indicates that one item has been classified or reported incorrectly. This is an important professional lesson: reconciliation is an investigation, not a procedure in which a desired answer is forced.

Suppose further review discovers that the CU 6,000 deposit was actually included in the bank statement balance, although it was incorrectly described as outstanding in the schedule. Removing that item from the reconciliation gives:

Adjusted bank balance = 49,850 − 4,200 + 350 − 200 = CU 45,800

This still does not agree with CU 52,250, revealing that the statement balance or transaction list contains another error. The reconciliation should remain unresolved until the source documents are examined. A reconciliation that balances only because of a suspense or unexplained difference is not acceptable control practice.

A simpler correctly balanced illustration is useful. Assume a book balance of CU 30,000, deposits in transit of CU 3,500 and unpresented cheques of CU 2,000, with all bank-originated items already posted:

Adjusted bank balance = 30,000 + 3,500 − 2,000 = CU 31,500

The bank statement should therefore show CU 30,000 if the only differences are the stated timing items and the book balance is the adjusted balance. The reconciliation schedule must clearly identify the starting balance and each adjustment.

5. Reconciliation in Tally and Similar Systems

Software names and menu labels vary by version, but the accounting logic remains stable. A practical workflow is:

  1. Create separate ledgers for cash, each bank account, payment gateways and relevant clearing accounts.
  2. Enter opening balances after verifying the prior period’s reconciliation.
  3. Record receipts, payments and contra transfers using source documents.
  4. Enter bank charges, interest, direct debits and direct credits when identified.
  5. Open the bank reconciliation screen or report for the selected bank ledger.
  6. Match book transactions to statement dates and references.
  7. Investigate unmatched items rather than deleting them.
  8. Record necessary adjustments through properly authorized vouchers.
  9. Review old outstanding cheques and deposits.
  10. Save or export the reconciliation statement with supporting evidence.

Bank-date fields and transaction-date fields should not be confused. A voucher may be entered on one date while the bank clears it on another. Reconciliation reports are more useful when the bank date, instrument number, transaction reference and narration are complete.

A payment-clearing ledger is useful where the organisation needs to distinguish an authorized payment from a bank-settled payment. However, additional ledgers increase complexity and must be reconciled regularly. Automation should reduce repetitive work, not remove human review.

6. Cash Management and Monitoring

Cash management involves forecasting, safeguarding, allocating and reviewing liquid funds. A daily cash position report may include:

ComponentAmount
Cash in handCU 4,500
Bank account ACU 28,000
Bank account BCU 12,500
Less: restricted funds(CU 5,000)
Available liquid fundsCU 40,000

The report should state the date, currency, account sources and whether uncleared or restricted amounts are included. A positive total does not guarantee that all obligations can be paid, because funds may be restricted, located in another currency or needed before expected receipts arrive.

A short-term cash forecast compares expected inflows and outflows:

Forecast closing balance = Opening balance + Forecast inflows − Forecast outflows

Forecasts should distinguish committed amounts from estimates and identify uncertainty. Important monitoring questions include:

  • What payments are due in the next seven, thirty or ninety days?
  • Which customer receipts are overdue?
  • Are minimum bank balances or loan covenants applicable?
  • Are there unusual transfers or dormant accounts?
  • Is excess cash earning an appropriate return without reducing liquidity?

Cash budgets should be updated when major assumptions change. A forecast is a decision tool, not a guarantee.

7. Internal Control, Ethics and Governance

Cash is vulnerable because it is portable, valuable and often processed frequently. Effective controls follow the principles of authorization, custody, recording and independent review.

Core controls

  • Separate the person who approves a payment from the person who prepares it.
  • Separate custody of cash from accounting entry where feasible.
  • Require supporting documents and approval limits.
  • Reconcile bank accounts at least monthly; high-volume accounts may require daily or weekly review.
  • Investigate old outstanding items.
  • Use sequential receipt and cheque numbers.
  • Restrict system access by role and review user rights periodically.
  • Preserve audit trails and prohibit deletion without controlled reversal procedures.
  • Perform independent cash counts and compare them with the ledger.
  • Review unusual transactions, weekend activity, round amounts and new beneficiaries.

Ethical conduct requires that employees do not use business funds for personal purposes, conceal shortages, backdate entries or manipulate reconciliations. A person who discovers suspected fraud should follow the organisation’s reporting and whistleblowing procedures while preserving evidence.

Banking regulations, anti-money-laundering requirements, data-protection rules, tax laws and electronic-payment regulations vary by jurisdiction. The accountant must follow local requirements and the organisation’s policies. Customer and employee banking information should be accessed only for legitimate business purposes.

8. Digital Banking and Contemporary Practice

Digital banking provides online statements, scheduled transfers, instant alerts, mobile approvals, electronic mandates, payment gateways and application programming interfaces. These features can improve speed and visibility but also increase cyber risk.

Good practice includes multi-factor authentication, transaction limits, device management, independent verification of beneficiary changes, daily alerts and prompt removal of former employees’ access. Bank feeds can import transactions into accounting software, but imported data must be reviewed for duplicate entries, incorrect ledger mapping, tax treatment and cut-off errors.

Artificial intelligence and rules-based automation may classify transactions, identify unusual patterns and suggest matches during reconciliation. They should be treated as decision-support tools. Human review remains necessary because an unusual transaction may be legitimate, and an apparently normal transaction may be fraudulent. The organisation should document model limitations, approval responsibility and procedures for correcting automated classifications.

Applied Case: Sunrise Office Supplies

Background

Sunrise Office Supplies, a small wholesaler, uses a current bank account, a petty cash fund and a digital payment gateway. The owner previously reviewed the bank statement only at year-end. Supplier complaints and unexplained differences began to occur.

Problem

The accounting ledger showed CU 86,200, while the bank statement showed CU 79,450. The bookkeeper had recorded supplier payments on instruction emails, but supporting invoices were incomplete. Bank charges, a returned customer payment and several gateway settlements had not been posted. Two former employees still had online banking access.

Analysis

The accountant obtained the statement, gateway settlement reports, payment register, supplier invoices and access list. Transactions were classified into timing differences, missing book entries and control exceptions. One payment of CU 3,800 appeared twice in the ledger. A cheque of CU 5,000 was outstanding, and a deposit of CU 2,400 was still in transit. Bank charges of CU 250 and a returned customer payment of CU 1,100 had not been recorded.

The duplicate payment entry was reversed with authorization. The bank charge and returned payment were posted. The outstanding cheque and deposit were retained as reconciling items because they were valid timing differences. Gateway receipts were matched to settlement reports rather than to individual customer invoices alone.

Solution and outcome

Sunrise introduced weekly reconciliation, a payment register, dual approval for transfers above CU 10,000, beneficiary callback verification, daily bank alerts and immediate removal of former users. The revised process produced a documented reconciled balance and reduced unexplained differences. Management also began receiving a weekly available-cash report that excluded restricted gateway balances.

Learning points

The case demonstrates that reconciliation identifies more than arithmetic differences. It tests the completeness of recording, the validity of payment evidence, the security of digital access and the reliability of management information. Timing items should be monitored, not repeatedly carried forward without explanation.

Challenges and Limitations

Bank reconciliation can be difficult when statements are delayed, references are incomplete, transactions are in multiple currencies or several payment channels are used. Automatic matching may fail when one bank settlement represents many customer receipts. Foreign-currency balances also require appropriate exchange-rate procedures and may create exchange differences.

A reconciled account is not proof that every transaction is legitimate. A fraudulent payment can be correctly recorded and reconciled. Reconciliation must therefore operate alongside authorization, access control, review of supporting documents and fraud monitoring. Likewise, a positive cash balance may conceal future insolvency if large obligations are due shortly.

Best-Practice Checklist

Before finalizing a bank reconciliation, confirm that:

  • the correct bank account and period were selected;
  • opening balances agree with the prior approved reconciliation;
  • every statement line has been matched or explained;
  • bank-originated items have been posted;
  • errors have been corrected through authorized entries;
  • outstanding items have dates, references and owners;
  • old items have been investigated;
  • the final balances agree mathematically;
  • the preparer and reviewer are identified; and
  • supporting documents are retained securely.

Chapter Summary

Banking and cash management connect accounting records with the organisation’s actual liquidity. Deposits, withdrawals, contra transfers, cheques, cards, electronic payments and bank charges must be recorded in the correct ledgers and supported by reliable evidence. Bank reconciliation compares the cash book or bank ledger with the bank statement, explains timing differences, records bank-originated transactions and detects errors or irregularities. Tally and similar systems improve efficiency through bank-date fields, reconciliation reports, bank feeds and payment registers, but automation does not replace review. Cash forecasting, segregation of duties, access controls, digital security and ethical conduct are essential to protect funds and produce trustworthy cash information.

Key Terms

Cash-in-hand: Physical currency held by the business.

Bank ledger: The accounting record maintained for a particular bank account.

Cash equivalent: A qualifying short-term, highly liquid investment convertible to a known cash amount with insignificant value risk.

Contra transaction: A transfer between cash or bank accounts that does not change total liquid funds.

Bank reconciliation: Comparison and explanation of differences between the accounting bank record and the bank statement.

Deposit in transit: A deposit recorded by the business but not yet credited by the bank.

Unpresented cheque: A cheque recorded as issued but not yet paid by the bank.

Bank charge: A fee deducted by the bank for services.

Direct debit: A payment collected automatically from a bank account under an authorized mandate.

Standing order: A recurring payment instruction given to a bank.

Payment gateway: A service that processes electronic customer payments and later settles funds to the business.

Payment-clearing account: An account used to track authorized payments before final bank settlement.

Maker-checker control: A control requiring one person to prepare a transaction and another to approve it.

Cash forecast: An estimate of future cash inflows, outflows and balances.

Liquidity: The ability to meet obligations when they fall due.

Audit trail: A record showing who created, changed, approved or reversed a transaction.

Bank feed: An electronic import of bank transactions into accounting software.

Reconciled balance: A balance supported by agreement between accounting records and external evidence.

Restricted cash: Cash unavailable for general use because of legal, contractual or other restrictions.

Review Questions

Short Answer Questions

  1. What is the purpose of a bank reconciliation?
  2. Distinguish a deposit in transit from an unpresented cheque.
  3. Why is a cash deposit into a bank recorded as a contra transaction?
  4. State two controls over electronic payments.
  5. What is the purpose of a payment-clearing account?

Long Answer Questions

  1. Explain the accounting treatment of receipts, withdrawals, bank charges, interest and supplier payments.
  2. Describe the complete process of preparing a bank reconciliation and investigating unmatched items.
  3. Discuss how Tally or similar accounting software supports banking and cash management.
  4. Explain the principles of segregation of duties and access control in cash management.
  5. Discuss the benefits and limitations of digital banking, bank feeds and automated reconciliation.

Analytical / Application Questions

  1. A business has a book bank balance of CU 44,000. Deposits in transit are CU 5,200 and unpresented cheques are CU 3,700. Assuming all other items have been posted, calculate the expected bank statement balance and explain your reasoning.
  2. A reconciliation includes old outstanding cheques, unexplained bank credits and a payment made to a newly changed supplier account. Identify the risks and recommend an investigation and control response.
  3. Design a weekly cash-management report for a small business using cash-in-hand, two bank accounts, a payment gateway, restricted funds and expected supplier payments. Specify the fields and review procedures you would include.

Multiple Choice Questions with Answers

Question 1

Which entry records cash deposited into the business bank account?

A. Debit Cash; credit Bank

B. Debit Bank; credit Cash

C. Debit Expense; credit Bank

D. Debit Receivable; credit Cash

Correct Answer: B. Debit Bank; credit Cash

Question 2

A deposit in transit is a deposit that has been:

A. Recorded by the bank but not by the business

B. Cancelled by the customer

C. Recorded by the business but not yet credited by the bank

D. Recorded twice in the cash book

Correct Answer: C. Recorded by the business but not yet credited by the bank

Question 3

Which item normally requires an accounting entry when first identified from the bank statement?

A. An unpresented cheque

B. A deposit in transit

C. A bank charge not yet recorded in the books

D. A cheque already recorded in the books

Correct Answer: C. A bank charge not yet recorded in the books

Question 4

A cash withdrawal from the bank for office use is recorded by:

A. Debiting Cash and crediting Bank

B. Debiting Bank and crediting Cash

C. Debiting Expense and crediting Cash

D. Debiting Receivable and crediting Bank

Correct Answer: A. Debiting Cash and crediting Bank

Question 5

If the book balance is CU 30,000, deposits in transit are CU 3,500 and unpresented cheques are CU 2,000, the adjusted bank balance is:

A. CU 24,500

B. CU 29,500

C. CU 31,500

D. CU 35,500

Correct Answer: C. CU 31,500

Question 6

Which control best addresses the risk of one employee creating and approving the same electronic payment?

A. Using a longer narration

B. Maker-checker authorization

C. Recording the payment monthly

D. Combining all bank accounts

Correct Answer: B. Maker-checker authorization

Question 7

A transfer between two bank accounts of the same business is generally classified as:

A. Revenue

B. An expense

C. A contra transaction

D. A bad debt

Correct Answer: C. A contra transaction

Question 8

What is the primary purpose of a bank reconciliation report in an accounting system?

A. To calculate depreciation

B. To compare accounting records with the bank statement

C. To prepare a sales invoice

D. To approve employee leave

Correct Answer: B. To compare accounting records with the bank statement

Question 9

Which statement about automated bank feeds is correct?

A. They eliminate the need for human review

B. They guarantee that every transaction is correctly classified

C. They can import transactions but still require review and reconciliation

D. They should be used without access controls

Correct Answer: C. They can import transactions but still require review and reconciliation

Question 10

Which item should normally be excluded from available liquid funds if it is legally restricted?

A. Unrestricted cash in hand

B. An ordinary current-account balance

C. Restricted cash

D. A cleared customer receipt

Correct Answer: C. Restricted cash

Tally & Accounting Systems
Chapter 7 of 15