Transaction Journal Format

Transaction Journal Format - Fields

Show/Hide All

Source Journal

This field displays the source journal code selected in the Transaction Journal Entry window and can only be viewed. For more information, see Transaction Journal Entry.

Offset Account No.

Enter an account number to post the offsetting distribution total amount for the journal entry, or click the Lookup button to select an account from the list. Press CTRL+F3, or right-click and select Account Entry to use the Account Entry window to select an account. For more information, see Account Entry.

The account number entered displays as the default account number in the Offset Account No. field on the Transaction Journal Entry Header tab. If you change the account number in this field, the change is displayed in the Offset Account No. field on the Transaction Journal Entry Header tab. If the Bank Reconciliation module is integrated with General Ledger, the offset account number must be changed in this field, and the Offset Account No. field on the Transaction Journal Entry Header tab can only be viewed.

Only active status accounts can be entered. If a financial source journal is selected in the Source Journal field, only financial type accounts can be entered. If a nonfinancial source journal is selected in the Source Journal field, only nonfinancial type accounts can be entered.

If you change the Bank Code field, the Offset Account No. field is not automatically updated to the general ledger account defined for the bank code in Bank Code Maintenance.

Description

This field displays the description of the offset account and can only be viewed.

Offset

Enter the value to indicate the balance of the account selected in the Offset Account No. field. The value entered displays as the default value in the Offset field in the Transaction Journal Entry window. If the value is changed during transaction journal entry, the value entered displays automatically in the Offset field on the Transaction Journal Entry Header tab.

If Debit is selected, the offset account number is debited and the accounts on the Transaction Journal Entry Lines tab are credited.

If Credit is selected, the offset account number is credited and the accounts on the Transaction Journal Entry Lines tab are debited.

Transaction Total

Select this check box to enter a total amount for the entry in the Transaction Total field on the Transaction Journal Entry Header tab. The Transaction Total field on the Transaction Journal Entry Header tab is available only if this check box is selected.

Transaction Type

Enter the type of transaction for the entry. The transaction type entered determines the fields available for entry on the Transaction Journal Entry Lines tab.

If the Bank Reconciliation module is not integrated with General Ledger, only Check Number or Document Reference type transactions can be entered.

If the Bank Reconciliation module is integrated with General Ledger, Check Number, Document Reference, Deposit, Adjustment, or Bank Transfer type transactions can be entered.

Entry Sample

Enter....

If....

Check Numbers

A check number is to be entered on the Transaction Journal Entry Lines tab.

Bank Transfer

A bank code and document reference are to be entered on the Transaction Journal Entry Lines tab. If Debit is selected at the Offset field, the bank code entered on the Header tab receives the funds when a journal entry for transferring funds between banks has posted for the entry. If Credit is selected in the Offset field, the bank code entered on the Header tab transfers the funds when a journal entry for transferring funds between banks is posted.

Deposit, Adjustment, or Document Reference

A document reference number is to be entered on the Transaction Journal Entry Lines tab.

Auto Increment Check No.

Select this check box to automatically increment the check number for each transaction entry in the Check No. field on the Transaction Journal Entry Lines tab.

Clear this check box to enter a check number for each transaction in the Check No. field on the Transaction Journal Entry Lines tab.

This check box is available only if Check Number is selected in the Transaction Type field.

Post Deposits in Summary

Select this check box to post all deposit transactions for an entry as one entry in the Bank Reconciliation module. This check box is available only if the Bank Reconciliation module is integrated with General Ledger, and Deposit is selected in the Transaction Type field in the Transaction Journal Format window.

Clear this check box to post all deposit transactions for an entry as separate entries in the Bank Reconciliation module.

The value of this check box displays in the Post Deposits in Summary check box on the Transaction Journal Entry Header tab.

Note When the summary posting is updated to the Bank Reconciliation module, the posting date entered in the Posting Date field on the Transaction Journal Entry Header tab is used for the Bank Reconciliation deposit date, not the date entered in the Date field on the Lines tab.

Bank Code

Enter a bank code for the bank that is used for all transactions entered in Transaction Journal Entry. This field is available only if the Bank Reconciliation module is integrated with General Ledger, and Check Number, Deposit, Adjustment, or Bank Transfer is selected in the Transaction Type field in the Transaction Journal Format window.

If you change the Bank Code field, the Offset Account No. field is automatically updated to the corresponding account number defined for the bank code in Bank Code Maintenance.

The bank code entered displays as the default value in the Bank Code field on the Transaction Journal Entry Header tab. A description of the bank code displays.

Transfer Funds to Bank Code

Enter the bank code to send or receive the funds when a journal entry for transferring funds between banks is posted. If Debit is selected in the Offset field, the bank code selected in the Bank Code field on the Header tab will receive funds; if Credit is selected in the Offset field, the bank code selected in the Bank Code field on the Header tab will transfer funds. This field is available only if the Bank Reconciliation module is integrated with General Ledger, and Bank Transfer is selected in the Transaction Type field in the Transaction Journal Format window.

The bank code entered displays as the default value in the Bank field on the Transaction Journal Entry Lines tab, but can be changed during entry.

Enter....	If....
Check Numbers	A check number is to be entered on the Transaction Journal Entry Lines tab.
Bank Transfer	A bank code and document reference are to be entered on the Transaction Journal Entry Lines tab. If Debit is selected at the Offset field, the bank code entered on the Header tab receives the funds when a journal entry for transferring funds between banks has posted for the entry. If Credit is selected in the Offset field, the bank code entered on the Header tab transfers the funds when a journal entry for transferring funds between banks is posted.
Deposit, Adjustment, or Document Reference	A document reference number is to be entered on the Transaction Journal Entry Lines tab.