Contents 

Introduction
Faster Finder
Features And Benefits
Where Do I Start?
Updated Features & Topics
What's New In CAPITAL GL Controller?
Version 7.5
Special
Version 7.4
Entering Journals
Exchange Rate Table
Features And Benefits
General Journal Batches
General Ledger Codes
General Ledger Sets - Concepts
On-line Journal Entries
Multi-Currency Postings
Periods, Balances And Groups
Reporting Functions
Version 7.3
Clean Databases
Clean/Repair Databases
General Ledger Sets - Tutorials
Part 1: Create A New Stock General Ledger Set
Part 2: Assign The Set Code To Your Product
Step By Step Set-Up Guide
Version 7.2
Account Navigator
Clean/Repair Databases
General
Installation
Installing The Program
A Brief Overview
Files
Journals
Reports
Help
Using The Sample Charts Provided
Creating New Company Data
Using Sample Charts With CAPITAL Office
Creating New Data With Capital Office
General Ledger Basics
Assets, Liabilities, Income And Expenses
Assets
Liabilities
Current Liabilities
Retained Earnings
Income
Expenses
Debits And Credits
Financial Reports
Basic Set-Up Procedures
Entering Account Codes
Changing Account Codes
Account Codes
Account Types
Opening Balances
Step 1 - Check Your Financial Year
Step 2 - Notes On Entering Your Opening Balances
Entering Opening Balances
Posting
Printing A Trial Balance
Step By Step Set-Up Guide
The Check-List
General Ledger Sets - Tutorials
Part 1 - Creating General Ledger Sets
Part 2 - Creating Bank Accounts/Cashbooks In CAPITAL Office.
Your First Month's Activity
End Of Period Data Transfers
End Of Period Procedures
Step 1 - Print The Stock Quantities Report
Step 2 - Cashbook Direct Entries
Step 3 - Reconcile The Bank
Step 4 - Running A Bank Statement Report
Step 5 - Unpresented Cheques Lists
Step 6 - Printing Other Reports
Step 7 - Run The General Ledger
Manual General Ledger Mode
Automatic GL (1) - For Chart Of Accounts With Perpetual/Direct Adjustment Stock
Automatic GL (2) - For Chart of Accounts With Opening/Closing Stock
Step 8 - The Stock Journal
Step 9 - GST Reconciliation
Step 10 - Print The Trial Balance
Step 11 - Compare Reports
Step 12 - Print Financial Statements
Connecting To CAPITAL Office
Concepts
Customers And General Ledger
Suppliers And General Ledger
Stock And General Ledger
Advice On Stock Control
Cashbook And General Ledger
General Ledger Sets
The Priority Hierarchy
General Ledger Sets Priority Modes 0 And 1
Automatic Journals
Internal Accounts
A Connection Set-up Check-List
Reference Guide
Account Integrity
Base On Existing Company
Budgets
Budget Calculators
Clean Databases
Clean/Repair Databases
Complete Automatic Repair
Create Company Wizard
Create From Scratch
Delete Company
End Period Wizard
End Of Year Close
Entering Journals
Exchange Rate Table
Financial Formulas
Financial Year Structure
Fix Systems Batch
General
General Journal Batches
General Ledger Codes
General Operation
General Ledger Tools
General Ledger Sets
Journals
Last Year Balances
Locations
Make New System Batches
Multi-Currency Postings
Open Company
On-line Journal Entries
Posting Batches
Printing
Quick Automatic Repair
Set Accounting Period
Special
Standing Journal Tables
Systems Journal Batches
Transfer Expenses
Trouble-shooting Problem Batches
Standard Reports
Audit Trail Listing
Batch Journal Errors
Budgets And Variances
Batch Listings - General/Systems/Standing
Chart List
Financial Formulas
General Ledger Sets - Report
Transaction History
Trial Balance
Report Formulas Technical Guide
The Financial Formula Table
Real Account Groups
Advanced Options
Compound Groups
Tutorial - Creating Sub-account Groupings
Hints & Tips
The Quick Report Writer
Introduction
Testing Quick Reports
The Report Writer/Editor
Introduction
Report Lay-Outs
The Report Body
Periods, Balances And Groups
Report Commands
Reporting Functions
Report Directives
Printing Financial Statements
Security System
Logging On
Master Security
Technical Notes And Trouble Shooting
Technical Notes
Network Installation
Data Files
Why Doesn't My Opening Stock Show On My Profit/Loss Report.
Why Doesn't My Trial Balance Balance?
How Do I Fix A Trial Balance That Doesn't Balance?
I Need To Revalue My Stock. Can I Do A One-sided Journal Entry?
What Do I Do If One Of My Account Codes Displays ??????????????
How Do I Best Deal With Supplier Invoices That Come In Late?
How Do I Consolidate Accounting Information From More Than One Company?
Export Solution 6 MAS 5 Journals
Network is Busy
Sample Reports
Sample 1 - Profit & Loss/Balance Sheet
Sample 2 - Column Profit & Loss/Balance Sheet
Glossary
Glossary

CAPITAL Series 7 GL Controller Reference Guide

Prev Page Next Page

The Report Writer/Editor


The report designer/editor allows you to construct customised financial statements, modify existing reports or edit reports created by the Quick Report Writer.

From the menu select Reports|Report Writer/Editor. The following screen shows the report designer/editor screen in edit mode.

generate/report.jpg

Click on the open icon on the toolbar or select File|Open... from the menu to produce a list of available reports for editing. Select the name of the report you wish to edit (the file extension will be .GPT) and click on Ok.

If you wish to create an entirely new report, click the 'New' icon or select File|New from the menu.

Use all four arrow keys as well as the pgup and pgdn keys to move around the report. Click the relevant buttons to select options.

Editor Options

General Ledger Codes

Displays the account codes and descriptions of your chart of accounts. Click x to close the window or press ESC, or use the scroll bar to highlight the entry you want and double click to copy it into your report at your current cursor position.

Financial Formulas

Displays the various financial formula table account group codes. These can also be pasted into the report.

Preview Report

Select this option to display the output generated by the report under construction, to the screen. It will give you an accurate idea of how the report will appear in print. Click closeto return to editing mode. You can also print a trial run version of the report using this option.

Save

Select this option to save all changes made to the report.

Save As

Select this option to save all changes made to the report under a different report name. CAPITAL will prompt you for a file name. Select from the list to replace the original report with this report, or type in a new file name to create a new report.

Constructing Reports

Numerous commands are available for specifying page centering and justification, company details, and time based information such as the date the report was printed or the period name in words, as well as other types of information. Refer to the list of topics below for detailed information.

Report Lay-Outs

Report Body

Periods, Balances And Groups

Report Commands

Report Functions

Report Variables

Report Directives