Modules»Accounts Payable»A/P Daily Balancing Spreadshee…
  • RSS Feed

Last modified on 9/16/2015 7:59 PM by User.

A/P Daily Balancing Spreadsheet Example

Beginning Balance Batch # Starting / Ending Voucher # "D" Voucher Postings Starting / Ending Check # "F" Check Register Calculated Ending Balance "H"         A/P ATB AMOUNT
$200,745.24           $200,745.24  
  200 1004-1030 $10,024.74 7847 $1,000.00 $209,769.98  
  201 1031-1042 $2,000.00 7848-7850 $798.25 $210,971.73  
  203 1043-1044 $2,500.00 7851-7875 $45,745.32 $167,726.41  
  204 1045 $17.00     $167,743.41  $ 167,743.41
  205 1046 $742.00     $168,485.41  
  206 100093-100107 $39,743.56     $208,228.97  
  207 1047-1049 $2,345.79     $210,574.76  
  208 100108-100125 $43,745.23     $254,319.99  $ 254,319.99
        7876-7881 $2,375.96 $251,944.03  $ 251,944.03
               
      $101,118.32   $49,919.53    
             
Column D:  Total equals "Regular Entries, Regular Total (Net Change to A/P)" on the Voucher History report  
      and "Increase in Accounts Payable" on the A/P to G/L Interface report.  
Column F equals "Paid Entries Within Date Range, Paid Total (Net Change to Cash)" on the Voucher History  
     report and "Paid and Regular Checks" on the A/P to G/L Interface report  
Column H is "GRAND TOTAL" on A/P Aged Trial Balance report