Why is it so important to reconcile the General Ledger?

The General Ledger is the book of numbers for any company. From senior management level and down through the ranks, this ‘book’ provides a snapshot view of the company’s financial position at any given point in time.

It is the central accounting record and as such, provides management the vital data required in the decision-making process.

Clearly, accuracy in the General Ledger is of paramount importance. Reconciliations between books of prime entry and the general ledger should be performed regularly to ensure that accuracy and consistency of the financial records.

Let’s break this down further.

Financial integrity

Reconciling involves comparing financial records. Both external such as bank and supplier statements, and internal – the books of prime entry such as Accounts Receivable, Accounts Payable and Inventory.

Any inaccuracies in the data can lead to financial discrepancies that can result in financial losses, compliance issues and even damage to the organization’s reputation

Decision-making

Accurate data is essential for making informed decisions. Stakeholders rely on the accuracy of the underlying data making up the Financial Statements for almost all financial decision-making. For example:

  • For budgeting and planning

Decision makers rely on historical financial data from the ledger to create budgets and make long-term financial plans.

  • To evaluate performance

Organizations use financial metrics and key performance indicators (KPIs) derived from ledger data to evaluate the performance of various departments, projects, or investments.

Likewise, when considering investments, acquisitions, or divestitures, stakeholders depend on accurate financial data to assess the potential risks and returns

  • Managing costs

Effective cost control requires precise tracking of expenses in the ledger. Inaccuracies can result in over or under estimating costs, which can affect profitability.

  • Making informed decisions about cash management, borrowing, or investing surplus funds.
  • Identifying areas for improvement and process optimisation

Accurate ledger data supports operational efficiency by providing insights into cost structures, revenue streams, and resource allocation.

Compliance and audit requirements

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 and internal controls within an organization. When it comes to reconciliations, auditors typically have specific requirements and procedures they follow to assess the completeness and accuracy of the reconciliation processes.

Auditors may perform substantive testing to verify the completeness and accuracy of reconciliations.

Operational efficiency

Inaccurate data can lead to inefficiencies in operations. For example, reconciling inventory levels with sales records requires precise data to prevent overstocking or understocking of products, which can impact a company’s ability to meet customer demand and its profitability.

Resource optimization

Inaccurate data reconciliation often requires additional resources to identify and rectify errors. This can result in wasted time and effort, diverting resources away from more productive tasks.

Long-term sustainability

Maintaining data accuracy in the reconciliation process contributes to an organization’s long-term sustainability. It helps ensure that financial and operational decisions are based on reliable information, reducing the likelihood of financial crises or reputational damage.

In conclusion

Data accuracy is not just a matter of convenience in the reconciliation process. It is a fundamental requirement for maintaining financial integrity, compliance, and operational efficiency. Organizations that prioritise data accuracy in the General Ledger can make better decisions, mitigate risks, and build a strong foundation for long-term success.

12 reasons why DataRapt is the balancing tool of choice for SYSPRO

DataRapt has been providing a balancing tool for SYSPRO since version 6.0 (and for every version since). Over the years it’s fair to say that there isn’t much that hasn’t been thrown at it and we’ve continually made improvements and refined it as and when new anomalies come along.  We’re confident that our balancing tool will find all the variances that make up any difference between your sub-ledgers and the General Ledger. But, if there’s an oddity we haven’t previously come across, we’ll investigate and make sure it’s catered for. It’s for this reason that companies around the world have come to rely on DataRapt to keep their sub-ledgers in balance to their general ledgers whatever version of SYSPRO they are running.

This doesn’t have to be a time consuming task as the recons can be automated to run unattended and for responsible people to be emailed the latest results, helping you to keep on top of the task of balancing, which can otherwise be laborious and labor intensive. We’ll even give you information on each variance identified, helping you to resolve it.

Here are 12 reasons why our customers love DataRapt:

  1. DataRapt identifies all the variances making up the difference between the sub-ledger and the General Ledger.
  2. DataRapt doesn’t rely on stored ‘buckets’ for the sub-ledger balances; instead, they are recalculated, ensuring their accuracy (particularly in prior periods).
  3. Using DataRapt, you can balance as far back as the first period of the previous financial year. The exceptions to this are Assets (only the current financial year) and Inventory (only 12 financial periods).
  4. DataRapt offers balancing utilities for Accounts Payable, Accounts Receivable, Assets, Cash Book, Dispatch Notes, Inventory, GRN Suspense, Goods in Transit, Work in Progress and WIP Inspection as well as a GL Reconciliation tool.
  5. DataRapt enables you to balance a range of periods at a time.
  6. DataRapt’s ‘Reconciliations at a Glance’ program shows you the balances from all of its reconciliations on a single screen. From there you can run the individual reconciliations to investigate any imbalances.
  7. DataRapt’s ‘What Next?’ facility provides insight into what may have caused a variance and offers suggestions to resolve it.
  8. Because DataRapt’s balancing utilities are an interactive application, you can:
    • launch the programs needed to correct the variance directly from the ‘What Next?’ facility and then immediately refresh the data to see the effect.
    • use the contra facility to de-clutter the reconciliation so you can focus on what requires your attention.
    • drill down to variances at a control account level.
    • exclude control accounts per operator so that if your operators are responsible for reconciling only certain control accounts they only see those.
    • see which banks, branches and warehouses update which control accounts.
    • capture notes against a variance, a financial period or for the module itself.
    • zoom on the source journal from the individual variance.
  9. DataRapt has written a data extract to facilitate investigation of specific problems. The extract (which, for confidentiality, anonymizes the data) has been designed to create an extremely space-efficient data file that is usually small enough to email to us. This innovative extract allows us to offer a quick turnaround to support queries from our resellers and customers.
  10. DataRapt provides a working area within the reconciliation to which you can move variances, no matter their classification. This provides a powerful tool for analysing differences.
  11. In several modules, DataRapt provides a movement schedule that assists in checking the detailed sub-ledger balance against SYSPRO reports and, in some cases, highlights erroneous transactions.
  12. DataRapt has been providing balancing tools for over 10 years to companies in 29 countries.

And 1 more

  1. DataRapt’s products are very stable; in fact, across all the released versions of our products, we have encountered and corrected fewer than 0.5 bugs per 1000 lines of code.

If the reasons above are not convincing enough, why not watch our video demonstration and sign up for a free trial?

How the DataRapt free trial works:

  1. Complete the form to request a free trial
  2. Follow the instructions we send you to install the software (this can also be done by your DataRapt reseller)
  3. Send us an activation request file so that we can generate a trial key for you
  4. Apply the trial key, and you have 7 days to use and evaluate the system

Licensing the product

If you decide that you’d like to purchase a license, you have the option to purchase a standard license (which, like SYSPRO’s licensing, has an Initial License Fee and Annual License Fee portion, the ALF being payable annually) or rent it over a period of time.

Our 6-month rental license is the more economical choice for any period up to 3 years. If you opt to purchase two 6-month rental licenses up front, we give you a 10% discount.

For any period longer than 3 years, our standard licensing model makes more sense. If you are renting the product and feel that you would be better off on our standard license, we will refund your spend on your current 6-month rental license when you convert to the standard license.

Product Support

Experience tells us that DataRapt requires very little support, but if you do require some help, your DataRapt Reseller will be your first line of support. We’re always here to provide assistance, though, should you or your DataRapt Reseller need to escalate a support query to us. As we’ve already mentioned, if we need to look at your data in order to answer a query, our data extract really helps us to drill down into the data to find and respond to customer-specific queries with a fast turnaround time.

Tips for accountants as the calendar year draws to a close

With the holiday season just around the corner, things may be quietening down for some.

So for those of us with desk jobs, and by ‘us’ I mean accountants, it’s a great time to clear the leaning tower of Pisa. Not the one in Italy, which dating back to 1173, took 344 years to build and started leaning after 5 years, but the one in the ‘In-Tray’ which took almost no time to build and leans precariously with the inclusion, at times, of one-sided input.

However there is a lot more to an accountant’s life than dealing with and reacting to input from any number of different sources from both within and from outside the company.

It is a good time to put on a stethoscope and examine the overall health of the company.

For SYSPRO users, it’s good to know that DataRapt works tirelessly, 24/7 365 to keep tabs on the integrity of the fixed and working capital control accounts and, provides corrective action guidelines to resolve imbalances.

Tips for accountants as the calendar year draws to a closeHowever DataRapt cannot identify imbalances and other issues that may reside deep within the detailed sub-ledger supporting records. Hence the need for an in-depth look into the pertinent records to confirm or otherwise that, in the main, the investment in working capital is without deadwood, is in balance with demand, meets liquidity requirements and responds dynamically to market changes. Not something achieved and maintained without good teamwork.

While Santa Claus has the resources to meet the expectations of zillions of children of all ages, cultures and backgrounds, so accountants, with a somewhat smaller team, play a key role in the more demanding and ongoing requirement to manage company resources to generate wealth and maintain liquidity levels to meet the expectations of the diverse stakeholder groups.
It is again time to get together with colleagues to review and reflect on the company’s growth, financial and service delivery performance in the light of its mission statement objectives and the expectations of its stakeholders who are comprised of the entities and individuals who have a gainful interest in the company.

Internal stakeholders’ expectations are those of the individual employees and the infrastructure support service groups they comprise. To this end we encourage and endeavour to provide a supportive interactive working environment across the organisation to promote team spirit and individual self-worth and growth which is a key requirement for maintaining high performance company standards and meeting internal stakeholder expectations.

Communications, informal and in the course of business, pertinent company records and the company share performance provide the information required to determine external stakeholder satisfaction levels.

Last but not least, it is time to meet my own expectations of a welcome and eminently enjoyable break from the office leading up to a great year ahead that exceeds my expectations.

And on that note, all of us at DataRapt take this opportunity to wish you well over the holiday season. Whatever it is you choose to do, may it take you into the New Year with renewed inspiration.

Control Account and Balance Sheet Values

A balance sheet, at a given date, reflects a company’s net worth as the difference between the sum of its asset and liability values.

A company’s fixed asset values could run into many millions of dollars and include substantial and extensive investments in properties, plant, vehicles, furniture and equipment.

Control Account and Balance Sheet ValuesWhile detailed records of costs and depreciation provided are maintained for each and every asset, fixed asset control account balances (which of necessity need to be shown to agree with the sum of the corresponding detailed asset values) are recorded in the balance sheet.

A company cannot operate without working capital, which, in the balance sheet, is reflected as the sum of the following control account balances that, as with fixed assets, need to be shown to agree with the supporting detailed records which in turn are substantiated with reference to external documentation. The detailed records, particularly for the medium and larger companies, could annually record many thousands of transaction entries.

Cash and Bank Balances

Cash books may record details of thousands of payments and receipts annually which need to be reconciled and agreed with the corresponding entries in one or more bank accounts.

Customer Account Balances

Sub ledgers maintain details of large numbers of transaction details in customer accounts which are checked against and reconciled with the corresponding customer records.

Cost of Inventory Items on Hand

Inventory sub ledger records maintain details of a very large number of transactions in inventory accounts. (Inventory account on-hand quantities are checked against physical counts.)

Costs Incurred on Production Work in Progress

Details of all production costs incurred are recorded in a sub ledger which is maintained to reflect the costs of incomplete jobs.

Supplier Account Balances

Suppliers, by providing credit, contribute towards the funding of working capital.

Supplier sub ledger records maintain details of a large number of transactions in supplier accounts which are checked against and reconciled with the corresponding supplier records.

Importance of General Ledger Control Accounts

The sum of general ledger control account values reflects the bulk of stakeholder investment in the company and the integrity of the balance sheet may be seriously compromised where control account values differ from the supporting detailed records.

DataRapt’s Role

DataRapt’s automated functions are designed to identify variances daily and to email details to the parties concerned. This allows for corrective action to be taken timeously. With DataRapt, whatever the size of a company, there is no reason for balance sheet values to ever differ from the supporting detailed records.

Related reading:

Shopping Centres, DataRapt and Sarbanes-Oxley

What on earth could link Shopping Centres, DataRapt and Sarbanes-Oxley?

Let me explain.

In the late 1920s and in the early 1930s the phrase, “One Stop Shopping” was coined in America following the creation of shopping centres and, a successful business model which offered customers the convenience of having multiple needs met in one location.

The phrase today is used to describe everything from Web sites to TV shows where people can find most of what they need, including information, in one place.

This brings us to DataRapt, the “One Stop Information Source” that, insofar as is shown below, provides invaluable tools and information, (optionally on a day to day basis), that enhance a company’s internal controls which are at the heart of the Sarbanes-Oxley legislation.

The American Sarbanes-Oxley Act of 2002 provides for imposing horrendous penalties on the boards of directors and their corporations for publishing misleading financial statements. The directors are personally held accountable if internal controls, (their statutory responsibility), were not implemented and maintained to ensure the ongoing day to day accuracy of a non-porous financial pipe line.

Furthermore, internal control failures may need to be disclosed to shareholders where material errors are found and corrected by the auditors, particularly if, but for the auditors, the discrepancies would not have been picked up.

Apart from Sarbanes-Oxley and the demands of International Accounting Standards, it is of prime importance to accountants to provide a constantly reliable source of on-time and accurate financial operating reports and statements. This can be achieved only if, at the time of reporting, the financial source data is complete and accurate.

General ledger accounts are maintained to record, in financial values, the sum of all the transactions and activities in a company and a record of the company’s assets, liabilities and reserves.

An important internal control requirement is the substantiation of all of a company’s balance sheet values with reference to and reconciliation with conclusive external or internal sources and to ensure the required approvals are in place and that all assets and liabilities have been brought to account.

In addition there is a need to regularly review and, where necessary, analyse and summarise expense and income accounts with reference to the source of transactions that require proof of approval or an explanation.

DataRapt Sarbanes-Oxley and the Balance Sheet

Fixed Assets and Working Capital General Ledger Accounts

DataRapt proactively contributes to the ongoing function of checking and maintaining the integrity of balance sheet values that comprise a company’s investment in working capital and fixed assets which are substantiated by the transaction details recorded in sub ledgers.

New meaning is given to “Internal Control” as DataRapt automatically checks the financial dataflow of every transaction in a company’s sub-ledgers with the following objectives;

Parties automatically advised by email, when a sub ledger is out of balance with the corresponding general ledger account value included in the balance sheet.

Variances and their source identified and documented.

The What Next?” feature provides insight into the possible or likely cause of each variance together with suggestions for corrective action.

Supplier Prepayments

DataRapt has a product that provides for complete visibility and tight control over all aspects of supplier prepayments.
Prepayments are automatically posted to and cleared from a Balance Sheet General Ledger Account which is substantiated by reports detailing the transaction entries and the make-up of the account balance at any time.

Other Balance Sheet Accounts

As detailed below, DataRapt’s General Ledger Reconciliation module facilitates the reconciliation and justification of balance sheet account values allowing, as it does, for links with or reference to supporting documentation for account verification purposes and other documents providing proof that transactions are authorised as required.

The module provides the means and access to source information to readily analyse, summarise and review transactions within a given range of periods for a selected account or for a predefined group of accounts, (identified by a code description), which also facilitates the analysis and review of income and revenue accounts.

The comprehensive transaction details which are displayed in a listview may be categorized and, optionally, removed from the listview when using a facility to accumulate them into user defined groups with descriptions and system generated ID codes.

At transaction level:

  • Source journal details may be viewed.
  • A user defined status code and a description may be attached.
  • Notes may be attached using the note pad provided.
  • A facility to link supporting documents is provided.
  • SYSPRO listview styles may be used to highlight transactions.
  • User defined functions may be controlled with electronic signatures.

A listview displays balances and movements for the selected general account or account group for each period within the selected range of periods.

What more does one need?

Please let us know.

Balancing Acts Without a Tightrope

TightropeWalker
I recently read an interesting post about “How to become an expert tightrope Walker” by Erin Loury.

Erin starts the article with the following: “Life is a constant balancing act, especially if you’re a tightrope walker. The best athletes make treading a circus high wire or a low-hanging slackline look effortless, but they’re actually juggling complex challenges of perception and motor control. Now researchers have constructed a mathematical explanation of how such nimble acrobats remain upright. Their calculations point to a theoretical “sweet spot,” or optimal conditions for a person to balance on a line with minimal effort. Such a model may help scientists better understand how the brain and body work together to pull off difficult tasks.”

[If you’re interested in seeing the rest of the article, which I strongly recommend, you can find it on the Sciencemag site – tightrope article.]

After reading the article, it occurred to me that it is not only the tightrope walker who depends on balancing expertise to remain on track; we all do, in every walk of life!

My thoughts went along the following lines:

  • Quality of life

    The quality of our lives is undermined to the extent to which we do not succeed in maintaining a balance in our life style.

  • Broken Bones

    Elderly citizens face the challenging need to always maintain their balance to avoid breaking bones.

  • Relationships

    A balance needs to be maintained in relationships and attitudes. Predominately one-sided relationships tend to break down and extreme attitudes invite conflict.

  • On The Sports Field

    Ball players, in particular, have a basic need to consistently maintain their balance when they strike the ball, or else frustration!

  • Budgets

    Countries, companies and just about everyone else live with the ongoing, and often challenging, need to balance expenditure with income, at times, to avoid disastrous consequences.

  • Balance Sheets

    Out-of-balance control accounts are an accountant’s nightmare because the integrity of the balance sheet is at stake and the variances need to be resolved before the financial statements are released.

Imagine software that independently, reliably and automatically emails reports to financial directors and managers to draw attention to control account variances that they would otherwise not be aware of.

Further imagine that the source of each variance is identified and guidelines are provided for their resolution.

Such software would provide financial managers and their staff respectively with an efficient and cost effective means of control over and the maintenance of the integrity of the company’s fixed asset and working capital control accounts.

The good news is that our product, DataRapt, currently used successfully in 29 countries has all the above and many more features.

With DataRapt, the early detection and resolution of control account variances enables staff to spend their time more productively.

Why not contact us to discuss how we can help improve your company’s balancing act?