0 comments on “Do You Perform REGULAR Bank Reconciliation for Your Business?”

Do You Perform REGULAR Bank Reconciliation for Your Business?

Being the most liquid of assets, we recognize the importance of ensuring the accuracy of our cash balance through regular bank reconciliation.  However, most companies put this important process aside and settle with annual reconciliation, usually just to meet year-end audit requirements.

As complicated as it may sound, there are actually basic steps towards accurate cash reporting.

KNOW WHAT YOU NEED. To perform a reconciliation, you will need your (a) cash transactions and balance per books and (2) bank statement as of a specified date.  It is also very important to ensure that the covered period in both records are the same.

CLOSE YOUR BOOKS. Going through the entire reconciliation process only to find out that there were additional cash transactions booked in the period you are covering is inefficient and frustrating.  Make sure that your records are complete and no more cash transactions are booked on or before your covered period.  If unavoidable, be at least informed so you can consider them in your reconciliation accordingly.

ESTABLISH BANK BALANCE FIRST. It is generally easier to get the correct bank balance first since there are only a few (and usually recurring) reconciling items involved.  These transactions do not require you to post adjusting entries.  The most common bank reconciling items are Outstanding Checks, Deposits in Transit, and Bank Errors.

  • Outstanding Checks – These are checks released but not yet cleared with the bank. In your books, these are already considered payments hence, should be deducted from your bank balance.
  • Deposits in Transit – These are collections that are yet to be deposited. In your books, these are correctly recorded as part of your cash hence, should be added to your bank balance.
  • Bank Errors – Although uncommon, banks can commit errors too. In this case, you should inform your bank right away for proper action.  Depending on the transaction, bank errors may be added to or deducted from your bank balance to get to your adjusted amount.

Once you have established your bank balance, you can already compare it with your book balance and assess the magnitude of your book reconciling items.  Book reconciling items should be recorded accordingly to get to your correct book balance.  Book reconciling items include bank charges, direct deposits made by customers, auto-debit transactions (usually for utilities), and book errors.

SAY NO TO MONTHLY MATCHING. The secret to fast month-end reconciliation is by not doing it monthly.  As much as possible, matching book and bank transactions should be performed at least weekly.  A few companies are actually doing it daily!  TIP: If you subscribe to online banking, you can easily download bank balances and transactions as of the day before.

AUTOMATE. Bank reconciliation is already (or can be) embedded in most ERPs today.  Inquire with your software provider.  However, if you’re still comfortable with excel spreadsheets, templates can be developed to simplify the reconciliation process and significantly reduce the time spent manually matching transactions and identifying red flags.

rapid insights zone

How we can help? Developing and implementing a solid finance transformation agenda is the hallmark of our ACCOUNTING SERVICES model — we build, operate, and transform fundamental capabilities in people, processes, and technology. Contact us to know more about these services.

0 comments on “How to Effectively Manage Year-end External Audits”

How to Effectively Manage Year-end External Audits

Most companies actually dread year-end audits.  You will find that Finance organizations are usually off-limits during this period as they struggle to make last-minute adjustments, prepare supporting schedules, find source documents, and review a year’s worth of transactions.  Stressed, pressured, and burned-out, risk of errors increase.  Overall — an unpleasant experience.

But year-end audits should not be disruptive.  Nor preparations should be done, well, at year-end.  To ease the stress during this period, below are simple changes and process improvement that your Finance organization can adopt.


Plan your audit activities & deliverables and discuss with those who will be involved so they know what are expected of them.  A checklist of audit requirements and due dates that everyone, including your external auditors, can refer to is most helpful as it will keep people focused.  Schedule regular update meetings and use the checklist to track progress.


Leverage on available (and affordable) technology.  Reduce reliance on excel spreadsheets by investing in an accounting system that best fits your organization.  Most systems now come with subsidiary ledgers and customizable reports that will not only reduce time spent on data preparation but will also increase the accuracy of your information.  Documents-scanning technology (within your accounting system or as a separate software altogether) is also helpful when retrieving supporting documents requested by your auditors.


As mentioned, preparations for the year-end audit does not have to be done at year-end.  Embed automation, control, and period-end tasks within your day-to-day activities.  By adopting continuous accounting, you will be “audit-ready” any time of the year.


Year-end audit process will include review of your quarter one results right after the period under audit.  Make sure you don’t neglect your usual closing activities while attending to the requests of your external auditors.

Most of all, immediately after the conclusion of every year-end audit, take a moment to review, evaluate, and list down learnings and areas for improvement — both within your organization and with your external auditors — for an even more hassle-free year-end audit next time.

rapid insights zone

How we can help? Developing and implementing a solid finance transformation agenda is the hallmark of our ACCOUNTING SERVICES model — we build, operate, and transform fundamental capabilities in people, processes, and technology. Contact us to know more about these services.


0 comments on “Management Insight: Status Quo is Riskier than Change”

Management Insight: Status Quo is Riskier than Change

Experiences certainly present lots of old and new challenges, and adds more valuable learnings to become better in future dealings.

As can be expected, change will always certainly happen – whether planned or unplanned.  Either because it is internally initiated or externally triggered by events. Impact of changes can either be isolated or widespread, short-lived, or longer-lasting. But when is change good or bad?  When is it too soon or too late? When is it too little, too big, or just right?

People can either welcome or resist change.  People can either choose to be the catalyst and be in the forefront or choose the status quo and risk being left behind.

Whether we like it or not, change will undoubtedly happen – so might as well be open to liking it rather than resisting or fearing!

And in case we fail, we fail early.  And when we fail early, we learn earlier than the many. Remember, we can always stand up… and change again!  Just continue moving forward but not without the learnings!

Here’s an inside story of real happenings in a company who pioneered an industry segment years ago: Visibly a lucrative, profitable business, it quickly attracted other businessmen to enter the market like mushrooms, growing exponentially.  The multitude of entrants grew faster than the pioneer’s own business and consequently reduced its share to merely 35% of the market it dominated during its earlier years.
Although the enterprise was quick enough to implement the growing technology-enabled products, the head office administration, support services, finance and management organization remained traditional.  Instead of propelling the front businesses, these head office services and practices slowed down business expansion thus allowing the rest of the market to grow faster.
Realizing the need to change, they hired executives, managers, and professionals to enable transformation of its central operation and management.
New people in the organization expectedly introduced surgical transformational changes. Expectedly as well, the natural resistance to change of the homegrown people prevented the faster realization of the advantages and benefits. Just as when the initiatives were about to peak further and reach new highs, significant external events triggered tsunami-like waves of challenges risking all the great business creativities.
Suddenly, the entire organization scampered for further and quicker changes.  Many of the postponed actions in consideration of homegrown people’s sensitivities became absolutely urgent and thereby executed swiftly. Only this time, rightly or wrongly, there was no longer regard to human sensitivities as crisis situations require desperate (not necessarily deliberate) counter measures.  What were intended to make the business thrive are now being made to merely survive.

In this story, change initiatives introduced but sidelined in the past turned out to be the most sought life-saving medicines when needed desperately. See, protecting the status quo is riskier because the rest of the world will continue to change anyway. Don’t forget: LIFE HAPPENS!

rapid insights zone

How we can help?

Developing and implementing a solid finance transformation agenda is the hallmark of our ACCOUNTING SERVICES model — we build, operate, and transform fundamental capabilities in people, processes, and technology. We go beyond change management! Contact us to know more about these services.

0 comments on “FAST CLOSE: How to get there?”

FAST CLOSE: How to get there?

How fast do you close your books?

If you can close your books, distribute reports to stakeholders, AND give analysis or data-driven insights to management within 5 days after period-end, then CONGRATULATIONS — you may stop reading this now and get on with doing a very fine job!

These days, it is not uncommon to find Finance organizations struggling every period-end — swamped with non-value adding activities and overworked during closing — resulting to burned-out employees, increased risk of errors, and out-of-date results. This is especially true in retail organizations (i.e. drugstores, restaurants, coffee shops, etc.) where consolidation of multiple remote locations remains a challenge.

Fret not, here are common and simple solutions and approaches applied from years of experience in various industries:


  1. Define clear objectives. People will follow you if they know where you are going.
  2. Set key performance indicators. You can’t control (hence, can’t improve) what you can’t measure.
  3. Ensure continuous learning & development. When you know better, you do better.


  1. Automate. There are already an abundance of technology solutions available even to small enterprises from as basic as desktop automation like workflow and macros to sophisticated cognitive automation.
  2. Integrate. When data is compartmentalized, organizations look to the office of the CFO to initiate integration of various systems in order to operate from a single version of truth.
  3. Innovate. To maintain competitive advantage, it is imperative that your business be up to date with all of the relevant technological upgrades such as cloud-based technology.


  1. Standardize and simplify. From transactions processing to master lists to report templates, standardization enhances the quality of data and makes it easy to spot mistakes/errors.
  2. Implement and enforce effective controls. Strategic checkpoints and red-flags throughout the period eliminates period-end lengthy tracking and tracing and resolution of errors.
  3. Set cut-offs. Pro tip: It doesn’t have to be the last day of the month.
  4. Process documentation. Documentation of tasks that are done more than once or completed by multiple people provides consistency and allows easy monitoring and revision of processes as you go along.
  5. CONTINUOUS ACCOUNTING embeds automation, control, and period-end tasks within day-to-day activities. Blackline explains it accurately in these illustrations (READ MORE: https://www.blackline.com/continuous-accounting).
OLD MODEL: Record-to-report

Blackline - old model

THE MODERN APPROACH: Continuous Accounting

Blackline - modern approach

rapid insights zone

How we can help?

Developing and implementing a solid finance transformation agenda is the hallmark of our ACCOUNTING SERVICES model — we build, operate, and transform fundamental capabilities in people, processes, and technology. Contact us to KNOW MORE about how to FAST CLOSE.


1 comment on “ANALYTICS: The New Core of Finance”

ANALYTICS: The New Core of Finance

The big question being repeatedly asked of Finance is “are we there yet, are we there yet… are we there yet?”


The GREAT NEWS is that new technologies already abound thus making tools available and affordable even to the small and medium enterprises! Analytics tools are not anymore just for the big players to play with. Big or small enterprises now invest in the TECHNICAL CAPABILITY aspects of big data and analytics.  Cleansing raw data and building analytics models are detailed works, and the right technical tools make the process much more efficient.

However, that is only half of the solution.  Real return on investment is realized in the HUMAN FACTOR of analytics.

Without the human factor, analytics is just an informative tool.   But with the critical human factor, analytics becomes a transformative tool.

The human factor transforms data to analytics to insights to action to competitive advantage — the true value of human insight is definitely infinite!

The BIG DATA phenomenon focuses a bright spotlight on those who can perform deep information analysis and talent for finding hidden patterns.  Good data analysts select and address the business problems that have the most value to the organization.

ANALYTICS is and certainly must be the NEW CORE of Finance!


 rapid insights zone

How can we help? Accelerating your analytics journey is the core objective of RAPID INSIGHTS ZONE — premium analytics professional services, made available to all business types and sizes. Our services will help you KNOW MORE through analytics, so you have MORE TIME and resources to focus on growth. When you are ready to accelerate your analytics journey and inevitable business transformation, contact us!