How do I reconcile accounts payable to General Ledger in GP?
How do I reconcile accounts payable to General Ledger in GP?
To open the “Reconcile to GL” window, point to Tools on the Microsoft Dynamics GP menu, point to Routines, point to Financial, and then click Reconcile to GL. Below is a running list of issues that we have seen that may cause differences: Not all GL batches are posted.
How do I void a GP manual check?
To void a payment in Dynamics GP, go to Purchasing > Transactions > Void Historical Transactions. In the Void Historical Payables Transactions window, enter or select the vendor for the payment you want to void. Then mark the check box in the void column next to the transaction you wish to void.
How do I apply for unapplied payments in Great Plains?
On the Navigation Pane on the Left Side of Screen – Go To Sales >> Transactions >> Apply Sales Documents. This will open the Apply Sales Documents Window. Select the Customer with the Payment / Credit Memo / Return that needs to be unapplied and applied correctly.
How do I run a customer statement in the Great Plains?
Select Microsoft Dynamics GP – Tools – Routines – Sales – Statements. Enter the Statement ID. Enter the Statement Description to define when and which customers the statement applies to. The Address ID should auto fill in once the initial parameters are entered.
How do I reconcile AR to GL?
Reconciling Accounts Receivable
- Update all transactions for the period of the reconciliation.
- Run an aged trial balance report.
- Run the general ledger report for the same period on the last day, as well.
- Track down any variances between the amount due on the AR report to the AR balance on the general ledger.
Why are accounts payable different from accounts receivable in general ledger?
This article discusses why the Accounts Payable account balance or the Accounts Receivables account balance in General Ledger differs from the total amount that is due on the Historical Aged Trial Balance report in Microsoft Dynamics GP. There are commonly asked questions at the end of this article.
How to reconcile payables and receivables in…?
Batches – This option will update the batch header and totals based on the unposted transactions saved in the system. This can be helpful if there are batches that are missing transactions. Workflow Status – If you mark this option, the workflow status and priority are reconciled for active and inactive vendor records.
How are payables and receivables related to cash flow?
Both terms, receivables and payables, are generally related to accounting and financial analysis. Still, they are also common when it comes to administrating a business, especially managing cash flow. They are used in planning and forecasting as a measure of future cash movements.
Do you tie balances on reconcile to GL spreadsheet?
Because of the different calculation methods/tables used to obtain the balances, the Reconcile to GL spreadsheet is not expected to outright tie to the aging balances on the HATB reports and would make reconciling them difficult. It is not necessary to tie the balances on the reconcile to GL spreadsheet to the HATB report.