ADJUST CURRENCY BALANCES

Use this screen to access General Ledger cash accounts to make adjustments to foreign currency. You can make online adjustments to bank balances for reasons such as service charges or fluctuations in the exchange rate.

You can also use this screen to see your General Ledger cash accounts expressed in both your company's functional currency and the currency in which the account is denominated.

Before you use this screen, you must have first set up the bank and Electronic Funds Transfer (EFT) information on the EFT Bank Info subtask of the Manage Company Bank Accounts screen.

You must have the correct bank abbreviations linked to the cash accounts before you post any cash transactions. This allow easier bank reconciliations when working with multiple currencies.

Location

Selection Criteria

Bank Abbreviation

Enter, or click to select, a bank abbreviation for the bank whose transactions you want to view or adjust. These are the banks that you set up on the Manage Company Bank Accounts screen.

Bank

The bank ID and bank name display in these fields.

Currency

These field display the bank account currency code and currency name.

Bank Beginning Balance

After you select the fiscal year, your company's beginning bank balance is displayed in this field in the bank account's currency.

Functional Beginning Balance

After you select the fiscal year, your company's beginning bank balance displays in this field in your company's functional currency.

View

Summary

Select this option to summarize all like transaction types by date in the table window. For example, the total amount of receipts summarized by receipt date is displayed when the Summary option is selected. Each date containing adjustments displays in one row and each date for cash receipts also displays in one row.

Detail

Select this option to list all transactions in the table window. Additional information such as the transaction ID, transaction name, and transaction number also display.

Selection Ranges

Fiscal Year

Option

This field displays One to indicate that you can include only one fiscal year.

Start

Enter the fiscal year, or click to select one.

Period/Subpd

Option

From the drop-down list, select the range option to indicate the date through which you want the bank transaction history computed.

The options are:

• All — Select this option to include all periods and subperiods in the computation. The Start and End fields are disabled for this option.

• One — Select this option to include only one period and subperiod in the computation. Enter the period and subperiod in the Period Start and Subpd Start fields. The Period End and Subpd End fields are disabled for this option.

• Range — Select this option to include a contiguous range of periods and subperiods in the computation. Enter the beginning period and subperiod in the Period Start field and the Subpd Start field. Enter the ending period and subperiod in the Period End and Subpd End fields.

• From Beginning — Select this option to include a range that starts from the beginning of all available periods and subperiods and ends with the period and subperiod that you enter in the Period End and Subpd End fields. The Period Start and Subpd Start fields are disabled for this option.

• To End — Select this option to include a range that starts with the period and subperiod that you enter in the Period Start and Subpd Start fields and ends with the last period and subperiod of all the periods and subperiods. The Period End and Subpd End fields are disabled for this option.

Select a single subperiod if you are going to do a revaluation of the functional currency value of your bank account.

Do not do a revaluation posting for a range of periods or subperiods.

Start Period

Enter the starting period to include in the computation, or click to select a period. If you select All or From Beginning in the Option field, the Start Period field is unavailable.

Start Subpd

Enter the starting subperiod to include in the computation, or click to select a period. If you select All or From Beginning in the Option field, the Start Subpd field is unavailable.

Start Ending Date

After you enter subperiod numbers, the ending dates (including the month, day, and year) of the selected subperiods display to the right of the Start SubPd field.

End Period

Enter the ending period to include in the computation, or click to select a period. If you select All One, or To End in the Option field, the End Period field is unavailable.

End Subpd

Enter the ending subperiod to include in the computation, or select a subperiod from the drop-down list. If you select All, One, or To End in the Option field, this field is unavailable.

End Ending Date

After you enter subperiod numbers, the ending dates (including month day and year) of the selected subperiods display in the End Subpd field.

Table Window

This table window displays transactions based on the entries you made in the Selection Criteria block and Selection Ranges group box on this screen.

Transaction Type

This column displays the transaction type for a transaction. The types are:

• AP — Accounts Payable transactions

• CR — Cash Receipts transactions

• PR — Payroll transactions

Transaction Date

For CR transactions, the receipt date displays in this column.

For AP and PR transactions, the check date (or direct deposit date, as appropriate) displays in this column.

Outside of Subperiod Date

The check box in this column is selected if you entered a date outside the range that you specified in the Start and End Period/Subpd fields on this screen.

Bank Amount

This column displays a transaction amount in the foreign currency as indicated by the currency code.

Bank Balance

This column displays the bank balance in the foreign currency.

Functional Transaction Amount

This column displays the transaction amount expressed in your company's functional currency.

Functional Currency Balance

This column displays your company's bank balance expressed in your company's functional currency.

Transaction Description

For CR, AP, and PR transaction types, no historical transaction description is available. Costpoint automatically assigns the transaction source to this column, where it cannot be edited.

• For CR transactions, Cash Receipts Cash Account displays in this column.

• For AP transactions, AP Transaction displays in this column.

• For PR transactions, PR Transaction displays in this column.

Cash Account

The cash account that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Cash Organization

The cash organization that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Ref 1

The reference number 1 that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Ref 2

The reference number 2 that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Fiscal Year

The fiscal year that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Period

The period that you selected on the Adjustments and Revalue subtask displays in this column, which you can edit.

Subperiod

The subperiod that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Account Name

The account name that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Organization Name

The organization name that you selected on the Adjust/Revalue subtask displays in this column, which you can edit.

Subtasks