260
Since the last Bookkepeer never entered nothing, I am new in GP, and I a have all deposit matched up for some reason the checks and other wthdrawals did not match I have to enter an adjusment, so anybody can tell me how do this, this is an emergency SOS. Please
*This post is locked for comments
This is TK 857211
To restart Bank Reconciliation by using the current checkbooks, and to clear the old data, follow these steps.
Note Before you follow the instructions in this article, make sure that you have a complete backup copy of the database that you can restore if a problem occurs.
Reconcile the last bank statement in Microsoft Dynamics GP. Make sure that you list all the outstanding transactions that exist as of that reconciliation.
Post all the batches from other modules that would affect the checkbook.
Print an Undeposited Receipt report. To do this, click Reports, point to Financial, and then click Checkbook.
Note Enter a deposit to clear the receipts for any receipts that do not make up an outstanding deposit. Enter a deposit that contains receipts for any receipts that are on an outstanding deposit.
Reconcile bank statements. To do this, follow these steps:
Click Transactions, point to Financial, and then click Reconcile Bank Statement.
Enter the bank statement ending balance, and then enter the bank statement ending date from the statement that was used in step 1.
Specify a cutoff date that is the last day of the month that is being reconciled. This step will prevent the unintentional clearing of transactions from the following months.
In the Reconcile Bank Statements window, click Transactions, and then select all the transactions except the following transactions:
Outstanding transactions in step 1
Any transactions that were entered since the reconciliation in step 1
Open the Posting Setup window. To do this, use one of the following methods:
In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Posting, and then click Posting.
In Microsoft Dynamics GP 9.0 and in earlier versions, point to Setup on the Tools menu, point to Posting, and then click Posting.
In the Series list, click Financial. In the Origin list, click Reconcile Bank Statement.
Click to clear the Post to General Ledger check box.
Enter an adjustment to make the reconciliation difference zero. This adjustment will affect the checkbook balance. If this checkbook balance already matches the general ledger, let the adjustment post to the general ledger.
Print the Reconcile Edit List report, and then print the Outstanding Transactions report. To do this, use one of the following methods.
Note Make sure that these reports match the reports from the reconciliation in step 1. Specifically, make sure that the outstanding transactions and the Bank Statement Ending Balance match. If any transactions are missing from the Outstanding Transactions report, you must enter them in Bank Transactions, and you must make sure not to post to the general ledger if the transaction has already updated it.
In Microsoft Dynamics GP 10.0, click Print on the Microsoft Dynamics GP menu.
In Microsoft Dynamics GP 9.0 and in earlier versions, click Print on the File menu.
Reconcile. To do this, click Reconcile in the Select Bank Transactions window.
Open the Posting Setup window. To do this, use one of the following methods:
In Microsoft Dynamics GP 10.0, point to Tools on the Microsoft Dynamics GP menu, point to Setup, point to Posting, and then click Posting.
In Microsoft Dynamics GP 9.0 and in earlier versions, point to Setup on the Tools menu, point to Posting, and then click Posting.
In the Series list, click Financial. In the Origin list, click Bank Transaction Entry.
Click to select the Post to General Ledger check box. Also, you can click to select the Post Through General Ledger Files check box if you want to select this check box.
Make sure that the checkbook register contains only the outstanding transactions. Then, make sure that the last reconcile balance in Checkbook Maintenance is the Bank Statement Ending balance.
Make sure that the current checkbook balance matches the general ledger balance.
--------------------------------------------------------------------------------
1) I assume you are doing a bank reconciliation?
2) You state the checks and other withdrawls did not match. Does that mean that some are showing in the reconciliation while others are not?
3) If yes to number 2, for those checks / withdrawls that are not shown, were they entered into GP (probably at the vendor level)?
4) If the checks were entered at the subledger level (ie, Vendor), then do you see the transaction amount hitting the general ledger (ie, credit to cash account and debit to accounts payable)?
5) If the answer to number 2 is that all checks and withdrawls are not showing on the bank recon, then you need to first identify if the checks and withdrawls were created in GP (maybe they are hand written checks instead of system printed). If you have not done this, you can try to search for a check by going to Purchasing and under Inquiry, choose Transaction by Document. Type in one check number in the From To fields and hit redisplay to see if GP finds it at the subledger level.
6) For the checks that are missing at the bank level, do you know if the invoice(s) associated with the payment has been entered? If the invoices have been entered, then does GP still show them as open or in history?
I guess what I'm trying to determine is if the transactions were run through the subledger, but just are not appearing at the bank recon level as well as if the transactions were entered at the subledger level, did they make it to the general ledger/financial level.
Best regards,
Dale
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
