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

Real Account Groups


In a real group an account code range must be specified. For example, if you created the group "sales" and your sales accounts were listed from 10000-13999, you would specify "10000" in the from account field and "13999" in the to account field. The total would be specified as a credit, since you wish to add the credit accounts together as well as subtract any debits, such as discounts, from this range. For example:

10000 sales - whitegoods

$100 (credit)

10100 sales - audiovisual

$200 (credit)

10900 sales - discounts

$10 (debit)

 

-----------

 

$290

If you create a group with this account range, and call it "sales", you have a handy way of checking what your total sales are for the period, year, plus your total budgets, etc., Without having to print a report.

This is only the start however. You are also allowed to add multiple account code ranges to your "sales" in order to include or exclude certain accounts. For example, you might want to include all the accounts from 10000-11000 plus the accounts from 12000-13000. In this case you would add another group, issuing it the same group code of "sales". You then specify the new range. When CAPITAL sees two ranges with the same group code, it simply adds the two together and returns a cumulative result.

This is all you need to know in order to use financial formula groups with the quick report writer and/or financial report writer/editor. You may skip to: Quick Report Writer or see: the Report Writer/Editor. See: Advanced Options if you want to learn more about financial groups.