Invoice | Cash | Balance | 100,000 | 200,000 | 300,000 | 400,000 | 400,001 | | Total | | 55,000 | | 55,000 | 55,000 | 0 | 0 | | | | 55,000 | 0 | 125,000 | | 125,000 | 100,000 | 25,000 | 0 | | | | 125,000 | 0 | 185,000 | | 185,000 | 100,000 | 85,000 | 0 | | | | 185,000 | 0 | 250,000 | | 250,000 | 100,000 | 100,000 | 50,000 | | | | 250,000 | 0 | 335,000 | | 335,000 | 100,000 | 100,000 | 100,000 | 35,000 | | | 335,000 | 0 | 425,000 | | 425,000 | 100,000 | 100,000 | 100,000 | 100,000 | 25,000 | | 425,000 | 0 | 550,000 | | 550,000 | 100,000 | 100,000 | 100,000 | 100,000 | 150,000 | | 550,000 | 0 | | | | | | | | | | | | 55,000 | | 55,000 | 55,000 | 0 | 0 | 0 | 0 | | 55,000 | 0 | 125,000 | (55,000) | 70,000 | 45,000 | 25,000 | 0 | 0 | 0 | | 70,000 | 0 | 185,000 | (125,000) | 60,000 | 0 | 60,000 | 0 | 0 | 0 | | 60,000 | 0 | 250,000 | (185,000) | 65,000 | 0 | 15,000 | 50,000 | 0 | 0 | | 65,000 | 0 | 335,000 | (250,000) | 85,000 | 0 | 0 | 50,000 | 35,000 | 0 | | 85,000 | 0 | 425,000 | (335,000) | 90,000 | 0 | 0 | 0 | 65,000 | 25,000 | | 90,000 | 0 | 550,000 | (425,000) | 125,000 | 0 | 0 | 0 | 0 | 125,000 | | 125,000 | 0 | | | | | | | | | | | | | | | 如何設置公式?? | | | | | | |
|