Accounts Receivable Collections Tracker

Document Sample
Accounts Receivable Collections Tracker Powered By Docstoc
					Accounts Receivable Collections Tracker
Contents 1.1 Assumptions Goto A10 2.1 Collections Data Goto A21 3.1 Instructions Goto A71
------------- ------------------------------------- ----------- --------------- ------------- ------------ --------------- -------------Sales Data Sheet 1.1 ------------- ------------------------------------- ----------- --------------- ------------- ------------ --------------- -------------Report For Month Of: Augest 2003 Net Total Cash Credit Sales Returns Sales Sales -------------------------Last Month $100,000 $1,000 $5,000 $94,000 Month Before Last 96,000 4,000 4,000 88,000

Collections Data (Continues to Row 66)

Sheet 2.1

------------- ------------------------------------- ----------- --------------- ------------- ------------ --------------- -------------Amount Collected ------------------------------------- ----------- --------------- -------Month Last Date ---9-1 -2 -3 -4 -5 -6 -7 -8 -9 -10 -11 -12 -13 -14 -15 -16 -17 -18 -19 -20 -21 -22 -23 -24 Month -----1,000 2,000 0 1,675 2,608 1,665 966 1,788 1,009 0 2,445 768 2,278 120 2,455 4,167 0 5,346 4,678 4,212 4,867 2,213 2,440 0 Last -------250 400 350 350 200 0 180 4
				
DOCUMENT INFO
Description: ACCOUNTS RECEIVABLE COLLECTIONS TRACKER is a Microsoft Excel model that can be downloaded immediately and used by putting your numbers in the appropriate cells. Calculations are automatic. Can be customized to fit your needs.|n||n|Click to
BUY THIS DOCUMENT NOW PRICE: $17.95 100% MONEY BACK GUARANTEED
PARTNER SmallBusinessForum
With access to close to 10,000 small business owners we are able to draw upon their collective wisdom and insights to develop new products to solve their most pressing needs. We also have a Consultant Advisory Board which consists of some of the leading consultants in the industry. We use this group as a sounding board to discuss current issues, challenges and product development ideas.