Docstoc

Accounts Receivable Aging Detail

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

      INVOICE        INVOICE      UNPAID                        CUSTOMER PMT    DUE                                PAST DUE
     NUMBER            DATE      AMOUNT    CUSTOMER              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 receivable is a vital step in
ensuring cash is collected in a timely manner so as to support
sufficient cash flows. Our Accounts Receivable Aging Detail
worksheet will assist you in understanding your accounts
receivables and the timeliness of your cash collections .

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 Customer Name in the
respective columns.

Step 3: Enter the Customer 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 customer 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 Receivable Aging Detail
Thompsen Auto Repair
Reported as of      8/11/2014

      INVOICE      INVOICE       UNPAID                             CUSTOMER PMT    DUE                                        PAST DUE
     NUMBER          DATE       AMOUNT       CUSTOMER                TERMS (days)   DATE       CURRENT       1 - 30      31 - 60      61 - 90    91 AND OVER TOTAL DUE
TAR-002356          5/30/2014   $15,466.20   Bob Roberts                       30   6/29/2014                           $15,466.20                           $15,466.20
TAR-002359          5/30/2014   $26,098.40   Danielle Chambers                 30   6/29/2014                           $26,098.40                           $26,098.40
TAR-002368           7/7/2014   $31,912.40   Cory Left                         45   8/21/2014 $31,912.40                                                     $31,912.40
TAR-002369           7/7/2014   $18,312.99   Justin Andrews                    30    8/6/2014              $18,312.99                                        $18,312.99
TAR-002389          7/10/2014   $16,333.78   North West Salvage                20   7/30/2014              $16,333.78                                        $16,333.78
TAR-002390          7/10/2014    $5,489.30   Ronald White                      30    8/9/2014               $5,489.30                                         $5,489.30
TAR-002396          7/11/2014   $25,132.67   Corner Pizza                      60    9/9/2014 $25,132.67                                                     $25,132.67
TAR-002399          7/11/2014   $12,444.12   TC Plumbing                       15   7/26/2014              $12,444.12                                        $12,444.12
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                                                                                        $57,045.07   $52,580.19   $41,564.60       $0.00        $0.00 $151,189.86
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 receivable is a vital step in
ensuring cash is collected in a timely manner so as to support
sufficient cash flows. Our Accounts Receivable Aging Detail
worksheet will assist you in understanding your accounts
receivables and the timeliness of your cash collections .

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 Customer Name in the
respective columns.

Step 3: Enter the Customer 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 customer 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:13
posted:8/18/2014
language:English
pages:4
Description: Managing a business's accounts receivable is a vital step in ensuring cash is collected in a timely manner so as to support sufficient cash flows. This Accounts Receivable Aging Detail worksheet will assist you in understanding your accounts receivables and the timeliness of your cash collections. 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 they are owed in an organized manner.