How do I stop old checks from showing on a bank reconciliation?

How do I stop old checks from showing on a bank reconciliation?

How do I stop old checks from showing on a bank reconciliation?

Create a journal entry for void checks and then clear it.

For example, there may be a check that shows up on the bank reconciliation. To stop the check from showing up, you'll need to create a journal entry in General Ledger to record a check that is "stale-dated" or that should have been voided.

 

Important! Please refer to the state regulations for instructions on how to handle unclaimed property.

 

Step 1: Creating a journal entry for a void check

1. Open Connect General Ledger > Journals > Enter Journal Amounts.

The Enter Journal Amounts Options displays.

2. Use the Journal menu to select the CD journal associated with the bank being reconciled.

3. Use the Period menu to select the correct GL period.

4. Click OK.

The Enter Journal Amounts form displays.

5. Click to select the field titled Reference, and then enter the check number.

6. Click to select the field titled Description, and then enter a reason for the journal entry.

Example: "Stale Check - John Smith" or "Void Check - John Smith"

7. Click to select the field titled Account, and then enter the expense account the check was originally recorded to.


8. Click to select the field titled Amount, and then enter the check amount as a negative amount.

Example: -#######.##

9. Press Enter.

10. Click Close.

Connect asks, "Do you wish to create auto-offset transactions?"

11. Click Yes.

The journal entry for the void check is saved. The next step is to clear the original check AND then void the check in the bank reconciliation.

 

Step 2: Clearing the void check

1. Open Connect General Ledger > Reconciliation > Reconcile Bank Accounts.

The Options form displays.

2. Select the bank and period to reconcile and then click OK.

The Reconcile Bank Accounts form displays.

3. Find the field titled Outstanding Checks and click the [...] button at the end of the field.

The Cleared Check Entry form displays a list of uncleared checks.

4. Find the original check number and check the box in the column titled Cleared.

5. Find the void check and then check the box in the column titled Cleared.

6. Click Accept.

7. Click Close.

You're done. The original check is cleared and voided in the bank reconciliation.

    • Related Articles

    • Bank Reconciliation

      See attached
    • New Bank

      We added a new fund and checking account for Fire by doing the following. 1. Create the fund - Go to General Ledger - Organization - Chart of Accounts. We created the following new account numbers: Asset 215-11100 Fund Cash (with Allocations set to ...
    • Voiding Stale Dated Checks

      See attached
    • Voiding Stale Dated Checks

      To properly address stale dated checks, you will need to ask a few questions.    Will the check be reissued to the same vendor for the same amount? o Yes         Go to Accounts Payable – Invoices & Payments – Void Checks         Enter the date that ...
    • Direct Deposit was rejected by bank. Need to issue check

      How to print a check when a direct deposit fails for an employee This process may be used when the entire amount for the direct deposit has failed and the check has not been updated to the GL.  If a portion of the direct deposit goes through and part ...