Import the Trial Balance — your starting point
The Trial Balance (TB) is the complete list of every general-ledger account with its closing balance. This is what you're auditing. Every workpaper, every adjustment, every FS line traces back to this TB. Get it right.
What a TB looks like
The client gives you a CSV or Excel file with these columns. AuditPro accepts a few common shapes and auto-detects the layout:
| Account code | Account name | Opening | Debit | Credit | Closing |
|---|---|---|---|---|---|
| 1010 | Cash on hand | 2,500.000 | 125,400.000 | 122,800.000 | 5,100.000 |
| 1020 | Bank — NBO Current | 285,400.000 | 2,140,800.000 | 2,089,400.000 | 336,800.000 |
| 1200 | Trade receivables | 412,000.000 | 2,450,000.000 | 2,398,500.000 | 463,500.000 |
| 1500 | Inventory | 385,000.000 | 1,200,000.000 | 1,095,000.000 | 490,000.000 |
| … 247 more rows … | |||||
| Σ Totals | 14,825,200 | 14,825,200 | BALANCED ✓ | ||
Step-by-step import
Get the file from the client
Standard email request: "Please send your YE Trial Balance as Excel/CSV with columns: account code, account name, opening, period debits, period credits, closing." Most accounting systems (Tally, QuickBooks, Sage, Zoho, Odoo, SAP) export this directly.
Open the job → Trial Balance tab
From the audit job, click Trial Balance → Upload TB. Drag-drop the file. Max size 10 MB. Accepted:
.csv,.xlsx,.xls.Map the columns
The wizard auto-detects column headers and shows a preview. Confirm: which column is account code, which is name, which is closing balance. If your client uses signed-balance (negative for credits) vs separate-debit-credit, pick the right radio.
Validate
System checks: Σ Debits = Σ Credits (must balance to 0.000), no duplicate account codes, no blank rows, no non-numeric balance values. Failed rows are highlighted with the reason. Imbalanced TBs are rejected.
Commit
Once validated, click Commit import. The system writes ~250 rows into
job_trial_balance_rows, stamps the upload metadata (uploader, file hash, timestamp), and the TB is now the immutable starting point.Sanity-check the totals
Click Summary tab: Total assets, Total liabilities, Total equity, Total revenue, Total expenses, Profit. Compare these to the client's last FS draft — if they're wildly different, you imported the wrong file.
Common gotchas
Client's GL is broken. Send back, ask them to balance, then re-import. Common cause: sub-ledger not posted to GL.
Same code appearing twice with different balances. Pick one (or sum them — ask the client).
If amounts include fils (3 dp) but the file uses 2 dp, you'll lose 0.001 OMR everywhere. Ask the client to re-export with full precision.
Some systems export credits as negative numbers in a single column. Pick the right radio in the import wizard or you'll have inverted P&L.
What you can do once the TB is in
- View the full TB with sort + filter + search
- Drill into any account → see opening, movements, closing
- Re-export to CSV (for sharing with the manager / partner)
- Compare to prior-year TB (uploaded as a separate version)
- Trigger Auto-seed workpapers — Phase 3 covers that
Open Engagements → Jobs → Annual Audit FY 2025 → Trial Balance. Use the demo TB if available. Click any account → see the GL detail. Sort by amount descending — the largest balances are where your audit risk concentrates.
Don't accept a "summary TB" — you need the full GL chart of accounts, not just management's grouped figures. If the client gives you a 30-row summary, ask for the underlying detailed TB. Your audit must be on raw data.
If the client sends a corrected TB mid-audit (very common), don't overwrite the original. Click Upload new version — the old TB is preserved as v1, the new one becomes v2, and your AJEs auto-rebase. Audit history is preserved.
What's next
TB imported, validated, locked as v1. 250 GL accounts now sit in the system, balanced. Phase 3 takes the magic step — Auto-seed workpapers — where AuditPro maps every account to its workpaper and pulls the lead-schedule numbers automatically.