SEO Header Title

Loading...

Repeating Transactions

Enter and Import Repeating Transactions

Repeating Transactions

You may use the Repeating Transactions facility to enter transactions, which occur on a periodic basis. They may be weekly, monthly, quarterly or annually, etc. You may enter the transactions once, and then when it is due, copy or import the repeating transactions into the normal batch, edit amounts if they have changed, or delete a transaction or even add a new transactions. This will save you time.

Note - Repeating Transactions cannot be posted (updated) to the ledger. Repeating Transactions are basically master files which are maintained (transactions entered and / or edited on the Edit menu.

You may identify those transactions in your business and enter them in this Repeating Transactions. A few examples of these entries are:

  • For entry in the General Journal or alternative batch type.
  • Depreciation of fixed assets.
  • Payroll Journals or integration.
  • For entry in the Payments Journal (Debit orders to third parties).
  • For entry in the Receipts Journal (Debit orders from third parties).

Enter Repeating Transactions

To Enter Repeating Transactions:

  1. Click on the Edit→Repeating Entries menu option.
    Keyboard Access - Keyboard Access: Press the Alt+E+R keys on your keyboard.

    The Batch Type screen listing all the available batch types is displayed:
    Repeating Batch Selection Screen
    Note - If no contra account is displayed on the Batch Type selection screen, you need to set the options for the batch. If you have not yet set the selected journal (e.g. General or Depreciation Journal) for the specific transactions, or if your requirements should change, click on the F10: Setup icon, or press the F10 key on your keyboard, to set up your batch.
    Important - The Debit and Credit Unposted column will not be displayed on the Batch Entry Selection screen for Repeating Transactions. If you see this column on the Batch Type selection screen, close or exit it and access it on the Edit→Repeating Transactions menu option.
  2. Select the Batch Type (e.g. General Journal or any other Journal, e.g. Depreciation Journal) in which you wish to enter the repeating entries.
  3. Click on the Open button. The Batch Entry screen for the General Journal or other selected Batch Type is displayed:
    Repeating Batch Speedbar
    Note - The Batch Entry screen for the selected journal or batch (e.g. General Jnl or Depreciation Jnl) is indicated as a Repeating Entries batch as follows:

    • In the place of the alias * Repeating Entries * will be displayed on the title bar.
    • The F6: Post icon will be inactive, since repeating transactions cannot be posted (updated) to the ledger.
    • The rows for the transactions are displayed in a light pink background colour.
      Note - Since no Tax is applicable to these transactions, you may select to hide the tax column, Exclusive and Inclusive icons, as well as the lookup facility in the Setup Options for the General Journal, as in this example.
  4. Enter the transactions in the batch entry screen in the normal way. The screen for Repeating Entries for General Journal, or Depreciation Journal, for which you have entered Repeating Transactions should reflect as follows:
    Repeating Batch Enter Transactions
  5. Click on the F5: Balance icon, or press the F5 key on your keyboard, to balance the batch.
    Repeating Batch Balance Transactions
  6. In the case of the General Journal, the description for the balancing entry is given as “BALANCING ENTRY General Jnl”.
    Note - It is a good idea to over type this description, as it is not very meaningful to an outside auditor or accountant. If you over type these, it will definitely make it easier to trace and reconcile transactions.
    • Over type the description with a sensible description as to reflect the origin and nature of the contra transaction in the description column.
    • Do not over type the eight asterisks in the reference column, as this indicates that these are contra transactions.
  7. Press the Esc key on your keyboard, to close or exit this repeating batch.
  8. If you do not wish to enter or edit transactions in another repeating batch press the Esc key again to exit or close the Batch Type Selection screen.

Note - When you need to import and process the repeating transactions, you need to click on the Batch Entry icon, or press the F2 key on your keyboard. You then need to select the batch type to copy or import the repeating transactions into the same batch type as the batch type in which the repeating transactions was entered.


Note - New transaction can be added, a transaction, which was applicable for the previous periods, may no longer be applicable or amounts may change from time to time. You add a new entry, delete an existing entry or edit the amount on this screen, but it is recommended that you edit your repeating entries in the Edit→Repeating Transactions menu option to avoid having to change the same issues every time you wish to update a repeating batch.

Repeating Transactions Import

You may import a repeating transactions batch into a normal batch. To use this facility, you need to enter the transactions of a repetitive nature (which occurs frequently) in a repeating batch on the Edit→Repeating Transactions menu option. You may then at any required time import the repeating transactions into a normal batch.

Note - Once the Repeating Transactions have been imported into a normal batch, you need to check the repeating entries and edit it before posting the normal batch to the ledger.

To Import Repeating Entries into a Batch:

  1. Click on the Batch Entry icon, or click on the Input→Batch Entry menu option.
    Keyboard Access - Keyboard Access: Press the F2 key on your keyboard. Alternatively, press the Alt+I+B keys on your keyboard.
    The Batch Type Selection screen will be displayed.
  2. Select the Batch Type for which you wish to import transactions from a Repeating Batch.
  3. Click on the Open button. The batch entry screen for the selected Batch Type is displayed:
  4. Click on the F9: Process icon, or press the F9 key on your keyboard. The Process the batch options screen will be displayed.
  5. Select the Repeating Transactions option, and click on the OK button. The Enter Month and Year to repeat entries to screen is displayed:
    Repeating Transactions Import Options
  6. Select and enter the following options:
    1. Year - Select this year or last year in which you wish to process the repeating transactions.
    2. Period - Select the period for this year or last year, depending on which year you have selected from This Year or Last Year lookup facility.
    3. Add this to descriptions - Enter any description, which you wish to add to any existing descriptions.
    4. New Reference – You may enter a new reference, if necessary. The new reference will replace the existing reference as entered in the Reference field of the selected Repeating Transactions batch.
  7. Click on the OK button, or press the Enter key on your keyboard. The repeating transactions will be copied into the normal batch.
  8. Check the transactions and, if necessary, edit the transactions in the batch.
  9. Once you have finished importing and / or editing the repeating transactions in the selected batch, you need to:
    1. Click on the F5: Balance icon, or press the F5 key on your keyboard, to balance the batch.
    2. Click on the F9: Process icon, or press the F9 key on your keyboard, to change the alias (batch name).
      Note This will help you if you wish to identify a specific batch to generate a batch type report, or if you wish to export posted batches to a file.

    3. Click on the F8: List icon, or press the F8 key on your keyboard, to list the batch.
      Note - It is a good idea to list the batch, and check the entries on the batch thoroughly. If there are any errors, you may edit the batch, before posting the batch.

    4. Click on the F6: Post icon, or press the F6 key on your keyboard, to post the batch.

Warning - Once the repeating entries have been copied to a normal batch and the batch is posted (updated) to the ledger, you need to process transactions in another batch to rectify any errors, if you did not edit the batch, before posting the batch.

Error - No Data to Import

Error - No Data to Import:

  1. If no repeating transactions are available or entered in the Edit→Repeating Transactions menu option for the selected batch type, TurboCASH will display the following error message:
    No Data to Import
  2. Click on the OK button.
  3. Select the correct batch type, and proceed to import the Repeating Entries.

If it is the correct Batch Type:

  1. Exit or close the Batch Entry Transaction screen.
  2. Enter the transactions in the Edit→Repeating Transactions menu option.
  3. Access the Batch Type in the Input→Batch Entry menu option to import the repeating transactions.
0 votes so far for this article. Did this article help you? YES NO
Article Id: 454 - Version: 1 - Created: 17-10-2006 - Last Updated: 30-11-1999 - Hits: 610 

Comments & Questions

No comments yet!

Powered By mosKnowledgebase - (©) 2005 Blue Flame IT Ltd.

Quick Quote Request





User Statistics

72740 registered
2 today
196 this week
405 this month
Last: vmv