Skip to content
Open Bokeping

Why does a vendor balance differ from the statement?

Check missing bills, payments, advances, and report dates before changing your payable balance.

In BokepingReports → A/P Aging Summary

By

Last updated:

A vendor statement and Bokeping may use different dates or include different documents. Start with the same vendor and statement cutoff; do not enter a balancing expense simply to make totals agree.

Open Reports → A/P Aging Summary and review the report date. Compare it with the vendor’s statement date. Inspect the vendor’s bills, payments, and credits for the same period, including opening balances from a migration.

DifferenceWhat to check
A bill is still outstanding after paymentThe payment exists but may not be allocated to that bill.
The vendor owes you moneyLook for an unapplied advance or credit before recording another payment.
Bokeping is higher by exactly one billCheck for a duplicate bill or a duplicated vendor opening balance.
The vendor statement is higherLook for a missing bill or a payment the vendor has not received/allocated yet.
Totals changed after an earlier closeReview backdated edits and the report date with your accountant.

Before allocation, the $1,000 bill can remain open while a separate $300 unapplied prepayment exists. After you allocate the original advance, the bill should have $700 remaining. Before allocation, A/P can remain $1,000 while $300 is held separately in the Vendor Prepayments asset account. After application, A/P is $700 and that advance is consumed. Compare the prepayment schedule separately rather than forcing the open-bill total to show a net figure before application.

Apply credits form with a $300 vendor payment selected against a $1,000 bill, leaving $700 after application.

Open full-size screenshot ↗

This is the Demo company’s $300 advance application to a $1,000 bill. The application was saved and the $700 remaining balance was verified in the bill.

Re-run the report after correcting the verified source record. Keep the vendor’s statement and your list of differences. Compare the A/P control account with supporting vendor balances using consistent dates; journal-only changes may not explain individual vendor documents.

Frequently asked questions

Why doesn't my vendor's statement match what I owe them in Bokeping?

The two often use different dates or include different documents. Open Reports > A/P Aging Summary, set the report date to the vendor's statement date, and inspect that vendor's bills, payments, and credits for the same period, including opening balances from a migration. Don't enter a balancing expense simply to make the totals agree.

Why is a vendor bill still open after I paid it?

The payment probably exists but is not allocated to that bill. Find the vendor's payment and check which bills it was applied to, or whether it is sitting as an unapplied advance. Allocate it to the correct bill instead of recording another payment, then re-run the A/P Aging Summary.

Why is my vendor balance in Bokeping higher by exactly one bill?

Look for a duplicate. When Bokeping shows more than the vendor's statement by exactly one bill, check whether the same bill was entered twice or the vendor's opening balance was duplicated. Correct the verified source record, then re-run the report.

The vendor's statement says I owe more than Bokeping shows. What's missing?

Look for a bill you haven't entered yet, or a payment the vendor has not received or allocated on their side. Compare the statement line by line with the vendor's bills and payments in Bokeping for the same cutoff date, and keep the statement with your list of differences.

Why does accounts payable still show the full bill after I paid the vendor an advance?

Because the advance hasn't been applied yet. With a $1,000 bill and a $300 advance, A/P can stay at $1,000 while the $300 is held in the Vendor Prepayments asset account. After you allocate the advance to the bill, the bill has $700 remaining and A/P is $700.

Screenshot