Reports¶
One screen.
Reports¶
Reports
Eighteen reports as a row of buttons. There is no Run button — a report runs the moment you land on it, and again whenever you change a control.
What you see¶
The controls in the header change with the report. Only the ones that actually affect what you are looking at are shown, so there is never a date box that silently does nothing.
From / To appear on Profit & Loss, Cash Flow, Changes in Equity, Tax Return, Commission and Account Ledger. As Of on Balance Sheet, Trial Balance, both ageings, Dunning and FX Exposure. Subsidiary on most financial reports. Account on the Account Ledger only.
If a report cannot be produced it says so in red with the reason, rather than showing an empty page. Where the failure is a server error it adds that the backend console will have the reason on its last few lines.
Fields¶
| Field | What goes in it |
|---|---|
| From / To / As Of | The period or the date. Changing one re-runs the report. |
| Subsidiary | Leave on All (Consolidated) for the combined view. |
| Account | On the Account Ledger. Pick from the chart of accounts. |
| Country | On the Tax Return — SG or MY. |
| Period | On Consolidated. Newest first; a closed period is marked. |
| Fiscal year, Rate %, From stage, Brand, Rows | On Budget vs Actual, Commission, Dunning and Top Sellers respectively. |
Buttons¶
| Button | When you can use it | What it does |
|---|---|---|
| Account by account | On the Trial Balance and the Chart of Accounts — every row is clickable. | Opens that account in the Account Ledger, so you can see what makes the balance up. |
| Previous | On the Account Ledger, past the first page. | Goes back a page. The running balance continues correctly. |
| Next | On the Account Ledger, before the last page. | Goes on a page. |
| Close | On any drill-in panel. | Dismisses it. |
Rules this screen enforces¶
- The Account Ledger is the drill-down the Trial Balance never had. Pick an account and a date range and you get every posting with a running balance. There are three ways in: the Account dropdown, clicking a Trial Balance row, or clicking a row on the Chart of Accounts.
- On the ledger, Opening is what the account held before your range began, Movement is the net effect inside it, and Closing ties to the Trial Balance at the same date. The running balance is shown the way an accountant reads that account, so income and liabilities do not appear as negatives; the debit and credit columns are exactly what was posted.
- Long ranges are paged 200 postings at a time, and the five figures at the top always describe the whole period, not the page in front of you. The footer says so when there is more than one page.
- The Tax Return will not let you file from an incomplete figure. If any line was left out — no tax code, a foreign code on a Singapore line, a code that maps to nothing — the report itemises exactly what was excluded, how much, and says "Do not file from this until the above is resolved."
- The Malaysian tax figures carry their own caution: the rates and classifications come from secondary research and should be confirmed against the official portal before filing.
- Where more than one currency is involved, the ageing buckets add different currencies together and the report says so. Only the base-currency total is a single comparable number, which is why the buckets carry no currency symbol.
- If a currency has no exchange rate on or before the date asked for, the FX report excludes those documents and names the currency. It does not invent a rate.
- Cash Flow checks itself: if the statement does not tie to the movement on the bank accounts it says so above the figures, with both numbers, and tells you to check the chart of accounts before using them.
- Consolidated reports what percentage of the ledger it could translate, and leads with a warning rather than presenting an incomplete figure as complete.
- The commission report tells you how much revenue carries no salesperson and therefore earns nobody commission. That is a gap on the documents, not a problem with the rate.