{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Welcome","Summary Dashboard","Invoicing","Collections","Credit risk management","Cash reconciliation"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Summary Dashboard","index":1,"n_rows":50,"n_cols":6,"rows_kept":50,"cut":false,"hidden":false,"merged":[[21,1,22,4],[21,5,21,6],[22,5,22,6],[5,5,5,6],[6,5,6,6],[9,5,9,6],[10,5,10,6],[13,5,13,6],[14,5,14,6],[17,5,17,6],[18,5,18,6],[5,1,6,4],[9,1,10,4],[13,1,14,4],[17,1,18,4]]}
[]
[]
[]
[]
[]
[null,"Your overall AR automation status",null,null,null,{"$f":"C50","v":"NOVICE"}]
[]
[]
[]
[null,"Your invoicing automation status",null,null,null,{"$f":"Invoicing!$C$6","v":0}]
[]
[]
[]
[null,"Your collections automation status",null,null,null,{"$f":"Collections!C6","v":0}]
[]
[]
[]
[null,"Your credit risk automation status",null,null,null,{"$f":"'Credit risk management'!C6","v":0}]
[]
[]
[]
[null,"Your cash reconciliation automation status",null,null,null,{"$f":"'Cash reconciliation'!C6","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"AVERAGE(Invoicing!V24,Collections!V23,'Credit risk management'!V26,'Cash reconciliation'!V20)","v":0},{"$f":"IF(B50>=0.75, \"LEADER\", IF(B50>=0.5, \"COMPETENT\", IF(B50>=0.25, \"ADVANCED BEGINNER\", \"NOVICE\")))","v":"NOVICE"}]

{"sheet":"Invoicing","index":2,"n_rows":25,"n_cols":22,"rows_kept":25,"cut":false,"hidden":false,"merged":[[12,2,12,10],[1,1,1,3],[8,2,8,10],[9,9,9,10],[10,2,10,10],[11,2,11,10],[5,1,6,1],[5,2,5,4],[6,2,6,4],[19,2,19,10],[20,2,20,10],[13,2,13,10],[14,2,14,10],[15,2,15,10],[16,2,16,10],[17,2,17,10],[18,2,18,10]]}
[]
[null,"Invoicing Automation Scoring Scale"]
[]
[]
[]
[null,"Your invoicing automation status"]
[]
[]
[null,"Tasks","Check if automated. Drag the slider to indicate your level of automation."]
[null,null,"Manual",null,null,null,null,null,null,"Fully Automated"]
[null,"Capture purchase order details",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Create invoice templates",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Sending invoice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Setting up a recurring invoice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Tracking if customer has received and opened the invoice",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Sending payment reminder before the due date",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Tracking number of open invoices",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Tracking total accounts receivable amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Generate account statements",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Payment processing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP((SUM(V11:V23)/(COUNTA(B11:B20)*5)), 2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V24>=0.75, \"LEADER\", IF(V24>=0.5, \"COMPETENT\", IF(V24>=0.25, \"ADVANCED BEGINNER\", \"NOVICE\")))","v":"NOVICE"}]

{"sheet":"Collections","index":3,"n_rows":24,"n_cols":22,"rows_kept":24,"cut":false,"hidden":false,"merged":[[18,2,18,10],[19,2,19,10],[12,2,12,10],[13,2,13,10],[16,2,16,10],[15,2,15,10],[17,2,17,10],[14,2,14,10],[1,1,1,3],[8,2,8,10],[9,9,9,10],[10,2,10,10],[11,2,11,10],[5,1,6,1],[5,2,5,4],[6,2,6,4]]}
[]
[null,"Collections Automation Scoring Scale"]
[]
[]
[]
[null,"Your collections automation status"]
[]
[]
[null,"Tasks","Check if automated. Drag the slider to indicate your level of automation."]
[null,null,"Manual",null,null,null,null,null,null,"Fully Automated"]
[null,"Creating aging analysis report",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Assign overdue invoices to collection analysts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Collectors' worklist prioritization",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Verifying/checking deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Customer segmentation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Customer 360 degree view (Centralization of customer data)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Creating duning emails",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Adjust payment terms (e.g. extend payment due date)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Adjust credit limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Write-off the bad debt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Cash receivables forecasting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Predict delinquency and bad debt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(V11:V22)/(COUNTA(B11:B22)*5), 2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V23>=0.75, \"LEADER\", IF(V23>=0.5, \"COMPETENT\", IF(V23>=0.25, \"ADVANCED BEGINNER\", \"NOVICE\")))","v":"NOVICE"}]

{"sheet":"Credit risk management","index":4,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[[18,2,18,10],[21,2,21,10],[22,2,22,10],[23,2,23,10],[10,2,10,10],[11,2,11,10],[12,2,12,10],[13,2,13,10],[14,2,14,10],[15,2,15,10],[20,2,20,10],[19,2,19,10],[8,2,8,10],[9,9,9,10],[1,1,1,3],[16,2,16,10],[17,2,17,10],[5,1,6,1],[5,2,5,4],[6,2,6,4]]}
[]
[null,"Credit Risk Automation Scoring Scale"]
[]
[]
[]
[null,"Your credit risk automation status"]
[]
[]
[null,"Tasks","Check if automated. Drag the slider to indicate your level of automation."]
[null,null,"Manual",null,null,null,null,null,null,"Fully Automated"]
[null,"Real-time alerts when customers submit credit application form",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Real-time credit risk monitoring",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Alerts about customers' credit risk status change",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Revise credit limits for customers",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Rescore customers with real-time data",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Predict blocked orders",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Order release recommendations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Automatic currency conversions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Calculation of metrics such as average customers onboarding time",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Alerts before certificate expiry date of documents",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Customer creation & updation in ERP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"System driven Approval Workflows",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Data driven analytics(customer onboarding, reviews, risk class)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(V11:V24)/(COUNTA(B11:B24)*5),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V26>=0.75, \"LEADER\", IF(V26>=0.5, \"COMPETENT\", IF(V26>=0.25, \"ADVANCED BEGINNER\", \"NOVICE\")))","v":"NOVICE"}]

{"sheet":"Cash reconciliation","index":5,"n_rows":21,"n_cols":22,"rows_kept":21,"cut":false,"hidden":false,"merged":[[5,1,6,1],[5,2,5,4],[6,2,6,4],[8,2,8,10],[9,9,9,10],[15,2,15,10],[16,2,16,10],[17,2,17,10],[10,2,10,10],[11,2,11,10],[12,2,12,10],[13,2,13,10],[14,2,14,10]]}
[]
[null,"Cash Reconciliation Automation Scoring Scale"]
[]
[]
[]
[null,"Your cash reconcilation automation status"]
[]
[]
[null,"Tasks","Check if automated. Drag the slider to indicate your level of automation."]
[null,null,"Manual",null,null,null,null,null,null,"Fully Automated"]
[null,"Alerts about customers payments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Match customers payments with the right invoices (Cash application)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Match payments received with book of records (Cash reconciliation)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Identify deductions",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Manage deductions (e.g. dunning email to customer, apply discount code, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Customers can submit disputes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Alerts and notifications about disputes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Disputes resolution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(SUM(V11:V19)/(COUNTA(B11:B18)*5),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V20>=0.75, \"LEADER\", IF(V20>=0.5, \"COMPETENT\", IF(V20>=0.25, \"ADVANCED BEGINNER\", \"NOVICE\")))","v":"NOVICE"}]