Docstoc

Schedule of Accounts Receivable

Document Sample
Schedule of Accounts Receivable Powered By Docstoc
					Invoice Instructions
Enter date in cell E2
Enter invoice number in E3
Enter terms (number of days before invoice is due) in cell E12
Complete invoice placing a "T" in column D if the item is taxable
Enter applicable sales tax rate in cell E31
Enter payments or deposits received in cell E33


Schedule of Accounts Receivable Instructions
Enter today's date in cell A1
All other items will populate from invoice
                                                                                                  INVOICE
Your Company Name                                                             DATE:         September 12, 2011
Your Company Slogan                                                           INVOICE #     100

                                                                              FOR:          Project or Service Description
Street Address
City, ST ZIP Code                                                             BILL TO:      Name
Phone:                                                                                      Company Name
Fax:                                                                                        Street Address
                                                                                            City, ST ZIP Code
                                                                                            Phone:
                                                                              Terms         30
DESCRIPTION                                                                           T                  AMOUNT

Sample                                                                                T      $                               25.00




                                                                              SUBTOTAL       $                               25.00

                                                                               TAX RATE                                      8.60%

Make all checks payable to Your Company Name. If you have any                 SALES TAX      $                                2.15
questions concerning this invoice, contact Name, Phone Number, Email
                                                                            Payment Rcv'd                                     5.00
THANK YOU FOR YOUR BUSINESS!                                                        TOTAL    $                               22.15


                                                     THANK YOU FOR YOUR BUSINESS!



    © Copyright 2011 Docstoc Inc.
                                                                                                  INVOICE
Your Company Name                                                             DATE:         October 1, 2011
Your Company Slogan                                                           INVOICE #     102

                                                                              FOR:          Project or Service Description
Street Address
City, ST ZIP Code                                                             BILL TO:      Name
Phone:                                                                                      Company Name
Fax:                                                                                        Street Address
                                                                                            City, ST ZIP Code
                                                                                            Phone:
                                                                              Terms         15
DESCRIPTION                                                                           T                  AMOUNT

Sample                                                                                       $                          4,000.00

Sample                                                                                       $                          2,500.00

Sample                                                                                       $                          5,000.00




                                                                              SUBTOTAL       $                        11,500.00

                                                                               TAX RATE                                      8.60%

Make all checks payable to Your Company Name. If you have any                 SALES TAX     $                                 -
questions concerning this invoice, contact Name, Phone Number, Email
                                                                            Payment Rcv'd                               5,000.00
THANK YOU FOR YOUR BUSINESS!                                                        TOTAL    $                          6,500.00


                                                     THANK YOU FOR YOUR BUSINESS!

    © Copyright 2011 Docstoc Inc.
                                THANK YOU FOR YOUR BUSINESS!




© Copyright 2011 Docstoc Inc.
                                                                                                  INVOICE
Your Company Name                                                             DATE:         October 20, 2011
Your Company Slogan                                                           INVOICE #     103

                                                                              FOR:          Project or Service Description
Street Address
City, ST ZIP Code                                                             BILL TO:      Name
Phone:                                                                                      Company Name
Fax:                                                                                        Street Address
                                                                                            City, ST ZIP Code
                                                                                            Phone:
                                                                              Terms         45
DESCRIPTION                                                                           T                  AMOUNT

Sample                                                                                T      $                          4,600.00

Sample                                                                                       $                          2,500.00

Sample                                                                                T      $                          1,000.00




                                                                              SUBTOTAL       $                          8,100.00

                                                                               TAX RATE                                      8.60%

Make all checks payable to Your Company Name. If you have any                 SALES TAX      $                           481.60
questions concerning this invoice, contact Name, Phone Number, Email
                                                                            Payment Rcv'd                                     -
THANK YOU FOR YOUR BUSINESS!                                                        TOTAL    $                          8,581.60


                                                     THANK YOU FOR YOUR BUSINESS!



    © Copyright 2011 Docstoc Inc.
   11/25/11           Type       Date        Num         P. O. #          Name    Terms    Due Date     Aging        Open Balance

              1   Invoice       09/12/2011         100             Company Name       30   10/12/2011       44                22.15
              2   Invoice       10/01/2011         102             Company Name       15   10/16/2011       40             6,500.00
              3   Invoice       10/20/2011         103             Company Name       45   12/04/2011           -9         8,581.60
              4   Invoice                                                                  01/00/1900    40872
              5   Invoice                                                                  01/00/1900    40872
              6   Invoice                                                                  01/00/1900    40872
              7   Invoice                                                                  01/00/1900    40872
              8   Invoice                                                                  01/00/1900    40872
              9   Invoice                                                                  01/00/1900    40872
              10 Invoice                                                                   01/00/1900    40872
              11 Invoice                                                                   01/00/1900    40872
              12 Invoice                                                                   01/00/1900    40872
              13 Invoice                                                                   01/00/1900    40872
              14 Invoice                                                                   01/00/1900    40872
              15 Invoice                                                                   01/00/1900    40872
                                                                                                                          15,103.75




© Copyright 2011 Docstoc Inc.
				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:452
posted:1/4/2012
language:English
pages:6
Description: This Schedule of Accounts Receivable is a template spreadsheet that can help companies track accounts receivables by pulling data from invoices. This document includes several sample invoices. Data from the invoices will automatically populate information in the schedule of accounts receivable worksheet. The worksheet calculates the due date, aging, and open balance for each invoice. This document also comes with instructions on how to populate the invoices and spreadsheet.