AP Balancing Spreadsheet

(BalanceAP.exe) This inquiry program generates a concise look at balancing the Accounts Payables at the end of the month. Displays data from various reports onto a single screen. The formula used is: Prior Aging plus Invoices, minus Check Register, plus Voided Check register, plus pre-Paid Vouchers, minus Prior Pre-Paid vouchers equals Ending Calculated Balance minus Current Aging equals the Variance ( if any).

May choose the Selection Criteria either By Entity All Periods or By Period All Entities. Enter the Period or use the up/down arrows to select (defaults to the last closed period). Enter the Year (if different). Press the Generate AP Balance Information button. May be run any number of times. There is a RE-Generate AP Balance Information.

User has the ability to Export Grid under the File menu. May also change the View to choose the period to display on the grid.