home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Frostbyte's 1980s DOS Shareware Collection
/
floppyshareware.zip
/
floppyshareware
/
LGB
/
GJ.ZIP
/
CHART.DOC
< prev
next >
Wrap
Text File
|
1987-03-02
|
36KB
|
703 lines
Experienced bookkeepers and accountants need not review the material
immediately following. Page down to the section beginning "Your Chart of
Accounts".
History
-------
The German romantic poet Goethe said that double entry bookkeeping is
beautiful and elegant. It is all of that and more, probably the most
powerful, yet simplest, bit of lateral thinking ever conjured up by the human
imagination. It allows a people with no formal concept of zero or negative
numbers to indulge in the most complex of financial dealings -- piracy, trade
and empire.
Double entry bookkeeping as we know it probably appeared in the great Islamic
civilization of the 10th or 11th Centuries. Conceivably, the Arabs introduced
it into Europe through Spain, along with algebra, the zero, and modern clocks,
at about the time of Ferdinand and Isabella, just prior to the Renaissance.
But earlier... Did Omar Khayyam puzzle over double entry bookkeeping? He
knew about closing an account in 1123 A.D., if we can trust Fitzgerald's
translation of the Rubaiyat! And he wrote the first Arabic book on algebra.
Did he or some other astronomer-mathematician INVENT algebra as a way to
explain to the poobahs of the Persian court how double entry actually works?
I don't know, but I'd like to think so. I think double entry bookkeeping came
first, and suggested algebra to the quick-witted sometime later. But Omar
Khayyam, vizier to the Caliphs of Persia, knew about it in the 12th Century.
Modern accounting PRACTICE, on the other hand, dates only from about the 16th
Century, or about the time of the Borgias.
This leads us to a very brief tutorial
--------------------------------------
Double entry bookkeeping is designed to show the ownership of assets. That's
ALL it does. Once you've caught on to that, the rest is easy.
Everything you have either belongs to you, or to your bank or other creditors.
Everything you have is described in Asset accounts. Everything your bank or
creditors has loaned to you is described in Liability accounts. Everything
you can call your own is summarized in Equity accounts. The sum of what you
OWN and what you OWE, therefore, equals the value of what you HAVE:
What You Have = What You OWE plus What You OWN.
Your books therefore BALANCE. Each side is equal. That is double-entry
bookkeeping in a nutshell, and the rest is just practice and experience. The
equation is called the Fundamental Equation of Accounting:
Assets = Liabilities + Equity.
For example, your Checking Account is an ASSET. You have money. But your
bank owns the money it lends you. If you take out a loan, the TRANSACTION is
a two-edged sword: You increase the value of your Checking Account, AND, you
increase the level of your debt. The difference in either account is exactly
the same. There is a CONVENTION that you DEBIT assets (record them in the
left column) and CREDIT liabilities (right column), that is:
Left = Right.
Left + Amount Loaned = Right + Amount Owed.
If you are familiar with algebra or computer programming, this might be a
useful insight: A Ledger ACCOUNT is like a VARIABLE. It can contain a value
or no value at all. The value it contains can be positive (LEFT column) or
negative (RIGHT column). And the account can have a name, independent of the
value in it. This parallel with algebra is very suggestive to historians and
it has been used to teach accounting at least since Beau Brummel invented
pants. But it gets in the way, too!
The modern (post-Renaissance) convention further states that when you tote it
all up, you get zip:
Assets - Liabilities - Equity = 0.
It required the invention of algebra to realize this fact. But buried in this
simple-looking formula is the ultra-modern insight that computers can
represent Credits as negative numbers and Debits as positive; thereafter, mere
addition automates everything! That's great for programmers, bad for people.
Assets + ( -Liabilities ) + ( -Equity ) = 0.
Unfortunately, bad design in accounting software all too often forces people
to think like computers. Instead of writing plain positive numbers in
traditional left and right columns -- the method used for centuries -- bad
human factors force you to think in and use negative numbers. And negative
numbers are a pointless, unnecessary distraction.
The algebraic interpretation is pervasive and correct. But it's also wrong.
With GL version 1.12, you don't have to add or subtract anything.
The reason you use this GL program (or any other) is so YOU DON'T HAVE TO
THINK ABOUT THE ARITHMETIC, period. Just record your transactions, following
the Debit (left column) and Credit (right column) rules by rote, and the rest
truly is automatic!
Visual Reminders of Rote Rules
------------------------------
The "rote rules", in GL version 1.12, are clearly indicated in your General
Journal. Every account you use is marked by a "+|-" or "-|+" reminder, to
indicate which columns you use to INCREASE or DECREASE an account's balance.
Asset and Expense accounts are marked "+|-", meaning that you put money into
your checking account (an Asset account) in the LEFT (debit) column, and you
increase the level of your expenditures the same way. (But notice that
increasing expenditures means decreasing income. Expense accounts are a
special case of the pattern for Liability, Revenue and Equity.)
Liability, Revenue and Equity accounts are marked "-|+", the exact opposite.
You take out a loan (Liability) in the RIGHT (credit) column, you pay off your
creditors in the LEFT (debit) column. You record dividend income (a Revenue
account) the same way. You record your capital investment (an Equity account)
in the RIGHT column, and you record your personal withdrawals from capital
(also an Equity account) in the LEFT column.
Double entry means that you DEBIT AND CREDIT every transaction, once to an
account in the left column, and once to another account in the right column.
If you receive dividend income, DEBIT your (Asset) Cash account and CREDIT
your (Revenue) Dividends account. See the General Journal documentation for
some other examples.
The Check Register function of GL version 1.12 handles the special case of
recording your checks and checking account deposits. The "+|-" reminders are
not shown there, because you do not have to decide for yourself which columns
you should use.
Revenue & Expense Accounts are Equity Accounts
----------------------------------------------
It's not obvious where the notion of profit & loss fits into the fundamental
equation of accounting. It's not obvious that profit is even relevant to some
kinds of accounting, such as home bookkeeping, or non-profit corporations, or
government agencies. A deficit or zero "profit" has special meaning in these
cases, but it's still "profit" -- Revenues less Expenses -- although you may
call it something else. In the case of home accounting, if your income
exceeds your expenses, the difference contributes to your total Net Worth.
Revenue and Expense accounts are the instrument you use to keep track.
This is worth emphasizing:
Revenue and Expense accounts are all a species of EQUITY
account. That is, a credit to an EXPENSE account has exactly
the same effect on your Balance Sheet as a credit (!) to a
REVENUE account.
Is that what you expected? If you understand that, you understand everything
there really is to know about double entry bookkeeping. Discussion follows!
The only difference between a Revenue and an Expense account is what you USE
it for, the kind of information that gets stored there. This is why we can
say that account numbers in the 600's, 700's, 800's and 900's are Expense
accounts (like 500's). To look at it another way, all these "expense"
accounts are just another sort of Revenue account (like 400's) -- "negative
income". The way ALL of these EQUITY accounts are managed by the centuries-
old double entry bookkeeping rules is exactly the same in every case. An
expense account is only an expense account because we record Expenses there.
If the customary usage is different, typically the account's customary name is
also different -- e.g., "Revenue". The Muse of History is fickle.
How does the USAGE vary, then? Why not just have ONE BIG Equity account
called PROFIT (or NET LOSS, if you're a pessimist). Custom, the practice of
the ages, has decreed that one shall not do that, because it's not very
useful. Instead, bookkeepers block off a chunk of Equity accounts, and in
these accounts all expenditures are recorded in the LEFT column (only). In
another block of Equity accounts, all income is recorded in the RIGHT column
(only). And this is all there is to it -- that alone creates the distinction
between Revenue and Expense accounts.
You COULD do it all in one account -- an account has two columns, after all --
but you would quickly lose your grip on what's happening if you did that.
It's better to keep the details where they are, and summarize later.
When you "close the books" at the end of a month (or other natural accounting
period), the difference between your total revenues and expenses -- your
profit, be it gain or loss or breakeven -- actually is posted to yet another
Equity account. This special Equity account is usually called Retained
Earnings.
The Retained Earnings account is the "one big account" just mentioned.
Ahhh... you CAN have everything! The Retained Earnings account is also
privileged -- normal accounting practice prohibits any adjustment to Retained
Earnings except by means of closing the books (a rule which GL enforces
according to the strict interpretation).
Closing the books means that an amount equal to every Revenue or Expense
account's net balance is posted to the OPPOSITE COLUMN, to bring the balance
to zero, AND SIMULTANEOUSLY, an opposing entry is posted to Retained Earnings.
If an account has a LEFT column balance of $300.00, the account is CLOSED by
writing $300.00 in the RIGHT column of that same account (bringing the balance
to $0.00), AND BY writing $300.00 to the LEFT column of the Retained Earnings
account. The effect is to move the $300.00 from where it was to a summary
account, without affecting the balance of the books.
The amount posted to Retained Earnings is a SUMMARY OF ALL the Revenue and
Expense accounts, but an actual offsetting value is posted to each one of your
Revenue or Expense accounts.
The indirect method, which requires closing the books, is preferred to the
naive approach, then, because it provides a powerful analytical tool:
This method allows you to see IMMEDIATELY how you stand
at the end of an accounting period, and how you did at
the end of every OTHER accounting period.
This is the origin of the phrase "the bottom line"...!
You can SEE the result of closing the books, in GL version 1.12, by doing a
Periodic Close, and then doing Query Accounts on the Retained Earnings account
(399) and on any of your Revenue (400's) or Expense (500's and up) accounts.
Typically, all Revenue & Expense accounts are closed at the same time. The
prohibition in GL against direct access to the Retained Earnings account means
that in THIS general ledger program, they MUST all be closed together.
No OTHER account is ever "closed", by the way. In this sense of the word,
the only accounts that are closed are your income and expense accounts, and
the net balance of them all is posted to your Retained Earnings account.
Nothing else is affected.
Following the details of these accounts, especially as they are summarized on
your Balance Sheet, Statement of Revenues and Expenses, Trial Balance and
Detail General Ledger reports, is an illuminating exercise. It will quickly
convince you that there is more to double entry bookkeeping than meets the
eye, easy and obvious as it eventually seems. Very soon you will wonder what
all the mystery was about.
For that, thank Omar Khayyam, not me or any other programmer! All I've done
here is automate, and try to explain what I've learned from the past.
What Accounts Do I Need?
------------------------
Wisdom and hard knocks dictate the accounts you should create: You should
have an Asset account for your checkbook. You should have an Expense account
for each of Rent, Telephone, Medical Expenses, and so forth. You should have
a Liability account for each of your major debts. You should have Revenue
accounts for each of the major sources of your income.
Notice that one of your goals is to clearly identify your INCOME. Your
checkbook balance at year end will not usually indicate your actual income,
especially if you are frequently reimbursed for expenses you incurr on
someone else's behalf -- business lunches, mileage, etc. This money gets
cycled through your checking account more than once, and inflates your sum of
deposits. This is one example of why you need to keep a general ledger!
YOU SHOULD ASK YOUR ACCOUNTANT for help, because everyone's case is different,
and because the tax consequences and legal ramifications of your decisions can
be IMPORTANT. In particular, depreciation on inventory and major assets can
be a mind-boggling problem to record correctly, so you should seek
professional advice. But ask someone who is familiar with your own unique
circumstances. And be prepared to pay for the service. It's not trivial.
If you don't have an accountant, READ BOOKS! ASK FRIENDS! READ TAX MANUALS!
USE YOUR HEAD! GUESS! Remember, ANY system is better than NO system,
especially if it records the details of your annual income and expenses.
This is the end of a very brief tutorial. It is not a complete discussion of
accounting by any means! However, it is far more than you usually get if
you've never done any bookkeeping before. I've tried to be accurate in my
description, and tried to suggest what you should think about.
The rest of this document describes how GL version 1.12 actually maintains
your Chart of Accounts.
Your Chart of Accounts
----------------------
Entries in your Chart of Accounts have four identifying parts: The account
NUMBER, the account NAME, the account TYPE, and the COLUMN on your Balance
Sheet (left, middle, or right) which this account uses to print its balance
in. The account types are: Header, Normal Posting Account, Control Account,
Subaccount, Automatic Transaction Procedure, Reserved for P&L, and nine levels
of Break Total. All are explained below.
In addition, account entries may contain Balances and some other kinds of
behind-the-scenes housekeeping information which are not accessible through
Chart Maintenance.
Adding an account:
------------------
When you give an account number in Chart Maintenance, if the account does not
exist it will be added. If this is a mistake, simply give the same number
again (by hitting Enter), and you will have the chance to delete the account.
Chart Maintenance
-----------------
Chart Maintenance enforces the following rules with an "out of sight is out
of mind" philosophy. That is, if you may not do something, you never have
the chance to be contrary -- the question is never asked.
There is no magic word that will give you permission to, say, delete the P&L
account. If you can't figure out "what key lets me do it" by looking at the
help screen or reading this, it ain't there, and it ain't allowed. On the
other hand, you won't get any nasty error messages either, because anything
you CAN do is ok. (Even if it doesn't make sense -- but that's up to you!)
The rules (gently enforced) are these:
You may not delete any "active" account (defined just below), or change its
type to non-posting. The only accounts which ever contain a balance are
Normal Posting Accounts, the P&L account (called "Retained Earnings" only by
default), and Subaccounts. In addition, you may edit the P&L account's name,
but that's all -- you can't delete the P&L account or change its type, period.
GL defines an "active" account as one which prints out detail lines on the
Detail General Ledger report. In other words, it has a history of activity
even if its current balance is zero. (The Year End routine clears out the
previous detail for an account with a zero balance -- this makes it deletable
once again.)
Note that you can change an active Subaccount to Normal Posting, or vice
versa, but you CAN'T change it to a non-posting type like Header, Control,
etc. There is a trick you may wish to use concerning Subaccounts (see below),
so bear this in mind.
To select the account TYPE or the balance sheet COLUMN, press the SPACEBAR and
you will cycle through all the options. Press Enter to accept the value.
You may always change ANY account's name or balance sheet printout column.
You may always delete a non-posting account (Header, Control, ATP, or Total
Break) and you may always change the type of any account you can delete.
If an account cannot be deleted, Chart Maintenance displays the account
balances. Accounts which never have balances, i.e., the Header, Control,
ATP and Break Total accounts, never display a balance (not even zero).
Aside from the Blank Ledger (F9) option to set ALL account balances to zero,
you have no direct access to balances. Any other change to an Account Balance
must be accomplished by means of an entry in your General Journal. For
example, you must enter starting balances from the General Journal.
Which leads us to a brief but interesting digression...
Audit Trails
------------
YOU MAY NOT EVER "adjust" an account balance without leaving an audit trail
through the journal. This restriction has immense practical consequences.
For one thing, the IRS is far more likely to believe your story when you back
it up with a complete audit trail. The logic of that audit trail is self-
evident, credible, consistent, and independent of this or any other GL
program.
Unless you save your printouts, you have no audit trail. Remember: Your
audit trail exists ON PAPER, so this GL program is designed to print its tale
whenever you choose. The audit trail IS your story, and without that
hardcopy, the numbers on your Balance Sheet are just so much froufrou, fluff
and nonsense.
In other words, while your financial data may be stored on a 30mb hard disk,
it is only there for the sake of convenience. What you should really be
after is that complete, unaltered, PRINTED record of all your transactions.
Types of Accounts
-----------------
GL recognizes six different account types: Header, Normal Posting, Control,
Subaccount, Automatic Transaction Procedure, and nine levels of Break Total.
A "seventh type" of account is the Equity account reserved for P&L, account
399.
Note that only the P&L account, Normal Posting Accounts and Subaccounts
actually receive financial data. All the other "accounts" have special roles
and functions. These are discussed below.
Account Numbers
---------------
Account numbers are broken into two three-digit fields. The left field is the
customary 3-DIGIT ACCOUNT LABEL familiar to any bookkeeper. The right field
is separated from the left by a space (e.g., "100 019"). The right field may
be used however you wish, but GL itself just treats the right field as the
lesser digits of a 6-digit account number. The right field is suppressed if
it contains all zeroes, except when GL prompts you for an account number.
Normally, you see three digits.
The numbers you may select for your Chart are pre-defined. ASSET accounts are
the 100's, LIABILITY accounts are the 200's, EQUITY accounts are the 300's
(Retained Earnings is 399, leaving 100 slots for Break Totals between Retained
Earnings and the Revenue section), REVENUE accounts are the 400's and EXPENSE
accounts are the 500's. Any account number beginning with 600, 700, 800, or
900 will be treated the same as an expense account -- i.e., as a deduction
from revenues (or, equivalently, as a DEBIT to Retained Earnings).
The space which separates the two 3-digit fields is innocuous. It may be
interpreted or ignored many different ways. It is also inviolate -- you can't
type anything in the gap.
GL does not reset the account number edit mask between entries; this is a
great convenience because you need not retype trailing digits that are already
correct. For example, a DEBIT to your Checking Account ("110") followed by a
CREDIT to Consulting Fees ("410") requires only two keystrokes to enter the
"410," namely "4" and ENTER.
Normal Posting Accounts
-----------------------
These are the regular accounts which accumulate financial data. Their use
depends on whether they are Asset, Liability, Owner Equity, or Revenue &
Expense accounts. You should consult your own professional accountant for
specific advice on how to use the regular posting accounts.
An account is an Asset account if and only if its account number begins with
100, and so on as detailed above. An account beginning with 200 CANNOT be
anything other than a Liability account. The numbering scheme is fixed,
a constant in a sad, inconstant world.
Control Accounts & Subaccounts
------------------------------
Control Accounts may not be directly posted to. These accounts provide a
summary of activity in the Subaccounts which they "control". If you use
Control Accounts, the Control Account prints on your Balance Sheet, Statement
of Income, etc., BUT THE SUBACCOUNTS DO NOT. Control Accounts print on your
"presentation" documents -- the ones you'd show a banker.
On the other hand, Subaccounts print on your Detail General Ledger, but the
control accounts do not (at most, they print out only as headers in your
Detail GL, and don't appear at all on Trial Balance). Subaccounts print on
your "internal" documents -- the ones you'd show the Internal Revenue Service.
The method is simply a way to edit out unnecessary detail from a presentation.
If you are audited, you have the complete audit trail provided by your Detail
General Ledger (with Subaccounts). If you're just looking for a loan, you
have the summary information provided on your Balance Sheet (with Control
Accounts).
If you prefer NOT to use this method, simply define all your accounts as
normal posting accounts, and we won't mention it again.
A Subaccount must either follow a Control Account in your Chart (in numerical
order), or else follow another Subaccount. If there is no Control Account at
the head of a list of Subaccounts, the Subaccounts in the list are treated the
same as normal posting accounts.
Because no financial data is ever posted to a Control Account (it gets its
value from the information in the Subaccounts), you can add or delete Control
Accounts at any time. You can always INSERT a Control Account into your
Chart, and DELETE it later, whenever you would prefer to show a summary
instead of detail in your Balance Sheet. And, you can always convert a Normal
Posting Account to a Subaccount, or vice-versa. Think about it!
Reserved for P&L
----------------
Account 399 000 is Retained Earnings. This Equity account accumulates the net
of Revenues less Expenses when your books are closed. There is only one such
account. It cannot be deleted. The Reserved for P&L account type cannot be
assigned to any other account.
Header Accounts
---------------
Header Accounts are informational. The names of Header Accounts print out on
your Balance Sheet, but there is no financial data in them. They are just
PART OF THE TEXT on your Balance Sheet.
The typical use for Header Accounts is to block off the major divisions in
your Chart of Accounts. I.e., Assets, Liabilities, etc. There are just there
to improve readability, and can be deleted from your Chart without harm to
your arithmetic. If you DO delete them, your Balance Sheet might have a "less
professional" appearance, by some standards. Header accounts also provide
convenient stopping points when you PgUp and PgDn through the Chart list.
Break Total Accounts
--------------------
The nine levels of Break Total account are used on your Balance Sheet. You
cannot post to them as accounts. They are informational.
Break Total accounts cause totals to be printed on your Balance Sheet. They
also contain instructions about which COLUMN to print the total in -- left,
middle, or right. This is the same as for other accounts, except that here
you might more commonly choose the middle and right columns.
Break Totals maintain a running total of all the accounts which precede them
in your Chart, during printouts. Whenever a Break Total is found in your
Chart while printing out the Balance Sheet, the total so far is printed out
and the Break Total value is reset to zero. The total then begins
accumulating again, until the next time a Break Total WITH THE SAME OR HIGHER
LEVEL NUMBER is encountered.
There are nine Break Total levels, but you may have any number of Break Total
accounts in your Chart. Break Total 1 is the "lowest level", Break Total 9 is
the "highest level."
In effect, as you read your Chart from the top down, the balance of each
account is added up simultaneously on each of nine adding machines, numbered 1
to 9. Whenever a Break Total N account comes up in your Chart, this is an
instruction to the Nth adding machine to print out its value. Simultaneously,
the instruction tells N, AND ALL THE ADDING MACHINES LESS THAN N, to clear
their registers to zero and prepare to add up the remaining accounts. The
adding machines from N + 1 TO 9 ARE NOT AFFECTED, and they continue to
maintain the running total until instructed to print & clear.
The "adding machines" know the difference between debits and credits,
naturally, and compute their totals accordingly.
The NAME of the Break Total account is printed before its total, so the name
is therefore PART OF THE TEXT OF YOUR BALANCE SHEET. A typical Break Total
account name might be "Sum of Equity Less Withdrawals".
One way to compute the "Sum of Equity Less Withdrawals" is by using two Total
Break accounts. Break Total 3 (for example) would accumulate "Sum of Equity",
then print before it hit Withdrawals, whilst Break Total 4 would print AFTER
the Withdrawals account. Obviously, Break Total 3 and Break Total 4 must BOTH
be clear when they hit the Equities section of your Chart. You can ensure
this by using Break Totals greater than 4 above the Equity accounts, since
whenever you print (and clear) 4, you also clear 3, 2 and 1 implicitly, and
so on down the line.
As it might appear in your chart,
LIABILITIES <- header account
.
.
.
Sum of Liabilities <- Break Total 9 (print 9, clear all!)
EQUITY <- header account
R.B. Doe, Capital <- normal posting account
J.Q. Doe, Capital <- normal posting account
Sum of Equity <- Break Total 3 (print 3, clear 3,2,1)
J.Q. Doe, Withdrawals <- normal posting account
Sum of Equity LESS Withdrawals <- Break Total 4 (print 4, clear 4,3,2,1)
.
.
.
Note, in the example, that since amounts are normally DEBITED to withdrawals,
but CREDITED to Capital, the meaning of the TOTAL in Break Total 4 is indeed
"the sum of equity less withdrawals".
Note, also, that you can accumulate a total of Subaccounts in a Control
Account. The difference is that the value is not printed as a "Total", and
the Subaccount detail does not print at all. The "balance" of the Control
Account prints as though the Control Account were a normal posting account.
Automatic Transaction Procedures
--------------------------------
NOTICE: ATP's are NOT implemented in Version 1.12!
An "Automatic Transaction Procedure" is a description of an ordinary
transaction. The ATP description is stored on disk, and recalled as needed.
The way to describe the transaction itself is outlined below, under "Defining
Automatic Transaction Procedures."
An ATP is used in your Journal, up to a point, as though it were any other
account. As soon as you enter an amount in your journal worksheet, though,
the ATP takes the amount you entered and automatically distributes it into a
"boilerplate" journal entry, which may be as lengthy and complex as you like.
For example, suppose you are a small, regional community corrections agency,
and you receive the monthly phone bill for your office in Poweshiek County.
State law requires you to distribute telephone expenses among the areas in
which your department is organized: 40% to probation services expense, 40% to
residential facility expense, 20% to administrative expense.
Rather than enter this transaction every month, with all the mental arithmetic
to distribute three debits to departmental expenses and one credit to accounts
payable, you simply define an ATP account (in Chart Maintenance), e.g., "590".
Now, when you enter "590" on your General Journal worksheet, the transaction
is NOT posted to "account 590." Instead, the Journal program retrieves ATP#
590 from disk, and following the instructions found there, your transaction is
AUTOMATICALLY credited to (for example) "210 - Northwestern Bell", and
AUTOMATICALLY pro-rated and debited to (say) "510 001 - Probation Expense",
"510 002 - Residential Expense", and "510 003 - Administrative Expense".
Any odd cents get distributed in round robin fashion among all the accounts
in the same column.
The AMOUNT of the bill is automatically distributed among the various debits
and/or credits according to your formula, and the item memo says "Poweshiek
Co. Phone Bill" with a normal date and journal entry number. As with manual
journal entries, you have the opportunity to reject the entry before it goes
into your Journal. The end result of an ATP journal entry is exactly the same
as a manual journal entry -- they are indistinguishable.
Even with a disk access, the computer fills in the transaction quicker and
more accurately than a good keypunch operator can do it. (Especially at 4
p.m. on Friday!)
Obviously, you can restrict automatic accounts to be simple 2-entry ATP's if
you wish. These simple cases can be used for Fixed, or Recurring,
transactions.
As noted elsewhere, there is NO PRACTICAL LIMIT on the number of reversing
entries you may have in a transaction: There IS a system limit somewhere in
excess of 500 unbalanced entries. The same almost non-existent "restriction"
applies whether you are doing manual or automatic transactions.
Defining Automatic Transaction Procedures
-----------------------------------------
Add an account in Chart Maintenance, and specify "Automatic Transaction
Procedure" as its type. YOU DO NOT NEED TO DEFINE THE ACTUAL PROCEDURE UNTIL
THE FIRST TIME YOU USE THE ATP IN YOUR JOURNAL.
Then, as prompted, SIMPLY ENTER A COMPLETE, ACTUAL TRANSACTION, using real
data. The percentages are calculated for you, and the whole procedure is
stored away on disk for next time. Again, the first time you use an ATP which
has not been defined yet, the demon "wakes up" and tells you to do it the
long, regular way. The ATP will pay attention.
The next time you use the ATP, nothing happens until you enter the date, item
memo and amount. Then the ATP takes over and automatically "plays back" your
RECORDED transaction procedure, plugging in distributions as it goes. The
next thing you see is your Journal Worksheet summary, and the question whether
everything is ok.
In other words, the ATP learns from you, by the example you provide.
Cautions about ATPs
-------------------
An ATP accont may not contain any reference to another ATP account. Automatic
Transaction Procedures cannot distribute monies to other Automatic Transaction
Procedures. However, the procedures you define can debit or credit ANY
normal posting account or Subaccount whatsoever -- there is NO validation and
NO rule checking, except for the rule against referring to another ATP.
*** WARNING ***
An ATP transaction will be entered EXACTLY as you defined it. Such
transactions could be bizarre and difficult to correct later, requiring you to
create special "reversing ATP's", with several hours of tedious backtracking.
An ATP is essentially a (very small) computer program which you write
yourself. An ATP is therefore considered to be a rule which YOU create.
IT IS YOUR RESPONSIBILITY to ensure that the ATP is correct and conforms to
Generally Accepted Accounting Practice.
You may delete ATP accounts the same way you delete any other account.
Size Limits
-----------
There is no PRACTICAL limit on the size of your Chart of Accounts -- it is
bounded by the absolute total free memory available on your PC, up to 640k.
On a 512k system, you could presumably have something like three or four
THOUSAND accounts in your Chart. I have not tested the upper limits, which
are in any case far greater than those required by most individuals or small
going concerns. The General Journal will exhibit a noticeable "catch" or
momentary pause when searching for an account name, if your Chart contains
more than a few hundred entries.
(The purely theoretical maximum is 900,000 accounts, and I would love to meet
the chrome-derriered secretary who finally achieves it. Probably next
century; in some regards, this program is a Time Capsule for a generation of
intelligent machines who will probably collect antique software like this.
Salutations, sweetheart! But back to business...)
Conclusion
----------
The numbering scheme is perhaps too rigid for your taste. However, it
does the "garden variety" Chart of Accounts very nicely, and many bookkeepers
are already familiar with something like it. Whilst you may not change the
MEANING of the account numbers, you MAY change any of the account names to
suit your own taste and purpose. "Retained Earnings" may be revised, for
example, to "Net Worth". The Retained Earnings account number, 399 000, is
sacrosanct in this system; it is, however, the only account number which is
defined to all six places.
Also, contrary to the naive view, most bookkeepers DO think in numbers,
especially when using the short, three-digit form of account labels, so this
system does NOT implement so-called "mnemonic account names." Use your
numbering system, and remember it well. (In the Journal, you can always
review your Chart of Accounts by pressing the F3 function key.)