usix product guide

Axon User Guide

From the moment you open a file to checking and saving the results, we explain the actual work order.

Axon performs its core analysis on your computer. This manual focuses on the free Axon features, while the paid accounting workflow product Soma is marked separately where applicable.

View the Soma workflow and pilot

Support by operating system

On Linux, analysis functionality is intact, with the only exception being the ability to connect directly to a running Microsoft Excel.

FeaturesWindowsLinux
Audit report verification, ledger analysis, MUSSupportedSupported
OpenDART public disclosure inquirySupportedSupported
MUS ↔ Desktop Excel LiveSupported
usix-vba Excel Ribbon Add-inSupported

01

installation

01.1

Download

Select the installation file that matches your operating system. The download button will always link to the latest public version.

  1. 1Windows selects the .exe file.
  2. 2Linux picks up the .deb file.
  3. 3Run the downloaded file and install it.
01.2Windows

signature warning

When you first install Windows, you may see a SmartScreen warning. This message appears because a public code signing certificate is not applied to the current deployment file.

signature warning screen
01.3Windows

Turn off SmartScreen

First, check that the file was received from the official download address and that the SHA-256 checksum displayed on the homepage matches. If they match, check the publisher and file name again in 'Additional Information' in SmartScreen and proceed with installation.

CheckIf the download address or checksum is different, do not run it, but delete the file and download it again from the official website.
01.4

Installation complete and automatic update

After installation, Axon will run automatically. Afterwards, when you run the program, it will check for new versions and update automatically, so you don't need to install them separately.

Installation complete and automatic update screen

02

Getting started

02.1

First Run — Agreement to Terms and Conditions and Beta Information

When you run it for the first time, a terms of use guide will open. After reading and agreeing to the full terms and conditions, you will be taken to the main workspace. Axon is currently in beta, so you'll see a BETA badge in the top left corner of your screen.

CheckThe analysis results are helpful data for business review. Be sure to check with the original material before making any important decisions or making submissions.
02.2

screen structure

In the left function bar, go to Auditing, Internal Accounting, Excel Tools, Help, Settings. The sidebar of the audit workspace contains audit reports, statements/settlement sheets, document/ledger analysis, DART financial statement inquiry, and account area tools. You can expand or collapse the document list or search conditions by pressing the arrow to the left of the item.

screen structure screen
02.3

status bar

You can check the OpenDART authentication key registration status in the status bar at the bottom of the screen. Change the screen theme, display language, and font size in the 'General' section of settings.

02.4

Feature differences between Windows and Linux

Audit report verification, ledger analysis and MUS sampling are available for Windows and Linux. The Live Roundtrip feature, which connects directly to a running desktop Excel, and the usix-vba Ribbon add-in are Windows-only.

TipOn Linux, enter audit values ​​on the Axon screen or use file export/import. The Windows Excel Live Connection screen displays those items separately.

03

Audit report analysis

03.1

Load report

You can open archived DSD files or search public audit reports in OpenDART. When you open a report, the financial statement body and notes appear in the document tree on the left.

  1. 1Select 'Open DSD File' or 'View in OpenDART'.
  2. 2Select your company and report.
  3. 3From the document tree on the left, open the financial statement or note you want to review.
TipOpenDART inquiry requires an authentication key. Please register first in settings.
Load report screen
03.2

Footing

Recalculate the totals and subtotals displayed in the table to find cells where there are differences. Amounts linked between financial statements, such as cash in the statement of financial position and end-of-period cash in the statement of cash flows, are also compared.

OutcomeCheck whether the reported amount matches the recalculated amount, the difference amount, and the original cell location.
TipThe default is automatic validation when the report is opened. If you have turned off automatic verification in the settings, you can run it directly by clicking 'Verify Total' in the toolbar.
Screen showing the current and previous period total verification results as TRUE in the synthetic financial position statement of the virtual company Example Industry
This is an example of virtualizing the company name and amount based on the verification results of an actual public audit report. At the time of verification, all 250 totals and subtotals calculated from 50 tables matched, and TRUE on the right side of the screen indicates that the reported amount matches the recalculated amount.
03.3

Mid-term (semi-annual/quarterly) report

Semi-annual and quarterly audit and review reports are also recognized. It separates the 4-column profit and loss (accumulated basis) and the structure contained in the consolidated and separate files and performs total verification, inter-statement conversion and annotation roll-forward (basic → end of the period). The 'Next Quarter Base Document' creates a framework for the next interim period of the same base, with dates and prose to be checked by the user.

03.4

Text/annotation amount line

Check whether the amount in the body of the financial statement matches the amount in the notes or other financial statements. It also shows unit differences and rounding differences that occur during the display process.

  1. 1Select the amount you want to check in the text.
  2. 2Check the corresponding amount and location provided by Axon.
  3. 3If there is a match, it is marked as 'no problem' and, if necessary, the corresponding cell is specified directly.
Audit report annotation results candidate list
You can distinguish between exact matches and candidates with simple differences for review.
03.5

Report Comparison/Electrical Ambassador

⚖️ When comparing audit reports left and right with other .dsds, changes, additions, and deletions are color-coded. 📑 The prior-period reconciliation matches both the previous year audit report and the current year financial statement text and notes, and also matches items with changed account names based on similarity and amount. The biography is automatically looked up by OpenDART, and if it is not found, you can specify the .dsd manually.

Summary of differences in audit report version comparison
Once the comparison is complete, item-by-item check any differences found in the financial statements and notes.
03.6

Carryover — Create the next draft

📥 'Carryover from previous period' creates a draft for the next period with the confirmed current period report. Raise all bases in the document by one (27th period → 28th period), and move the amounts from the current period column to the previous column. The values ​​in the statement of changes in capital and notes are also carried forward. Since the new basic amount cannot be known for the roll forward/change/decrease table, the form must be left blank, and descriptive contents such as dates and audit opinions must be edited manually. The results will open in a new tab without changing the original. It also provides protection against accidental overwriting of drafts with existing data.

03.7Windows

DSD ↔ Windows Excel Live Editing

Selecting 'Edit with Excel' will open the current report in Excel as it is running. Every time you save (Ctrl+S) in Excel, the changes are reflected on the Axon screen.

OutcomeIt uses Excel's familiar editing features while keeping DSD's tabular structure and Axon review screens together.
  1. 1First open the DSD report you want to review.
  2. 2Under 'DSD ↔ Excel', select 'Edit with Excel'.
  3. 3After editing and saving in Excel, check the cells reflected in Axon.
CheckThis feature requires desktop Excel running. After saving, be sure to compare the Axon screen with the original report.
Tool screen connecting DSD and Excel
Perform DSD import, Excel editing, electromapping and DSD saving tasks all in one place.
03.8

External Excel reflection and DSD storage

'Import Excel' reflects changes in an external .xlsx file into the current report while preserving the original formatting and XBRL. When you add a row to the table, you are prompted to select an account code (ACODE) from the standard accounting scheme.

  1. 1Check the .xlsx file you want to reflect and the target DSD.
  2. 2Review table changes and account code candidates.
  3. 3Save it as a new DSD and confirm it on the DART receipt verification screen.
CheckThe ability to create DSDs in Excel is in beta. You must pass DART acceptance verification prior to actual submission.
03.9

export

When saving in Excel, the financial statements and notes are each created on separate sheets. 'Include putting' saves the sum verification mark together, and 'Exclude putting' saves only the organized results without the verification mark. The current report can be saved again as DSD, and the report comparison results can be exported to Excel or HTML.

04

Accounting — Audit tools by account area

04.1

Inquiry form PDF → Excel conversion

You can convert multiple financial institution inquiry replies to Excel at once by selecting 'Convert Inquiry PDF' in the Account area of ​​the Accounting screen. Digital PDF recognizes the cell structure of tables, and scanned copies and PNG/JPG images are processed through character recognition.

OutcomeSave each reply file in the same folder as 'file name_time.xlsx' format. The conversion results should be checked against the original PDF.
  1. 1In your account area, select 'Convert Inquiry to PDF'.
  2. 2Select multiple PDF, PNG, or JPG files to convert.
  3. 3Check the completed list and the Excel results in the source folder.
Inquiry form PDF → Excel conversion screen
Screen for converting financial institution inquiry form PDF to Excel
If you select multiple inquiry PDFs, each file will be saved as an Excel file in the original folder.

05

Journal and ledger analysis

05.1

Ledger analysis in 24 seconds

The flow loads 1,640 rows of the fully synthetic ledger, checks the title row, and opens the monthly trend and account Pareto.

OutcomeYou can first see where the import settings and the two analysis screens lead.
CheckThe company name, client, and amount in the video are all virtual data created for demonstration purposes.
Fully synthetic demo · Import 1,640 rows → Monthly trend → Partner Pareto
05.2

Open/Column Mapping/Merge Files

Import CSV or Excel ledgers. In the import screen, specify a title row and columns for date, amount, and summary. Files divided by month can be created into one data set by ‘combining and opening multiple ledgers’.

  1. 1Select ‘Open Ledger File’.
  2. 2Specify the title row and columns to use for analysis.
  3. 3Check the preview and complete the import.
TipIf the title row is two lines or the column names are different in each file, make sure the actual transaction is displayed correctly starting from the first row in the preview.
Import screen confirming synthetic ledger row 1,641 as the last data row
After checking the title row and last data row, complete the import.
1,640 row ledger table consisting of virtual customers and synthetic amounts
After importing, review the date, document number, account subject, customer, debit, and credit columns in the table.
05.3

Ledger standardization

‘Ledger standardization’ organizes the Douzone account-specific ledger (.xls) or ERP ledger (CSV) into a standard table and verifies the totals for each account. If there is no document number in the original, a sequential number is assigned, and the detected form, number of transaction rows, and mismatched accounts can be checked on the results screen.

OutcomeCreate standard columns and account-specific total validation results to use in your analysis without overwriting the original.
05.4

Overlap, Pivot, Monthly Trend, Pareto

Track original transactions by displaying duplicate values ​​and pivoting, and compare the number and amount of transactions by account in monthly trends. Pareto analysis shows the amount and cumulative ratio for each customer and account.

OutcomeNarrow down follow-up review to spikes in specific months and amounts concentrated in a small number of customers/accounts.
Bar and line graph showing monthly amount and number of transactions in synthetic ledger
Compare the monthly amount bars and transaction count lines together.
Pareto graph showing the amount and cumulative ratio for each customer in the synthetic ledger
Confirm concentration by ranking of amount and cumulative ratio for each customer.
05.5

distribution analysis

Compares the first digit of the amount to the expected distribution from Benford's law and looks for transactions with a constant ending digit.

CheckDistribution differences are not definitive evidence of error. Review deal nature, pricing policy and population mix together.
05.6

calculation column

Derived columns such as debit−credit are added as calculated columns and used for verification. The calculation results are added to the current workspace and do not change the original file.

05.7

MUS (Monetary Unit Sampling)

Extract a monetary sample by specifying an amount column, importance amount, and confidence level. Enter the audit confirmation amount of the sample and the upper error limit (UEL) and decision result will be calculated.

OutcomeCreate a list of extraction intervals and samples, enter the confirmation amount, and then display expected error, basic precision, upper limit error, and whether additional procedures are needed.
  1. 1Select 'MUS' and specify the Amount column.
  2. 2Enter the importance amount and confidence level to extract a sample.
  3. 3In 'MUS Assessment', enter the audit confirmation amount and check the results.
CheckPerformance materiality, confidence level and error evaluation method must be confirmed by the reviewer in accordance with the audit methodology of the engagement.
MUS screen specifying debit and performance importance of KRW 50 million and confidence level of 95 percent in synthetic ledger
Specify the Amount column, Performance Importance, and Confidence Level.
List of 208 MUS samples extracted from fully synthetic ledger
This composite example took 208 samples.
Evaluation screen indicating that upper margin of error exceeds performance significance for synthetic MUS samples and additional procedures are required
Check whether the evaluation component and the upper error limit exceed the performance criticality.
05.8Windows

MUS ↔ Windows Excel Live Roundtrip

Extracted samples are sent to running Excel, entered with audit confirmation amounts, and returned to Axon for evaluation. The video shows the process of modifying the audit value of the first sample and then reflecting the recovery result in the upper error limit.

  1. 1After extracting the MUS sample, select ‘Send Live’ from the Excel menu.
  2. 2Enter the audit confirmation amount in the Audit_Value column in Excel.
  3. 3Run a 'live recall' on Axon and check the MUS evaluation results.
TipSampling and in-app evaluation are also available on Linux. Live Send/Retrieval, which connects to a running desktop Excel, is only available for Windows.
Full synthetic demo · 208 samples → Excel audit value modification → Live recall → Evaluation
Screen to modify Audit Value of synthetic MUS sample in Windows Excel
Enter the audit confirmation amount in the Audit_Value column of the Protected Samples sheet.
05.9

Counter-entry extraction

The 'Counterbalance Statement' button analyzes the debit/credit counterpart accounts of a specific account to identify abnormal transaction patterns.

05.10

Save/open workspace

You can save the currently loaded dataset and entire analysis status as multi-sheet Excel, and reopen it later to continue your work.

05.11

export

Click ‘Export…’ on the right side of the toolbar. 'Save the analysis results of the current screen as PDF, Excel, or CSV.

06

OpenDART financial statement inquiry

06.1

Authentication key registration and company inquiry

After registering the OpenDART authentication key in settings, search publicly disclosed financial statements by company name or item code. You can check the query conditions and selected report period on the left side of the screen.

  1. 1Register the OpenDART authentication key in settings.
  2. 2Open the ‘DART Financial Statement Query’ in the Audit workspace.
  3. 3Select the company, period, and consolidated/separate criteria to search.
CheckOpenDART queries are online functions that are executed by the user. Compare the amounts and accounts displayed on the screen with the original disclosure.
06.2

Compare trends across multiple years and multiple accounts

By adding accounts to be compared one by one in the viewed financial statements, you can view amounts from multiple years as a line graph with the same standard.

OutcomeQuickly find long-term flows for each account and changes in a specific year, then go to the original disclosure to check.
OpenDART public disclosure search screen · Add accounts one by one and compare them based on the same criteria

07

Internal Accounting (ICFR)

07.1

RCM version management

🛡️ Open the .xlsx files of both versions of the Internal Control Statement (RCM) from ‘RCM Version Management’ in the Internal Accounting Dashboard. After specifying the control description column to be compared to the control number column, click 'Compare Differences' to organize the added, deleted, or changed controls. Controls with changed numbers are connected based on the similarity of the contents and classified as 'number change', and the similarity standard can be adjusted. Results can be saved in Excel. This is a local feature available for free.

RCM version management screen
07.2

Control Coverage — Account/Management Statement Mapping

Control coverage is checked by mapping each control in RCM to account items and management assertions. Marks on both the transaction and balance, such as completeness, confirm the claim by specifying the axis of control (transaction process / account balance), and if there are multiple account candidates, the auditor selects them. Company-specific notation that is not included in the standard normalization can be reused for the next audit once confirmed with the company-specific account rule set (paid).

07.3

Design evaluation/operation evaluationsoma

Design evaluation and operational evaluation are performed based on the connected controls. Evidence of operational evaluation is organized in the form of an audit report, and attribute samples are extracted from the population according to the sample number standard and created into a sample list sheet. It will be provided as a usix interconnection function.

08

usix-vba — Excel Ribbon Add-in

08.1Windows

Install/Delete

Add frequently used functions to the Excel ribbon, such as going back to the previous cell, applying formatting, and sorting sheets. It is only installed to your current Windows user account and can be uninstalled from the same screen.

CheckIf your company security policy has restricted Excel's trusted locations, you may still see macro warnings.

09

usix family and Somasoma

09.1

Product classification

usix is ​​the name of a suite of accounting automation products. Axon is a free local accounting analysis and preparation tool, and Soma is a paid accounting preparation product that creates RCM, reconciliation schedules, and report drafts with linked evidence step by step.

09.2

What Soma Will Expandpreparing

Soma is a separate paid product designed to carry out data organization, document-to-document translation, RCM and report writing procedures based on Axon's analysis and writing results and tools. The scope of provision and data processing method will be announced in a separate manual upon release.

09.3

Data processing principles

Axon's primary analysis is performed on the user's computer. Features that require external connectivity, such as Soma, only work on tasks explicitly initiated by the user. The information to be transmitted and how it is processed will be clearly explained on the product screen and in the policy.

10

setting

10.1

common

Change the theme (dark/light), font size (10~30px slider), and language (Korean/English). Everything is reflected immediately.

common screen
10.2

function module

You can clean up the left function bar by turning off unused function modules. Even if you turn off the function, your data will be preserved. Detailed functions such as MUS Excel export/import are also set here.

10.3

OpenDART Authentication Key · Newsletter

You can save or delete OpenDART authentication keys. Subscribe to our newsletter and receive new versions and updates by email. Subscription is optional and must be completed by clicking the confirmation link in the email you received. You can cancel at any time thereafter.

10.4

Report an error

If you run into any issues, you can send us feedback from the Help menu. After directly checking the transmission content with sensitive information hidden, select 'Send directly' or 'Send by email'. No information is sent automatically.

inquiry: [email protected]

Terms of Use: look · privacy policy: look