Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

Overview

The financial reports in the system are accessed here. '''Warning''' The Standard Reports in the system rely on maintenance of the Financial Years in the following way

  • Reports look back to the last closed financial period and use the totals from the closed period results and then calculate forward. This requires a discipline when re-opening periods to make adjustments. If you re-open a period you MUST
  1. Close the period
  2. Roll the period totals
  3. Roll all period totals for closed periods after this period
  4. Roll the financial year for any closed year
  5. Continue through any other closed years after this year with the same process. If you do not do this your balance sheet may not balance due to the Retained Earnings figure for each year not being correctly calculated.

To create Financial Reports

  1. Select the date range of interest
  2. Select if the report is be printed to screen or provided as an export
  3. Select the Report Note that for the Balance Sheet Report or the Trial Balance select the "As at date". '''Note''' if your trial balance is not balanced it indicates that your period totals are not correct go to Standard Financial Reports, roll periods and years. The retained earnings figure if not calculated will make the trial balance out of balance.
Expand
titleConfiguration

In order for the reports to work you need to setup some settings in Symbols Config

  1. GLAcctLiabilities: Value = LIABTS
  2. GLAcctAssets: Value = ASSETS
  3. GLAcctCapital: Value = CAPITAL
  4. GLAcctCostOfSales: Value = COGS
  5. GLAcctRevenue: Value = REVENUE
  6. GLAcctExpenses: Value = EXPENSES

Report List

Miscellaneous Tab

 Lists reports that are not often used such as

...

Standard Financial Reports Module

Financial reports can be run to screen or to PDF.  Reports run to screen can be exported to Excel.

When a report is run to screen - right click on a total to reveal the journals that make up that total.

See Financial Reports including Balance Sheet, Profit and Loss, Trial Balance, Aged Debt and Payable, Stock Valuation

see also GST Explorer for BAS to review all GST related information.