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 “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 “How to Ensure Success of Finance Operations during Christmas Break”

How to Ensure Success of Finance Operations during Christmas Break

Christmas is just around the corner and we can’t help but get distracted with parties, reunions, shopping, and out-of-town trips!  However, we should not lose our hats and forget our responsibilities as a Finance organization.

We don’t need to be physically reporting to the office, but safeguards should be in place for business continuity – and stress-free Christmas break!

MAINTAIN CREDIT STANDING. While you can be conservative and not expect collections from customers during holidays, don’t expect the same from your suppliers.  Review your payables and settle due accounts before the long break.

SECURE CASH POSITION. Some banks open their doors even on holidays.  Make sure you have enough cash to cover account payments (auto-debits, PDCs, outstanding checks) and emergency purchases during this period.

MANAGE INVENTORY. Head office may be closed during the holidays, but this is the busiest time of the year for those in retail and manufacturing.  Study your historical data: forecast sales and analyze inventory behavior to avoid losses due to out-of-stock fast-selling items and stocking up instead on the not so popular ones.

PLAN HEADCOUNT. Expect people to file vacation requests that, most of the time, will extend beyond declared legal holidays.  To avoid unpleasant surprises and business disruption, ask for at least one-month notification and ensure proper delegation of tasks and turnover of important files (electronic and manual) to those who will be temporarily covering for them.

STAY INFORMED. Take advantage of cloud-based technology solutions to keep in touch with your business anytime, anywhere, and with any device for as long as you have internet connection.  View sales and inventory balance with just a few clicks, approve purchases, invoices, and payments online, even send (scheduled) management reports even if you’re enjoying a long vacation yourself!

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 Measure Performance of Your Finance Organization”

How to Measure Performance of Your Finance Organization

New technology triggers the transformation of finance into an analytics powerhouse that derives insight from data.

Finance will become the enterprise hub of analytics by the end of the decade, if not sooner.

Finance must earn this role quickly or be simply relegated to an automated accounting function.   Success will depend on a finance workforce with very different skills than today.  Automation, robotics processes, and intelligent systems are becoming part of the finance team – i.e., humans and machines will join forces to boosts Finance organization’s influence and value in the business.  Humans will turn to the judgment work that machines cannot do.

Now, between the full shift and today, Finance must strive to promote its value in the business by publishing performance scorecards of its key deliverables and service level objectives.  The scorecards must contain metrics of productivity and efficiency of finance in the overall and in core functional areas.

  • Headcount: ratio to stores or total company
  • Finance G&A cost: ratio to revenues
  • Accounts payable: no. of days to process, volumes per day per person, errors
  • Financial closing: no. of days to complete and release reports to management
  • Tax compliance: no. of days before deadline, incidences of penalties

Gone are the days when finance (and any functional department) can operate and function without published key performance indicators.  Without the performance metrics, no one will understand and appreciate a functional department’s value in the company.  Besides, an organization without measures will just be seen in motion without any direction.

Much sooner than later, challenges in developing performance metrics will become greater as the shift to analytics, and robotics and intelligent systems become more real than just a concept.

Imagine the metrics of performance when finance is fully transformed into the analytics arena.

Finance must keep scoring and expanding the business value it delivers to stay relevant.

Are your people ready to migrate from spreadsheets to analytics? They better be!

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 “Ways to Manage Seasonality in Small and Medium Businesses (Sales and Inventory)”

Ways to Manage Seasonality in Small and Medium Businesses (Sales and Inventory)

Filipinos are known to celebrate Christmas early. Once September kicks in, you’d hear Jose Mari Chan songs blasting on mall grounds, see Dapitan Arcade stalls abound Christmas decorations for sale, and of course, experience unimaginably worse standstill traffic.

We call it the “-ber months”. Filipino businesses rely on this four-month period for their entire year’s sales.  This may be true and established for some, but many are just following suit and don’t even know when the exact period of their business’ seasonality peaks. In fact, in its recent reader survey, Rappler found that -ber season is a myth – to quote: “Though many retailers begin their Christmas campaigns in September, consumers aren’t making the bulk of their purchases that early.”

Not knowing about this behavior as it relates to your business is dangerous and risky especially in inventory management and cash flow. Obviously, understocking leads to lost opportunities and unserved deliveries, resulting to reputation damage. However, another real danger is in overstocking, because cash is tied up to inventories that you may need to undervalue just to sell.

The only way to outlast seasonality woes is through data-driven planning and analysis. Off-peak seasons are a great time to start this deep-dive thinking process so you are equipped when the next peak season comes.

If you already think this is unnecessary time to spend, better be prepared for the worst because truly, it pays to pay attention.

Here’s how:

  • Historical information is good reference point, especially because you want to understand overall direction in a do-nothing scenario.
    • First things first – know your seasonality! Point-of-sale (POS) solutions are top sources for this key information because seasonality should be drilled down as far as days than just months.
    • Then, find out historical inventory balances (at least monthly). Just note that not all POS can provide this, except when it is integrated with a dynamic analytics tool.
  • Find out patterns and plan accordingly — the devil is in the details!
    • Inventory supply must anticipate the demand highs and lows. Understanding and establishing patterns in sales trends help minimize errors in buying inventory.
    • Thorough review of inventory balances highlights slow or non-moving inventory, allowing you to plan returns, exchanges, or proper markdown strategies to prevent inventory losses.
  • Ensure planning is an ongoing process. Monitor performance, see if plans work, and adjust as necessary.

Don’t succumb to being a bandwagoner especially with running your business. Know MORE so you can WIN in business.

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. We offer PREMIUM but affordable retail management solutions and professional services suitable to your requirements: point-of-sale and analytics. 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!