I Can See Clearly Now: Maintaining Required Levels of Transparency for IFRS Reporting

Are spreadsheets still a part of your IFRS (International Financial Reporting Standards) reporting process? For most companies, the answer is yes – thanks in large part to the complex requirements of IFRS, spreadsheets were often put in place to bridge the gap between the reporting differences in ERP systems and IFRS during the initial conversion to IFRS. This practice worked because making changes to the ERP system before going through an IFRS cycle could have led to obtuse and costly workarounds in the long run – but the continued use of spreadsheets causes even greater problems. Spreadsheets are prone to error, burdensome to maintain and less secure than dedicated applications with built-in controls.

Ideally, post-audit requirements have been established, and these requirements were mapped to specific changes in the ERP system. In many cases, these changes have not occurred, and some ERP areas to address moving forward include:

  • Existing data may need to be aggregated in different ways. In some cases, more granular information is needed – for example, to prepare component depreciation calculations, as much as 10+ years of data may be required.
  • The chart of accounts and cost center structures may need to be redesigned.
  • All balance sheet validation should be reviewed and must include a multi-year valid audit trail.
  • The IFRS standards require additional and changed information and disclosures for financial reporting purposes. Compiling these details will require multiple years’ worth of drill-down information.

See also the Pocket Guide to IFRS Standards: the global financial reporting language

While taking all of these factors into consideration, changes made to an ERP system should be based on one controlling principle: transparency. For financial reporting purposes, transparency is defined as ensuring that full drill-down (vouching) and push-up (tracing) is maintained. Drill-down, or vouching, means that all reported IFRS balances, financial performance, and disclosure amounts can be easily vouched to underlying data within the ERP system and then to the source document – e.g., bill, check, shipping manifest, etc. Drill-down is essential for annual audits of assets and owner’s equity. Push-up, or tracing, means that it is possible to trace any amount from the underlying ERP system into the reported IFRS balances, financial performance, and disclosure amounts. Push-up is essential for annual audits of liabilities and owner’s equity. Failure to maintain transparency both ways is a costly mistake that will lead to a more burdensome and lengthier audit.


IFRS Compliance — the Requirement for Transparency

Since IFRS guidelines do not explicitly require transparency, the concept is an area of much confusion for both preparers and users of financial information. Because of the level of detail required for reporting – including presenting multi-period balances and performance, supporting financial statement disclosure, providing an adequate audit trail, and providing comprehensive information for external auditors – close to full transparency into at least ten years’ worth of ERP financial information is needed.

Failure to maintain adequate transparency and drill-down at all levels of the financial reporting systems can result in increased risks to the organization, such as:

  • Financial reporting and supporting processes being manual and more time-consuming.

  • Misstated financial statements results due to missed adjustments or incorrectly calculated manual adjustments.

  • Difficulty in tracking and maintaining topside adjustments over time.

Because it is a universal truth that accountants love their spreadsheets and that their standard operating procedure for financial reporting tends to be SALY (same as last year), it is very tempting to continue to use the ad-hoc solution from first-year IFRS conversion – that is, leaving the underlying ERP system(s) the same, following generally local GAAP, and then just continuing to use those first-year spreadsheets to bridge the gap. This temptation is understandable, because the initial IFRS conversion was exhausting! But, as a continued process, this solution compromises full transparency and is, in general, a poor idea.

 

GL Consolidation Doesn’t Work

The simple litmus test for whether an IFRS reporting solution is fully transparent is to test each direction, drill-down and push-up. Ideally, all balances and reporting information is maintained in one ERP system. That said, organizational constraints may prevent this. As a result, when multiple ERP systems are used for entity wide IFRS reporting, it may be necessary to export the transaction and balance information, then import it into a larger, corporate reporting system. If all books and records are maintained within one ERP instance, full transparency is generally the result.

When a company uses a consolidating ledger set up a secondary ledger with subledger accounting. With a multi-instance reporting environment, the risk of not achieving bi-directional transparency is significant.

Two of the more common solutions used for multi-instance reporting environments are external reporting tools (such as Hyperion) or a data warehouse. If significant transformations are made to the data from multiple instances to make them suitable for IFRS reporting, or if additional transformations are made in the corporate reporting system, transparency may be lost because there is not a clear way to drill down to the detail. Additionally, loss of transparency will occur if charts of accounts and calendars in all reporting systems are not consistent and rationalized for IFRS compliance. This occurs because the transformation code that is required to rationalize disparate charts of accounts or calendars can be changed without providing an audit trail or enforcing data integrity from the transaction system (Oracle® E-Business Suite) and the reporting system.

 

Conclusion

IFRS can be a painful, but necessary process. But with careful planning and attention given to maintaining full transparency, the IFRS reporting process can become an efficient one for creating financial statements and, more importantly, completing the annual audit process.

Download PDF

522 thoughts on “I Can See Clearly Now: Maintaining Required Levels of Transparency for IFRS Reporting”

  49. Peterdex says:

    Kamagra pharmacie en ligne [url=https://kamagraprix.com/#]Achetez vos kamagra medicaments[/url] kamagra gel

  55. Peterdex says:

    Acheter Viagra Cialis sans ordonnance [url=http://tadalmed.com/#]cialis generique[/url] Pharmacie en ligne Cialis sans ordonnance tadalmed.com

  61. Peterdex says:

    pharmacies en ligne certifiГ©es [url=https://pharmafst.shop/#]pharmacie en ligne pas cher[/url] pharmacie en ligne livraison europe pharmafst.shop

  66. Peterdex says:

    Kamagra Oral Jelly pas cher [url=https://kamagraprix.com/#]achat kamagra[/url] acheter kamagra site fiable

  72. Peterdex says:

    kamagra gel [url=http://kamagraprix.com/#]Acheter Kamagra site fiable[/url] kamagra pas cher

  78. Peterdex says:

    acheter mГ©dicament en ligne sans ordonnance [url=https://pharmafst.com/#]pharmacie en ligne[/url] Pharmacie en ligne livraison Europe pharmafst.shop

  83. Peterdex says:

    п»їpharmacie en ligne france [url=https://pharmafst.shop/#]Livraison rapide[/url] Pharmacie en ligne livraison Europe pharmafst.shop

  98. Peterdex says:

    pharmacie en ligne fiable [url=https://pharmafst.com/#]Medicaments en ligne livres en 24h[/url] pharmacie en ligne france fiable pharmafst.shop

  104. MichaelFuB says:

    canadian pharmacy near me [url=http://expressrxcanada.com/#]Canadian pharmacy shipping to USA[/url] trustworthy canadian pharmacy

  110. MichaelFuB says:

    MedicineFromIndia [url=http://medicinefromindia.com/#]cheapest online pharmacy india[/url] Medicine From India

  115. MichaelFuB says:

    Rx Express Mexico [url=https://rxexpressmexico.com/#]RxExpressMexico[/url] mexico pharmacies prescription drugs

  121. MichaelFuB says:

    pharmacy wholesalers canada [url=https://expressrxcanada.shop/#]Generic drugs from Canada[/url] pharmacy canadian superstore

  132. MichaelFuB says:

    reliable canadian pharmacy [url=https://expressrxcanada.com/#]ExpressRxCanada[/url] best canadian online pharmacy

  137. MichaelFuB says:

    best india pharmacy [url=https://medicinefromindia.shop/#]indian pharmacy online[/url] Medicine From India

  142. MichaelFuB says:

    mexican online pharmacy [url=http://rxexpressmexico.com/#]RxExpressMexico[/url] mexican online pharmacy

  151. Richardanock says:

    пин ап зеркало [url=http://pinuprus.pro/#]пин ап казино[/url] пин ап зеркало

  156. Richardanock says:

    пин ап казино [url=https://pinuprus.pro/#]пинап казино[/url] пин ап зеркало

  171. Richardanock says:

    вавада зеркало [url=https://vavadavhod.tech/#]vavada[/url] vavada casino

  181. Richardanock says:

    пин ап казино [url=http://pinuprus.pro/#]пинап казино[/url] пинап казино

  187. Richardanock says:

    пинап казино [url=http://pinuprus.pro/#]пин ап вход[/url] пин ап казино

  191. Richardanock says:

    pin up вход [url=http://pinuprus.pro/#]пинап казино[/url] пин ап казино

  206. Richardanock says:

    пин ап зеркало [url=http://pinuprus.pro/#]пин ап казино[/url] пин ап зеркало

  208. Richardanock says:

    vavada вход [url=https://vavadavhod.tech/#]вавада казино[/url] вавада казино

  221. Richardanock says:

    vavada [url=http://vavadavhod.tech/#]vavada casino[/url] вавада казино

  224. Richardanock says:

    вавада казино [url=https://vavadavhod.tech/#]вавада зеркало[/url] vavada casino

  228. Richardanock says:

    пин ап вход [url=https://pinuprus.pro/#]пинап казино[/url] пин ап зеркало

  232. Richardanock says:

    вавада казино [url=http://vavadavhod.tech/#]vavada casino[/url] vavada casino

  241. Richardanock says:

    vavada casino [url=https://vavadavhod.tech/#]вавада казино[/url] вавада казино

  245. Richardanock says:

    вавада зеркало [url=http://vavadavhod.tech/#]вавада зеркало[/url] вавада казино

  254. Richardanock says:

    пин ап зеркало [url=https://pinuprus.pro/#]пинап казино[/url] пин ап вход

  258. Richardanock says:

    vavada вход [url=http://vavadavhod.tech/#]вавада зеркало[/url] вавада официальный сайт

  262. Richardanock says:

    пин ап казино официальный сайт [url=http://pinuprus.pro/#]пин ап казино[/url] пин ап казино официальный сайт

  270. Richardanock says:

    vavada [url=http://vavadavhod.tech/#]вавада казино[/url] вавада казино

  296. Richardanock says:

    пинап казино [url=http://pinuprus.pro/#]пин ап казино официальный сайт[/url] пин ап казино официальный сайт

  300. Richardanock says:

    вавада казино [url=http://vavadavhod.tech/#]вавада официальный сайт[/url] вавада казино

  305. Lorenzoalera says:

    purchase Modafinil without prescription [url=http://modafinilmd.store/#]purchase Modafinil without prescription[/url] doctor-reviewed advice

  311. Lorenzoalera says:

    verified Modafinil vendors [url=https://modafinilmd.store/#]safe modafinil purchase[/url] modafinil 2025

  317. Lorenzoalera says:

    generic sildenafil 100mg [url=http://maxviagramd.com/#]buy generic Viagra online[/url] discreet shipping

  321. Lorenzoalera says:

    generic sildenafil 100mg [url=https://maxviagramd.shop/#]secure checkout Viagra[/url] best price for Viagra

  324. Lorenzoalera says:

    secure checkout ED drugs [url=https://zipgenericmd.com/#]online Cialis pharmacy[/url] generic tadalafil

  330. Lorenzoalera says:

    modafinil 2025 [url=https://modafinilmd.store/#]buy modafinil online[/url] Modafinil for sale

  336. Lorenzoalera says:

    reliable online pharmacy Cialis [url=http://zipgenericmd.com/#]best price Cialis tablets[/url] best price Cialis tablets

  341. Lorenzoalera says:

    Cialis without prescription [url=http://zipgenericmd.com/#]reliable online pharmacy Cialis[/url] cheap Cialis online

  346. Lorenzoalera says:

    buy generic Cialis online [url=https://zipgenericmd.com/#]cheap Cialis online[/url] online Cialis pharmacy

  351. Lorenzoalera says:

    fast Viagra delivery [url=http://maxviagramd.com/#]order Viagra discreetly[/url] safe online pharmacy

  357. Lorenzoalera says:

    discreet shipping ED pills [url=https://zipgenericmd.com/#]buy generic Cialis online[/url] buy generic Cialis online

  362. Lorenzoalera says:

    discreet shipping [url=http://maxviagramd.com/#]cheap Viagra online[/url] same-day Viagra shipping

  367. Matthewvek says:

    amoxicillin 500 mg online [url=https://amohealthcare.store/#]price for amoxicillin 875 mg[/url] where can i buy amoxicillin without prec

  372. Matthewvek says:

    can i purchase generic clomid without prescription [url=https://clomhealth.shop/#]get cheap clomid without a prescription[/url] where can i buy clomid without rx

  377. Matthewvek says:

    prednisone 300mg [url=http://prednihealth.com/#]buy prednisone online canada[/url] PredniHealth

  389. Matthewvek says:

    cost of clomid online [url=https://clomhealth.com/#]can i get generic clomid pills[/url] can i buy clomid

  393. Matthewvek says:

    how can i get clomid [url=https://clomhealth.shop/#]Clom Health[/url] where can i get cheap clomid price

  397. Matthewvek says:

    PredniHealth [url=https://prednihealth.shop/#]PredniHealth[/url] generic prednisone for sale

  402. JosephGaire says:

    order cialis canada [url=https://tadalaccess.com/#]Tadal Access[/url] when does cialis patent expire

  407. JosephGaire says:

    cialis dopoxetine [url=https://tadalaccess.com/#]cialis overnight deleivery[/url] cialis with dapoxetine 60mg

  411. JosephGaire says:

    cialis overdose [url=https://tadalaccess.com/#]can you drink alcohol with cialis[/url] where to buy cialis soft tabs

  415. JosephGaire says:

    nebenwirkungen tadalafil [url=https://tadalaccess.com/#]Tadal Access[/url] cialis going generic

  419. JosephGaire says:

    cialis premature ejaculation [url=https://tadalaccess.com/#]TadalAccess[/url] cialis high blood pressure

  423. JosephGaire says:

    cialis dopoxetine [url=https://tadalaccess.com/#]cialis generic canada[/url] how much does cialis cost at walmart

  427. JosephGaire says:

    maxim peptide tadalafil citrate [url=https://tadalaccess.com/#]TadalAccess[/url] cialis high blood pressure

  432. JosephGaire says:

    order cialis soft tabs [url=https://tadalaccess.com/#]cialis over the counter at walmart[/url] originalcialis

  437. JosephGaire says:

    cialis online aust [url=https://tadalaccess.com/#]Tadal Access[/url] does cialis make you last longer in bed

  441. JosephGaire says:

    tadalafil and ambrisentan newjm 2015 [url=https://tadalaccess.com/#]Tadal Access[/url] cialis used for

  445. JosephGaire says:

    mint pharmaceuticals tadalafil [url=https://tadalaccess.com/#]buy cialis online without prescription[/url] cialis and nitrates

  449. JosephGaire says:

    cialis and nitrates [url=https://tadalaccess.com/#]when does tadalafil go generic[/url] cialis high blood pressure

  453. JosephGaire says:

    usa peptides tadalafil [url=https://tadalaccess.com/#]TadalAccess[/url] how long before sex should you take cialis

  457. JosephGaire says:

    free cialis samples [url=https://tadalaccess.com/#]generic tadalafil prices[/url] how long for cialis to take effect

  461. JosephGaire says:

    tadalafil liquid fda approval date [url=https://tadalaccess.com/#]what is the normal dose of cialis[/url] tadalafil (tadalis-ajanta)

  465. JosephGaire says:

    cialis online usa [url=https://tadalaccess.com/#]TadalAccess[/url] cialis using paypal in australia

  471. JosephGaire says:

    india pharmacy cialis [url=https://tadalaccess.com/#]what doe cialis look like[/url] is cialis a controlled substance

  479. JosephGaire says:

    tadalafil 5mg once a day [url=https://tadalaccess.com/#]Tadal Access[/url] buy cheap tadalafil online

  483. JosephGaire says:

    tadalafil 40 mg india [url=https://tadalaccess.com/#]maxim peptide tadalafil citrate[/url] cialis price costco

  487. JosephGaire says:

    cialis alternative over the counter [url=https://tadalaccess.com/#]TadalAccess[/url] buy cialis canada

  491. JosephGaire says:

    cialis canadian purchase [url=https://tadalaccess.com/#]Tadal Access[/url] cialis payment with paypal

  495. JosephGaire says:

    cialis over the counter at walmart [url=https://tadalaccess.com/#]cialis free trial voucher[/url] cialis online no prescription australia

  499. JosephGaire says:

    cialis vs sildenafil [url=https://tadalaccess.com/#]cialis otc 2016[/url] cialis 20 milligram

  504. JosephGaire says:

    does medicare cover cialis [url=https://tadalaccess.com/#]cialis discount coupons[/url] cialis tadalafil 5mg once a day

  508. JosephGaire says:

    buy cialis online in austalia [url=https://tadalaccess.com/#]cialis dosage 20mg[/url] cialis advertisement

  512. JosephGaire says:

    is there a generic cialis available [url=https://tadalaccess.com/#]when will generic cialis be available in the us[/url] cialis back pain

  517. JosephGaire says:

    side effects of cialis tadalafil [url=https://tadalaccess.com/#]tadalafil review forum[/url] buying cialis without prescription

  521. JosephGaire says:

    cialis dapoxetine europe [url=https://tadalaccess.com/#]purchase cialis[/url] is tadalafil and cialis the same thing?

Leave a Reply

Your email address will not be published. Required fields are marked *