AWRA OpsHub Search

AWRA Help Center

Copy link
Reports Filters Export
01 Report Export Step-by-Step Workflows 02 Missing Reports Troubleshooting 03 Finance, Accounting & Reports Module Guides

Financial Reports

The income statement, balance sheet, trial balance, cash flow and aging report — all read from the same ledger, so the statements agree with each other and with the entries behind them.

Open Accounting → Journal; the statements are at the top of the accounting sidebar. The income statement and balance sheet come from one calculation, used on the web and in the API alike, so profit on one is the profit carried into equity on the other — POS takings included.

Income Statement

  • With no dates it covers everything since the ledger began. Choose a from and to date to see a period.
  • Narrow it to one Department, Branch or Project, or choose Break down by to see one column per department, branch or project with a net result for each.
  • The bottom line is always the net result, labelled Net Income or Net Loss, so a month of costs and no sales reads as the loss it is.

A figure reaches a department, branch or project column only if the posting carried that tag — supplier bills without an order, invoices, expenses, petty cash, staff advances and manual journal lines can carry one. Postings without a tag appear in an Unassigned column, so the split always adds up to the whole.

Balance Sheet

  • Assets, liabilities and equity as of a date you choose, or today.
  • Equity includes Retained Earnings — profit to date, the same net result the income statement shows up to that date.
  • If assets differ from liabilities plus equity, the sheet says by how much, and points to the usual cause below.

Unclassified Accounts

Each account is classified as asset, liability, equity, revenue or expense. An account with a balance but no classification is listed at the top of the statement rather than silently dropped or guessed into the wrong place. Edit the account in the chart of accounts, choose its classification, and it moves onto the statement.

Trial Balance, Cash Flow And Aging

  • Trial Balance — every account with a balance, on its debit or credit side, with the two columns totalled.
  • Cash Flow — cash from operating, investing and financing activities, with a trend of money in and money out.
  • Aging Report — what customers owe, bucketed current, 1–30, 31–60, 61–90 and over 90 days by each invoice’s due date, with reminders you can send from the report. Its payables side ages open purchase orders by their expected date; for what you owe on supplier bills, use the Owed to suppliers and Overdue figures and the overdue filter on Supplier Bills.

Reports You Can Rely On At Month End

  1. Post what is missing: bank charges straight from the statement in Bank Reconciliation, accruals and corrections as manual journals.
  2. Classify any account the statements list as unclassified.
  3. Run the income statement for the month and the balance sheet as of its last day.
  4. Close the month under Accounting Periods, so nothing dated in it moves after you report it.

Common Mistakes

  • Comparing an all-time statement with a monthly one. The income statement covers everything since the ledger began until you choose dates.
  • Expecting a document to reach the books before it is final. A draft invoice, an unapproved bill or an unconfirmed bank payment has posted nothing yet.
  • Mixing currencies. AWRA keeps amounts in different currencies apart rather than adding them into one figure; see Currency & Billing.

Related

Need help with this topic?

Capture the module, record number, branch or warehouse, user, visible message, and what you expected to happen before contacting support.

Open support guide