Hi
Likes to know complete steps to reconcile -
1. AP liability accounts with GL accounts.
* besides payable transfer to GL.
2. FA Capital accounts with GL accounts
Reconciliation steps
To Reconcile AP with GL
First run AP Trial Balance report-Trial Balance report lists your
outstanding accounts payable liability information
Run GL Account Analysis report for the Liability account for the same date range. Thses two should help in reconciliation.
Also For example, you are closing your
accounting period for April and you
have just posted your final
invoice and payment batches to your
general ledger system. To reconcile
your accounts payable activity for April,
make the following calculation:
Accounts Payable Trial Balance as of March 31
+Posted Invoice Register for the period between
April 1 and April 30
-Posted Payment Register for the period between
April 1 and April 30
= Accounts Payable Trial Balance as of April 30
First run AP Trial Balance report-Trial Balance report lists your
outstanding accounts payable liability information
Run GL Account Analysis report for the Liability account for the same date range. Thses two should help in reconciliation.
Also For example, you are closing your
accounting period for April and you
have just posted your final
invoice and payment batches to your
general ledger system. To reconcile
your accounts payable activity for April,
make the following calculation:
Accounts Payable Trial Balance as of March 31
+Posted Invoice Register for the period between
April 1 and April 30
-Posted Payment Register for the period between
April 1 and April 30
= Accounts Payable Trial Balance as of April 30
AR reconcillation
Report Information
India ? Debtors Trial Balance Report Opening Balance
Transaction Register Transactions
Adjustment Register Adjustments
Applied Receipts Register Applied Receipts
Unapplied Receipts Register Unapplied Receipts
India ? Debtors Trial Balance Report Closing Balance
Formula
Opening Balance
Add Transactions
Add/Subtract Adjustments
Less Applied Receipts
Less Unapplied Receipts
Closing Balance
TIA
Report Information
India ? Debtors Trial Balance Report Opening Balance
Transaction Register Transactions
Adjustment Register Adjustments
Applied Receipts Register Applied Receipts
Unapplied Receipts Register Unapplied Receipts
India ? Debtors Trial Balance Report Closing Balance
Formula
Opening Balance
Add Transactions
Add/Subtract Adjustments
Less Applied Receipts
Less Unapplied Receipts
Closing Balance
TIA
first run the following report:
payable account analysis report in ap module and give the following parametre:
liabilities a/c.....xyz
summarised report....yes
the report will be generated and u will find dr.and cr.total
this report is generated on code combination,after that pl run the following report in GL >account analysis sub ledger detail
take precaustion that give the same liability a/c as u have given in ap.
after matching both the report u can easily reconicile your a/c.
regards
payable account analysis report in ap module and give the following parametre:
liabilities a/c.....xyz
summarised report....yes
the report will be generated and u will find dr.and cr.total
this report is generated on code combination,after that pl run the following report in GL >account analysis sub ledger detail
take precaustion that give the same liability a/c as u have given in ap.
after matching both the report u can easily reconicile your a/c.
regards
Who is online
Users browsing this forum: No registered users and 5 guests