home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
HomeWare 14
/
HOMEWARE14.bin
/
accounts
/
medlin_n.arj
/
PC-GL.DOC
< prev
next >
Wrap
Text File
|
1992-12-29
|
44KB
|
833 lines
PC-GL
Version 3.7
Copyright 1992, Jerry Medlin
PROGRAM DESCRIPTION
PC-GL is a double entry accounting program which allows a
small to medium size business to rapidly and accurately produce
financial reports and reconcile the bank statement. The program
runs on a IBM PC or compatible computer with at least one disk
drive, and requires at least 256k memory.
PC-GL is a Shareware program. You are encouraged to give
copies to anyone who might use it. If you use the program, please
send $35 to:
Jerry Medlin
1461 Sproul Avenue
Napa, Ca. 94559
To order using Master Card or Visa, call (707) 255-4475.
Your contribution entitles you to a copy of the latest
version of the program and limited telephone assistance should you
require it. You also receive a program which allows you to
customize some features of PC-GL. A complete description of this
customizing program is contained at the end of the manual.
To run the program, simply type "PC-GL". If you want to
specify a drive designation and path for your data, add the drive
and path description after the program name. i.e. type "PC-GL B:"
to use the B drive for data files. If you are going to use the
standard chart of accounts, be sure the file PC-GL.COA is on the
specified drive and subdirectory.
Each time you run the program, a menu is displayed for
operator selection:
Enter or Change Chart of Accounts
Enter or Change Transactions
Bank Reconciliation
Print Chart of Accounts Listing
Print Transaction Listing
Print General Ledger
Print Income Statement
Print Balance Sheet
Print Account Summary Report
Start a New Period or Year
End of Processing
Make a selection by using the up or down arrows to highlight
the desired function, then press <Enter>.
PC-GL allows a maximum of 800 items in the chart of accounts
and 6000 transactions per accounting period. With 256k of memory,
the number of transactions is reduced to about 500 per accounting
period. The number of additional transactions you can enter is
printed at the bottom of the menu screen. This number is limited
by either disk space or memory available, and is subject to an
absolute maximum of 6000 transactions.
When inputting information, the plus <+> key has the same
effect as the return or enter key. The minus <-> key enters a
negative number. This makes using the numeric key pad even
easier.
THE PROCESSING CYCLE
Usually accounting is done on a monthly cycle, but the PC-GL
program allows you to use any length of accounting period. Checks
and journal entries for the accounting period are entered using
the second menu selection (Enter or Change Transactions). Debits
are entered as positive <+> numbers and credits are entered as
negative <-> numbers.
Once all of the checks and deposits for the month have been
entered and the offsetting entries to cash in the bank have been
made, you may choose "Bank Reconciliation" from the menu and
balance your bank account. Bank Reconciliation an optional step
and is described later in the manual.
When all of the transactions have been entered and checked
you may begin printing reports. Reports may be printed in any
order and as often as desired. Reports may be printed to the
screen first to check their accuracy. Should you discover a
posting error after examining the reports, correct the error and
rerun the reports.
The only report that must be printed to the printer each
period is the General Ledger Report. If the General Ledger Report
has not been printed to the printer (not just the screen), you are
not allowed to end an accounting period and start another. The
General Ledger Report shows the opening balance for each account,
all of the transactions posted to the account for the accounting
period, followed by the closing balance for each account. Once
you start a new accounting period, the printed General Ledger
Report is your only audit trail. Starting a new accounting period
without printing the general ledger would leave no trace of how an
account arrived at its present balance. Since organizations like
the IRS want to know how you arrived at those numbers on your tax
return, the General Ledger Report is required. If it hasn't been
printed, you will not be able to start a new accounting period.
To start a new accounting period, you may answer "Y" to the
question "Do you want to start a new accounting period?" on the
opening screen, or you may select "Start a new period or year" on
the main menu. When you start a new period, the current period
balances are set to zero and the transactions for the previous
period are saved for later review. You may then begin entering
transactions for the new period.
DOUBLE ENTRY ACCOUNTING
Double entry accounting requires the total of all debit <+>
entries to be the same as the total of all credit <-> entries. It
does not mean there must be a credit for every debit, only that
all of the entries must add up to zero. Each accounting period
consist of a series of balanced entries with equal pluses and
minuses.
All of the checks written during a month are posted to the
various expense accounts as debit <+> amounts. Then the total of
all of those checks is then posted to the CASH IN BANK account as
a single credit <-> amount. All income amounts are entered as
credit <-> amounts to various income accounts and a corresponding
debit <+> entry is made to the Cash in Bank account or to Accounts
Receivable. The net of all the transactions posted is therefore
zero, making a balanced series of entries. The PC-GL program
helps you when posting transactions, by displaying the balance of
all transactions posted at the upper right of the screen. When
all of the transactions for the accounting period have been
posted, the balance displayed should be zero.
If you are unfamiliar with double entry accounting, it is
beyond the scope of this manual to completely cover the subject.
However, all is not lost. The PC-GL system can also be used as a
simple single entry system. Just enter all your expenses and
income to the proper account, and run the system normally.
Expenses are entered as positive <+> amounts and (this is
important!) income amounts are entered as negative <-> amounts.
To enter a negative amount, first enter the number then press the
minus<-> sign.
SETTING UP THE CHART OF ACCOUNTS
A standard chart of accounts is provided with the program.
Although any sequential numbering scheme will work with the
general ledger program, the one provided is in common usage by
accountants. To use the standard chart of accounts, simply run
the program with the file PC-GL.COA on the data disk drive.
The chart of accounts can be added to at any time during the
processing period. All chart of accounts setup and modification
is done using the <Enter or Change Chart of Accounts> selection on
the menu. This section allows you to add new COA items, delete or
change existing ones, or examine the COA by scrolling up and down
the screen. You may even change account numbers at any time and
the program will automatically change the account numbers on any
transactions. All commands are listed at the bottom of the screen
and are selected by a single keystroke. Upon entering this
section, you may immediately begin adding items to the chart of
accounts or, by pressing the Escape key, you may go to the command
mode and insert, delete or change items in the chart of accounts.
You will not be allowed to delete an account with a balance
or change balance amounts. Changing amounts is done by posting
transactions to the account. This way you have that all important
audit trail. Upon exiting the chart of accounts section, the
chart of accounts is automatically sorted in account number order.
The following information is contained in each chart of
accounts:
1) ACCOUNT NUMBER - A three digit number between 000 and
999 which will be used for posting transactions.
2) ACCOUNT CODE - A two digit number which determines how,
and on which reports, the item will be printed. (See the
section on COA coding for details.)
3) PRIOR YEAR % - This number will be printed on the income
statement and is for informational purposes only. If no
prior year % is desired just press enter for this entry and
none will be printed on the income statement. The prior year
% is updated automatically at the end of the year, by the
Start a New Year procedure.
4) ACCOUNT DESCRIPTION - Up to 27 characters are allowed
for the account description.
5) CURRENT AMOUNT - This is the balance of all transactions
entered to this account for the current accounting period.
If an asterisk <*> is entered during setup, this chart of
accounts entry will be treated as a title account on reports.
Title accounts are used to provide headings and totals on
reports. Transactions cannot be posted to a title account.
Press any other key during setup to enter a zero beginning
balance for current and year to date.
6) YTD AMOUNT - This is the balance of all transactions
entered to this account for the current year. Opening
account balances cannot be entered when the chart of accounts
is set up. They must be posted as transactions.
Remember to look at the bottom of the screen, when in doubt.
Your options are printed there.
The first item in the chart of accounts should contain the
company name to be printed on all reports. If you are using the
standard chart of accounts, change the description of the first
account from STANDARD CHART OF ACCOUNTS to the name you want
printed on your financial statements.
Once the chart of accounts has been setup, you won't use this
section, except to occasionally add new items to the chart of
accounts or delete unwanted accounts with zero balances.
ENTERING TRANSACTIONS
All checks and journal entries for the accounting period are
entered using the <Enter or Change Transactions> selection of the
menu. This selection also allows you to examine entries by
scrolling up and down the screen and to insert, delete or change
entries. You may also obtain a total for a particular account and
you can search all of the transactions for any string of
characters. All commands are listed at the bottom of the screen.
Each transaction contains the following information:
1) DESCRIPTION - Allows up to 21 characters to describe the
entry. Pressing <Enter> or <+> causes the previous entry to
be repeated. To enter a blank description, press the space
bar, then <Enter>.
2) CHECK NO. - A five digit check or reference number.
Numbers or letters may be used. Pressing <Enter> causes the
previous number to be repeated. Pressing <+> enters a number
equal to the previous number plus one. (This is useful when
entering a series of checks with sequential check numbers.)
3) DATE - The date must be entered in MODA form. i.e.
0108, for January eighth. Pressing <Enter> or <+> repeats
the previous date. Any day of the month higher than 80
causes the transaction to be posted to the year to date
balance only. So, a transaction with a date of 0193 would
not affect the current balance, only the year to date
balance.
4) ACCOUNT NUMBER - Enter a three digit account number.
With each digit entered, a list of possible matching account
numbers and descriptions will be displayed at the bottom of
the screen. Just Pressing <Enter> at the beginning, will
enter the previous account number. Pressing <Enter> after
entering the first digit will enter the first account number
displayed at the bottom of the screen. If you attempt to
enter an account number not in the chart of accounts, the
computer will beep.
5) AMOUNT - Enter the amount calculator style without using
the decimal point. Debit entries are entered as positive
numbers and credit entries are entered as negative numbers.
Positive <+> numbers are entered with either the plus <+> or
Enter key. To enter a negative number, enter the number and
then press the <-> sign.
If you press the <Enter> key without entering an amount, an
amount is entered equal to the net of all of the transactions
for the period, but with the opposite sign. In other words,
a balancing entry is created. If the net of all of the
transactions so far is +1234.56 and you press the <Enter> key
without entering an amount, 1234.56- is entered. This
feature is especially useful for those users who want to
enter a debit for each credit.
You may pop up a calculator at any time by pressing the F10
key. To insert the calculated result in for the amount,
press <Enter>.
The net amount of the current check, and the net of all the
transactions posted for the period are constantly displayed on the
screen. The check balance is useful when posting a single check
to multiple accounts. For double entry accounting, the net amount
of all transactions should be zero when you finish with posting
for the period.
When using the <C> Change selection to change a chart of
account item or a transaction, you don't have to reenter each
field. Press the enter key, to skip to the next field.
The <T> Total selection for transaction entries is useful for
checking balances. It can, for instance, be used to add up all
the purchases, so you can make an ending inventory calculation
based on a desired cost of sales.
If you are using the PC-AP Accounts Payable program, <R> Read
PC-AP Transactions allows you to read all of the checks written by
PC-AP into the PC-GL program. Transactions from PC-AP are not
posted to PC-GL until you select <R> Read PC-AP Transactions.
The <G> Go Back to Previous Period can be used when you
answered the "Do you want to start a new accounting period?"
question incorrectly. It undoes all of the things "Start a new
accounting period" does. You can go back to a previous period
only if there are no current transactions and you can only go back
one period. You cannot go back to a period in the previous year.
The asterisk key <*> is used to mark checks that have not
cleared the bank at the end of the month. Bank reconciliation is
described later in the manual.
PRINTING REPORTS
To print any of the available reports, select the report from
the main menu. You will be asked to input a report date to be
printed on the report. Alphabetic and numeric dates are
acceptable. i.e. January 31, 1987. Pressing enter enters the
displayed default date.
You can then choose to print to a printer, to the screen or
to a file.
If you choose to print to a file, you are prompted for a file
name. The program prints the report to this file exactly as it
would have been printed to the printer. These files are regular
ASCII files, and are read by most word processors. You may
optionally leave off the report headings, when you print to a
file, so that the data can be imported into a spread sheet or data
base.
ACCOUNT SUMMARY REPORT
Each time you start a new accounting period, the transactions
for the prior period are saved. Eventually, up to 12 accounting
periods (months) are saved. The most recent transactions are in a
file named GL1.TRN, and the oldest transactions are in a file
named GL12.TRN. The account summary report allows you to print a
summary of transactions for a single account. You can also sort
the transactions by description, date, check number or account
number. You will be asked for an account number and the number of
months to go back. Inputting zero for the number of months will
look at only the current period. If you enter ALL for the account
number, you may also print a General Ledger Report going back up
to 12 months.
This is a useful report to print at the end of the year so
that you can review the year's activity with one General Ledger
Report instead of having to look at 12 individual reports.
START A NEW PERIOD OR YEAR
The choices are "P" to start a new period or "Y" to start a
new year. You may also start a new period by answering Yes to the
question "Do you want to start a new accounting period?" on the
opening screen. However, you will not be asked if transactions
have been entered or changed since he General Ledger report was
last printed.
At the beginning of a new accounting year, press "Y" from
this selection to set all profit and loss account balances back to
zero. The prior year percentages will also be updated to reflect
the year just ended. You will be asked for the account number of
your capital account, so the profit or loss for the year just
ended can be automatically posted to the capital account. If you
are using the standard chart of accounts, the capital account is
account number 465. This section should be used only once a year.
Normally, you must start a new period before starting a new
year. If you start entering transactions for the first month of
the new year, but forget to start a new year, you may still start
a new year. The current transactions will become part of the new
year.
END OF PROCESSING
When processing is completed, you must exit the program using
this selection. You are asked if you want to end processing. A
yes "Y" answer saves the chart of accounts, and all of the current
transactions. Any answer other than "Y" returns you to the main
menu.
CHART OF ACCOUNTS CODING
If you use the standard chart of accounts or a modified
version of the standard chart of accounts, it is not necessary to
be familiar with chart of account coding. Just delete the
unwanted chart of account items. This information is provided for
those who want to use their own chart of accounts, or produce
special reports.
The first number of the two digit code is a number from 1 to
9 which determines the account type.
1. ASSETS
2. LIABILITIES & EQUITY
3. INCOME (OR SALES)
4. COST OF SALES
5. GROSS PROFIT
6. OPERATING EXPENSES
7. OTHER INCOME
8. OTHER EXPENSES
9. NET PROFIT
The GROSS PROFIT (#5) and PROFIT OR LOSS (#9) are generally
used only once in each chart of accounts, for totaling purposes.
The COST OF SALES (#4), GROSS PROFIT (#5), OTHER INCOME (#7) and
OTHER EXPENSES (#8) can be omitted, if your applications don't
require those categories.
When printing the income statement, the sign for the balances
of accounts with odd numbered account codes is reversed. So,
income amounts (#3) which normally have a credit balance and are
carried as minus numbers in the general ledger are printed on the
income statement as positive numbers.
The second number of the two digit code determines the
totaling level for an account on the income statement and balance
sheet. The total level is used to determine what totals and
subtotals appear on reports. Each higher total level totals all
previous lower account numbers. The best way to understand how
the totaling level works is to experiment. Change the number and
reprint the report to see how it looks. Chart of account coding
can be changed at any time without causing problems.
Total Level:
0 The balance and description will print only on the general
ledger report. When printing the balance sheet or income
statement, the balance (if any) is totaled and printed into
the next higher number. i.e. The total for a series of 0
coded accounts prints into the next account numbered 1 or
higher.
1 Used for most accounts. On the balance sheet the account
balance is printed in the first column.
2 Prints total of all previous 0 and 1 accounts. Prints in the
middle column of the balance sheet.
3 Prints total of all previous 0, 1, and 2 accounts. Prints in
the right hand column of the balance sheet.
4 Used for subtotal accounts such as TOTAL ASSETS, OPERATING
PROFIT etc.
5 Used for the NET PROFIT account on both the balance sheet and
income statement. If the balance sheet does not contain a
level 5 account, the balance sheet will not balance.
For complex income statements, an additional total level (6)
is available.
The second digit is also used to control paging, spacing and
underlining. Any number higher than 1 will be preceded by a blank
line. A 9 in the second digit of a title account causes the
printer to start a new page.
Accounts used only for totaling the balances of previous
accounts or for printing titles on a statement are title accounts.
A title account is created by entering an asterisk in the current
balance column of an account. You cannot post any transactions to
a title account. Most accounts with a totaling level higher than
1 are title accounts.
You can print an extra blank line on the income statement or
balance sheet by entering a title account with a blank
description.
Underlining on the income statement and balance sheet is
accomplished by entering an account, with a non-numerical
character in the second digit of the two digit code. (Non-
numerical means something other than 0 through 9.) The character
will be used to print a line under the last number printed on the
income statement or balance sheet. So, an account code ending
with a dash <-> prints a single underline and an account code
ending with the equal sign <=> prints a double underline. The
account's only purpose is to print the underline. The account
should be a title account, and it's description will be ignored.
USING OTHER PROGRAMS FROM JERRY MEDLIN
There are four other programs available from Jerry Medlin:
PC-AR - a balance forward Accounts receivable program.
PC-PR - a payroll writing program.
PC-AP - an accounts payable and check writing program.
PCINV - an invoice writing program
The only program which integrates directly with PC-GL is the
accounts payable program: PC-AP. You must have PC-GL in order to
use the accounts payable program. All of the checks or invoices
entered in PC-AP are automatically posted to PC-GL at the end of
the month.
PC-AR and PC-PR are "stand alone" programs and do not
automatically post to PC-GL. You must post the totals from the
accounts receivable program and the payroll program with a short
series of journal entries each month, which usually takes no more
than a few minutes each month. This provides greater control and
flexibility to the whole accounting process.
The details of the journal entries from PC-PR and PC-AR to
PC-GL depend on your particular situation, but might look
something like this:
Check Account Check
Description Number Date Number Amount
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Cash Received on Acct GJN01 0131 103 22345.67
January Sales GJN01 0131 511 22345.67-
January Gross Pay GJN01 0131 708 2045.43
January Fed W/H GJN01 0131 331 190.00-
January FICA GJN01 0131 332 146.26-
January SDI W/H GJN01 0131 333 24.53-
January State W/H GJN01 0131 334 14.70-
January Net Pr GJN01 0131 103 1669.94-
The first two entries are from the accounts receivable
program and the last 6 entries are from the payroll program. The
entries would vary depending on cash or accrual basis and, of
course, the amounts and accounts involved.
PRIOR PERIOD CORRECTIONS
If you find an error in the previous period and you have not
yet started a new accounting period, you can answer "N" to the new
accounting period question at the beginning of the program and
rerun the period. Even after you have started a new accounting
period, the <G> Go Back to Previous Period from Enter or Change
Transactions can be used to go back to the previous period. It
undoes all of the things "Start a new accounting period" does.
You can go back to a previous period only if there are no current
transactions and you can only go back one period. You cannot go
back to a period in the previous year.
Other than going back to the previous period, you cannot
change prior transactions with PC-GL. If the error is from an
earlier period, you must make the correction to the current
period. You can enter the correction without affecting current
period balances, by using a day of the month higher than 80. A
date such as 0193, for instance, would tell the program to enter
the transaction only in the year to date column, and not post as a
current transactions.
HANDLING BEGINNING AND ENDING INVENTORY
If your application doesn't require the beginning and ending
inventory to show on the income statement, you can skip this
section. It discusses a commonly used, but somewhat confusing,
technique to properly display beginning and ending inventory on a
computerized income statement.
Any transaction with a date containing a day of the month
higher than 80 is posted as a year to date transaction only. It
does not affect the current period balance. This is moderately
useful for making adjustments to the year to date balances, but
it's principal value lies in making the beginning and ending
inventory work properly on the income statement.
If we assume the inventory at the beginning April was
$25000.00, and the inventory at the end of April was $29000.00;
the following series of entries are required:
Description Ref # Date Acct # Amount
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Inventory GJN04 0430 151 29000.00
Inventory GJN04 0430 151 25000.00-
Beginning Inv. GJN04 0430 610 25000.00
Ending Inv. GJN04 0430 696 29000.00-
Ending Inv. GJN04 0493 696 25000.00
Beginning Inv. GJN04 0493 610 25000.00-
Notice the last two entries are year-to-date entries, because
the day of the month is higher than 80. If the beginning and
ending inventory accounts start at zero (as would be the case at
the beginning of the year), the last two year-to-date entries are
omitted.
BANK RECONCILIATION
To reconcile your bank statement simply mark the checks that
have not cleared the bank and then enter your bank statement
balance and any adjustments.
Outstanding checks are marked from the Enter or Change
Transactions screen. Press the asterisk <*> key to mark or unmark
a check as outstanding. If a check has been split among several
different accounts and therefore takes several transaction lines,
marking anywhere in the check marks the whole check. You may also
mark deposits that have not yet shown up on the bank statement if
your deposits have been entered individually with unique check
numbers. If you make a mistake press the * key again to unmark a
check.
Outstanding checks will be printed with an * in the
Transaction Listing report, but have no effect on the Income
Statement, Balance Sheet, General Ledger or Account Summary
Reports.
Now choose Bank Reconciliation from the menu, and enter the
ending balance on the bank statement under "Balance Per Bank
Statement".
You may enter up to five "adjustments" to the bank balance
and a short description of each adjustment. Examples of such
adjustments:
1) Any outstanding checks from prior months must be entered as a
minus <-> amount. Normally, if a check doesn't clear the bank in
a month, it never will and should be voided. You can, however,
enter a slow check as an adjustment.
2) Outstanding checks from the payroll program must be entered as
a minus <-> amount. Normally, individual checks from PC-PR are
not posted to PC-GL, so you cannot mark the checks as outstanding.
If you use PC-PR, run a tape of the outstanding payroll checks and
enter the total as an adjustment.
3) Deposits in transit at the end of the month should be entered
as a plus <+> amount. If your deposits have been entered as
unique transactions, you may, instead, mark them as outstanding
and they will be included with the outstanding checks total.
4) Any checks from the next month that have already cleared the
bank should be entered as a plus <+> amount.
If you have more than five adjustments, you must consolidate
some and enter a total.
The reconciled bank balance should eventually be the same as
the General Ledger bank balance for the Cash in Bank account. The
last number on screen is the difference and should be zero. If
you get zero on your first try, you are indeed living a charmed
life. If not, welcome to the real world. There are several
things to check:
1) The GL balance is based on the closing balance in account 103.
If you have no account 103 in your chart of accounts the next
account following 103 is used. If your chart of accounts has
another account using number 103, you must change it. Remember,
you can change account numbers in the chart of accounts at any
time and the program will automatically change any previous
transactions entered to the old account number.
2) Make sure you have entered the offsetting entries to the Cash
in Bank account: a credit <-> entry for all of the checks entered
and a debit <+> entry for all deposits entered.
3) Check the adjustments. All outstanding checks from a previous
period and outstanding checks from the payroll program must be
entered as a minus <-> amount and any deposits in the GL but not
on the bank statement must be entered as a plus <+>.
4) Check the bank statement. Any bank charges or adjustments
must be included in the transactions with an offsetting debit or
credit to the Cash in Bank account. Any checks shown as
outstanding on your last bank reconciliation that haven't cleared
the bank must be voided or entered as an adjustment.
5) Check your transactions. Scroll through your transactions
using Enter or Change Transactions. Each transaction for the
current month should either be on the bank statement or marked as
outstanding. If your accounting includes several months in a
single period, make sure there are no transactions in this period
marked as outstanding that have since cleared the bank.
Transactions with a net of zero ( ie journal entries) and
transactions to the bank account may be ignored.
Once your statement is in balance, you may print it by
pressing <P>. The list of outstanding checks is also included in
the printed report and may be viewed at any time by pressing <V>.
The Bank Reconciliation selection works best when used with a
bank statement that lists cleared checks sorted by check number.
Most banks now provide such a statement.
USING THE CONFIGURATION PROGRAM
The configuration program (GLCONFIG.EXE) is provided to all
registered users. It allows you to change certain features of PC-
GL. The GLCONFIG.EXE program and the main program (PC-GL.EXE)
should both be on the same disk drive and sub directory, when you
configure your copy of PC-GL. Run the program by typing GLCONFIG
at the Dos prompt. The previous configuration of PC-GL will be
displayed. Use the up and down arrows to move the pointer and
then press <C> to change an item. The following information may
then be changed:
Display Colors - If you have a color adapter and monitor, you
can change the colors for screen borders, program prompts,
data, and background. Allowable colors are from 0 to 15
(except for background color which can only be from 0 to 7).
Laser Printer? - You can also change the way PC-GL starts a
new page. Usually, PC-GL starts a new page by counting lines
until the page total equals 66 lines. If you enter a "Y" for
the laser printer question, PC-GL starts a new page by
issuing a form feed command. This also works on most other
printers, but requires you to set the top of form before you
start printing.
Zero Balances on Statements? - If you don't want accounts
with zero balances to print on the income statement or
balance sheet, change this to a "N".
Months to Save - The program normally saves the past 12
months of transactions so that they can be reviewed with the
Account Summary selection. You can change this time period
to any number from 1 to 30. A smaller number requires less
disk space, and speeds the new period processing by a few
seconds.
Disk Drive and Path - Enter a drive and path designation for
PC-GL data. If you want the program to read data from the B
drive, enter B:.
Printer Number (1 or 2) - For printing to LPT1 or LPT2.
Income Statement Heading - You can change the default heading
printed on the income statement report. You will probably
need to start with some blank spaces to line up the heading
correctly. Sometimes trial and error is the best way.
Balance Sheet Heading - You can also change the balance
sheet headings.
Income Statement and Balance Sheet Footers - A "footer" is a
short comment inserted at the end of a report. An example of
a footer would be a statement like "Prepared without benefit
of audit", or any other meaningless comment your attorney
tells you to put on your financial statements.
When you have finished making your changes, press the escape
key to exit the program. You will then be asked if you want to
save the changes. If you answer with a Y, PC-GL is changed, until
you run the configuration program again.
DATA FILES
Data files are created automatically by PC-GL. If you wish
to back up data files only, copy these files to another disk using
the DOS copy or BACKUP command.
PC-GL.COA Chart of account listing with balances.
PC-GL.TRN Current period transactions.
PC-GL.CFG Configuration data created by GLCONFIG.
GL1.TRN, GL2.TRN, GL3.TRN etc contain the previous period
transactions. GL1.TRN is the most recent.
HELPFUL HINTS
You may pop up a four function calculator at any time by
pressing the F10 key. Use the + and - keys to add and subtract,
and the * and / keys along with the = key to multiply and divide.
Opening balances are entered as transactions, using the Enter
or Change Transactions selection. If you enter the opening
balances using a day of the month higher than 80 (for example
0293), the opening balances do not affect the current period
totals.
It is helpful to remember that PC-GL uses data loaded into
random access memory. New data is not saved to the disk until you
end processing, or select the <S> Save option from the Enter or
Change Transactions section of the program.
If you do not get the question "Do you want to start a new
accounting period?" when starting PC-GL, it is because you didn't
print the General Ledger report to the printer. Changing even a
single transaction convinces PC-GL you have not printed the
General Ledger report, and prevents the new period question from
appearing.
The first 12 times you start a new accounting period, more
disk space is required for historical files. If you have a large
business and you are using floppy disks for data storage, you
could run out of disk space. Reduce the number of periods saved
using the GLCONFIG program.
You can use the Account Summary Report each January to help
in summarizing payments for 1099 forms. The 1099 is the form the
government wants every year which reports payments to individuals
of over $600.
The "Zero Balances" selection in the chart of account command
mode sets ALL chart of account balances to zero and deletes any
transactions entered for the period. There are only two reasons
to ever use this command:
1) When you first start using PC-GL you might want to practice a
few times before you really get started. Use "Zero Balances" to
get a fresh start. If you have run a number of test months, and
wish to delete all of the Account Summary data: exit to the disk
operating system and type: ERASE GL*.TRN.
2) If you want to use an existing chart of accounts setup on a
new application, you could zero the existing balances after
copying the chart of accounts file PC-GL.COA to the disk for the
new business.
If your transactions are being posted only to the year to
date balance and not the current balance, it is because you have
entered the date incorrectly. Dates should normally be entered as
month and day, not month and year. A date such as 0693 will cause
the amount to be posted to the year to date balance only.
This version of PC-GL is completely compatible with all other
versions of PC-GL except for the method of saving and recalling
old transaction files. If you have been using a version number
lower than 3.0 (version 2.9 or lower), you need to convert the
historical data if you want to use it with this program. Contact
us for instructions on how to convert the old data.
PC-GL is written in Turbo Pascal. The source code is
available for $95.