Skip to main content

XPA: Print financial statements in Xcede Professional Accounting

Set up your client ledger, then print management, group and compliance financial statements in Xcede.

Xcede Professional Accounting can print compliance and management financial statements for any client ledger. Complete the ledger details first, then print a management report or a group report. You need a client ledger created from one of the supplied templates.

Complete the ledger details

Financial statements print information stored on the ledger, so complete these details before you print.

  • Organisation: Enter the full name that you want to appear on the financial statements.

  • Company No: Enter the Australian Company Number (ACN) or Australian Business Number (ABN). Enter an ACN as nine digits with spaces, for example 123 456 789. Enter an ABN as eleven digits with no spaces.

  • Tax No: Enter the entity's tax number, where required.

  • Entity type: Check that it is correct. Incorporated associations are set up as company ledgers, so select their entity type from the company list.

  • Reporting status: Check that it is correct.

Select the Reporting button to add up to four extra heading lines, draft accounts text, and signatory details for the compilation report and auditor's report.

⚠️Important: Complete the auditor details only where an auditor signs the auditor's report.


Complete the financial reporting fields

Financial reporting fields hold ledger-specific information, such as the date a compilation report or directors' declaration is signed, and balances that do not appear in the trial balance.

Each template includes default settings in the General Items section. Set Are accounts audited? to Yes for audited accounts. This changes the footers on the financial statements.


Select the main source of income

Standard management jobstreams print a profit and loss statement based on the ledger's main source of income. Make this selection once, when you create the ledger. Enter the number that matches the ledger in the relevant financial reporting field:

  • Selection 1: Trading profit and loss.

  • Selection 2: Professional income.

  • Selection 3 or 0: Investment income. Selection 0 is the default.

  • Selection 4: Rental income.

  • Selection 5: Livestock.


Print a management report

Each entity type has two management jobstreams. Both print a cover page, index, profit and loss statement, balance sheet, supporting notes where appropriate, declarations, and a compilation report. Use the jobstream for your entity type:

  • Company: MANAGECOMP or MANCOMPANY.

  • Trust: MANAGETST or MANTRUST.

  • Incorporated association: MANAGE IA or MAN ASSOC.

  • Partnership or sole trader: MANAGEPART or MANP'SHIP.

The two management jobstreams for each entity type differ in the format of the profit and loss statement. One format is built around the main source of income. The other prints a separate trading statement, if required, followed by a profit and loss statement that lists all income and then all overheads.

  1. Click Reporting, then click XCEDE.

  2. Select Template as the source of the management accounts jobstream.

  3. Double-click the jobstream for your entity type to open it. The Selected Sheets list shows the statements in print order.

  4. Click Run. The Jobstream Run window opens.

  5. Run the report with the default options, or change the options first.

🤓Tip: Clear Paginate Sheets when you print draft accounts. Pagination slows down report generation.

Choose print options

In the Jobstream Run window, these options are the most useful:

  • On the General tab, select Override Individual Options to apply one set of print settings to every sheet. Clear it if each sheet should use its own settings.

  • On the General tab, select Generate Note Sheet to print the NOTES sheet.

  • On the General tab, select Final Report for the final version. This removes the control row and column, the formatting column, gridlines and hidden rows.

  • On the General tab, select Black and White to convert colour to black and white. This gives better print resolution on black and white printers.

  • On the Actual tab, choose Actual/Budget to print actual or budget balances.


Print projected year end figures

Projections help you estimate profit for the year. The report shows year to date figures, your projected figures for the rest of the year, and a comparative year.

  1. Enter the projected amount for each account in the period after the current period. Give the projection a Budget Code of up to ten characters.

  2. In the Budget tab, select your Budget Code from the drop-down list, then click Run.

📌Note: The ledger needs at least two active periods in the current year to use projections.


Print a group report

Group reports print across several ledgers. Each group jobstream prints the group profit and loss statement, appropriation statement and balance sheet. Choose the jobstream that fits the number of entities:

  • GROUP15: Prints up to fifteen entities in portrait orientation. When you display the year to date detail for all ledgers, the report paginates across more than one page and is not designed to be printed.

  • GROUPL: Prints up to five entities in landscape orientation.

  • GROUPP: Prints up to three entities in portrait orientation.

⚠️Important: Group jobstreams do not generate rounded reports. They print actual values to zero decimal places. If the group has periodic ledgers, each ledger, including the group ledger, must have the same number of periods.

To remove balances between entities, post elimination journals to the group ledger. Use the sub account that matches each ledger number. For example, to eliminate a management fee paid by ledger 1 to ledger 3, debit account 192 with sub account /003 and credit account 395 with sub account /001. These entries appear when you print the group report, but they do not change the individual ledgers. Elimination entries posted to balance sheet accounts are not included.

At year end, balance forward the group ledger as usual. This clears elimination entries posted to profit and loss accounts and creates a blank trial balance for the new year.


Print compliance accounts

Compliance accounts jobstreams are available for companies, trusts, partnerships, incorporated associations and superannuation funds. They print primary statements, supporting notes, declarations, and a compilation or audit report. Financial reporting fields control who signs the declarations and the wording of the compilation report and auditor's report.


Find more detail

The XPA Producing Financial Statement manual covers each step in more depth. These sections are the most useful next steps:

  • Ledger details and financial reporting fields.

  • Management financial statements.

  • Group reports and the group template.

  • Profit distribution for discretionary trusts.

Did this answer your question?