Outstanding Report Excel 2003
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Outstanding Report Excel 2003 as PDF for free.
More details
- Words: 516
- Pages: 6
YOUR COMPANY NAME -UNLOCK WITH 54321 OUT STANDING REPORT 10 May 2009 , Sunday , 10:27 AM SL
CLIENT'S NAME
1 EXAMPLE 2 EXAMPLE
PHONE /FAX
12345
DEPARTMENT
FOR
FOR UNLOCK
THESE CELLS
OPENING BALANCE INV NO
INV DATE
12345 01.01.09
DATE SUBMT
01.01.09 01.01.09
AMOUNT
1,500.00 1,000.00
DUE PERIOD
30 45
RECEIVED
1,000.00
DATE
BALANCE
31.01.09
DUE DATE
500.00 1,000.00
DAYS
31/01/2009 15/02/2009
129 129
3 4 5 6 7
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0
8
-
30/12/1899
0
9
-
30/12/1899
0
10
-
30/12/1899
0
11 12 13 14 15 16
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0
-
30/12/1899 30/12/1899
0 0
19 20 21
-
30/12/1899 30/12/1899 30/12/1899
0 0 0
22 23
-
30/12/1899 30/12/1899
0 0
24
-
30/12/1899
0
25 26 27
-
30/12/1899 30/12/1899 30/12/1899
0 0 0
28 29 30 31 32 33 34 35 36
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0 0 0
17 18
Unlock This Sheet With My Mob.No +966555129805
37
-
30/12/1899
0
38 39 40
-
30/12/1899 30/12/1899 30/12/1899
0 0 0
41 42
-
30/12/1899 30/12/1899
0 0
43 44
-
30/12/1899 30/12/1899
0 0
45 46
-
30/12/1899 30/12/1899
0 0
47 48
-
30/12/1899 30/12/1899
0 0
49 50 51 52 53 54 55 56
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0 0
57
-
30/12/1899
0
58 59
-
30/12/1899 30/12/1899
0 0
60
-
30/12/1899
0
61
-
30/12/1899
0
62
-
30/12/1899
0
63
-
30/12/1899
0
64
-
30/12/1899
0
65
-
30/12/1899
0
66
-
30/12/1899
0
67
-
30/12/1899
0
68
-
30/12/1899
0
69
-
30/12/1899
0
70
-
30/12/1899
0
71
-
30/12/1899
0
72
-
30/12/1899
0
73
-
30/12/1899
0
74
-
30/12/1899
0
75 76 77 78 79 80 81
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0
82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
-
TOTAL
2,500.00
1,000.00
CLOSING BALANCE
1,500.00
1,500.00
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLECTED %
OD DAYS
99 84 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
40
CLIENT'S NAME
1 EXAMPLE 2 EXAMPLE
PHONE /FAX
12345
DEPARTMENT
FOR
FOR UNLOCK
THESE CELLS
OPENING BALANCE INV NO
INV DATE
12345 01.01.09
DATE SUBMT
01.01.09 01.01.09
AMOUNT
1,500.00 1,000.00
DUE PERIOD
30 45
RECEIVED
1,000.00
DATE
BALANCE
31.01.09
DUE DATE
500.00 1,000.00
DAYS
31/01/2009 15/02/2009
129 129
3 4 5 6 7
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0
8
-
30/12/1899
0
9
-
30/12/1899
0
10
-
30/12/1899
0
11 12 13 14 15 16
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0
-
30/12/1899 30/12/1899
0 0
19 20 21
-
30/12/1899 30/12/1899 30/12/1899
0 0 0
22 23
-
30/12/1899 30/12/1899
0 0
24
-
30/12/1899
0
25 26 27
-
30/12/1899 30/12/1899 30/12/1899
0 0 0
28 29 30 31 32 33 34 35 36
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0 0 0
17 18
Unlock This Sheet With My Mob.No +966555129805
37
-
30/12/1899
0
38 39 40
-
30/12/1899 30/12/1899 30/12/1899
0 0 0
41 42
-
30/12/1899 30/12/1899
0 0
43 44
-
30/12/1899 30/12/1899
0 0
45 46
-
30/12/1899 30/12/1899
0 0
47 48
-
30/12/1899 30/12/1899
0 0
49 50 51 52 53 54 55 56
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0 0
57
-
30/12/1899
0
58 59
-
30/12/1899 30/12/1899
0 0
60
-
30/12/1899
0
61
-
30/12/1899
0
62
-
30/12/1899
0
63
-
30/12/1899
0
64
-
30/12/1899
0
65
-
30/12/1899
0
66
-
30/12/1899
0
67
-
30/12/1899
0
68
-
30/12/1899
0
69
-
30/12/1899
0
70
-
30/12/1899
0
71
-
30/12/1899
0
72
-
30/12/1899
0
73
-
30/12/1899
0
74
-
30/12/1899
0
75 76 77 78 79 80 81
-
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0
82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100
-
TOTAL
2,500.00
1,000.00
CLOSING BALANCE
1,500.00
1,500.00
30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899 30/12/1899
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
COLLECTED %
OD DAYS
99 84 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
40
Related Documents
Outstanding Report Excel 2003
May 2020 8
Outstanding Report Excel 2007
May 2020 5
Outstanding Report
December 2019 15
Excel 2003
November 2019 23
Excel-2003
May 2020 20
Excel 2003
October 2019 31More Documents from ""
Cumulative Interest Calculation
May 2020 4
Outstanding Report Excel 2007
May 2020 5
Daily Cash Book
May 2020 3
Attendance Register
May 2020 6
Outstanding Report Excel 2003
May 2020 8