0 0

Schedule of Accounts Receivable

ABOUT THIS DOCUMENT

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.

Reads: 350 times
Used: 1 times
Pages: 6
Size: 56 kb
Format: Excel Spreadsheet

Text Version

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:
Sign-up for Docstoc Premium
Registration enables you to experience on site recommendations of documents, articles, packages and courses as well as recommendation emails for the content we think you'll love the most
Already a member?
Don't have a Facebook account?
Register with E-mail

Enter a valid email address (xxx@xxx.com)
Preloader
By registering with docstoc.com you agree to
our privacy policy and terms of service
Sign-in
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Forgot Password?
Complete Access to Over 20 Million Professional Documents Including Premium Legal Contracts & Business Forms
Hundreds of Hours of Online Courses & Video Tutorials
24/7 Premium Customer Support
No Cost - No Obligation - No Risk
Use your email and password to sign-in here.
Click forgot your password if you need help.
Need to register?
Don't have a Facebook account?
Login with your Docstoc account.


Email or Username

Preloader

1. Please rate your experience on the following scale:


2. Would you recommend Docstoc to a friend?


Submit

Would you be interested in taking a longer survey for a chance to win a 1-month free subscription to Docstoc Premium?