Accounts Payables Trial Balance Mismatch
Normally we will do the reconciliation between AP to GL to make sure our liability account/control account is matching in both Payables and General Ledger. In some cases where this liability account will not match with the GL. in that case we need to use the formula to make sure the balance is correct in AP and GL..
Use the following Payables reports to reconcile your posted invoices and payments to your Accounts Payable Trial Balance to ensure that your Trial Balance accurately reflects your accounts payable liability:
-
- Posted Invoice Register
-
- Posted Payment Register
-
- Accounts Payable Trial Balance (last period and current period)
Previous month Accounts payables trial balance
+ April Posted Invoice Register
– April posted Payment Register
=============================================
Current Month Accounts Payables Trial Balance
==============================================
In one of the use case where the business was creating invoices and transferred to GL and they realized that it is not matching with GL.. we have examined the issue and we found that the user was using the liability account in the AP invoice distribution lines as an expense.. We can use this below script to find out such invoices where the liability account was used as an expense account and which is causing an issue..
SELECT aid.Period_name,
aid.invoice_id,
aid.amount,
aid.dist_code_combination_id,
aia.Invoice_num,
gck.concatenated_segments
FROM apps.AP_INVOICE_DISTRIBUTIONS_ALL aid,
apps.ap_invoices_all aia,
apps.gl_code_combinations_kfv gck
WHERE aid.invoice_id = aia.invoice_id
AND aid.dist_code_combination_id = gck.code_combination_id
AND aid.dist_code_combination_id = ‘10967’
–AND aid.period_name in (‘SEP-19′,’OCT-19′,’NOV-19′,’DEC-19’)
AND aid.period_name = ‘JAN-19’
