Transcription of ACL ESSENTIALS
1 ACCOUNTS RECEIVABLEACL ESSENTIALSGet insight into your ERP process health, compliance & financial exposurePageAnalyticNameDebtors age analysisAR Analytic 01 Debtor balances compared to credit limitsAR Analytic02 Debtors with credit balancesAR Analytic03 Outstanding debtors greater than 60 daysAR Analytic04 Customers with no credit limitsAR Analytic05 Change to customer credit limitsAR Analytic06 Version 2018/08Re-computes debtors ageingACCOUNTS PAYABLEPAGE 3 ACL ESSENTIALS ACCOUNTS RECEIVABLEACL ESSENTIALS | ACCOUNTS RECEIVABLE | AR_ANALYTIC_01_ARCS101 ContextDebtor age analysis provides a summary of outstanding debtor balances and period outstanding. This will assist with debtor management and ' Results Field NamesCompany CodeCompany NameCustomer NumberCustomer Credit LimitOutput Visualization ExamplesPAGE 4 Report CurrencySummary table of debtor age analysisTotal amount in reporting currency by customerPie chart of total amount in reporting currency by customerReport Amount 60 90 DaysReport Amount 90 120 DaysReport Amount >120 daysTotal Amount Report CurrencyReport Amount 0 30 DaysReport Amount 30 60 DaysCompares debtor closing balances to credit limits loadedPAGE 5 ACL ESSENTIALS ACCOUNTS RECEIVABLEACL ESSENTIALS | ACCOUNTS RECEIVABLE | AR_ANALYTIC_02_ARCS102 ContextDebtor trading limits should be assigned as this is an indication of the authorised exposure per debtor.
2 Debtor amounts owing are also managed in terms of the credit ' Results FieldsOutput Visualization ExamplesPAGE 6 Company CodeCompany NameCustomer NumberCustomer Credit LimitOutstanding Total AmountReport CurrencyBar graph of debtor balances compared to credit limits by customerPie chart of outstanding total amount by customerTotal Amount Report CurrencyCustomer NameExtracts all debtors with credit balancesPAGE 7 ACL ESSENTIALS ACCOUNTS RECEIVABLEACL ESSENTIALS | ACCOUNTS RECEIVABLE | AR_ANALYTIC_03_ARCS103 Results Field NamesOutput Visualization ExamplesContextThe debtor balance should always be a debit balance, amounts owing to the organisation. All credit balances should be investigated as this indicates amounts owed to the debtor by the 8 Company CodeCompany NameCustomer NumberCustomer NameTotal Amount Reporting CurrencyReport CurrencyCustomer Credit LimitSummary of all debtors with credit balancesPie graph of customers with credit balances by credit limitExtracts all outstanding debtors greater than 60 daysPAGE 9 ACL ESSENTIALS ACCOUNTS RECEIVABLEACL ESSENTIALS | ACCOUNTS RECEIVABLE | 'invoicesolderthan60days,whichisthetypic alnumberofdaysafterwhichtherecoverabilit yofdebtscomesintoquestion, debtors should be followed up on a regular basis to ensure that amounts owed are recovered in a timely manner.
3 This also assists in verifying the accuracy of the disclosed debtor 10 Output Results Field NamesOutput Visualization ExamplesCustomer NumberCompany CodeCompany NameCustomer NameReport CurrencyCustomer Credit LimitReport Amount 60 90 DaysTotal Amount Reporting CurrencyReport Amount 90 120 DaysReport Amount >120 daysSummary table of outstanding debtors greater than 60 daysTotal outstanding amount by customerTotal outstanding debtor amount by credit limit and customerExtracts customers with no credit limitsPAGE 11 ACL ESSENTIALS ACCOUNTS RECEIVABLEACL ESSENTIALS | ACCOUNTS RECEIVABLE | AR_ANALYTIC_05_ARCS105 , trading limits should be assigned to all customers as this is an indication of the authorised exposure per debtor. Customer amounts owing are also managed in terms of the credit 12 Output Results Field NamesOutput Visualization ExamplesCompany CodeCompany NameCustomer NumberCustomer NameCustomer Credit LimitAmount in Reporting CurrencyReport CurrencyAmount in Document CurrencyDocument CurrencyItem TextCreation DateTotal outstanding debtor amount by creation date and customerPie graph of customers with no credit limitsPie graph of customers with no credit limitsExtracts all changes to customer credit limitsPAGE 13 ACL ESSENTIALS ACCOUNTS RECEIVABLEACL ESSENTIALS | ACCOUNTS RECEIVABLE | AR_ANALYTIC_06_ARCS106 :Thisanalyticcanbeusedbyauditorstodetect unauthorizedchangestoacustomer' ' Results Field NamesOutput Visualization ExamplesContextCustomer trading limits should be assigned as this is an indication of the authorised exposure per customer.
4 Debtor amounts owing are also managed in terms of the credit 14 Company CodeCompany NameCustomer NumberCustomer Credit LimitDocument DateChange User IDChange Control DateCredit Limit Change DateChange User NameChange to customer credit limit by changed user name and credit limitChange to customer credit limit by changed date, credit limit and customerCustomer Nam
