Accounts Receivable Collections Tracker by SmallBusinessForum

VIEWS: 957 PAGES: 2

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

More Info
									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
								
To top