Docstoc

Accounts Payable Aging Detail

Document Sample
Accounts Payable Aging Detail Powered By Docstoc
					Accounts Payable Aging Detail
Enter your Company Name here
Reported as of     [Month] [Day], [Year]

      INVOICE        INVOICE     INVOICE                     VENDOR PMT     DUE                                PAST DUE
     NUMBER            DATE      AMOUNT    VENDOR            TERMS (days)   DATE   CURRENT    1 - 30     31 - 60      61 - 90    91 AND OVER TOTAL DUE
Invoice 1 …                                                                                                                                      $0.00
Invoice 2 …                                                                                                                                      $0.00
Invoice 3 …                                                                                                                                      $0.00
Invoice 4 …                                                                                                                                      $0.00
Invoice 5 …                                                                                                                                      $0.00
Invoice 6 …                                                                                                                                      $0.00
Invoice 7 …                                                                                                                                      $0.00
Invoice 8 …                                                                                                                                      $0.00
Invoice 9 …                                                                                                                                      $0.00
Invoice 10 …                                                                                                                                     $0.00
Invoice 11 …                                                                                                                                     $0.00
Invoice 12 …                                                                                                                                     $0.00
Invoice 13 …                                                                                                                                     $0.00
Invoice 14 …                                                                                                                                     $0.00
Invoice 15 …                                                                                                                                     $0.00
Invoice 16 …                                                                                                                                     $0.00
Invoice 17 …                                                                                                                                     $0.00
Invoice 18 …                                                                                                                                     $0.00
Invoice 19 …                                                                                                                                     $0.00
Invoice 20 …                                                                                                                                     $0.00
Invoice 21 …                                                                                                                                     $0.00
Invoice 22 …                                                                                                                                     $0.00
Invoice 23 …                                                                                                                                     $0.00
Invoice 24 …                                                                                                                                     $0.00
Invoice 25 …                                                                                                                                     $0.00
Invoice 26 …                                                                                                                                     $0.00
Invoice 27 …                                                                                                                                     $0.00
Invoice 28 …                                                                                                                                     $0.00
Invoice 29 …                                                                                                                                     $0.00
Invoice 30 …                                                                                                                                     $0.00
Invoice 31 …                                                                                                                                     $0.00
Invoice 32 …                                                                                                                                     $0.00
Invoice 33 …                                                                                                                                     $0.00
Invoice 34 …                                                                                                                                     $0.00
Invoice 35 …                                                                                                                                     $0.00
Invoice 36 …                                                                                                                                     $0.00
Invoice 37 …                                                                                                                                     $0.00
Invoice 38 …                                                                                                                                     $0.00
Invoice 39 …                                                                                                                                     $0.00
Invoice 40 …                                                                                                                                     $0.00
TOTALS                                                                                $0.00      $0.00      $0.00        $0.00        $0.00      $0.00
TIP: Sheet 2 (Example) Has a
filled out example

TIP: Hover over column titles
for more instructions



Notes on Preparation:
Note: You may want to print this information to use as reference
later. To delete these instructions, click the border of this text box
and then press the DELETE key.

Note: Managing a business's accounts payables is a vital step in
ensuring vendors are being paid properly so as to ensure there are
no disruptions to the supply of goods and services. Our Accounts
Payable Aging Detail worksheet will assist you in understand your
accounts payables and the timeliness of making payments.

Note: Enter data into cells beneath columns that contain comments
(red triangle in upper right corner of cell).

Steps for Preparation:
Step 1: Enter your Company Name and the Date all figures are
reported as of in the report header.

Step 2: For each unpaid invoice, enter the Invoice Number, Invoice
Date (as MM/DD/YYYY), Invoice Amount and Vendor Name in the
respective columns.

Step 3: Enter the Vendor Payment Terms (as number of days) in the
next column.

Note: Amounts in the Due Date, Current Amount, Past Due and
Total Due columns will automatically populate with values based
on the imbedded formulas. The formulas will also determine the
duration a balance is past due and place a figure in the correct
column based on the vendor payment terms.

Step 4: If additional rows are required in order to input all of
your invoices, click on the Column A cell under the last Invoice
Number entered and right click your mouse, click Insert, select
Entire Row and click OK (repeat as many times as necessary in
order to add multiple rows). Then copy the Due Date through Total
Due columns' formulas (Column F through Column L) into the newly
inserted rows by selecting a previously existing single row's
Column F through Column L cells and clicking the right mouse
button and selecting Copy and then highlighting the Column F
through Column L cells for the rows just added, then right clicking
the mouse again and selecting Paste (be sure the mouse pointer is
located on the highlighted range). Repeat as necessary.
                                                              Accounts Payable Aging Detail
Southern Printing, LLC
Reported as of         8/11/2014

      INVOICE        INVOICE       INVOICE                              VENDOR PMT      DUE                                      PAST DUE
     NUMBER            DATE        AMOUNT    VENDOR                     TERMS (days)    DATE       CURRENT      1 - 30     31 - 60      61 - 90    91 AND OVER TOTAL DUE
TR184490              3/31/2014 $5,014.20    Bradley Lumber, LLC                   15   4/15/2014                                                    $5,014.20    $5,014.20
22398                 6/30/2014    $655.34   F. R. Appliances                      30   7/30/2014                $655.34                                            $655.34
444-5913              7/15/2014 $1,230.00    Lane Flooring Inc.                    20    8/4/2014              $1,230.00                                          $1,230.00
23-FR-399             5/21/2014     $34.21   Mary's Cleaners                       30   6/20/2014                            $34.21                                  $34.21
892                    6/1/2014    $230.00   RDF Plumbing                          60   7/31/2014               $230.00                                             $230.00
SNT001                7/30/2014 $15,961.99   South Colfax Supply Inc.              15   8/14/2014 $15,961.99                                                     $15,961.99
33992                 7/20/2014 $1,877.00    Tri State Legal LLP                   45    9/3/2014  $1,877.00                                                      $1,877.00
1-330T                 8/3/2014    $240.00   Westerly Advertising                  30    9/2/2014    $240.00                                                        $240.00
Invoice 9 …                                                                                                                                                           $0.00
Invoice 10 …                                                                                                                                                          $0.00
Invoice 11 …                                                                                                                                                          $0.00
Invoice 12 …                                                                                                                                                          $0.00
Invoice 13 …                                                                                                                                                          $0.00
Invoice 14 …                                                                                                                                                          $0.00
Invoice 15 …                                                                                                                                                          $0.00
Invoice 16 …                                                                                                                                                          $0.00
Invoice 17 …                                                                                                                                                          $0.00
Invoice 18 …                                                                                                                                                          $0.00
Invoice 19 …                                                                                                                                                          $0.00
Invoice 20 …                                                                                                                                                          $0.00
Invoice 21 …                                                                                                                                                          $0.00
Invoice 22 …                                                                                                                                                          $0.00
Invoice 23 …                                                                                                                                                          $0.00
Invoice 24 …                                                                                                                                                          $0.00
Invoice 25 …                                                                                                                                                          $0.00
Invoice 26 …                                                                                                                                                          $0.00
Invoice 27 …                                                                                                                                                          $0.00
Invoice 28 …                                                                                                                                                          $0.00
Invoice 29 …                                                                                                                                                          $0.00
Invoice 30 …                                                                                                                                                          $0.00
Invoice 31 …                                                                                                                                                          $0.00
Invoice 32 …                                                                                                                                                          $0.00
Invoice 33 …                                                                                                                                                          $0.00
Invoice 34 …                                                                                                                                                          $0.00
Invoice 35 …                                                                                                                                                          $0.00
Invoice 36 …                                                                                                                                                          $0.00
Invoice 37 …                                                                                                                                                          $0.00
Invoice 38 …                                                                                                                                                          $0.00
Invoice 39 …                                                                                                                                                          $0.00
Invoice 40 …                                                                                                                                                          $0.00
TOTALS                                                                                            $18,078.99   $2,115.34     $34.21        $0.00     $5,014.20   $25,242.74
TIP: Sheet 2 (Example) Has a
filled out example

TIP: Hover over column titles
for more instructions



Notes on Preparation:
Note: You may want to print this information to use as reference
later. To delete these instructions, click the border of this text box
and then press the DELETE key.

Note: Managing a business's accounts payables is a vital step in
ensuring vendors are being paid properly so as to ensure there are
no disruptions to the supply of goods and services. Our Accounts
Payable Aging Detail worksheet will assist you in understand your
accounts payables and the timeliness of making payments.

Note: Enter data into cells beneath columns that contain comments
(red triangle in upper right corner of cell).

Steps for Preparation:
Step 1: Enter your Company Name and the Date all figures are
reported as of in the report header.

Step 2: For each unpaid invoice, enter the Invoice Number, Invoice
Date (as MM/DD/YYYY), Invoice Amount and Vendor Name in the
respective columns.

Step 3: Enter the Vendor Payment Terms (as number of days) in the
next column.

Note: Amounts in the Due Date, Current Amount, Past Due and
Total Due columns will automatically populate with values based
on the imbedded formulas. The formulas will also determine the
duration a balance is past due and place a figure in the correct
column based on the vendor payment terms.

Step 4: If additional rows are required in order to input all of
your invoices, click on the Column A cell under the last Invoice
Number entered and right click your mouse, click Insert, select
Entire Row and click OK (repeat as many times as necessary in
order to add multiple rows). Then copy the Due Date through Total
Due columns' formulas (Column F through Column L) into the newly
inserted rows by selecting a previously existing single row's
Column F through Column L cells and clicking the right mouse
button and selecting Copy and then highlighting the Column F
through Column L cells for the rows just added, then right clicking
the mouse again and selecting Paste (be sure the mouse pointer is
located on the highlighted range). Repeat as necessary.
				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:18
posted:8/18/2014
language:English
pages:4
Description: Managing a business's accounts payables is a vital step in ensuring vendors are being paid properly so as to ensure there are no disruptions to the supply of goods and services. This Accounts Payable Aging Detail worksheet will assist you in understanding your accounts payables and the timeliness of making payments. Each cell includes instructions what information should be inserted. These instructions can be seen by hovering over each cell and the instructions can be deleted by left clicking on the cell and clicking “Delete Comment”. In addition the second sheet of this worksheet includes a filled out sample that provides further guidance and clarity. This worksheet is ideal for small businesses or other entities that want to keep track of the money the owe vendors and suppliers in an organized manner.