Back to Basics

DataRapt released the first sub-ledger control account bundle way back in February 2008.  We have come a long way since then and now cover 4 SYSPRO versions, 10 sub-ledgers and serve customers world-wide. It must be said that without our valued partners and customers, none of this would have been possible.

Looking at our growth between then and now, I have realised that it’s time to take out some of our older blogs and give them a good spring clean.

This, then, is our new, updated look at the basics.

Refreshing the Reconciliations

The Refresh function is the heart of the sub-ledger reconciliations. First, the opening and closing balances for the sub-ledger and control accounts are calculated from transaction level up. Then all transactions that make up the sub-ledger balance are compared to the relevant GL audit trail files. Finally, the audit trail files are compared to the entries posted to the control accounts in the Ledger.

Two very important notes about the Refresh:

  1. This function is performed only for the financial period or periods that you have selected. In order to refresh the data for any other period, you must select the required period before selecting this function. In addition, if any transactions have been posted back to a prior period, the refresh for that period must be performed again.
  2. DataRapt does not write any data to SYSPRO tables, but rather updates its own set of tables with the results of the refresh. This highlights the importance of re-refreshing the reconciliation(s) if changes have been made to the SYSPRO data.

‘Correcting’ the DataRapt Reconciliations

There is a misconception that the DataRapt reconciliations can, themselves, be adjusted to remove variances that have been corrected in the General Ledger by way of ledger journals.

There is no posting function in the DataRapt reconciliations. Every transaction that makes up the sub-ledger balance is drawn from the underlying SYSPRO tables. This means that the only way to ‘fix’ the DataRapt reconciliation is to correct the problem in the sub-ledger. The WhatNext? function that is available for every variance in the reconciliation attempts to address how the variance may have arisen, and suggested corrections are provided.

We do not ever suggest correcting or over-riding data in the SYSPRO tables, but are here to assist you in finding a solution to data inaccuracies.

Date changes

Whilst SYSPRO is a period driven system, there are some tables that use transaction dates to ascertain the timing of the transaction. This applies particularly to the Fixed Assets module, where the purchase date of the asset is key to all SYSPRO and, by extension, DataRapt calculations. The Work in Progress module also relies on dates for certain calculations in DataRapt.

Performing the Financial Year or Month change function in SYSPRO can, on occasion, cause timing difference between the sub-ledgers and the general ledger.

Please contact the DataRapt team if you find yourselves in this situation.

DataRapt Purge

There is some confusion regarding the purge function within DataRapt. We have been asked the question “Will the Purge Reconciliation Information function purge SYSPRO data?”

The answer is no, you cannot purge SYSPRO data through DataRapt.

The data you are being prompted to purge here is DataRapt data. The retention of this data influences how far back you can view previously refreshed periods in the recons without refreshing again. If you purge this data then you will have to refresh the periods again if you want to query them. Bear in mind that if you would like to view periods older than those that can be re-refreshed then this will no longer be possible if you have purged those periods.

DataRapt Releases and Builds

DataRapt’s ‘hotfix’ equivalent is the DataRapt Build. We have separate builds for the different SYSPRO versions we support and sometimes for different releases of those versions.

If you are experiencing problems with any DataRapt program, you should ensure that you are running the latest build for the version and release of SYSPRO that you are using.

You can get information on any program changes between the build of DataRapt you are currently running and the latest build by looking at the Change Notes on our support site.

DataRapt Licensing

This section covers quite a large topic, and might deserve a write-up of its own. Thus, instead of basics, I will cover some of the misconceptions regarding licensing.

DataRapt needs ‘Activation Keys’ in order to run. These keys are automatically issued on receipt of payment and should be valid for the entire license period. However, there are times when the keys become invalidated due to a change in user environment and will need to reissued. The most common reasons for this are:

  1. the server identifier against the licensed server has changed
  2. the number of licensed SYSPRO users has increased
  3. the SYSPRO company name has been altered or a new one has been added
  4. the version of SYSPRO has changed

If you add a new SYSPRO company name on the server, you’ll need a corresponding activation key for DataRapt. You will need to tell us how the company name is defined in SYSPRO as the DataRapt key needs to match the company name in SYSPRO exactly.

DataRapt licensing is based on the number of licensed SYSPRO users. If this changes, you may need to apply for new DataRapt Activation Keys. There may be license fees payable but we will advise you if this is the case.

Facts, Follies and Fictions

I have written many a line on the importance of General Ledger reconciliations. It stands to reason considering the accountant in me and how vital a practice regular reconciling has become. The process is essential for detecting errors and discrepancies, and even exposing fraud in financial transactions.

However, it is not always as straightforward as it sounds, so I’ve come up with a list of some facts, follies, and fictions related to ledger reconciliation.

Facts

Accuracy

The accuracy of financial accounts directly impacts decision-making, financial reporting, and compliance with regulatory requirements. The financial statements such as the balance sheet, income statement, and cash flow statement, must be accurate to provide a true and fair view of a company’s financial position and performance.

Compliance

Many industries and regulatory bodies have strict compliance and audit requirements. Accurate reconciliation data is necessary to demonstrate compliance with financial regulations, ensuring that an organization avoids penalties, fines, or legal consequences.

Audits play a critical role in ensuring the accuracy and reliability of financial statements. When it comes to reconciliations, auditors typically have specific requirements and procedures they follow to assess the completeness and accuracy of the reconciliation processes.

Timing

Ledger reconciliation should be performed regularly, to promptly identify and address discrepancies. With DataRapt, it is possible to refresh the automated reconciliations overnight, thus providing a day-to-day view of the sub-ledger to ledger reconciliations.

Fraud

Reconciling the ledger regularly helps in detecting fraudulent activities, such as unauthorized transactions or embezzlement, by identifying discrepancies between records.

Manual vs. Automated

Ledger reconciliation can be done manually or using specialised software tools. Automation can significantly reduce errors and save time. The DataRapt suite of reconciliation products provides just this assurance.

Follies

Neglecting Reconciliation

Failing to perform regular ledger reconciliation can lead to financial mismanagement, inaccurate financial reporting, and even legal issues.

Human Error

Manual reconciliation is prone to human error, such as data entry mistakes or overlooking discrepancies. Specialised software such as DataRapt can alleviate this.

Incomplete Records

If all financial transactions are not recorded in the ledger, the reconciliation process may not be effective in identifying discrepancies. With DataRapt, transactions posted in the source modules are checked at each step of their paths to the General Ledger control accounts and any differences between them are shown.

Misinterpretation

Misinterpreting accounting terminology or standards can lead to improper reconciliation, potentially causing further issues. The team at DataRapt are always ready to provide rapid assistance in ascertaining where to start the investigative process. It all boils down to comparing two sets of records, and understanding where the error or difference lies – and how to go about correcting it.

Fictions

Perfect Automatic Reconciliation

Some may believe that automated reconciliation tools will always yield perfect results. While automation reduces the risk of errors, it does not guarantee a flawless reconciliation process. DataRapt provides a number of tools to assist you in getting to the bottom of variances that arise within the reconciliations. The most popular of these is the WhatNext? facility which provides insight into the possible cause of variances as well as suggested steps to correct such variances.

The team at DataRapt are on hand to provide further assistance should this be required.

No Need for Reconciliation

There is a misconception that reconciliation is unnecessary because financial records are always accurate. In reality, errors can occur due to various reasons, making the reconciliation function essential.

Reconciling Solves All Problems

Reconciliations identify discrepancies, but it doesn’t fix the underlying issues causing those discrepancies.

By design, DataRapt does not update SYSPRO tables, rather we provide links to posting programs, insights into the possible causes of the problem along with possible solutions.  We also offer a variety of user-defined tools to assist with investigating variances in control accounts.

Reconciliation is Time-Consuming

While reconciliation can be time-consuming if done manually, automation tools such as DataRapt can significantly reduce the time and effort required for the process.

In Conclusion

Clearly, regular ledger reconciliation is a vital financial practice that helps ensure the accuracy of financial records. However, it requires regular attention. Avoiding or neglecting to reconcile your ledger can lead to all sorts of problems, so it’s essential to recognise the importance in financial management.

5 Tips for Successful Reconciliation

Successful Reconciliation, the process of ensuring that two sets of records (usually two sets of financial accounts) are in agreement, is a critical task in both personal and business finance. Done correctly, it assures that financial data sets are accurate and trustworthy. But, as many companies would attest, achieving a successful reconciliation can be challenging. With that in mind, here are five tips to guide your reconciliation journey:

1. Centralize Your Data Repository

Centralization can make or break the reconciliation process in an age where information comes from multiple sources.

Why it Matters: Centralizing data minimizes the risk of overlooking crucial transactions and ensures a single point of truth. You can avoid unnecessary discrepancies and mismatches when all your data reside in one place.

How to Implement: Invest in a robust data management system that allows you to integrate different data sources. Whether you’re dealing with bank statements, invoices, or sales receipts, having them feed into a unified system will streamline reconciliation.

2. Track Transactions at Every Step

Every transaction has a life cycle, from initiation to completion. Monitoring each stage can provide invaluable insights.

Why it Matters: By tracking each transaction’s path, you can quickly identify any discrepancies, ensuring they are resolved promptly and do not compound over time.

How to Implement: Use tools that timestamp and log every change or transfer of a transaction. Modern financial software often provides an audit trail feature that allows users to see the history of a transaction, making discrepancies easier to spot and resolve.

3. Invest in a Reconciliation Tool

In finance, manual processes can be both time-consuming and error-prone. That’s where reconciliation tools come in.

Why it Matters: Automated reconciliation tools reduce human error, speed up the process, and provide valuable analytics to understand patterns and potential bottlenecks.

How to Implement: Assess your business needs and budget, then research and invest in a reputable reconciliation tool. These tools often have features like matching algorithms, discrepancy alerts, and detailed reporting to enhance accuracy and efficiency.

4. Regularly Review and Update Processes

Reconciliation is not a one-size-fits-all process. As your business evolves, so should your approach to reconciliation.

Why it Matters: Regular reviews ensure that your reconciliation processes align with your business’s operational realities. This can help identify inefficiencies and areas for improvement.

How to Implement: Schedule regular reviews (quarterly, bi-annually, or annually) of your reconciliation processes. Use these reviews as an opportunity to train staff, implement new technologies, or refine current methodologies.

5. Ensure Clear Communication Among Teams

Reconciliation often involves multiple departments, from finance to sales to operations. Clear communication across these teams is paramount.

Why it Matters: Discrepancies can often arise from simple misunderstandings or miscommunications. Regular dialogue ensures everyone is on the same page, reducing errors.

How to Implement: Hold regular meetings that involve key stakeholders from each department. Establish clear protocols for data entry, reporting, and resolving discrepancies. Investing in collaborative tools can also be beneficial to keep everyone connected and informed.

To Conclude

Achieving successful reconciliation is a blend of using the right tools, implementing effective processes, and fostering a culture of clear communication and continuous improvement. While challenges are inevitable, following these five tips can significantly enhance the efficiency and accuracy of your reconciliation processes, ensuring your business’s financial health and integrity.

The Importance of Data Accuracy in Reconciliation

Data accuracy in reconciliation is vital in today’s rapidly advancing digital world, where data has emerged as the lifeblood for businesses of all sizes and sectors. From streamlining operations and identifying growth opportunities to understanding customers better, data drives decisions. But there’s a catch – the data used must be accurate. This is especially critical when it comes to reconciliation processes.

Why Data Accuracy Matters in Reconciliation

Trustworthy Financial Reporting:

At its core, reconciliation ensures that the data in two sets of records match. This is crucial in financial contexts. Without accurate reconciliation, companies may have erroneous financial reports, leading to poor decisions and potentially severe legal consequences.

Operational Efficiency:

Inaccuracies in reconciliation can lead to a lot of wasted time and effort. Think of the countless hours spent identifying and rectifying discrepancies. This not only slows down business processes but also increases operational costs.

Enhanced Decision Making:

For business leaders, data-driven decisions are only as good as the data they are based on. If there’s any inconsistency or inaccuracy in the reconciled data, the subsequent decisions may be flawed, leading to suboptimal outcomes.

Maintaining Stakeholder Confidence:

Stakeholders, whether they’re investors, customers, or partners, trust businesses to provide accurate information. Repeated inconsistencies or errors can erode this trust, affecting a company’s reputation and credibility.

How DataRapt’s Product Elevates Data Accuracy in Reconciliation

Recognizing the importance of accurate data in reconciliation processes, DataRapt offers solutions tailored to enhance precision and reliability.

Automated Reconciliation:

Manual reconciliation processes are tedious and prone to human error. DataRapt’s product comes with automated reconciliation features, ensuring a quick, efficient, and more accurate matching of records.

Discrepancy Alerts:

If discrepancies arise, it’s essential to know about them timeously. DataRapt’s product offers prompt alerts, ensuring businesses can quickly rectify any inconsistencies.

Comprehensive Reporting:

After the reconciliation process, understanding the outcomes and insights is equally important. DataRapt’s solution offers detailed reporting tools, providing a clear overview of the reconciliation results and highlighting areas needing attention.

In Summary

Data accuracy is non-negotiable in today’s business landscape, especially when it comes to reconciliation. The implications of inaccurate data can be vast, from skewed business decisions to eroding stakeholder trust. Solutions like those offered by DataRapt can not only simplify the reconciliation process but, more critically, ensure it’s grounded in accuracy and reliability. In a world where data drives decisions, ensuring its accuracy should always be a top priority.

Quality planning and control

In our last blog, we defined quality and touched on how to define quality standards. This blog will look at the steps in quality planning and control.

Organizations perform quality planning and control to ensure products or services satisfy expectations consumers have about the design specifications of the product or service. Meeting consumer needs depends on the design of these specifications.

Steps in quality planning and control

Step 1

Defining quality characteristics of the product or service takes place in this step. These quality characteristics are directly related to the product or service’s design specifications. The most common quality characteristics include:

  1. Functionality: whether the product performs its desired function.
  2. Appearance: whether the physical aspects are attractive.
  3. Reliability: the ability of the product or service to perform continuously.
  4. Durability: the total life expectancy.
  5. Serviceability: the ability for the organization (or third party) to repair the product or service.
  6. Contact: the interaction available between the client/consumer and an organization.

Step 2

After determining quality characteristics, try express them in measurable terms. Characteristics that are measurable are controllable.

Step 3

Each defined quality characteristic of the product or service should have set standards. Quality standards for quality characteristics enable the operations manager to measure the conformance and achievement of the defined quality characteristics.  Having fewer than 0.5 bugs per 1000 lines of code is an example of a quality standard. If 3 bugs per 1000 lines of code were observed then quality standards weren’t met to ensure the satisfaction of ‘reliability’ quality characteristics.

Step 4

Determine whether the product or service satisfies realistic quality standards by analysing them. This is the control step. The operations manager is concerned with three areas in this control process:

  1. Whether to Implement preventative, in-time or reactive control.
  2. Deciding if they will check each product or service individually or if they will take a general sample to determine if all products and services meet quality standards.
  3. Statistical process control or acceptance sampling is conducted. Statistical process control is when inspection is conducted during the manufacturing or rendering process. Acceptance sampling is when inspection occurs after the manufacturing or rendering process.

Step 5:

Never perceive quality deviations negatively. Although they can be costly, they give the organization a chance to identify and correct causes of poor quality. Conduct identifying and rectifying poor quality at this stage.

Step 6:

The last step is to continuously look for ways to improve the quality of products and services. Improvement of products and services is based on performance measurement. Improvement can either be dramatic and large scale – such as breakthrough improvement or it can be incremental where regular and small scale changes take place – continuous improvement.

The customer/client-marketing-design-operations cycle

The customer/client-marketing-design-operations cycle (BJ Erasmus, 2013, p. 289)

How does your organization plan and control their quality? Do you have any other steps you might want to add?

Sources:

  • BJ Erasmus, J. S. S. R.-K., 2013. Introduction to Business Management. 9th ed. Cape Town: Oxford.

 

Defining Quality in Organizations

Quality seems to be a term that is thrown around lately without giving much consideration to what it actually means. Organizations are using quality as a unique selling point or key differential. How different can one company’s quality be when they are all talking about it? Defining quality in organizations is what truly counts and what creates the differential.  Identifying quality aspects in a product include breaking it down, measuring the quality and controlling it. These steps are how companies are able to define their quality and communicate what sets it apart.

What is quality?Defining Quality in Organizations

In management, quality is the “consistent conformance to customers’/clients’ expectations”. Other definitions include; “the absolute best”, “suitable for the purpose for which it was designed”, “flawless”. Quality, however is subjective and depends on perception and experience with an organization’s products or services

When defining quality in organizations, it is up to the organization itself to explore and identify how their customers or clients perceive and define quality so that they can meet these expectations or even change opinions. You would need to change opinions if your client/customer has a different idea of the quality of your products compared to what they truly are. The key aim is to eliminate any ‘gaps’ between perceived and actual quality through thorough investigation, corrective action and communication.

How are quality standards decided?

During the strategic planning phase of any organization, the mission, vision and objectives of the organization are established to reach long-term goals. Certain performance standards need to be identified that need to be met to achieve these goals and objectives. These performance standards determine the quality standards that need to be measured and controlled in various ways. In our next blog we will touch on different quality control methods. The performance and quality standard is a planned target to which the final performance and quality standard will be compared.

Any deviation from this standard can be easily controlled and measured by establishing them upfront.

Customers and clients of the organization are the key driving force behind the sort of standards an organization needs to uphold. Customer needs are being met by the products or services of the organization. If their needs aren’t being met adequately then the business cannot survive.

Who is responsible for quality management?

Traditionally the operations management function was responsible for ensuring quality standards were met and quality control was implemented. Now, total quality management (TQM) is a management approach which assumes that it is the responsibility of all members of the organization to ensure that quality standards are met according to customer needs and in order to achieve business objectives.

Under the system of TQM, it is up to all members of the organization to continuously work toward improving an organization’s work systems, products and services to meet desired quality.

The benefits of meeting quality expectations

Apart from the fact that good quality (whatever ‘good’ means to your customers or clients) will increase your sales and income, there are a few other benefits of meeting quality standards.

  1. In marketing and public relations efforts, acquisition is far more expensive than retention. Having long-term value customers comes from maintaining consistency in quality and meeting standards every time without deviation. Less money needs to be spent on returning customers because they no longer need to be ‘wooed’ by your company. Instead, they trust your products or services to be of a quality that is reliable and consistent every time – increasing your credibility and enhancing your reputation.
  2. Having everyone in an organization be mindful of quality management can dramatically decrease your costs. Defective products or corrective action waste unnecessary resources that the company cannot afford to lose. In the long run, poor quality products require maintenance or repair work that the customer or client may refuse to pay for.
  3. Apart from the obvious cost-saving benefit, quality products can reduce waste. By reducing the amount of waste generated by defective products or parts, an organization will throw away less and contribute towards maintaining a clean environment. Being a company that is mindful of decreasing waste also puts it in a position to be socially responsible and a good corporate citizen.

There are many reasons why companies pay attention to their quality and what sort of quality they wish to promise their clients/consumers. What does ‘good quality’ mean to you?

Sources:

  • BJ Erasmus, J. S. S. R.-K., 2013. Introduction to Business Management. 9th ed. Cape Town: Oxford.