Filtered A/P Ledger

Introduction

This is actually a form that shows you a list of bills, with their cheque numbers, for a certain set of accounts, but it is most often used to produce reports. The reports are more detailed than the form. You can print a subsidiary ledger report for the accounts you select with the date and account filters. This is important for those who use the Accounts Payable as a subsidiary ledger and do not put full details into the General Ledger. A screen capture of the form is shown below.


Filtering the Data

Dates: You can select one or both dates. If you want a single month, you can pick it from the list. If it is currently February, then choosing January or February will set the Start and End dates to that month for the current year. Choosing a month between March and December would then set the two dates to the first and last day of the chosen month but for the previous year. If you only set the start date, then all bills will be included that have a bill date that is as of or beyond that start date. Similarly, setting only the End Date will show all bills that have a bill date up to and including the date you entered.

Account Parts: Each account number is made up of several parts. Use the Filter row of pull down lists to pick the set of accounts that should be included on the report

Once you have chosen the filters, click the Apply button in the top right to update the form's data.
 

Understanding Print vs Print All

Both buttons will open similar Subsidiary Ledger reports. There are two main differences between these two reports. One key difference is the amount of information shown per bill is greater when the Print button is used than when the Print All button is used. Another key difference is the Print button will show the report with only those accounts that match the chosen date and account filter. On the other hand, the Print All button will include all data since the General Ledger and Accounts Payable were last archived.  If you use the Clear button to remove the filter, then click the Print button, that report will also include all accounts and all bills.

 

[Cheque List] [Filtered A/P Ledger]