How do I edit, void, delete or adjust miscellaneous GL cash receipts in Accounts Receivable?
Description

Cause

Resolution

Note: If your deposit date and bank account don’t need editing, and all you want to change is the credit account, keep the information as is in Edit Register, use Record Entries in General Ledger to debit the incorrect credit account used and credit the correct GL account.

 

To adjust a Miscellaneous GL cash receipt:

  1. If you don't know the batch number, locate the batch number in Cash Management:
    1. Go to Cash Management, Inquiries, Entries, Deposits by Bank.
    2. Select the Register file and click OK.
    3. Select the applicable Bank Account.
    4. Add the column for Batch and note the batch number for the miscellaneous cash receipt. See How do I add or edit a column in an inquiry?
    5. Click Close.
  2. If you don't know the General Ledger accounts used for the Miscellaneous GL cash receipt, locate the General Ledger accounts in Accounts Receivable:
    1. Go to Accounts Receivable, Inquiries, Entries, Transactions.
    2. Select the Current file and click OK.
    3. Select the Active file and click OK.
    4. Click Conditions, select Batch, Equal to, and type the batch number in the Value box.
    5. Click OK twice.
    6. Add the Debit Account - Cash or Accrual and Credit Account - Cash or Accrual columns. See How do I add or edit a column in an inquiry?
    7. Note the General Ledger accounts.
  3. In Cash Management, Tasks, Edit Register create a subtracting adjusting entry:
    1. Use the same General Ledger accounts as the original cash receipt.
    2. For the GL debit, use the credit account entered on the AR Misc Cash Receipt. See How do I enter a deposit, withdrawal, adjustment, service charge, or other transaction types to a bank account in Cash Management?
    3. If multiple credit accounts have distributions from the cash receipt, enter the subtraction as a split withdrawal. See How do I split a Cash Management Withdrawal to multiple debit accounts?
  4. If this should have been to a customer, go to AR and enter the cash receipt for the customer. You may need to enter a unique deposit ID.

Notes: While recording the register adjustment in Cash Management, you may receive an error, "Could not determine if [date] is in a closed GL period for prefix [prefix]." See Error: "Could not determine if [date] is in a closed GL period for prefix [prefix ID]" (When in Cash Management Edit Register).
Depending on the accounting date of the adjustment, you may need to remove rejecting entries in General Ledger. See How do I remove unposted and unwanted transactions from the General Ledger new file using File Tools?


[BCB:156:Chat 300 CRE US:ECB]





Steps to duplicate
Related Solutions

How do I enter a deposit, withdrawal, adjustment, service charge, or other transaction types to a bank account in Cash Management?
How do I edit, void, delete or adjust miscellaneous JC cash receipts in Accounts Receivable?
How do I enter a Miscellaneous GL cash receipt in Accounts Receivable?