How does the AP Period End report for CCP Accounts work?
Description
Cause
Resolution

The Period End report for CCP Accounts compiles all of the transactions with a Credit Card Payable account through the Cutoff date entered. These transactions include the credit card payments (from Record Payments by Credit Card) and the statement invoice (from Verify Statement Balance - Create Invoice), as well as any voided credit card payments or deleted statement invoices.

Since the credit card payments are created on the individual vendors of the invoices being paid but the statement invoice that satisfies the credit card payable is created on the credit card vendor, the vendors are different so the report is unable to show only what is open. This report will continue to grow in size as your credit card activity increases.

The Include Invoiced checkbox prompt field determines whether credit card payments with a status of Invoiced should be included. An Invoiced status means that the statement invoice has been created.

When running the report to balance with General Ledger, you will want the Include Invoiced prompt selected. If it is not selected and the statement invoice was not created until after the cutoff date, the report will be off by what was invoiced after the cutoff date.

If the report total has a positive balance, the balance in General Ledger on the credit card payable account should be a credit balance. If the report total has a negative balance, the balance on the account in General Ledger should be a debit balance.

NOTE: As long as the check box is marked for Include Invoiced, the following are true:

  • The sum of the "CC Payable Balance As Of" column is the account balance at the time of the period end cut-off date. The sum of this column should tie to the account balance in General Ledger as of the cut off date.
  • The sum of the "Current CC Accts Payable Balance" column is the account balance as of the current date (all posted items). The sum of this column should tie to the ending balance in General Ledger.
DocLink: How do I reconcile AP credit cards to GL?

[BCB:156:Chat 300 CRE US:ECB]
Defect ID
Steps to duplicate
Related Articles