Period Close Difference and Manual Journal Request

A manual journal entry should not be used to force the reconciliation to zero. The difference is a symptom of unresolved subledger transactions, and a manual entry would mask the cause, misstate the liability or cash, and create a reversing problem next period.

The likely contributors are visible in the facts:

• Unaccounted invoices: three invoices failed distribution validation, so no accounting was created and nothing was transferred to the GL. Their liability is in Payables but not in the ledger.
• Insufficient Information holds: these invoices may not have validated or accounted correctly. A hold itself does not always prevent accounting, but this hold often blocks progress until the missing data is supplied.
• Unconfirmed payment: the $18,000 payment is issued but not confirmed. Payment accounting or bank clearing may be incomplete, which can create a Payables-to-GL or bank reconciliation difference.
• Missing withholding: the $7,500 invoice has no withholding tax group, so withholding was not calculated. The supplier liability, withholding liability, and payment amount can all be wrong.

The controller should drill into the reconciliation by transaction type, accounting date, and status. Correct the source transactions, create accounting, transfer to GL, post, and then re-run the reconciliation. A residual difference can be investigated and explained; it should not be journaled away without support.

Close in a controlled sequence:

1. Resolve holds and invalid distributions. Fix the three unaccounted invoices and the two Insufficient Information invoices. Supply missing distributions, supplier site data, or tax details, then validate them.
2. Correct withholding. Populate the supplier site withholding tax group, recalculate withholding on the $7,500 invoice, and verify the liability and payment amount. If the invoice was already accounted, process the necessary adjustment.
3. Confirm the payment. Confirm the $18,000 payment and reconcile it to the payment register. The bank statement may arrive later, but the payment status should not remain unconfirmed at close without explanation.
4. Create accounting and transfer to GL. Run Create Accounting for all eligible transactions, review exceptions, transfer the journal entries, and post them in GL.
5. Reconcile. Re-run Payables to Ledger Reconciliation and investigate any remaining difference by transaction. Do not close on an unexplained balance.

Before closing Payables, the business unit should have no unaccounted transactions that belong in the period, withholding should be calculated, payments should be confirmed or explicitly excluded, and the reconciliation should be zero or fully explained. The GL period should remain open until the subledger entries are posted.

Use the reconciliation and exception reports together rather than relying on the trial balance alone:

• Payables to Ledger Reconciliation to identify the total difference and drill into accounting vs. transaction status.
• Unaccounted Transactions Report to list invoices and payments that have not been accounted.
• Invoice Hold Report filtered by hold reason to see the Insufficient Information items and aging.
• Payment Register and payment status reports to confirm issued vs. confirmed payments.
• Withholding Tax reports to verify withheld amounts and supplier liabilities.
• Received Not Invoiced and accrual reports to check period-end accruals.

If the period is closed too quickly, the main accrual risks are understating liabilities for unaccounted invoices, misstating cash or payables for unconfirmed payments, and misstating withholding liabilities. A manual journal entry can make the total look right while leaving individual supplier balances wrong, which creates supplier statement disputes and a harder close next period. The control is to require transaction-level reconciliation and documented clearance of every exception before close.