Skip to main content

Cashbook Report Structure

www.trestechnologies.com
© Tres Technologies. All Rights Reserved.

Cashbook Report Structure

The Cashbook Report Structure determines how General Ledger accounts will appear/be categorised in the MyCCT Cashbook Reports.

To set up a Cashbook Report Structure go to Options menu, select Tables, and then select Cashbook Accounts.

A list of all Cashbook accounts with their current set-up will be displayed. This list provides each account’s details and set-up in the Cashbook:

  • Account ID
    • Account Name
  • GL Account ID
    • Account Numeric Code
  • Account Description
    • Account Name (prints on reports)
  • Type
    • Profit and Loss or Balance Sheet
  • Control (CTRL)
    • Indicates if it is a Control Account. This is a total of amounts contained in a subsidiary ledger.
  • Normally
    • If account balance is normally in debit or credit.
  • Account Category
    • Income, Expense, Asset, Liability or Equity
  • Account Sub-Category
    • E.g. Client Income, Other Income
  • GST Type
    • CAI Capital Acquisition
    • FRE GST Free
    • GST Goods and Services Tax
    • MIX Mix of GST and GST Free
    • N-T No Tax
    • PAY PAYG Tax

 It is recommended that the set-up of these accounts be advised by your accountant.

mceclip0.png

 

Making a Change

The way in which accounts are set-up determines whether they appear in the Balance Sheet or Profit and Loss Statements, and how they are categorised within the reports.

  • Click on the Reporting Structure button. Once again a list of all Cashbook accounts will be displayed.
    • This list provides each accounts’ reporting structure details (pertaining to the Profit and Loss (Detail) Report) and includes the same fields as the previous screen as well as:
  • Service Type
    • Where Account balances can be separated into service types for the Profit and Loss (Detail) Report.
  • Sales Code
    • Where Account balances can be separated into Sales Codes for the Profit and Loss (Detail) Report.
  • Sort
    • Currently has no function.
  • Description
    • Account Name (prints on reports)

mceclip1.png

  • This area allows Sales Control, Cost of Sales and Discount Expense balances to be broken down into their Service Type and/or Sales Code on the Profit and Loss (Detail) Report.
    • One line per account must be left as a neutral setting, i.e. no Service Type or Sales Code should be selected.
  • To report by Service Type, highlight the account to be separated and click the New button. A new, identical line will appear for the account.
    • Click in the Service Type column and select the Service Type required to be itemised on the report. It is possible to add multiple lines for numerous Service Types in order to provide greater detail in reports.
  • To report by Sales Code, highlight the account to be separated and click the New button. Select Domestic, International or Sundry Sale from the scroll.

mceclip2.png

  • It is possible to report by both Service Type and Sales Code by selecting both modifiers on the same line, eg. Flight - Domestic, Insurance – International.
  • Click on OK to save the changes.

Deleting a Structure Line

To delete a Cashbook Report line:

  1. Select the Options menu, click on Tables and select Cashbook Accounts
  2. Click on the Reporting Structure button
  3. Highlight the line to delete and press Ctrl+D
  4. Click Yes to delete
  5. Click OK to save changes and close

Related articles