AP#1 Book Closure – Accountant’s Nightmare

 

Book Closure – A Nightmare

Closing the books – sounds easy enough, right? Just enter some numbers, hit a button, and voila! Financial statements magically appear. But for many accounting teams, it turns from a routine task into a month-end monster. Don’t get us wrong, recording income, expenses, and the like is essential. But the sheer volume of data, combined with the need for manual entry and double-checking everything, can make closing the books feel more like a tedious chore than a satisfying accomplishment. The pressure to meet deadlines just adds to the stress, turning this necessary step into a bit of a dreaded necessity. Luckily, there are ways to tame the month-end beast! Lets dive deep in the world of accountants to ease the tedious work of book closure into fun and excitement.

Understanding & Accepting Problem

The closing process, while seemingly straightforward, holds immense significance for organizational leadership. Timely and accurate financial reports generated during the close are crucial for informed decision-making in subsequent accounting periods. A smooth close often goes unnoticed, but its importance becomes starkly evident in scenarios of delayed or inaccurate closing.

Errors stemming from late or failed closes may not have immediate consequences, but they can inflict significant financial damage in the long run. Miscalculations based on outdated or erroneous financial data can translate to inflated tax bills, or even trigger audits with potential fines. Furthermore, the lack of access to accurate cash flow reports can lead to unpaid bills, missed loan covenant deadlines, or even payroll disruptions.

Perhaps most concerning is the fact that the significant time and effort invested in the closing process may not guarantee accurate or actionable results. A study by Dimensional Research revealed that 75% of participants lacked full confidence in the accuracy of their most recent close, with a staggering 78% having to reopen the books after closing them¹. Beyond the immediate financial risks, a rushed, inaccurate, or failed close has a less obvious but equally unfortunate consequence: it deprives organizations of valuable data for strategic decision-making. When an entire department spends a significant portion of each month simply finalizing the books, the opportunity to leverage the insights generated by the closing process is lost. Ideally, financial executives should be able to analyze this data to pinpoint areas for improvement, identify growth opportunities, and make informed predictions for the future. However, achieving this becomes impossible amidst the chaos of a troubled monthly close.

Lets look at the possible issues faced by the accountants while closing a books at reporting period.

• Manual Processes
• Time Limitations
• Flow of Information inside Organization
• Heterogeneous Accounting System in Place

Data accuracy is paramount during the month-end close process. However, the high-pressure environment often associated with closing can lead to an increase in errors. Imagine the frantic rush of getting ready in the morning – juggling breakfast, searching for keys, and hurriedly shoving papers into a bag. In this state, how likely are you to meticulously tie your shoes without a single loose lace? Similarly, overworked and stressed teams rushing to meet deadlines are more susceptible to making mistakes. These errors, while seemingly minor at first (e.g., typos in data entry, mismatched columns, overlooked receipts), can have a compounding effect, leading to significant discrepancies and wasted time spent on rework during the reconciliation phase.

A critical challenge for many finance departments during the close process is the limited availability of resources. This manifests in two ways: a lack of time and a lack of qualified personnel. Insufficient staffing levels often lead to a cycle of rework due to errors caused by time constraints. The pressure to meet deadlines prioritizes speed over accuracy, resulting in the need for extensive corrections and verification later in the process. Furthermore, limited resources dedicated to strategic accounting tasks further exacerbates the situation, hindering the department’s ability to optimize bookkeeping practices and implement efficient closing procedures.

Nepal’s Case Study

In Nepal, the process of accounting book closure is often seen as a complex and challenging task, particularly due to limited knowledge and understanding of the appropriate methods required for both annual and monthly closures. One of the key areas where book closure is crucial is accounts receivable and accounts payable. Proper reconciliation is essential to track money owed to the company and debts that need to be settled. Equally important is managing the inventory on hand, where businesses must ensure that their records match the actual stock available to avoid discrepancies.

Another aspect that adds to the complexity is the recognition of prepaid expenses that have expired, which must be properly accounted for as the prepaid benefits are consumed over time. The cash margins deposited for import letters of credit also require careful tracking, as they impact both cash flow and financial statements. For many businesses, especially those involved in trade, this is an area that can create significant financial risk if not managed correctly.

In Nepal, the recognition and measurement of Tax Deducted at Source (TDS) is an essential component of book closure, as companies must ensure that the appropriate tax has been deducted and remitted on payments made to vendors and service providers. This also extends to employee-related expenses, where salary tax calculation must be accurate to avoid legal consequences. Recurring expenses such as lease or rental payments, security personnel costs, and others also involve TDS calculations, adding further layers to the complexity of monthly or annual book closure.

A critical part of the process is bank reconciliation, where businesses must ensure that their financial records match the bank’s records. This task becomes even more significant when managing post-dated checks (PDCs), which require proper tracking for cash flow management in the upcoming days or weeks. The reconciliation of Value Added Tax (VAT) is another crucial task in compliance with Nepal’s VAT regulations. Companies must accurately reconcile VAT collected and paid to ensure that they are following tax laws.

The book closure process in Nepal involves numerous day-to-day activities, but it serves the sole objectives of maintaining accuracy, transparency, and accountability in financial management. Without a proper understanding of these procedures, businesses may face challenges in maintaining compliant and reliable financial records, which could lead to financial misstatements or even penalties. Therefore, educating businesses about the importance of the book closure process and equipping them with the necessary skills and tools is critical for the improvement of Nepal’s financial reporting environment.

Approach to Accounting Book Closure – A Process

Traditionally, the accounting book closure process has been manual and time-consuming, but modern tools such as accounting software and spreadsheets like Microsoft Excel can make it much easier.

Steps to Close the Books (Traditional Approach)

1. Post Entries to General Ledger
2. Total General Ledger Accounts
3. Prepare a Preliminary Trial Balance
4. Prepare Adjusting Journal Entries
5. Prepare Adjustments to General Ledger
6. Prepare an Adjusted Trial Balance
7. Prepare Financial Statements
8. Prepare Closing Entries
9. Prepare Post-Closing Trial Balance

Financial Statements Preparation

1. Balance Sheet/ Statement of Financial Position (SOFP): Shows a snapshot of the business’s financial position by listing assets, liabilities, and owner’s equity.
2. Income Statement (Profit & Loss Statement)/Statement of Income & Loss: Summarizes income and expenses, showing the net income or loss for the period.
3. Cash Flow Statement: Summarizes the net cash flow generated in operating activities, investing activities and financing activities for the period.

Modern Tools and Software for Book Closure (Contemporary Approach)

Accounting Software (e.g., SWASTIK, FACT, BUSY, Tally): Automates many of the steps involved in closing books, such as posting to the ledger, generating trial balances, and preparing financial statements.

1. Automatic Updates: Journal entries automatically update the ledger in real-time.
2. Built-In Reports: Trial balances, income statements, and balance sheets are generated instantly.
3. Error Reduction: Less manual input means fewer errors.
4. Time saving: Tasks that would take hours or days manually are completed in minutes.

Microsoft Excel:

Excel can be used to create templates for ledgers, trial balances, and financial statements.

Functions like SUM, IF, VLOOKUP, XLOOKUP, etc. simplify calculations and tracking errors.

Pivot tables can quickly summarize data for trial balances and financial reports.

Mixed Approach for Businesses with Limited Resources

For institutions that do not have the capital to fully adopt accounting software but still want to streamline processes, a mixed approach can be useful. Here is how:

• Manual Entry with Software Support: Use traditional journals to record daily transactions manually but input these records into Excel for calculations and adjustments. Excel can generate trial balances, financial statements, and oversee basic reconciliations.

• Partial Automation: Use free or low-cost software for basic tasks like payroll, invoicing, and tax calculations, but manually post to ledgers and prepare closing entries.

• Human Oversight with Tech Assistance: Rely on staff to ensure accuracy in complex areas like adjustments, while using software to oversee repetitive or error-prone tasks like tax calculations and depreciation schedules.

By adopting a mixed approach, businesses can improve efficiency without needing to invest heavily in technology or additional personnel, balancing traditional methods with the advantages of modern tools.

Illustrative Example of Accounting Book Closure Process

In this example, we will walk through the book closure process for a firm named PBMS Consulting using traditional, contemporary, and mixed approaches for bank reconciliation, accounts receivable, TDS recognition and measurement, salary-related expenses, and other recurring expenditures.

1. Bank Reconciliation

Scenario: 

PBMS Consulting’s bank statement shows a balance of NRs 500,000, but the company’s cash book shows NRs 480,000. There is a difference of NRs 20,000 due to unpresented cheques and bank fees not yet recorded.

Traditional Approach

• Manually check the bank statement against the company’s cash book.
• Identify the unpresented cheques (NRs 15,000) and bank fees (NRs 5,000).
• Adjust the cash book by deducting the NRs 5,000 in bank fees and note the NRs 15,000 for pending clearance in future reconciliations.
• Update the general ledger manually with the adjusted cash balance.

Contemporary Approach

• The accounting software automatically matches bank transactions with those in the cash book (using bank feeds).
• The software identifies unmatched transactions and suggests entries, like bank fees and unpresented cheques.
• After reviewing the suggestions, simply approve them, and the software automatically updates the cash book and general ledger.

Mixed Approach

• Manually download the bank statement and compare it with the cash book in Excel.
• Use Excel formulas to highlight discrepancies (e.g., VLOOKUP for unpresented cheques and bank fees).
• Adjust the cash book in Excel, then update the general ledger manually.

Closing Journal Entries

Bank Charges Expense Dr. 5,000
To Bank Account Cr. 5,000
(Being bank charges recorded as per bank reconciliation)

No journal entry is needed for unpresented cheques since the payment is already recorded in the books. It will clear when the cheques are presented to the bank.

2. Accounts Receivable (AR)

Scenario: 

PBMS Consulting sold goods worth NRs 200,000 on credit. By month-end, only NRs 120,000 had been collected. The remaining NRs 80,000 is still outstanding.

Traditional Approach

• Manually track receivables through a sales journal.
• At month-end, check which accounts are still outstanding by reviewing customer ledgers.
• Update the general ledger with the collected amounts and carry forward the outstanding balance.

Contemporary Approach

• The accounting software automatically updates the AR account as soon as sales are made.
• Payments received are recorded instantly, and the outstanding balance is adjusted in real-time.
• A monthly AR aging report is generated by the software, providing a quick summary of pending receivables.

Mixed Approach

• Track sales manually in a sales journal but record receivables in Excel.
• Use Excel formulas to track outstanding balances and prepare an aging report.
• Manually update the general ledger with the collected amounts at the end of the month.

Closing Journal Entries

Accounts Receivable Dr. 200,000
To Sales Revenue Cr. 200,000
(Being credit sales recorded)

Cash/Bank Account Dr. 120,000
To Accounts Receivable Cr. 120,000
(Being cash received from debtors)

The remaining NRs 80,000 stays in the Accounts Receivable account until it is collected or written off in the future.

3. TDS Recognition and Measurement

Scenario: 

PBMS Consulting has made payments of NRs 100,000 to vendors. According to tax laws, 1.5% of TDS must be deducted and remitted to the tax authorities.

Traditional Approach

• Manually calculate TDS by multiplying the vendor payment by 1.5% (NRs 100,000 × 1.5% = NRs 1,500).
• Record the TDS payable in the journal and update the general ledger.
• At month-end, manually prepare the TDS return for tax submission.

Contemporary Approach

• The accounting software automatically calculates TDS on each vendor payment.
• It records the TDS payable in real-time and updates the general ledger.
• The software can also generate TDS reports for easy submission to tax authorities.

Mixed Approach

• Record vendor payments manually but calculate TDS in Excel.
• Use Excel formulas to apply the 1.5% rate to each payment.
• Manually record TDS in the general ledger but use Excel for tracking and reporting.

Closing Journal Entries

Vendor Expense Dr. 100,000
To Cash/Bank Account Cr. 98,500
To TDS Payable Cr. 1,500
(Being payment made to vendor and TDS deducted)

TDS Payable Dr. 1,500
To Cash/Bank Account Cr. 1,500
(Being TDS remitted to tax authorities)

4. Salary-Related Expenses

Scenario: 

PBMS Consulting’s employees’ gross salary for the month is NRs 300,000. The company needs to calculate salary tax, provident fund, and other employee-related deductions.

Traditional Approach

• Manually calculate salary taxes and provident fund contributions for each employee.
• Record these deductions in the payroll journal.
• Update the general ledger with the net salaries and tax liabilities.

Contemporary Approach

• Use payroll software to automatically calculate salary taxes, provident fund contributions, and net pay.
• The software updates the general ledger with the salary expenses, tax liabilities, and deductions in real-time.
• Generate payroll reports for tax and compliance purposes.

Mixed Approach

• Calculate gross salaries manually but use Excel to compute taxes and deductions.
• Create payroll templates in Excel to track net pay, deductions, and liabilities.
• Manually update the general ledger with the payroll figures but rely on Excel for reporting.

Closing Journal Entries

Salary Expense Dr. 300,000
To Salary Payable Cr. 240,000
To Salary Tax Payable Cr. 30,000
To Provident Fund Payable Cr. 30,000
(Being salary expense recorded and deductions made for taxes and provident fund)

Salary Payable Dr. 240,000
To Cash/Bank Account Cr. 240,000
(Being net salary paid to employees)

Salary Tax Payable Dr. 30,000
To Cash/Bank Account Cr. 30,000
(Being salary tax paid to tax authorities)

Provident Fund Payable Dr. 30,000
To Cash/Bank Account Cr. 30,000
(Being provident fund contributions remitted)

5. Other Recurring Expenditures (e.g., Rent, Utilities, Security Expenses)

Scenario: 

PBMS Consulting has monthly recurring expenses like rent (NRs 50,000), utilities (NRs 10,000), and security services (NRs 15,000).

Traditional Approach

• Manually track and record recurring expenditures in a journal.
• At the end of the month, post these expenses to the general ledger.
• If TDS applies to certain expenses (e.g., security services), calculate it manually and record it.

Contemporary Approach

• The accounting software automatically posts recurring expenses each month based on preset rules.
• It calculates TDS for applicable expenses and updates the general ledger in real-time.
• The software can also generate reports for all recurring expenses.

Mixed Approach

• Track recurring expenses in a manual journal but use Excel to calculate TDS.
• Enter expenses in Excel to track payment schedules and apply TDS formulas.
• Update the general ledger manually at the month-end based on Excel figures.

Closing Journal Entries

Rent Expense Dr. 50,000
Utilities Expense Dr. 10,000
To Cash/Bank Account Cr. 60,000
(Being rent and utility payments recorded)

Security Expense Dr. 15,000
To Cash/Bank Account Cr. 14,775
To TDS Payable Cr. 225
(Being security services payment recorded with TDS deduction)

TDS Payable Dr. 225
To Cash/Bank Account Cr. 225
(Being TDS on security services remitted to tax authorities)