My g/l reconciles to the vendor balances, but the sub-ledger Open Payables report does not reconcile to the month-end g/l balance because future payments that are posted are not being reflected on the Open Payables report. But the vendor itself shows a zero balance and that zero balance is being reflected in the g/l - even though the actual payment is not made yet (it is scheduled to be paid). I would like to either have the g/l not reflect future a/p payments (preferred), or have the printed sub-ledger reflect the actual vendor balances. Any suggestions?

The reason for future payments being posted, is from online banking payments being scheduled a few weeks in advance. i.e. Telus invoice Aug 20/16 with payment scheduled to be paid Sept 12/16. We enter the invoice for August, and in August, we enter the payment for Sept 12/16. The G/L for August 31, 2016 shows a zero balance for this vendor, but the a/p sub-ledger listing shows it as outstanding.

On the Open Payables report, If the "C" indicating transactions completely settled by post-dated transactions appeared, I could easily reconcile, but I am not showing any "C"s for fully paid vendors that are still showing a balance. Maybe this is the problem I need to resolve?