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

Financial Reports


Let us now turn to the two most common financial reports. The profit and loss statement or trading statement and the balance sheet. The first type of report is concerned with income and expense accounts. Its purpose is to show how we arrived at our retained earnings (net profit) for a given time frame. Typically this is a one month period, but some organisations may print reports only for the quarter or entire year. The report often comes in several sections which some firms combine together while others print separately. The first part is the revenue/income/trading section. It includes the income accounts and direct expenses. It might take the form of:

Revenue

 

Current

 

Month

Sales - accessories

295.00

Sales - cards

200.00

Sales - stationary

                     205.00

Sales - magazines

                  78.22

Sales - books

115.00

                                        

  ------------

                                            

     893.22

Other income

 

                                                

Current

Month

Rent

                                           115.00

         

                                  ------------

             

                                    115.00

                 

                         ------------

                     

                          1008.22

Less cost of goods sold

 

cost of stock

                      450.00

freight and handling

                   24.00

                                 

          ------------

Gross profit

          534.22

Strictly speaking, a trading statement would probably not show an "other income" section in this part of the report since "other income" is not a part of regular day to day trading. This is why some accountants prefer to call this report the income statement.

The gross profit differs from net profit in that indirect expenses have not yet been taken into account. These expenses are listed in the expense schedule portion of the profit and loss statement:

 

Operating expenses

 

 

Current

Month

Accounting fees

100.00

Delivery expenses

10.00

Cleaning

45.00

Spare parts

200.00

Insurance - workers compensation

115.00

 

------------

 

470.00

Less gross profit

534.22

 

------------

Net profit

64.22

As we can now more clearly see, net profit is calculated by adding up the income account balances (which are conveniently all credits) and deducting the expense accounts (which are all debits).

Previously it was mentioned that net profit and retained earnings are the same thing. In certain circumstances this may not be the case and this is shown in the appropriations section of the profit and loss statement. Appropriations inform readers of the report what was done with the net profit. Shareholders may seek dividends and the taxation department will want their cut. This section might take the form of:

 

Statement of appropriations

                                                  current

                                                    month

Net profit before tax 64.22

Less income tax expense 19.27

                                             ------------

Net profit after tax 45.95

Less dividends declared/paid 0.00

                                             ------------

Retained earnings for period 45.95

                                             ------------

 

Although income tax expense is an ordinary expense account, we show this after the other expenses are listed on the report. This is because company tax will be based on your net profit and this must therefore be calculated last. What is left after this is retained earnings. This may receive further deductions in the form of dividends paid to shareholders. If dividends are not issued, the remainder is carried into the balance sheet report and becomes part of the firm's retained earnings.

Observe one other interesting point: tax on earnings is calculated before dividends (if any) are provided to shareholders. Dividends are not usually tax deductible. While they are, in a sense, an expense to the company concerned, they are treated as a special type of non-deductible expense.

The balance sheet report lists your company assets, liabilities and special liabilities that was previously referred to as CAPITAL. Deducting liabilities from assets equals net worth. Net worth should also be equal to retained earnings plus other shareholder or owner investments. This is equivalent to the firm's total equity. That is to say, total equity = net worth. This is the balance sheet up to the calculation of net assets:

Current assets

 

Stock on hand

25846.84

Anz bank

5681.14

Debtors

234.35

 

------------

 

31762.33

Fixed assets

 

Furniture and fittings

10350.00

Plant and equipment

65456.50

 

------------

 

75806.50

Current liabilities

 

Creditors

668.27

 

------------

 

668.27

Non current liabilities

 

Bank loan ANZ

10000.00

 

 

Net assets

96900.56

The final section of the report lists the CAPITAL accounts:

Shareholders equity

 

Authorised CAPITAL

90000.00

Retained earnings

6900.56

 

------------

 

96900.56

In this case, retained earnings for the current period ($45.95) as calculated on the profit and loss statement, has been lumped together with retained earnings from prior periods (sometimes referred to as reserves) of $9554.61. The total adds up to $9600.56.

Observe once again the principle total equity = net worth. If a company makes a profit this means a gain in assets. After all, the profit is going to be in the form of cash, or a higher debtor balance or more stock, etc. So an asset must be increased by a certain amount along with the retained earnings account. Likewise, if a loss is made, this increases a liability or reduces an asset (or both) and, of course, retained earnings is also reduced. As you can see from this, asset and liability accounts are linked to CAPITAL liability accounts. A change in one will directly cause a change in the other.