You will find your Account Reports under the Accounts & Contacts menu. From here, you will find various options for producing reports.


TABLE OF CONTENTS


How to run an accounting period based report 

  1. Select the Monthly tab from the right-hand side of the report.
  2. Put a tick next to the report you wish to run.
  3. Select the report filters if applicable and click Refresh.
    • Account type: filters the report for either Debtors or Creditors. To print all accounts, leave as All accounts
    • Account use: filters the report based on the Account Use setup in the Account List screen. 
    • Period: filters the report for the selected accounting period.
  4. Once the report is shown on screen, you can print it to your printer, or export it for use by other software applications such as MSExcel or MSWord.


How to run a date based report between any two dates

  1. Select the Date based tab.
  2. Select the Account type and Account Use filters as appropriate.
  3. Enter the start and end dates.
  4. Put a tick next to the report you wish to run. If you are running the Uninvoiced bookings report, also select which sales types to include.
  5. Click on the Refresh button
  6. View on screen, print, or export as required.

Date Based


Aged balance report

A standard aged trial balance, showing the balance owing, current, 30 days, 60 days, and 90+days. Please note that you need to be rolling the account period to be able to see your Aged Trial Balance in the Accounts Reports

  1. Select the Monthly tab from the right-hand side of the report.
  2. Put a tick next to the Aged balance for accounts report you wish to run:
    • Current (as of today) for the "Aged balance for accounts" report, the report will print out the aged trial balance as at the time of printing.
    • At end of historic period - previous accounting periods can be selected in the "Period" drop-down box.
    • If show zero balances is ticked, this report will print with all accounts, not just those with a balance.
  3. Select the report filters if applicable and click Refresh.
    • Account type: filters the report for either Debtors or Creditors. To print all accounts, leave as All accounts
    • Account use: filters the report based on the Account Use setup in the Account List screen. 
    • Period: filters the report for the selected accounting period.
  4. Once the report is shown on screen, you can print it to your printer, or export it for use by other software applications such as MSExcel or MSWord.

Aged Balance


Payment summary 

This shows each payment added from the banking screen. The report is grouped by payment date and payment type.

You can access this report by selecting Accounts & Contacts > Accounts Reports. Place a tick in the box "Payment Summary."

Monthly banking associated with selling reservations should reconcile to the Payment Summary report (Accounts Reports). This report groups by payment type e.g. Cash, Direct Credit and Cheque.

  • To reconcile payments made select Account Type = Creditors
  • To reconcile payments received select Account Type = Debtors.
  • To view all payments in the same report select Account Type = All Accounts.

If your banking from invoicing goes into the same account as income taken through Point of Sale, you will need to reconcile your monthly banking with the payments section in the Cash Reconciliation report.


Payment Summary


Invoice summary

This shows invoices generated over the selected period. The report is grouped by Account type and Invoice number. The Balance is the Balance of the invoice at the time of printing. You can access this screen by selecting Accounts & Contacts > Accounts Reports - place a tick in the box that says "Invoice Summary"

Invoice Summary


Journals

Choose the appropriate date selection type from the tab (Monthly, if you are rolling your accounting period, or Date based to view between any two dates). Journals are shown for all account types for the selected period.  

Journals


GST on commission

The GST component of each invoice is calculated. Report is grouped by Account Type. You can access this screen by selecting Accounts & Contacts > Accounts Reports - place a tick in the box that says "GST on commissions"

GST on Commission


Ledger summary

The Ledger Summary calculates and lists the opening and closing balance as well as totals for invoices, payments and journals in that period. As this report applies to all accounts the "Account type" and "Account use" drop-down menus will be greyed out.


You can access this screen by selecting Accounts & Contacts > Accounts Reports - place a tick in the box that says "Ledger summary"

Ledger Summary


Run the unsettled tickets report

The Unsettled tickets report was designed specifically for agents. It will list all tickets of status paid - this is the point where you have taken payment from the customer, but have not yet settled the ticket with the Operator via the Invoicing screen. This report is based on the ticket Sale date - if you prefer to see the unsettled tickets by product date, you must run the uninvoiced booking report under the date-based tab. The Unsettled tickets report will only be available on your menu if the Settle Accounts screen is on your menu.

  1. From the Accounts & Contacts menu, select Accounts Reports.
  2. Select the "Other" tab on the right of the screen. Note the Account type filter and the Account use filters do not apply to this report.
  3. Select a date in the Until date field. Vouchers for products that take place after this date will not show on the report.
  4. Choose either Unsettled tickets by month to group the report results by month or Unsettled tickets by account to group the report results by Account.

    The un-settled ticket report only shows tickets of status Paid. It does not show tickets that are of status Active, Cancelled, Closed, Settled, New or Confirmed. Referral vouchers will not show in this report. 

    Other Tab