Make any necessary adjustments to correct differences
Needs procedure intro:
-
If an amount is found in the
Journal Entry field, there are two ways to make a correction:
- Using the Enter JEs screen in the General Ledger module, make a journal entry that backs out the original journal entry. Post it to the accounting period that you are attempting to reconcile. Then go to the appropriate screen to do your transaction. If this is a cash transaction, go to the Manage Cash Receipts screen in Costpoint Accounts Receivable. Enter and post the cash receipt. If the transaction is for billing, then go to the appropriate billing screen and enter the bill (use the Manage Standard Bills, Manage Progress Payment Bills, Manage Customer Product Bills, Manage Project Product Bills, Manage Manual Bills, or Manage Milestone Percent Complete Bills screens in the Billing module). Print the bill and post.
- If you need to update customer or project information, go to the Manage Accounts Receivable History screen, and enter a new line for the detail that relates to the journal entry.
-
If there is an amount in the
Voucher field, the source of this amount came from an Accounts Payable voucher. There should not be activity in an Accounts Receivable account that has come from Accounts Payable. We recommend the following procedure:
- Enter a correcting voucher on the Manage Accounts Payable Vouchers screen in the Accounts Payable module and post it to the accounting period that you are reconciling. If this is a cash transaction, go to the Manage Cash Receipts screen. Enter and post the cash receipts. If the transaction is billing related, go to the appropriate billing screen, and enter the bill (use the Manage Standard Bills, Manage Progress Payment Billings, Manage Customer Product Bills, Manage Project Product Bills, Manage Manual Bills, or Manage Milestone Percent Complete Bills screens). Print the bill and post. We do not recommend that you manually update the Accounts Receivable History screens.
-
If the amounts on the Accounts Receivable Aging Report are higher than the General Ledger balances, there may be records in the Maintain Customer Accounts Receivable History or Maintain Project Accounts Receivable History screens that were manually entered. When you add any lines in the history screens, the General Ledger is not updated. If this is the situation, you have two ways to correct the imbalance:
- On the Enter JEs screen in Costpoint General Ledger, post a Journal Entry to record the invoice. The accounts that you will use are the Accounts Receivable billed receivable account and the unbilled receivable account. You must manually update the Manage Billing History screen. You also must update the Manage Closed Billing Detail screen if the invoice information has not yet been recorded there.
- The method that Deltek recommends to correct this imbalance is to delete the lines in the Accounts Receivable History screens. Enter the bill in the appropriate billing screen (use the Manage Standard Bills, Manage Progress Payment Billings, Manage Customer Product Bills, Manage Project Product Bills, Manage Manual Bills, or Manage Milestone Percent Complete Bills screens). Post the Billing Journal.
Parent Topic: A/R Aging Report To The G/L