Year end audits – let SAGE 300 carry the burden

Apr 18, 2019

Maintenance of accurate and comprehensive financial statements is not only a good accounting practice but also a part of quality corporate governance. Many of the organizations use various business applications and accounting software to facilitate this cause. However, irrespective of the size of the organization, the accounting departments are going through chaotic situations as a usual struggle during the time of financial audits.

Why does this happen and continue from one audit to another?

Bank reconciliations in regular intervals would be performed as the cash and bank balances are considered to be highly vulnerable where the most audits and transparency is required. 90% of the other transaction items in the balance sheet and the income statement rarely get the nearest importance of audits as bank reconciliations. Especially when the audit happens once a year, the accountants find it hard to prove the material accuracy of financial statements, as they should have auditable evidence to support every line item on the balance sheet as well as key revenue and expense accounts.

Audit preparation

The auditors request client prepared schedules and this may include;

  • Bank reconciliations
  • Accounts payable aging
  • Accounts payable transactions listing
  • Accounts receivable aging
  • Accounts receivable transactions listing
  • foreign exchange gain and loss reports
  • Inventory movement and balances listing
  • Fixed assets schedule etc

Based on the organization’s business complexity and the industry in, the list can be a lengthy one and whatever is considered material to the fair and accurate representation of the financial statements should be supported.

Preparing this information at each year audit is a challenging task and it demands a lot of time and concentration which can affect the day to day operation of the business. One of the best methods to minimize this work load is to establish an internal accounting review which simulate the year end audit and maintain the key accounting schedules on an on-going basis. Enforce a policy that sub ledger schedules are generated monthly and tally them with the GL control accounts. Consistent review process would ascertain the transactions are accurately recorded and always be supported by the verifiable evidences. Undoubtedly such a mechanism would make the accounting and finance team lives easy as they have already prepared most of the schedules auditors may request.

In an environment that a robust system is in place with the users who know how and when to generate the accurate schedules, implementation of this year-round audit process is very much a practical solution. Sage 300 is equipped with number of reporting options to help build and maintain year-round accounting review structure that would ease and simplify the year end audit agitation and efficiently improve the business intelligence of the company.

General Ledger Reports

Being the core accounting module in the ERP, GL trial balance and the Transaction Listing report provides majority of the audit trails. Generated in crystal reports preview but anytime can be converted to an MS Excel file on which further analysis could be done. As a renowned accounting software, previously known as Accpac now Sage 300 ERP, the fundamental logic has been developed that each monetary transaction would result in a double entry in the General Ledger. Trial balance simply provides the ending balance of each GL account for a specific period. Transaction listing report details out the line wise entries in a GL account from the sub-ledgers and the general ledger. This can be generated for a specific account, accounts groups or using specific transactional analysis dimensions to create the desired schedules.

Quite often auditors inquire the directly posted General Ledger Journal Entries, Posting Journal report can provide the evidence along with the source journal report. This can be further strengthened with customized crystal report for Journal Vouchers. Any correction entries would be facilitated with the audit trails of posting journal errors.

Financial Reporter is another fantastic tool built in General Ledger Function. Through macros Sage 300 pull out the general ledger data to predefined MS Excel templates. This template creation doesn’t need any programming skill and it brings enormous flexibility to customize the reports. Accounting schedules and reports could be varying from auditors’ requirements to the MIS demanded by other stakeholders. Since the users are enabled to do their own reports, Financial Reporter has gained much popularity among the Sage 300 users as a powerful tool to provide the ad hoc accounting schedules as and when auditors demand.

Sub-ledger Reports

The strong architecture of Sage 300 ERP has been one reason that it has been established in the market as one of the leading financial management software for over 30 years. Many of the financial and operational modules can be just plugged in and seamlessly integrate with the general ledger including the third party build add-on products.

Common schedules that auditors seek are readily available within Sage 300. Accounts receivable module provides the customer age analysis and customer transactions listing. Deposit slips report is a cross check for the bank receipt transactions. Accounts payable module provides vendor age analysis and vendor transactions listing. Check register is useful when reconcile with the bank for the payment made.  Inventory movement report, inventory valuation, aged inventory analysis, mark up analysis, sales statistics are some of the top audit picks that Sage 300 provides out of the box.

Generally, auditors are skeptical on the procurement function of the organization there are many internal controls also revolved around that. Purchase requisition to supplier payment made should have clear cut evidences for each transaction takes place. Sage 300 is very strong in this area and the base module is designed in such a way Requisition to PO, PO to GRN, GRN to Supplier invoice and then to the payment. This 3-way PO matching is one of the top prioritized procurement audit elements where Sage 300 assist perfectly. Purchase order module provides strong reconciliation

Sage 300 Document Attachments

Sage 300 provides number of document attachment solutions. They can effectively enhance the ERP by providing space to attach the source documents and retrieve them subsequently as and when required. Document management solutions allow the users to link scanned documents to Sage 300 and seamlessly integrate with common document management systems that they may already be using, such as One Drive, O365, Gdrive, etc. Sage 300 document attachment capability plays a vital role during the audit. When auditors request the proof of transactions, it’s very easy to provide them as the source documents are stored along with the transactions.


Final audit season should not create unnecessary pressure and unbearable workload. Sage 300 provides many straight forward audit reports which easily reconcile the sub-ledger balances with the general ledger. By default, there are key information captured the entered user, at what time stamp, deleted by who, etc. That can be further intensified by advanced modules like audit logger which can provide the audit snaps of changes of information. Eg: If a master file has been modified, what was the status prior to modification and done by which IP address. These strong controls in place proficiently make sure the audit goes smoothly.

In the News…

More Blogs…

How Copilot in Dynamics 365 Business Central can revolutionise your business 

In today’s fast-paced business world, staying competitive means embracing the latest technological advancements. This is where the powerhouse partnership of Copilot in Dynamics 365 Business Central can help you stay ahead of the curve. This dynamic duo is here to...

Latest features and updates in the M365 mobile app 

Enhanced Productivity with Copilot Chat  The Microsoft 365 mobile app remains an indispensable tool for staying productive while on the move, offering access to Word, Excel, PowerPoint, and PDFs. Now, it's even more powerful with Microsoft Copilot Chat and...

Dynamics Nav Vs Dynamics 365 Business Central: Benefits of upgrading to Business Central 

In the fast-paced world of business technology, staying ahead is not just an advantage; it's a necessity. With data vulnerabilities on an upward trend, it is crucial to protect company information at all costs. Gartner estimates that over 85% of organisations will...

ZILLIONe Takes Center Stage at Regional Tech Summit to Empower Tech Industry and Youth in Galle

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

Empower Your Business with ZILLIONe´s Microsoft FastTrack Services: Protecting Data, and Boosting Productivity

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

Exclusive benefits by ZILLIONe’s FastTrack ready partners to Microsoft 365 subscribers

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

Let´s Celebrate! ZILLIONe is officially “Great Place to Work” certified.

Advance systems today allow for preservation of multiple versions of databases that may be restored from different points in time.

5 reasons why your company needs a cloud recovery and backup plan

Advance systems today allow for preservation of multiple versions of databases that may be restored from different points in time.

Seal deals seamlessly with Microsoft Dynamics 365 Customer Service Solutions.

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

What’s new in Microsoft Teams – June 2022

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka