Universal Accounting Analyzer
Dashboard Overview
Active Clients
24
Pending Reconciliations
8
Data Imports Today
5
Identified Exceptions
12
Recent Activities
Imported trial balance for ABC Corp
10 minutes ago
Completed reconciliation for XYZ Ltd
2 hours ago
Generated Sankey diagram for Global Inc
5 hours ago
Identified 3 exceptions in Tech Solutions
Yesterday
Quick Actions
Client Management
Manage all audit clients and their information
| Client Name | Industry | Standard | Last Import | Status | Actions |
|---|---|---|---|---|---|
|
ABC Corporation
Cape Town
|
Manufacturing
|
IFRS | 2023-06-15 | Active | |
|
XYZ Limited
Johannesburg
|
Technology
|
IFRS for SMEs | 2023-06-10 | Pending | |
|
Global Industries
Durban
|
Retail
|
IFRS | 2023-05-28 | Active | |
|
Tech Solutions
Pretoria
|
Software
|
IFRS for SMEs | 2023-05-15 | Inactive |
Data Import
Import trial balances, general ledgers and other accounting data
Import New Data
or drag and drop
Excel, CSV or TSV up to 10MB
Recent Imports
Trial Balance - ABC Corp
Imported 15 minutes ago
Success: 120 accounts processed
General Ledger - XYZ Ltd
Imported 2 hours ago
Error: 3 invalid transaction dates
Subledger - Global Inc
Imported yesterday
Success: 1,245 transactions processed
Trial Balance - Tech Solutions
Imported 2 days ago
Warning: 5 accounts with zero balances
Reconciliation Analysis
Perform trial balance and account reconciliations with automated validation
Run Reconciliation
Reconciliation Results
ABC Corporation - Trial Balance Reconciliation
Period: 01 Jan 2023 - 31 Mar 2023
Accounts Processed
142
Reconciled
138
Exceptions
4
Reconciliation Progress
97% complete
| Account | Description | Status | Difference |
|---|---|---|---|
| 1000 | Cash and Cash Equivalents | Reconciled | - |
| 1100 | Accounts Receivable | Reconciled | - |
| 1200 | Inventory | Exception | 12,450.00 |
| 2000 | Accounts Payable | Reconciled | - |
| 3000 | Share Capital | Exception | 5,000.00 |
Exception Details
Account 1200 - Inventory
Difference: ZAR 12,450.00
Opening balance + GL movement does not equal closing balance. Possible inventory counting error or missing transactions.
Account 3000 - Share Capital
Difference: ZAR 5,000.00
Equity account movement doesn't match income statement balances. Possible dividend declaration not recorded.
Account 4000 - Revenue
Difference: ZAR 0.00
All revenue transactions properly accounted for in the period.
Reconciliation Notes
Sankey Analysis
Visualize transaction flows between accounts for audit understanding
Configuration
Cash Flow Visualization
ABC Corporation | 01 Jan 2023 - 31 Mar 2023 | Showing flows ≥ ZAR 5,000.00
Sankey diagram will appear here
Select accounts and click "Generate Diagram"
Key Observations
Revenue (4000) flows primarily to Accounts Receivable (1100) and Cash (1000) as expected for this retail business.
Unusually large flow (ZAR 45,200) from Accounts Payable (2000) to Operating Expenses (6000) in February - verify supporting documentation.
Missing expected flow from Inventory (1200) to Cost of Sales (5000) - potential inventory recognition issue.
Correlation Analysis
Identify statistical relationships between accounts for risk assessment
Analysis Parameters
Analysis History
ABC Corporation - Q1 2023
8 accounts | Pearson | 15 Apr 2023
XYZ Limited - Monthly 2022
12 accounts | Spearman | 2 Mar 2023
Global Industries - FY2022
6 accounts | Pearson | 15 Feb 2023
Correlation Matrix
ABC Corporation | Quarterly Analysis (Q1 2022 - Q1 2023) | Pearson Correlation
