Setting Up A Chart of Accounts
This accounting software comes from the developer complete with a construction chart of accounts. The information in this section applies only if there are plans to delete the existing chart of accounts and create a new one from scratch.
The accounting system offers the ability to design the format of a personal Chart of Accounts or to use a standard ‘prebuilt’ set of accounts. This flexibility extends to allowing account numbers of any length from one to ten digits. The convention of assigning accounts in the following manner may be used:
10000 |
Assets |
20000 |
Liabilities |
30000 |
Equity |
40000 |
Income |
50000 |
Expense |
60000 |
General Expense |
Or any consecutive numbering system may be used. For further information on setting up the Job Cost Control Accounts, please refer to the section entitled Setting Up Job Cost Control Accounts included with this document.
Accounts and Financial Statement Line Items
Setting up a financial statement is a two-step process. First, enter all the General Ledger Accounts. Second, create a financial statement structure by creating Financial Statement Line Items. These include Headings, Single Accounts, Master Accounts, and Totals.
Entering General Ledger Accounts
General Ledger Accounts are used to store actual financial information. They will reflect balances from transactions made though the General Ledger or any other accounting module in the system. A 30 character description may be given to each account.
Financial Statement Line Items
There are four types of Line Items. They are: Headings, Single Accounts, Master Accounts, and Totals. A 30 character description may be assigned to each Line Item.
Headings
Headings simply print a heading on the financial statement page. Headings may be designated as Page headings, Centered headings or Left Justified headings.
Page Headings
The first Line Item on the page tells the printing program to form feed to a new page. The description of this Line Item will print in the center at the top of the page. This Line Item is usually used to display information like the name of statement, company name, date, etc.
Centered Headings
This prints the same as Page Heading. The only difference is that this account does not send a form feed command to the printer.
Left Justified Headings
These are used to describe sections of the statement such as Assets, Jobs in Progress, General Expenses, Owner’s Equity, etc. When printed, they print to the left side, lined up with the description of the regular General Ledger Accounts.
Single Account Line Items
This line item will print balance information for a single General Ledger account. Its description will be the same as the description of the General Ledger account it represents.
Master Account Line Items
This line item will be displayed on the Financial Statement and can contain any number of Single Account Line Items. During the printing of the P&L, the balances of these Single Account Line Items are added up and the total is printed under the Master Account heading. In this case it is somewhat a totaling account but does not have any relation to totaling accounts which will be discussed later. Master Accounts are designed to make the P&L more succinct and to summarize the detail of several individual accounts that would not necessarily need to show up on the statement.
Totals
Total Line Items are used to print totals of sections or groups of sections on the statement. When entering a totaling account, the other Line Items that should be included in this total may be selected
Each Total Line Item can be tabbed to the right on the Balance Sheet report to improve report clarity.
Hidden Variables
There are hidden variables that will provide some useful and timesaving features. These variables are entered into the description field of the framework account. The variable itself will be replaced with the feature described below.
[Company] |
Will be replaced with the company name entered in company setup. |
[Page] |
Will be replaced with the page number being printed. |
[StartDate] |
Will print the starting date of the first fiscal period being reported. |
[Date] |
Will print the ending date of the last fiscal period being reported. |
[Heading] |
Activates printing the "Current Month" and "Year-to-Date" headings over the two column display on the Income Statement. It must be placed in a left justified framework account just prior to or including the first left justified account in the Income Statement. |