Making a
| From the TK-ACCOUNTING menu, select General Ledger. From the GENERAL LEDGER menu, select Enter Transaction. A journal entry is a set of transactions, each of which is composed of an account number, a transaction description and a debit amount or credit amount. For the entry to be posted, the sum of the debits must equal the sum of the credits.
| ||||||||||||||||||||||||||||||||
| Journal |
Select the journal into which this entry will be
saved by entering its two-character code and pressing [RETURN]. The two
journals which are predefined for you are...
GJ - General Journal Of course, others may have been created as well. Entries posted to the Balance Sheet Adjustment journal are not handled in the same way as normal entries. This journal is used for adding data to the prior fiscal year's Balance Sheet without re-opening the prior year. This is accomplished by adjusting the balances brought forward of the affected accounts for the current fiscal year. Use care.
| ||||||||||||||||||||||||||||||||
| Entry Date |
TK-LEDGER determines which accounting period your
entry should be posted to based on the date you enter here. Entry dates
which fall into a fiscal period which has already been closed will be
denied. However, they can be posted by re-opening the appropriate period,
posting the entry and closing the period again. Entry dates which fall in a future period that has not yet been defined to the system through the Fiscal Year Maintenance screen will also be denied. Enter the appropriate date and press [RETURN]. Remember that it is not necessary to enter the "/". However, it is necessary to enter six digits. For further details refer to the discussion regarding system conventions at the beginning of this manual.
| ||||||||||||||||||||||||||||||||
| Entering Transactions |
Once the journal and entry date have been entered, the cursor will move
to the first line of the transaction portion of the screen, under the
heading 'Account No.'. Notice in the upper right corner of the screen the phrase 'Page 1 of 1'. Since an entry can have many transactions but only fifteen can be displayed at a time, this screen will page forward and backward in the entry. And it will always tell you what page you are on and how many pages there are. If you are working with a large entry, use the NEXT SCREEN and PREV SCREEN keys to move back and forth. If you are unsure which keys these are on your terminal, press a [?] or refer to Appendix B in the back of this manual. | ||||||||||||||||||||||||||||||||
| Account Number |
There are two ways in which to enter an account
number. If you know the number, simply type it in and press [RETURN].
Remember, if you are doing Departmental Accounting and the account you are
entering is a revenue or expense account the format for entering the
account number is....
AAAAAA-DDDDD where AAAAAA is the Ledger account number and DDDDD is the department code. If you don't remember the exact account number, enter part or all of a word found in the account description and TK-LEDGER will display a list of accounts from which to choose as illustrated in the screen below. If none match, choose the last option in the window and try again.
If you select an income or expense account using this method and you are using the Departmental Accounting feature of TK-LEDGER, the window will be removed, the account number displayed and the cursor will move to the space immediately following the account number in which you can enter the appropriate department code. When you have entered a valid account number, a portion of the account description will be displayed next to it to allow you to verify its correctness and the cursor will move to the 'Comments' field. If it is not the account you intended, use the cursor [LEFT] key to move the cursor back to the 'Account No.' field and try again.
| ||||||||||||||||||||||||||||||||
| Comments |
Use the 'Comments' field to describe the current
transaction. Although there appears to be little space in which to enter a
meaningful comment, this is a scrolling field. It enables you to
enter more text than can be displayed here. After comments have been entered for the first transaction, these comments will be replicated automatically in the 'Comments' field of subsequent transactions. If you want the comments to be different, simply enter a new comment.
| ||||||||||||||||||||||||||||||||
| Debits |
When comments have been entered, the cursor will move
to the 'Debits' field. If the amount you wish to enter is a credit, press
[RETURN] to proceed to the 'Credits' field. Enter the amount of the debit. The following examples illustrate what needs to be typed. Since a transaction can have only one amount, when you have entered an amount in the 'Debits' field, the cursor will automatically move to the beginning of the next transaction. To remove an amount entered in the 'Debits' field by mistake, use the DEL CHAR key or the ERASE FIELD key either of which can be identified by pressing [?]. Or you can simply enter an amount of zero (0).
| ||||||||||||||||||||||||||||||||
| Credits | Enter the credit amount as a positive number as illustrated and described above. When completed, press [RETURN]. The cursor will move to the beginning of the next transaction. | ||||||||||||||||||||||||||||||||
| Wildcard | When entering the amount of the last transaction in the entry, you can press the equal sign [=] key in the 'Debits' or 'Credits' field. The screen will automatically compute the amount required to balance the entry. | ||||||||||||||||||||||||||||||||
| Posting |
TK-LEDGER posts transactions on an Entry by Entry
basis. When all of the transactions for your Journal Entry have been
entered and the Total Debits equal the Total Credits at the bottom right of
the screen, the Entry is ready to be posted. Press [RETURN] at the 'Account No.' field on an empty row or press the TAB or EXIT keys. A one-line menu of options will be displayed at the bottom of the screen, as shown in the following illustration. To post the Entry, move the highlighted bar to the option 'POST' and press [RETURN]. If any data entry errors are detected at this point, they will be described to you. Simply fix the error using the 'EDIT' option and try posting the Entry again.
As with all of the one-line menus found in TK-LEDGER, there are two methods of moving the highlighted bar. 1) Use the [SPACE] or cursor [LEFT] and [RIGHT] keys to move the bar to the desired option; or 2) Type the first character of the option. For example, to select 'POST', press a [P]. It does not matter whether the character is in upper or lower case, TK-LEDGER will find and highlight the appropriate option.
| ||||||||||||||||||||||||||||||||
| Exiting The Screen |
To exit the Journal Entry screen, proceed to the
one-line menu, and select the 'QUIT' option or simply press EXIT. Should it be necessary to exit the Journal Entry screen before completing an Entry, don't worry about losing what you have entered. The Entry will still be there in your work space when you return to the screen later.
| ||||||||||||||||||||||||||||||||
Making a
| From the TK-ACCOUNTING menu, select General Ledger. From the GENERAL LEDGER menu, select Enter Transaction. A journal entry is a set of transactions, each of which is composed of an account number, a transaction description and a debit amount or credit amount. For the entry to be posted, the sum of the debits must equal the sum of the credits. These totals are shown in the base currency equivalents at the bottom right corner of the screen.
| ||||||||||||||||||||||||||||||||
| Journal |
Select the journal into which this entry will be
saved by entering its two-character code and pressing [RETURN]. The two
journals which are predefined for you are...
GJ - General Journal Of course, others may have been created as well. Entries posted to the Balance Sheet Adjustment journal are not handled in the same way as normal entries. This journal is used for adding data to the prior fiscal year's Balance Sheet without re-opening the prior year. This is accomplished by adjusting the balances brought forward of the affected accounts for the current fiscal year. Entries posted to this journal should be handled with care.
| ||||||||||||||||||||||||||||||||
| Entry Date |
TK-LEDGER determines which accounting period your
entry should be posted to based on the date you enter here. Entry dates
which fall into a fiscal period which has already been closed will be
denied. However, they can be posted by re-opening the appropriate period,
posting the entry and closing the period again. Entry dates which fall in a future period that has not yet been defined to the system through the Fiscal Year Maintenance screen will also be denied. Enter the appropriate date and press [RETURN]. Remember that it is not necessary to enter the "/". However, it is necessary to enter six digits. For further details refer to the discussion regarding system conventions at the beginning of this manual. | ||||||||||||||||||||||||||||||||
| Entering Transactions |
Once the journal and entry date have been entered, the
cursor will move to the first line of the transaction portion of the
screen, under the heading 'Account No.'. Notice in the upper right corner of the screen the phrase 'Page 1 of 1'. Since an entry can have many transactions but only fifteen can be displayed at a time, this screen will page forward and backward in the entry. And it will always tell you what page you are on and how many pages there are. If you are working with a large entry, use the NEXT SCREEN and PREV SCREEN keys to move back and forth. If you are unsure which keys these are on your terminal, press a [?] or refer to Appendix B in the back of this manual. | ||||||||||||||||||||||||||||||||
| Account Number |
There are two ways in which to enter an account
number. If you know the number, simply type it in and press [RETURN].
Remember, if you are doing Departmental Accounting and the account you are
entering is a revenue or expense account the format for entering the
account number is....
where AAAAAA is the Ledger account number and DDDDD is the department code.AAAAAA-DDDDD If you don't remember the exact account number, enter part or all of a word found in the account description and TK-LEDGER will display a list of accounts from which to choose as illustrated in the screen below. If none match, choose the last option in the window and try again.
If you select an income or expense account using this method and you are using the Departmental Accounting feature of TK-LEDGER, the window will be removed, the account number displayed and the cursor will move to the space immediately following the account number in which you can enter the appropriate department code. When you have entered a valid account number, a portion of the account description will be displayed next to it to allow you to verify its correctness and the cursor will move to the 'Comments' field. If it is not the account you intended, use the cursor [LEFT] key to move the cursor back to the 'Account No.' field and try again. | ||||||||||||||||||||||||||||||||
| Comments |
Use the 'Comments' field to describe the current
transaction. Although there appears to be little space in which to enter a
meaningful comment, this is a scrolling field. It enables you to
enter more text than can be displayed here. After comments have been entered for the first transaction, these comments will be replicated automatically in the 'Comments' field of subsequent transactions. If you want the comments to be different, simply enter a new comment.
| ||||||||||||||||||||||||||||||||
| Currency |
When an account number is entered that account's assigned currency is
automatically displayed in the currency field. If a base currency
account, the currency will be displayed in low intensity and the cursor
will move directly to the 'Debits' field. You cannot change the
currency or exchange rate for a base currency account and the amount
entered in the 'Debits' or 'Credits' column must be in your currency. If the account is a foreign currency account, the currency and its default exchange rate (maintained in the Exchange Rate Maintenance screen) will be displayed in high intensity. Note that the exchange rate selected as the default will depend on the transaction date entered earlier. TK-LEDGER keeps track of all exchange rate changes and the periods of time each was active. So if you enter a transaction date for two months ago, the default exchange rate shown will be the one that was active on that date. For foreign currency accounts, TK-LEDGER allows amounts to be entered in either the foreign currency or base currency. The simplest way to switch to base currency or back is to press the [SPACE] bar. It works as a toggle... press it once and it changes to base currency. Press it again and it changes back to foreign currency. You can also enter the desired currency by typing it in. | ||||||||||||||||||||||||||||||||
| Exchange Rate |
The exchange rate is the reciprocal of the number of
units of foreign currency which equal one unit of base currency. For
example, if base currency is US$ and 76 yen equal one US$, the the exchange
rate is the result of dividing 1 US$ by 76 yen, or .013158. These ratios
are generally available from your bank and other sources. As discussed earlier, TK-LEDGER will display the most accurate exchange rate it has in its table for the currency. In most cases this rate can be accepted as it is. However, if it is necessary to change the rate, simply enter the new one and press [RETURN].
| ||||||||||||||||||||||||||||||||
| Debits | If the amount you wish to enter is a
credit, press [RETURN] to proceed to the 'Credits' field. Enter the amount of the debit in the currency you selected. Notice that the number of decimal places displayed when you have pressed [RETURN] is currency-sensitive. The examples shown here include Japanese yen which have no fractional quantities. As a result, yen are displayed as an integer value. Also note that the sum of the debits shown at the bottom of the 'Debits' column is expressed in base currency. The base currency debits must equal the base currency debits in order for the Entry to be posted. The following examples illustrate how the amounts can be entered. Since a transaction can have only one amount, when you have entered an amount in the 'Debits' field, the cursor will automatically move to the beginning of the next transaction. To remove an amount entered in the 'Debits' field by mistake, use the DEL CHAR key or the ERASE FIELD key either of which can be identified by pressing [?]. Or you can simply enter an amount of zero (0). | ||||||||||||||||||||||||||||||||
| Credits | Enter the credit amount as a positive number as illustrated and described above. When completed, press [RETURN]. The cursor will move to the beginning of the next transaction. | ||||||||||||||||||||||||||||||||
| Wildcard | When entering the amount of the last transaction in the entry, you can press the equal sign [=] key in the 'Debits' or 'Credits' field. The screen will automatically compute the amount required to balance the entry. | ||||||||||||||||||||||||||||||||
| Posting |
TK-LEDGER posts transactions on an Entry by Entry
basis. When all of the transactions for your Journal Entry have been
entered and the Total Debits equal the Total Credits at the bottom right of
the screen, the Entry is ready to be posted. Press [RETURN] at the
'Account No.' field on an empty row or press the TAB or EXIT keys. A
one-line menu of options will be displayed at the bottom of the screen, as
shown below.
To post the Entry, move the highlighted bar to the option 'POST' and press [RETURN]. If any data entry errors are detected at this point, they will be described to you. Simply fix the error using the 'EDIT' option and try posting the Entry again. As with all of the one-line menus found in TK-LEDGER, there are two methods of moving the highlighted bar. 1) Use the [SPACE] or cursor [LEFT] and [RIGHT] keys to move the bar to the desired option; or 2) Type the first character of the option. For example, to select 'POST', press a [P]. It does not matter whether the character is in upper or lower case, TK-LEDGER will find and highlight the appropriate option.
| ||||||||||||||||||||||||||||||||
| Exiting The Screen |
To exit the Journal Entry screen, proceed to the one-line menu,
and select the 'QUIT' option or simply press EXIT. Should it be necessary to exit the Journal Entry screen before completing an Entry, don't worry about losing what you have entered. The Entry will still be there in your work space when you return to the screen later.
| ||||||||||||||||||||||||||||||||
Printing A |
While still in the Journal Entry screen, you can print the current Entry
as many times as you wish prior to posting. Once the Entry has been
posted, it can only be printed through TK-LEDGER's standard reports. Use the TAB or EXIT key to bring up the menu at the bottom of the screen and select 'LIST'. As the example below illustrates, you can select the output device just as you would for any of TK-LEDGER's reports. A sample of the listing for multi-currency organization is shown on the next page.
When printing has finished, you will be returned to the menu at the bottom of the screen from which you can exit the screen, or continue editing. "INCLUDE DA,2
| ||||||||||||||||||||||||||||||||
Saving and | TK-LEDGER has been designed to enable repetitive Journal Entries to be entered and posted quickly and easily using the 'SAVE' and 'RECALL' options in the one-line menu at the bottom of the Journal Entry screen. Any Entry which is used frequently is an appropriate candidate for this feature. | ||||||||||||||||||||||||||||||||
| Saving |
To save an Entry, it must first be entered; enter it
the way you normally would before posting. Only this time do not post.
Instead select the 'SAVE' option on the one-line menu at the bottom of the
screen. The Journal Entry screen will ask you to give it a name as
illustrated below.
Enter a name for the entry which you will be able to remember later, such as 'INTEREST' for a monthly Interest Entry, and press [RETURN]. The Journal Entry you have entered is now saved and can quickly be recalled using the name you provided it. | ||||||||||||||||||||||||||||||||
| Recalling |
Recalling an Entry which has been saved earlier is as
simple as saving it was. Select the 'RECALL' option from the one-line menu
at the bottom of the Journal Entry screen. If the Journal Entry screen is empty when you entered, it will first be necessary to enter the appropriate 'Journal' and Entry 'Date' as you normally would to make an Entry. Then press the EXIT or TAB key to jump to the one-line menu at the bottom of the screen. When you have selected the 'RECALL' option, the screen will ask for the name of the Entry which was saved earlier as shown in the screen below.
At this point, there are three methods for finding the Entry you want to recall. 1) If you remember the name, type it in and press [RETURN]. If the Entry is there, the screen will load it and display the transactions on the screen where they can be edited first, or posted as they are. 2) If you remember the first character or two of the name, enter them and press [RETURN]. A window will be displayed listing all of the SAVED Entries which match the characters you typed in. You can select the desired one by moving the cursor to it and pressing [RETURN]. As in the first option, the Entry will be loaded and displayed on the screen. 3) If you are unsure what the Entry was named, simply press the HELP key. A list of all SAVED Entries will be displayed from which you can choose. (Remember the HELP key. If you are unsure which key it is, refer to APPENDIX B at the back of this manual.) Regardless of which method you use, the Entry you chose will be loaded and displayed. If at that point there are changes to be made, as there often are, select the 'EDIT' option from the one-line menu at the bottom of the screen and you will be given the opportunity to make them before posting the Entry. | ||||||||||||||||||||||||||||||||
| Discarding | SAVED Entries will remain
in the system until they are deleted. To discard an Entry select the
'DISC' option from the one-line menu at the bottom of the screen. You will be asked for the name of the Entry to be discarded, just as you would be to recall an entry, as shown below.
Enter the name of the Entry to be removed and press [RETURN]. The Entry will be removed immediately and you will be returned to the menu at the bottom of the screen from which you can choose to 'QUIT' or continue as appropriate.
| ||||||||||||||||||||||||||||||||
Balance Sheet |
From time to time, such as after income taxes have been paid, it is
necessary to adjust Balance Sheet accounts in the prior fiscal year.
Although TK-LEDGER allows prior years to be re-opened and adjusted, this
is not always desirable. This is particularly true when the financial
statements for the prior year have already been published, or made public
in some way. TK-LEDGER provides an alternative approach by enabling Journal Entries to be made to a special journal called... AD - Balance Sheet AdjustmentsThe adjusting Journal Entry is prepared in the normal way with one restriction: only Balance Sheet accounts may be posted to in this journal. This is because Income and Expense account balances are not carried forward from fiscal year to fiscal year, while Balance Sheet accounts are. When a transaction is posted to the Balance Sheet Adjustment journal, only the Balance Carried Forward is adjusted, not the period balance, regardless of the date given the transaction. Let's take a closer look at the income tax example. If the prior fiscal year were re-opened and the tax entered, the Journal Entry's transactions might look like this:
In the example, the Expense account for Federal Income Tax is debited the amount of the tax paid, and the Balance Sheet account which maintains the balance of the checkbook is credited the amount of the tax. However, the transaction shown above could not be made to the Balance Sheet Adjustment journal because account number 5501 is not a Balance Sheet account. Since all Income and Expense transactions affect the balance of the Current Year Earnings account, and the Current Year Earnings account is closed to Net Earnings, Prior Years when each fiscal year is closed, then the ultimate destination of the $1500 debit is Net Earnings, Prior Years which is a Balance Sheet account. Therefore, the same transaction using the Balance Sheet Adjustment journal would look like this:
Note that the transaction dates in the two examples are different. In the first example, the transaction was dated December 31, 1989 so that the transaction would be posted to the end of the last accounting period in 1989, even though the check was not written until March 15, 1990. In the second example, using the Balance Sheet Adjustment journal, the transaction date is March 15, when the check was actually issued. What are the other implications? 1) Since Balance Sheet Adjustment transactions affect the Balances Brought Forward in the current year and not the prior year's books, the final financial statements for the prior year remain unaffected. 2) Because the transaction is dated with the actual date of issue, the audit trail through the Journal Report, Account Detail Report and Account Inquiry is more accurate than it might have been. 3) The Account Inquiry screen which is described in detail later in this manual displays the transaction and indicates clearly that it was a Balance Sheet Adjustment transaction, as shown in the following example.
Notice that the Beginning Balance of the account is flagged with an asterisk (*), and that the first transaction (JE# AD1) shows no affect on the account balance. Actually it did affect the balance, but only the Balance Brought Forward or the 'Beg Bal' as shown. Also note that the transaction is clearly shown to have been posted to the Balance Sheet Adjustment journal; the journal entry number is 'AD1' indicating the journal ('AD') and the first entry posted to that journal in fiscal 1990.
|
Displaying
| From the TK-ACCOUNTING menu, select General Ledger. From the GENERAL LEDGER menu, select Account Inquiry. Immediately after selecting the Account Inquiry option, the following screen will be displayed.
| |||||||||||||||||||||||||||||||||||
| Selecting The Fiscal Year |
TK-LEDGER maintains detail not only for the current period, but also the
current fiscal year and all prior fiscal years. This feature makes it
very easy to go back and review transactions entered in the past. When the screen is first displayed, the current fiscal year will be displayed in the fiscal year field and the cursor will proceed directly to account selection. If you want to review transactions from a prior fiscal year, use the cursor [LEFT] key to get to the fiscal year field. Select the desired fiscal year by entering the year (with century). You can also press the [+] or [-] keys to increment or decrement the fiscal year by one, respectively. When you have selected the desired year and pressed [RETURN] the cursor will move back to the 'Account' field. | |||||||||||||||||||||||||||||||||||
| Selecting An Account |
Selecting the account to be reviewed is very easy. If you know the
account number, you can enter it and press [RETURN]. Remember, if you
have chosen to do Departmental Accounting, you must include the department
code with all Income and Expense accounts using the following syntax:
AAAAAA-DDDDDwhere AAAAAA is the number of a valid G/L Detail account and DDDDD is a valid department code. If you do not remember the account number, enter part or all of a word in the account description. For example, if you want to look at the Checking account you could enter either part of the word 'Account' or part of the word 'Checking'. As illustrated in the example below, TK-LEDGER will display a list of all Detail accounts having words containing 'CHE' from which you may choose.
When you have selected the account to be reviewed, TK-LEDGER will display the name of the account, its balance at the beginning of the year, its current balance and the number of pages of transactions there are to be displayed. Finally, the last page of transactions (the most recent) will be displayed as shown in the following illustration.
For each transaction listed, the screen will display the following:
Changing |
If you are taking advantage of the multi-currency capabilities of
TK-LEDGER and you select an account which has been assigned a foreign
currency, the account will first be displayed in its assigned currency as
shown in the following example using Singapore Dollars.
The base currency equivalents of these transactions can be viewed quickly by pressing the [SPACE] bar. The screen will be changed to display base currency, as illustrated below, and will remain in base currency until the [SPACE] bar is pressed again.
| ||||||||||||||||||||||||||||||||||
| Changing Pages | When the last page of transactions has been displayed, you can use the PREV SCREEN and NEXT SCREEN keys to page back and forth through the transactions in the account. | |||||||||||||||||||||||||||||||||||
| Exiting Account Inquiry | The EXIT key will return you to the 'Account' field to select another account to review. To exit the screen entirely, press EXIT once more. | |||||||||||||||||||||||||||||||||||
Searching for |
When an account has been displayed in the Account Inquiry screen, the
built-in search mechanism can assist you in finding specific transactions.
To search for transactions, press the FIND key. A one-line menu will be displayed at the bottom of the screen which contains a variety of search options, as shown below. Move the highlighted bar to the desired option and press [RETURN].
Each of the search options enables you to look for transactions which meet a specified criteria.
For example, suppose you want to find any transactions containing the amount 29.95. This could be accomplished by selecting the 'AMOUNT' option and entering 29.95. As the screen below illustrates, TK-LEDGER then searches for any such transactions and reports the number found that contain 29.95 and displays the first page of the account which contains one of the matching records. In addition, the matching records will be highlighted to make identifying them easier.
Knowing how many matches there are doesn't help find them, particularly in a heavily used account. For this situation, TK-LEDGER assigns a special function to the cursor [UP] and cursor [DOWN] keys. While the NEXT PAGE and PREV PAGE keys still enable you to page sequentially up and down the account, the cursor [DOWN] key will display the next page which contains a match and the cursor [UP] key will display any previous page which contains a match. In this way, the transaction or transactions to be reviewed can be quickly located.
| |||||||||||||||||||||||||||||||||||
Displaying |
Another important feature of the Account Inquiry screen is the
ability to display an entire Journal Entry. A single transaction does not
always provide all of the information which is needed to recall an entry
that was made in an earlier accounting period or fiscal year.
In the Account Inquiry screen, this is accomplished by finding the page which contains the desired transaction, pressing the SELECT key and entering the Journal Entry number associated with the transaction. This is illustrated in the screen above. If a valid Journal Entry number was entered, and the currently displayed page contains a transaction from that Entry, TK-LEDGER will display the complete entry as it has in the following illustration.
Press [RETURN] to return to Display Account Detail functions. |