| | Accounts Payable and General Ledger are out of balance (incorrect retainage payable account) |
| Cause | An incorrect retainage payable account was used. |
| Resolution | - Identify the month where AP and GL first go out of balance.
- Use the AP Transaction List report. Refer to option B in article 17963 "How do I create an AP transaction report or find deleted AP invoices?"
- Run the report and add the following conditions: Accounting Date Greater than or equal to [first day of the month in question] AND Accounting Date Less or equal to [last day of the month in question]
- Preview the report. Review the Retainage Payable Account column and note any entries for an account that is not a normal retainage payable account or is for the wrong prefix (company, entity, etc).
- Determine if the invoice can be deleted and re-entered using the correct retainage payable account. If this is not possible, record a GL journal entry from the incorrect account to the correct account.
- Note: If the invoice is not corrected in AP and there is unpaid retainage left on the invoice, the entries will still go to the wrong retainage payable account when the remaining amount is paid and another GL journal entry will need to be recorded.
|
|