This method has you print a list of unreconciled transactions from Bank Rec.
Method 2: (Manual method for any version of Microsoft Dynamics GP) You can select the Excel button to reopen the Excel spreadsheet from any saved reconciliation.
#Rcbc chequebook balance trial
The balances should be taken from the Checkbook and the GL Trial balance, and not relied on in this spreadsheet.īack on the Reconcile to GL window in GP, select Save to save this reconciliation, if you wish to go back and view your reconciliation history it anytime. Focus mainly on researching the items in the Unmatched Transactions section to help you reconcile. It's suggested to use this spreadsheet as an aid for your regular reconciliation. Reasons for unmatched items are listed at the top of this KB article. You'll need to research the Unmatched Transactions to investigate why there isn't a match. The items are listed according to sections for Unmatched Transactions, Potentially Matched Transactions, and Matched Transactions. You can add more GL accounts if needed or override it.Īn Excel spreadsheet will open displaying the items from the Bank Reconciliation table on the left side, and the GL entries on the right side. Under Accounts, the default cash account defined on the Checkbook ID will default in. *It's recommended to make a folder for your reconciliation spreadsheets, as you're allowed to save your reconciliation history. (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.
#Rcbc chequebook balance update
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.
#Rcbc chequebook balance how to
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 kommentar(er)
