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

A Connection Set-Up Check-List


This section describes changes to your operating procedures that will occur once CAPITAL Office is made general ledger "aware". It also offers a check-list that will help you in preparing CAPITAL Office to coexist with CAPITAL GL Controller.

As noted in the prior sections all supplier and cashbook transactions must have their "expense" allocations fully assigned. You will not be permitted to total the transaction unless this is done.

The trading statement report in the general reporting menu will no longer be available for use. CAPITAL removes this report from your system as it is superseded by CAPITAL GL Controller's financial statements reporting system.

A strategy should be worked out with regard to the updating of linked accounts. It is suggested that accounts directly updated by CAPITAL's automatic journals should not be accessible via supplier or cashbook expense allocations. To ensure that this is so, assign such accounts the account type "control" in general ledger codes.

Why should direct manipulation of linked accounts via CAPITAL Office not occur? This is because it makes the task of reconciling your general ledger balances more difficult than necessary. For example, since your "sales" account is automatically updated as each invoice is entered, it is a relatively easy process to confirm that total sales in CAPITAL Office matches period activity for sales in the general ledger. A sales report for the required period could be printed, for example, and the total cross-checked against your trial balance. However, if the sales account was also debited or credited through supplier entries or even through the general ledger, additional reports would have to be printed (such as an expense listing in CAPITAL Office or an audit trail history report in CAPITAL GL Controller) in order to account for the discrepancy.

If, for example, you need to increase or decrease your "sales" for the period, this should be done by entering an additional invoice or by issuing a credit note. Direct manipulation of the account balance via general ledger journals, for example, would in most cases be unnecessary.

If you wish to transfer supplier or cashbook transactions into the general ledger for periods that were entered prior to being general ledger "aware" then run the maintenance report unspecified expenses (found in the general reports menu) for cashbook and supplier transactions. You will need to allocate all the unallocated transactions listed on these reports. When doing this "clean up" it is recommended that you run CAPITAL Office in manual/passive general ledger mode. Otherwise a large number of "suspense" journals will be created.

Transactions added, edited or deleted outside of the current financial year will produce a warning message. You may not be able to "post" batches that are dated in this way. An exception to this is during the end of the financial year. CAPITAL will not warn you of a transaction date being greater than the current financial year for 60 days after the end of prior year. This is your period of grace. If a new financial year roll-over has not been performed after 60 days, CAPITAL will begin warning of the date problem after processing each transaction.

See the Integration Check List which follows. It recaps on the critical key points discussed in this section and suggests a plan of action for integrating CAPITAL Office with CAPITAL GL controller.

Integration Check-List

1. Set-up and install the general ledger.

2. Decide whether you wish to include transactions from prior periods into the general ledger. If so, run the CAPITAL install program and switch the general ledger activation mode to "manual/passive." In CAPITAL Office run the unspecified expenses report and fully allocate any partially allocated supplier or cashbook transactions.

3. By now you should have determined what stock control valuation method will be used. Read Appendix A if necessary.

4. Set up your general ledger sets.

5. Decide what general ledger activation mode you wish to run the system in. Go to the CAPITAL install program again and set the mode.

6. Test the general ledger sets you have created with test transactions.

7. Go to the general ledger and run the batch journal errors report on any newly created systems batches. Any obvious problems with the set-up of your general ledger sets will be reported.

8. Correct your general ledger sets if necessary and repeat step 6 until satisfied.