Profit21 NL

Accounts Payable

AP Trial Balance

Open vendor invoice balances as of today — aged by due date across current, 30, 60, 90, and 90+ day buckets. Run monthly to reconcile against your AP GL account.

What is the AP Trial Balance?

The AP Trial Balance (also called the Aged Trial Balance or ATB) lists every approved, open vendor invoice and how much remains unpaid. The total open amount should tie to your Accounts Payable GL account for the same period.

Run this report on a monthly basis and compare the total to the cumulative balance of your AP GL account. If they don't match, use the troubleshooting queries in the P21 KB to locate the imbalance — common causes include manual GL postings to AP, voided prepayment checks, and vouchers posted to a different period than their GL entry.

Open Balance Calculation

Each voucher's open balance is calculated as:

Open Balance = Invoice Amount
    − Amount Paid
    − Terms Discount Taken
    + Memo Amount

Payments and terms discounts are only counted if posted in or before the current period. Void checks with a void date in a future period are excluded from paid amounts.

Disputed Vouchers

When a voucher is marked Disputed in P21, it is excluded from check printing windows and appears in the Disputed column on this report. The disputed amount is still posted to the GL normally — only the payment eligibility is affected.

As of P21 v12.6, disputed vouchers are not included in the Total Open Amount by default. When reconciling to the GL, add the disputed balance back to get the true AP liability.

Aging Buckets

Vouchers are aged by their net due date — the date payment is due after applying the vendor's payment terms. Buckets:

CurrentDue today or in the future — not past due
1–30 Days1 to 30 days past the net due date
31–60 Days31 to 60 days past the net due date
61–90 Days61 to 90 days past the net due date
90+ DaysMore than 90 days overdue — escalation recommended

Open Vouchers — As of Today