Adjustments in Bank Reconciliation

Adjustments are necessary during a bank reconciliation to correct entries that may have been reconciled in error or need modifications.

By using the adjustment feature, users can easily manage these entries and create batches for any necessary changes.

This process ensures accurate financial records and helps maintain the integrity of reconciled accounts.

Note: You can not adjust entries that are reconciled.

Field

Value

All On/All Off

Select All On to select all the reconciled in error entries for the adjustment batch or All Off to de-select all the entries.

Reverse Amount

You can select the Reverse Amount tick box to populate the Adjustment Amount field with a contra amount of the entry being adjusted.

Select for Batch

Select Yes if you want to create a batch with the variance amount of the reconciled in error entry.

Date

Enter a date for the adjustment entry.

Entry Description

Enter an entry description by which the adjustment can be identified. This can be the reason for the adjustment.

Source Code

Enter a source code to identify the type of transaction. The source code tells you where the transaction comes from and what kind of transaction it is.

Account

Enter the General Ledger account to which you want to post the adjustment.

Comments

Enter an adjustment comment.

Button

Select

Batch Create

Select the Batch Create button to create a batch of the variance amounts for the entries selected for the batch.

Batch List

Select the Batch List button to go to the Cashbook Batch List form without leaving the Adjustments form.

Post Batch

Select the Post Batch button to post the Adjustment batch without leaving the Adjustments form.

View Entry

Select the View Entry button to view the entry details.

Close

Select the Close button to close the Adjustments window.

Adjustment Steps

Step 1: Select Date Range

Choose your desired date range and select Ok.


Step 2: Filter by Status

Filter by Unreconciled status and select Ok.


Step 3: Mark Entries

After filtering by Unreconciled status, all unreconciled entries will appear in the reconciliation grid.

Double-click or select the Space Bar in the Mark column for each entry you want to adjust. Only marked entries will be included.

Note: To adjust an unreconciled entry on the fly, right-click the relevant transaction in your bank reconciliation and select Adjust.


Step 4: Select Adjust

Right-click in the Cashbook Reconciliation grid and select Adjust from the menu. The Adjustments grid will populate with the marked entries.


Step 5: Choose Entries to Adjust

Use Select All On to select all marked entries or Select All Off to de-select any.


Step 6: Enter Adjustment Details

Enter the Date, Entry Description, Source Code, Account Code, and Comments for each selected entry. Select Batch Create to create the batch.


Step 7: Post Adjustment Batch

After successfully creating the batch, select Post Batch. In the pop-up, select All under Reconcile Transactions on Posting, then post the batch.


Step 8: Verify Adjustments

Filter by Unreconciled status to confirm all entries were successfully batched.