Financial Reporting Guide

By the end of this guide, you will have turned the quarter to 31 March 2026 into a balanced Trial Balance, a Profit and Loss statement broken down by branch, a Balance Sheet that balances, and exported all three to Excel for your external accountant.

The month itself is closed by Month-End Closing: its Stage 5 runs and checks Month End Processing, Stage 6 builds the statements and Stage 7 locks the month, and this guide points there for each rather than telling them twice. Plan for about 60 minutes the first month you do this on your own; once the rhythm sticks, you will be in and out in 20.

Closing the quarter, at a glance

1. Post March’s drafts and check the Stock Flow Report for each company: a draft is not in the ledger at all (Step 1).
2. Close March by Month-End Stage 5: run Month End Processing for each Set of Books, then check that every ledger has its two AUTO CREATED FROM MONTH END PROCESSING journals and, for a company that holds stock, its AUTO CREATED FROM COGS PROCESSING journal dated the month end. The screen reports success even when the close, or half of it, is missing, and without the COGS, STOCK_BALANCE, PROFIT_LOSS and RETAINED_EARNING default GL codes the cost-of-goods-sold and retained-earnings journals are not written and nothing says so (Step 2; the run in full is Month-End › Stage 5).
3. Generate one snapshot per company for the quarter. It reads month-end’s summaries, not the journals, and is frozen until you regenerate it (Step 3).
4. Check that the Trial Balance balances and the Balance Sheet balances, and read each company’s Profit and Loss (Steps 4 to 6).
5. Compare branches on the Profit Loss Report, which reads posted journals live and saves nothing; a CREATE grant with branch or company targets makes it refuse every search (Step 7).
6. After a back-dated entry, PROCESS the month and every later closed month, earliest first, then Regenerate. Regenerate alone changes nothing (Step 8).
7. Export the three statements per company and add them up for the group: there is no consolidation here (Step 9).
8. Lock March at LOCK_TXN, as Month-End Stage 7 does. Branches can no longer finalise into March (stock transfers still can); your adjusting journals still post, so each one means PROCESS and Regenerate again. LOCK_ALL waits for the year’s audit sign-off, and anyone with the fiscal-year update permission (or the owner or admin role) can set either back to Open (Step 10).

The quarter-end runs across three pages: Step 1 here, Steps 2 to 6 on Close the month and read the statements, and Steps 7 to 10 on Compare branches, regenerate, export and lock.

Meet GadgetSphere

You work in the GadgetSphere Sdn Bhd finance team. The group has three companies (the retail company GS, the e-commerce company GSO, and the wholesale company GSD) trading across 22 branches. Quarter-end falls on 31 March 2026, your external accountant needs the Excel files by next Tuesday for the Sales and Service Tax (SST) filing, and your finance manager wants to see how branch GS-KV-01 compared to GS-KV-05 over the quarter before they sign off. BigLedger does not produce a single true consolidated statement in this applet — you generate one set of reports per company (GS, GSO, GSD) and combine them in Excel for the group view your accountant signs off on.

Financial reporting: concepts you will meet

Set of Books — the reporting container that groups the ledgers you report together; at GadgetSphere, each holds one company’s. GadgetSphere has three: GS-Books, GSO-Books, and GSD-Books. You pick one Set of Books per report run; for a group-level view, generate one report per company and combine the figures in Excel.

Month-End Processing — a one-click routine, once per Set of Books per month, that writes the closing-day and opening-day journals and the per-account monthly summary rows that every Financial Report snapshot is built from. Run this before you generate the Financial Report, or the snapshot has nothing to read. The same click writes the month’s cost-of-goods-sold and retained-earnings journals, and says nothing when the default GL codes either needs are missing; what each run writes, and how to check it, is Month-End › Stage 5.

Financial Report snapshot — when you generate a Trial Balance, Profit and Loss, or Balance Sheet, BigLedger saves a snapshot of the numbers at that moment. Frozen unless you regenerate.

Profit and Loss Report (ad-hoc) (the on-screen menu label reads “Profit Loss Report”) — a separate screen that runs a Profit and Loss view on demand without saving a snapshot. This is where you compare branches, cost centres, or projects side by side.

Financial reporting: before you start

Run through this checklist once before you open the reporting screens. Five minutes here saves an hour of chasing later.

• Your Chart of Accounts is fully wired — every active GL Code (for example SALES-SMARTPHONE, COST-LAPTOP, EXPENSE-RENTAL) sits under a GL Category, and every Category sits under a GL Section (Assets, Liabilities, Revenue, Cost of Sales, Expenses, Equity). Anything missing that chain quietly drops out of the reports.
• Each of the three companies (GS, GSO, GSD) has its own Set of Books with at least one ledger linked.
• The GL Sections that the engine treats as profit and loss carry the codes it expects (SalesRevenue, CostOfGoodsSold, GeneralExpenses, OtherRevenues, OtherExpenses and the rest listed on the Financial Report applet page), and the retained-earnings section is coded RetainedEarnings. Rename those and month-end can no longer tell a P&L account from a balance-sheet one.
• Every sales invoice, purchase invoice, receipt, payment, and manual adjustment for March 2026 is posted (not still in draft). Anything in draft will not appear in your reports.
• Bank reconciliations for all 28 cashbooks are complete to 31 March 2026 — see the Bank Reconciliation Guide.
• Your user holds the Financial Report permissions: READ lets you open snapshots, CREATE lets you run month-end, create and regenerate snapshots, and run the Profit Loss Report. Keep CREATE free of branch and company targets, or the Profit Loss Report refuses every search (Step 7). Whatever your tenant calls the roles, those are the grants that matter.

Step 1: Confirm March 2026 is ready to close

Each document applet’s listing, then Financial Report > Error Checking > Stock Flow Report

Before you press a single button in the reporting screens, walk through your March 2026 checklist for each of the three companies (GS, GSO, GSD). In each document applet — Sales Invoice, Purchase Invoice, Receipt Voucher, Payment Voucher — filter the listing on March 2026 and Posting Status DRAFT. Every list should be empty. A draft document is not in the ledger at all, so its amount is simply missing from your Trial Balance.

Next, open Error Checking > Stock Flow Report, pick company GS and the date range 1–31 March 2026. It shows one row per module — Purchases, Purchase Returns, Sales, Sales Returns, Purchase Consignment, Reset MA — with the total of the month’s finalised documents (sales at their selling prices), the total posted to the module’s account, and the difference. It tells you every document posted its journal; it does not compare stock with the stock account (for that, see Stock report versus the stock account on the balance sheet).

Click a difference to see which documents are MISSING_ACCOUNTING, MISSING_INVENTORY or WRONG_AMOUNT; CREATE reposts the selected rows, and a row that comes back with an error usually means a missing default GL code on the item or company. Repeat for GSO and GSD. Finally, glance at the bank reconciliation listing for all 28 cashbooks and confirm a March 2026 session exists for each.

If one specific document worries you, Error Checking > Trace Document takes a document type and number and runs six checks on that one document — missing journal, wrong journal, missing cashbook line, missing shadow document, missing reversal — each with a Resolve button. It is a per-document tool, not a listing.

Watch out: if a document applet shows even one draft purchase invoice in March, stop and post it first — otherwise you will spend 20 minutes hunting a gap that is simply an unposted bill.

Next: Steps 2 to 6, close the month and read the statements.

What success looks like

Open the GS-Books Q1 2026 snapshot.

• Trial Balance footer shows total Debit RM 47,238,901.22 = Credit RM 47,238,901.22 (your actual number will differ — what matters is the two values are identical).
• The Profit Loss Report for Q1 shows Cost of Goods Sold around RM 10.6 million for GS-Books and a Gross Margin in the 12-18% range (around 14.6%), and the snapshot’s Profit And Loss tab shows a cost-of-sales figure of the same order — not zero — because the month-end cost-of-goods-sold journal was written for each of the three months.
• Balance Sheet shows Total Assets equal to Total Liabilities + Shareholders’ Equity (both around RM 18-22 million for GS-Books at this scale).
• You have nine Excel files saved (Trial Balance, Profit and Loss, Balance Sheet for each of GS, GSO, GSD).
• The March 2026 fiscal period for all three companies shows status LOCK_TXN.
• In Ledger And Journal, every ledger of all three Sets of Books has its two AUTO CREATED FROM MONTH END PROCESSING journals for March, dated 31 March and 1 April, and its AUTO CREATED FROM COGS PROCESSING journal dated 31 March (cost of sales can fail while the other two are written).

If all six tick, you are done — email the files and close the laptop.

Financial reporting: common mistakes

Each part of the quarter-end carries its own table, beside the steps it belongs to:

• Close the month and read the statements: empty snapshot tabs, a Balance Sheet that does not balance, a close that reported success with a statement missing, Cost of Goods Sold at zero, and a GL Code missing from the Trial Balance.
• Compare, regenerate, export and lock: a back-dated correction that does not show, and a Profit Loss Report that refuses every search or is missing a branch.

Related documentation