Spreadsheet: 866084d1713021242-need-to-fix-if-and-formula-for-windows-excel-365-mso-version-2308-sample
Sheet: Unapplied Cash and Application

Receipt Number (Include leading zeros) | [NAME] | Amount Available | Account Number | Apply to Invoice | Amt to Apply | Starting Invoice Balance | Amount to apply | Inv Balance | Account Number | Remaining Receipt Amount | Notes
021000022972159 | -11109.12 | -11109.12 | H-35580 | 10211194 | -11109.12 | 8395.68 | 8395.68 | 0 | H-61050 | -2713.440000000001 | Cleared Invoice 10211194 in full; remaining balance on OAC $(2,713.44)
021000022972159 | -11109.12 | -2713.440000000001 | H-35580 | 10220667 | -2713.440000000001 | 3867.25 | 2713.440000000001 | 1153.809999999999 | H-61050 | 0 | Cleared OAC 021000022972159 in full; remaining balance on invoice 10220667 $1,153.81
021000024014149 | -3937.5 | -3937.5 | H-35580 | 10220667 | -3937.5 | 1153.809999999999 | 1153.809999999999 | 0 | H-61050 | -2783.69 | Cleared Invoice 10220667 in full; remaining balance on OAC $(2,783.69)
021000024014149 | -3937.5 | -2783.690000000001 | H-35580 | 10222172 | -2783.690000000001 | 3355.92 | 2783.690000000001 | 572.2299999999996 | H-61050 | 0 | Cleared OAC 021000024014149 in full; remaining balance on invoice 10222172 $572.23
021000025019551 | -3819.5 | -3819.5 | H-35580 | 10222172 | -3819.5 | 572.2299999999996 | 572.2299999999996 | 0 | H-61050 | -3247.27 | Cleared Invoice 10222172 in full; remaining balance on OAC $(3,247.27)
021000025019551 | -3819.5 | -3247.27 | H-35580 | 10217670 | -3247.27 | 2387.42 | 2387.42 | 0 | H-61050 | -859.85 | Cleared Invoice 10217670 in full; remaining balance on OAC $(859.85)
021000025019551 | -3819.5 | -859.8500000000004 | H-35580 | 10222029 | -859.8500000000004 | 2443.2 | 859.8500000000004 | 1583.349999999999 | H-61050 | 0 | Cleared OAC 021000025019551 in full; remaining balance on invoice 10222029 $1,583.35
4000468562 | -2995.8 | -2995.8 | H-61050 | 10222029 | -2995.8 | 1583.349999999999 | 1583.349999999999 | 0 | H-61050 | -1412.45 | Cleared Invoice 10222029 in full; remaining balance on OAC $(1,412.45)
4000468562 | -2995.8 | -1412.450000000001 | H-61050 | 10193082 | -1412.450000000001 | 2213.79 | 1412.450000000001 | 801.3399999999992 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10193082 $801.34
021000025445048 | -2173.5 | -2173.5 | H-35580 | 10193082 | -2173.5 | 801.3399999999992 | 801.3399999999992 | 0 | H-61050 | -1372.16 | Cleared Invoice 10193082 in full; remaining balance on OAC $(1,372.16)
021000025445048 | -2173.5 | -1372.160000000001 | H-35580 | 10178753 | -1372.160000000001 | 2041.03 | 1372.160000000001 | 668.8699999999992 | H-61050 | 0 | Cleared OAC 021000025445048 in full; remaining balance on invoice 10178753 $668.87
4000468435 | -2006.07 | -2006.07 | H-61050 | 10178753 | -2006.07 | 668.8699999999992 | 668.8699999999992 | 0 | H-61050 | -1337.2 | Cleared Invoice 10178753 in full; remaining balance on OAC $(1,337.20)
4000468435 | -2006.07 | -1337.200000000001 | H-61050 | 10219791 | -1337.200000000001 | 1997.31 | 1337.200000000001 | 660.1099999999992 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10219791 $660.11
021000026231389 | -1985.52 | -1985.52 | H-35580 | 10219791 | -1985.52 | 660.1099999999992 | 660.1099999999992 | 0 | H-61050 | -1325.41 | Cleared Invoice 10219791 in full; remaining balance on OAC $(1,325.41)
021000026231389 | -1985.52 | -1325.410000000001 | H-35580 | 10220387 | -1325.410000000001 | 1851.22 | 1325.410000000001 | 525.8099999999993 | H-61050 | 0 | Cleared OAC 021000026231389 in full; remaining balance on invoice 10220387 $525.81
021000024875235 | -1876.14 | -1876.14 | H-35580 | 10220387 | -1876.14 | 525.8099999999993 | 525.8099999999993 | 0 | H-61050 | -1350.33 | Cleared Invoice 10220387 in full; remaining balance on OAC $(1,350.33)
021000024875235 | -1876.14 | -1350.330000000001 | H-35580 | 10218083 | -1350.330000000001 | 1925.1 | 1350.330000000001 | 574.7699999999991 | H-61050 | 0 | Cleared OAC 021000024875235 in full; remaining balance on invoice 10218083 $574.77
021000022807006 | -1830.96 | -1830.96 | H-35580 | 10218083 | -1830.96 | 574.7699999999991 | 574.7699999999991 | 0 | H-61050 | -1256.19 | Cleared Invoice 10218083 in full; remaining balance on OAC $(1,256.19)
021000022807006 | -1830.96 | -1256.190000000001 | H-35580 | 10220046 | -1256.190000000001 | 1626.42 | 1256.190000000001 | 370.2299999999991 | H-61050 | 0 | Cleared OAC 021000022807006 in full; remaining balance on invoice 10220046 $370.23
4000473821 | -1426.95 | -1426.95 | H-61050 | 10220046 | -1426.95 | 370.2299999999991 | 370.2299999999991 | 0 | H-61050 | -1056.72 | Cleared Invoice 10220046 in full; remaining balance on OAC $(1,056.72)
4000473821 | -1426.95 | -1056.720000000001 | H-61050 | 10220395 | -1056.720000000001 | 1051.19 | 1051.19 | 0 | H-61050 | -5.53 | Cleared Invoice 10220395 in full; remaining balance on OAC $(5.53)
4000473821 | -1426.95 | -5.530000000000882 | H-61050 | 10222015 | -5.530000000000882 | 966.06 | 5.530000000000882 | 960.5299999999991 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10222015 $960.53
021000024614136 | -1382.91 | -1382.91 | H-61050 | 10222015 | -1382.91 | 960.5299999999991 | 960.5299999999991 | 0 | H-61050 | -422.38 | Cleared Invoice 10222015 in full; remaining balance on OAC $(422.38)
021000024614136 | -1382.91 | -422.380000000001 | H-61050 | 10219473 | -422.380000000001 | 1101.12 | 422.380000000001 | 678.7399999999989 | H-61050 | 0 | Cleared OAC 021000024614136 in full; remaining balance on invoice 10219473 $678.74
021000025549583 | -1005.12 | -1005.12 | H-35580 | 10219473 | -1005.12 | 678.7399999999989 | 678.7399999999989 | 0 | H-61050 | -326.38 | Cleared Invoice 10219473 in full; remaining balance on OAC $(326.38)
021000025549583 | -1005.12 | -326.3800000000011 | H-35580 | 10219098 | -326.3800000000011 | 863.17 | 326.3800000000011 | 536.7899999999988 | H-61050 | 0 | Cleared OAC 021000025549583 in full; remaining balance on invoice 10219098 $536.79
021000029134233 | -885.79 | -885.79 | H-35580 | 10219098 | -885.79 | 536.7899999999988 | 536.7899999999988 | 0 | H-61050 | -349 | Cleared Invoice 10219098 in full; remaining balance on OAC $(349.00)
021000029134233 | -885.79 | -349.0000000000011 | H-35580 | 10217895 | -349.0000000000011 | 842.06 | 349.0000000000011 | 493.0599999999988 | H-35570 | 0 | Cleared OAC 021000029134233 in full; remaining balance on invoice 10217895 $493.06
4000468061 | -884.16 | -884.16 | H-61050 | 10217895 | -884.16 | 493.0599999999988 | 493.0599999999988 | 0 | H-35570 | -391.1 | Cleared Invoice 10217895 in full; remaining balance on OAC $(391.10)
4000468061 | -884.16 | -391.1000000000012 | H-61050 | 10218816 | -391.1000000000012 | 574.39 | 391.1000000000012 | 183.2899999999988 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10218816 $183.29
4000468364 | -838.56 | -838.56 | H-61050 | 10218816 | -838.56 | 183.2899999999988 | 183.2899999999988 | 0 | H-61050 | -655.27 | Cleared Invoice 10218816 in full; remaining balance on OAC $(655.27)
4000468364 | -838.56 | -655.2700000000011 | H-61050 | 10180222 | -655.2700000000011 | 551.09 | 551.09 | 0 | H-61050 | -104.18 | Cleared Invoice 10180222 in full; remaining balance on OAC $(104.18)
4000468364 | -838.56 | -104.1800000000011 | H-61050 | 10220055 | -104.1800000000011 | 476.41 | 104.1800000000011 | 372.2299999999989 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10220055 $372.23
4000472358 | -773.45 | -773.45 | H-61050 | 10220055 | -773.45 | 372.2299999999989 | 372.2299999999989 | 0 | H-61050 | -401.22 | Cleared Invoice 10220055 in full; remaining balance on OAC $(401.22)
4000472358 | -773.45 | -401.2200000000011 | H-61050 | 10221851 | -401.2200000000011 | 470.98 | 401.2200000000011 | 69.75999999999891 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10221851 $69.76
4000473770 | -773.45 | -773.45 | H-61050 | 10221851 | -773.45 | 69.75999999999891 | 69.75999999999891 | 0 | H-61050 | -703.69 | Cleared Invoice 10221851 in full; remaining balance on OAC $(703.69)
4000473770 | -773.45 | -703.6900000000012 | H-61050 | 10218815 | -703.6900000000012 | 368.1 | 368.1 | 0 | H-61050 | -335.59 | Cleared Invoice 10218815 in full; remaining balance on OAC $(335.59)
4000473770 | -773.45 | -335.5900000000012 | H-61050 | 10222174 | -335.5900000000012 | 309.38 | 309.38 | 0 | H-61050 | -26.21 | Cleared Invoice 10222174 in full; remaining balance on OAC $(26.21)
4000473770 | -773.45 | -26.21000000000117 | H-61050 | 10220134 | -26.21000000000117 | 277.2 | 26.21000000000117 | 250.9899999999988 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10220134 $250.99
4000468110 | -691.27 | -691.27 | H-61050 | 10220134 | -691.27 | 250.9899999999988 | 250.9899999999988 | 0 | H-61050 | -440.28 | Cleared Invoice 10220134 in full; remaining balance on OAC $(440.28)
4000468110 | -691.27 | -440.2800000000012 | H-61050 | 10190852 | -440.2800000000012 | 299.24 | 299.24 | 0 | H-61050 | -141.04 | Cleared Invoice 10190852 in full; remaining balance on OAC $(141.04)
4000468110 | -691.27 | -141.0400000000012 | H-61050 | 10222001 | -141.0400000000012 | 261 | 141.0400000000012 | 119.9599999999988 | H-61050 | 0 | Cleared OAC [PHONE] in full; remaining balance on invoice 10222001 $119.96
021000029999063 | -683.28 | -683.28 | H-35580 | 10222001 | -683.28 | 119.9599999999988 | 119.9599999999988 | 0 | H-61050 | -563.32 | Cleared Invoice 10222001 in full; remaining balance on OAC $(563.32)
021000029999063 | -683.28 | -563.3200000000011 | H-35580 | 10178198 | -563.3200000000011 | 259.2 | 259.2 | 0 | H-61050 | -304.12 | Cleared Invoice 10178198 in full; remaining balance on OAC $(304.12)
021000029999063 | -683.28 | -304.1200000000011 | H-35580 | 10217832 | -304.1200000000011 | 154.92 | 154.92 | 0 | H-61050 | -149.2 | Cleared Invoice 10217832 in full; remaining balance on OAC $(149.20)
021000029999063 | -683.28 | -149.2000000000011 | H-35580 | 10220139 | -149.2000000000011 | 82.29 | 82.29 | 0 | H-61050 | -66.91 | Cleared Invoice 10220139 in full; remaining balance on OAC $(66.91)
021000029999063 | -683.28 | -66.91000000000109 | H-35580 | 10221224 | -66.91000000000109 | 68.8 | 66.91000000000109 | 1.889999999998906 | H-61050 | 0 | Cleared OAC 021000029999063 in full; remaining balance on invoice 10221224 $1.89
21000026105147 | -525 | -525 | H-35580 | 10221224 | -525 | 1.889999999998906 | 1.889999999998906 | 0 | H-61050 | -523.11 | Cleared Invoice 10221224 in full; remaining balance on OAC $(523.11)
 | #N/A | -523.110000000001 | #N/A |  | -523.110000000001 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A