Finance and Accounting · Reports & controls · 8 min read

Run, drill into and export financial and tax reports

Run the trial balance, statements, ledgers, VAT and management reports, drill down to the entries, save views and export.

Before you begin

• report.view runs reports, drills down and saves views. report.export exports to CSV, spreadsheet and HTML. doc.print is needed for PDF. audit.view is needed for the Journal Audit report.
• The report list under Finance > Reporting comes from the system, so new reports appear without a change to the menu.

Run a report

1. Open Finance > Reporting and choose the report: Trial Balance, Profit & Loss, Balance Sheet, Cash Flow, General Ledger, Journal Register, Day Book, Bank Book, Cash Book, Customer or Vendor ledgers and balances, Reversed entries, Tax Return Summary, Tax Detail, Reverse Charge, management reports by cost centre, profit centre, department, project or branch, and realised and unrealised exchange differences.
2. Set Period: Today, This week, This month, This quarter, This fiscal year, Month, Quarter or Year to date, or a Custom range. Fiscal-year choices follow the year start month in Settings. A custom range needs both dates.
3. Set Entries: Posted only (the default for statements), Draft only, Posted and draft, Reversed or Cancelled. Anything other than posted only is marked provisional.
4. Optionally set Amounts in, Compare with (previous period, previous fiscal year or same period last year), Group by, Zero balances and filters for accounts, classes, journal types and dimensions.
5. Press Run report.

The classic Trial balance (classic) under Reporting takes a From and To date and shows opening, debit, credit and closing per account; period debit equals period credit.

Worked example: the statements agree

Posted entries: capital AED 10,000.00 paid into the bank, marketing AED 2,000.00 paid from the bank, and a sale of AED 5,000.00 plus AED 250.00 VAT on credit.

• Profit and Loss: revenue 5,000.00, expenses 2,000.00, net profit 3,000.00.
• Balance Sheet: assets 8,000.00 (bank) + 5,250.00 (receivables) = 13,250.00. Liabilities 250.00 (VAT). Equity 10,000.00 + current profit 3,000.00 = 13,000.00. Liabilities plus equity equal assets.

Drill down and saved views

• Click a row to open the General Ledger narrowed to that account and period. Its debits and credits equal the figures on the row. Some reports do not open into anything and say so.
• Press Save this view to keep your filters under a name, visible to only you, everyone, or as the company default.

VAT return

1. Run Tax Return Summary for the month, posted only. It lists output and input tax by tax code and treatment: standard rated, zero rated and exempt each on their own line.
2. Open Tax Detail to trace a figure to its documents with the partner's tax registration, rate, net and tax.
3. Run Reverse Charge to list reverse-charge purchases.

Example: output standard rated net 10,000.00 with tax 500.00; input net 6,000.00 with tax 300.00, all recoverable. Net VAT payable = 500.00 - 300.00 = 200.00. On a 50% recoverable code with 1,000.00 net and tax 50.00, the expense is 1,025.00 and VAT input 25.00.

Export

Press Export and choose CSV, XLSX, HTML, print or PDF. The file has a header with company, filters and user and its totals equal the screen. PDF reports are limited to 2,000 rows; narrow the filters first.

What happens next

Reports change nothing. Move the lock date forward after you file, so the month cannot change. See Close a month and a year.

Good to know

• Management reports show lines with no dimension as Not set, so the total equals the full profit and loss.
• Budget comparison is not on these reports; use Planning > Budget against actual.
• General Ledger runs are paged, and the running balance continues across pages.
• The Dashboard tiles equal these reports for the period you pick.