![]() Use this option to clear all old unused data, as you will want to clear all receipts from this window that will not be needed going forward. This option simply drops the receipt from the Deposit Entry window and does not affect GL. Clear Unused Receipts - Enter one large deposit for any receipts that are older than the date chosen in step 1 and not part of an outstanding deposit as of this date.(Note: GL was already updated when the cash receipt was posted.) This deposit option only updates the checkbook balance and does not affect GL. Enter as many deposits as needed and the Deposit Total for each should match the actual outstanding deposit amount(s) for ease in matching to the bank statement by amount. Deposit With Receipts - Enter a deposit(s) and mark any receipts that are part of an 'outstanding' deposit as of the date chosen in step 1 or after.Leave any current cash receipts unmarked that have not yet been deposited to the bank. Select the appropriate Type and enter as many Deposits as needed: Select the appropriate Deposit Date and Checkbook ID. Select Transactions, point to Financial and select Bank Deposits. Mark off deposited/reconciled receipts: Mark off the cash receipts in Microsoft Dynamics GP that have already been deposited and reconciled to the Bank Statement as of the point in time in step 1. Review the Undeposited Receipts Report to identify which receipts have already been deposited to the bank and reconciled, and which receipts are still outstanding, or part of an outstanding deposit as of the point in time chosen in step 1.Select Print to print the Undeposited Receipts Report.Select Destination and choose to print the report to the screen, printer, and/or file, and then select OK.Enter the Checkbook ID for the range and select Insert to add this restriction.Select the report for Undeposited Receipts, and select New.Select Reports, point to Financial and select Checkbook.Identify outstanding receipts: Print a list of cash receipts not yet deposited in Microsoft Dynamics GP to compare to the list of outstanding items from step 1, to identify the outstanding cash receipts. You do not want any other items affecting the checkbook balance or the GL Cash account balance at the same time you are doing maintenance to the checkbook, so it is recommended to have all batches posted in all modules, and ask all users not to key/post any transactions to this checkbook ID or GL cash account during this time. Post all batches: Post all the batches from other modules (GL, Payables, Receivables, SOP, POP, and so on) that would affect the checkbook balance. The outstanding items for the above reconciliation at this same point in time.The Bank Statement Ending balance at this same point in time.(Note: The GL cash account should only be linked to one checkbook ID.) ![]() The last Bank Statement ending date of the last reconciliation you completed between the Bank Statement and the GL cash account that is used with this checkbook.The goal will be to get the checkbook balance in Bank Reconciliation to match this balance that was last reconciled between the Bank Statement and General Ledger. You will also want to perform the steps in this article as close afterwards to that date as possible, to minimize the number of outstanding items since that date. Typically, this is the ending date of the last Bank Statement balance that you reconciled to the GL cash account used with this checkbook (which you should have been doing outside of Microsoft Dynamics GP). Select a starting point in time: Select a start date or point in time to begin reconciling the existing checkbook. Before you follow the instructions in this article, make sure that you have a current backup copy of the company database that you can restore if a problem occurs, or do this in a test company first.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |