7/15/2023 0 Comments New checkbook ledger![]() (The system will store this location and default it in for the next reconciliation for Bank Reconciliation, but you can override it at any time.) In the Output File, browse out to a location to save the Excel Spreadsheet* to and a default file name will be generated (consisting of the checkbook ID, sequence number, and beginning date of the date ranged entered). Select the Checkbook ID to be reconciled. Select the Module of Bank Reconciliation. It works best to reconcile a smaller date range such as a monthly basis. Select Tools under Microsoft Dynamics GP, point to Routines, point to Financial and select Reconcile to GL.Īccept the default Reconciliation number.Ĭhange the Reconciliation Date if wanted. Which Reconcile to GL tool can be found at: ![]() This routine will produce an Excel spreadsheet that will determine the matched, potentially matched, and unmatched transactions between Bank Reconciliation and the General Ledger for the date range and GL accounts entered. In Microsoft Dynamics GP 2013, Bank Reconciliation has been added to the Reconcile to GL routine to help automate the matching process between the GL cash account detail and the Bank Reconciliation detail. Method 1: (For Microsoft Dynamics GP 2013 ~ new feature) Use one of the two methods listed below to reconcile the GL cash account balance to the checkbook balance in Bank Reconciliation. Timing differences the transaction in Bank Reconciliation was posted to General Ledger with a different date. However, the general ledger cash account has $0 posted to it. In this situation, the checkbook balance is updated. The same cash account was debited and credited. The transaction was edited in a financial batch before it was posted to the general ledger. The starting checkbook balance isn't equal to the last reconciled balance.Ī deposit is saved. The cash account is coming from a customer, from a vendor, or from an employee instead of from a checkbook. ![]() However, you didn't enter a transaction in Bank Reconciliation. You entered a transaction to the cash account in the general ledger. ![]() However, the modules do update Bank Reconciliation. Other modules don't post to the general ledger. Posting setup wasn't set to post to the general ledger for the Bank Reconciliation origins. Non-cash transactions were posted to the general ledger cash account. However, the Bank Reconciliation files weren't restored. The same general ledger cash account is used for more than one checkbook.Īfter a posting interruption occurred, the module that had the posting interruption was restored. However, the deposit was made in Bank Reconciliation. General ledger transactions may still be sitting in a Financial batch waiting to be posted. However, the checkbook balance may not have been updated. In this situation, the general ledger may have been updated. However, the deposit hasn't been made to Bank Reconciliation.Ī Deposit to Clear Receipts deposit was posted to Bank Reconciliation, and those receipts came from Receivables Management or from another module. Receipts were posted to the general ledger. ![]() The outstanding information (that is, checkbook balance) was incorrect when you started using Bank Reconciliation.Ī deposit was posted in Bank Reconciliation (that didn't have receipts), and didn't post to the general ledger. For more information about how to correct these situations and to tie the Bank Reconciliation to the general ledger cash account, contact technical support for Microsoft Dynamics GP. ![]()
0 Comments
Leave a Reply. |