Skip to main content

Financial Reports

Overview

The Full Accounting Kit (base_accounting_kit) extends Community Accounting with statutory and management reports:

Category Reports
Financial statements Profit & Loss, Balance Sheet, Cash Flow
Ledgers General Ledger, Partner Ledger, Trial Balance
Partner ageing Aged Receivable / Payable
Books Day Book, Bank Book, Cash Book
Assets Fixed assets, depreciation schedules
Collections Customer follow-up levels, statements

Navigation: Accounting → Reporting.


Step-by-Step Guide

Profit & Loss

  1. Accounting → Reporting → Financial Reports → Profit and Loss.
  2. Select date range (month, quarter, year).
  3. Choose comparison period if needed.
  4. Expand account groups for detail.
  5. Export PDF or XLSX (where available).

Balance Sheet

  1. Accounting → Reporting → Balance Sheet.
  2. Set as at date (typically month-end).
  3. Verify assets = liabilities + equity.
  4. Drill down into account groups.

General Ledger

  1. Accounting → Reporting → General Ledger.
  2. Filter by account and period.
  3. Trace from summary to individual journal items.

Aged receivable

  1. Accounting → Reporting → Partner Reports → Aged Receivable.
  2. Review buckets: Current, 30, 60, 90+ days.
  3. Use for collections follow-up.

Fixed assets (if used)

  1. Accounting → Assets → Assets.
  2. Create asset from bill or manually.
  3. Run depreciation per schedule.
  4. Assets Report for net book value.

Export XLSX (customer variants)

Some deployments expose /xlsx_report POST endpoint for accounting exports — confirm with administrator.


FAQ

Q: Reports show zero — why? A: No posted entries in period, wrong company selected, or lock date excludes transactions.

Q: Can I customise report layout? A: Account group hierarchy customises structure. Full PDF templates may need developer assistance.

Q: Who can see all financial reports? A: Users with Accounting / Adviser rights. Restrict via SMEOne groups.

Q: How often should reports be run? A: Monthly management accounts minimum; daily cash/bank for active treasury.

Q: Does P&L include unrealised currency gains? A: Depends on multi-currency configuration. Standard SG SME deployments use SGD functional currency.