应收账款管理系统表

今天是:2020年9月28日【星期一】,应 收 账 款 总 览,2018-1-1~2020-9-30金额单位：元,序号客户名称上期应收余额本期应收本期已收期末余额备注,1.0客户11000.0938226.0978561.0-39335.0,2.0客户2500.01058061.81767471.0-708909.2,3.0客户319373.063069.0-42896.0,4.0客户4600.0148559.089800.059359.0,5.0客户5500.01990.018300.0-15810.0,6.0客户621150.021150.0,7.0客户7600.00.018020.0-17420.0,合计4800.02187359.82956371.0-764211.2,,客户对账单,Customer statement,客户名称：客户1起始日期:43101.0截止日期:44104.0,期初应收款:本期应收款:938226.0本期已收款:978561.0,本期剩余应收款:累计剩余应收款:,日期单号送货地址车牌号码品名数量单价应收金额收款金额总欠款备注,上期结转,43102.0496.05952.06952.0,43103.03310.023170.030122.0,43108.0107.0749.030871.0,43111.01120.08400.039271.0,43111.0-60729.0,43112.0580.04060.0-56669.0,43113.06170.046275.0-10394.0,43121.070.0490.0-9904.0,43124.0116.0870.0-9034.0,43130.0336.02520.0,1月92486.0,1月92486.0,43133.0400.02800.0-3714.0,43141.018020.0,2月2800.018020.0,2月95286.0118020.0,43165.02130.05.010650.0-32384.0,43165.012630.02.531575.0-63959.0,43166.07940.02.519850.0-83809.0,43166.01260.09395.0-74414.0,43167.01160.08700.0-65714.0,43173.04500.08.839600.0-26114.0,43176.070000.0-96114.0,43181.030000.0-126114.0,43185.0390.02925.0-123189.0,43188.0700.08400.0-114789.0,43190.01390.010425.0,3月79445.0162075.0,3月174731.0280095.0,43192.01330.09975.0-94389.0,43198.02680.020100.0-74289.0,43201.0131.0982.5-73306.5,43209.01090.08175.0-65131.5,43212.07500.0-57631.5,43217.040000.0,4月46732.540000.0,4月221463.5320095.0,43227.0720.05400.0-92231.5,43227.010110.02.222242.0-114473.5,43228.01230.09225.0-105248.5,43229.0930.011160.0-94088.5,43233.01450.010875.0-83213.5,43233.0920.011040.0-72173.5,43235.010990.05495.0-66678.5,43236.0650.04875.0-61803.5,43241.0580.04350.0-57453.5,43244.01090.08175.0-49278.5,43244.07000.052500.03221.5,-6778.5,300.0-7078.5,300.0-7378.5,43251.0195650.011739.0,5月123095.044581.0,5月344558.5364676.0,43255.01720.012900.0-6217.5,43263.0270.02025.0-4192.5,43263.040.0280.0-3912.5,43266.0-103912.5,43267.0550.04125.0-99787.5,43271.01450.010875.0-88912.5,43273.01080.08100.0-80812.5,43273.010050.05025.0-75787.5,43276.024.0180.0-75607.5,43277.01354.016248.0-59359.5,43277.0520.03900.0,6月63658.0,6月408216.5464676.0,43286.0-55659.5,43290.0140.01050.0-54609.5,43294.02520.018900.0-35709.5,43296.038.0285.0-35424.5,43296.02840.034080.0-1344.5,43297.097.0679.0-665.5,43297.0353.04236.03570.5,43306.0150000.09000.012570.5,43307.0326.02445.015015.5,43309.030000.0-14984.5,43311.01110.08325.0-6659.5,43312.02120.015900.0,7月94900.030200.0,7月503116.5494876.0,43313.04530.033975.043215.5,43317.06830.03415.046630.5,43318.0890.06675.053305.5,43321.0420.03150.056455.5,43325.0702.04563.061018.5,43327.01064.07980.068998.5,43329.018998.5,43330.038.0285.018713.5,43332.010050.05025.023738.5,43332.0-26261.5,43334.01739.013043.0-13218.5,43340.011430.02.629718.0-42936.5,43342.01400.016800.0-26136.5,43342.01140.08550.0-17586.5,450.03375.0-14211.5,1160.06.06960.0-7251.5,780.05.03900.0,8月113511.0133903.0,8月616627.5628779.0,43346.0375.02812.5-8339.0,43352.0225.09.282088.0-6251.0,43354.0400.03000.0-3251.0,43358.0669.05018.01767.0,43358.01700.012750.014517.0,43361.01190.08925.023442.0,43361.09810.04905.028347.0,43366.028147.0,43368.030.0210.028357.0,43369.0820.06150.034507.0,43369.0236.01770.036277.0,43372.0200000.012000.0,9月59628.5,9月676256.0628979.0,840.05460.053737.0,320.02400.056137.0,670.04355.060492.0,43377.0710.04615.065107.0,43384.0-34893.0,1660.012450.0-22443.0,6490.03245.0-19198.0,1017.07628.0-11570.0,43386.01.0-21570.0,43391.01227.09203.0-12367.0,43395.01010.012120.0,10月61476.0110000.0,10月737732.0738979.0,43412.0-50247.0,43417.01800.0-52047.0,43419.0790.05925.0-46122.0,43423.0290.02175.0-43947.0,1359.010193.0-33754.0,2009.015068.0-18686.0,420.03150.0-15536.0,43425.0-65536.0,43434.012060.02.226532.0,11月36511.0128332.0,11月774243.0867311.0,43438.01389.012.517363.0-74705.0,43439.0-74905.0,43439.0-174905.0,43451.0270.02025.0-172880.0,43457.05100.033150.0-139730.0,43457.06370.03185.0-136545.0,43458.011440.085800.0-50745.0,43459.01200.09000.0-41745.0,43461.01300.08.511050.0-52795.0,43464.01458.010935.0-41860.0,43464.0202.012.52525.0,12月163983.0111250.0,12月938226.0978561.0,品名,商品1,商品2,序号往来单位地址联系人联系方式期初欠款,1.0客户1北京吴厂长1111.01000.0,2.0客户2上海龙厂长2222.0500.0,3.0客户3天津李经理3333.0800.0,4.0客户4河北张工4444.0600.0,5.0客户5河南赵总5555.0500.0,6.0客户6海南张总6666.0800.0,7.0客户7浙江马会计7777.0600.0,使用说明:,1、《商品信息》《客户信息》录入对应资料。2、《业务录入》日期，客户,商品双击选择，其他手录。3、《客户总览》点击查询按钮，选择起止日期，自动生成统计报表。4、《客户对账》点击查询按钮，选择起止日期和客户，自动生成明细记录报表。5、《记录查询》录入检索条件,点击查询按钮，自动生成明细记录。,查询结果→→合 计776638.0938226.0978561.0,查询条件↓↓日期客户名称单号送货地址车牌号码品名数量单价金额收款备注,开始日期43102.0496.05952.0,结束日期43103.03310.023170.0,客户名称43108.0107.0749.0,43111.01120.08400.0,43111.0,43112.0580.04060.0,43113.06170.046275.0,43121.070.0490.0,43124.0116.0870.0,43130.0336.02520.0,43133.0400.02800.0,43141.018020.0,43165.02130.05.010650.0,43165.012630.02.531575.0,43166.07940.02.519850.0,43167.01160.08700.0,43166.01260.09395.0,43173.04500.08.839600.0,43176.070000.0,43181.030000.0,43185.0390.02925.0,43188.0700.08400.0,43190.01390.010425.0,43192.01330.09975.0,43198.02680.020100.0,43201.0131.0982.5,43209.01090.08175.0,43212.01000.07500.0,43217.040000.0,43227.0720.05400.0,43228.01230.09225.0,43227.010110.02.222242.0,43229.0930.011160.0,43233.01450.010875.0,43233.0920.011040.0,43236.0650.04875.0,43235.010990.05495.0,43241.0580.04350.0,43244.01090.08175.0,43244.07000.052500.0,300.0,300.0,43251.0195650.011739.0,43255.01720.012900.0,43263.0270.02025.0,43263.040.0280.0,43266.0,43267.0550.04125.0,43271.01450.010875.0,43273.01080.08100.0,43273.010050.05025.0,43276.024.0180.0,43277.01354.016248.0,43277.0520.03900.0,43286.0,43290.0140.01050.0,43294.02520.018900.0,43296.038.0285.0,43296.02840.034080.0,43297.097.0679.0,43297.0353.04236.0,43306.0150000.09000.0,43307.0326.02445.0,43309.030000.0,43311.01110.08325.0,43312.02120.015900.0,43313.04530.033975.0,43317.06830.03415.0,43318.0890.06675.0,43321.0420.03150.0,43325.0702.04563.0,43327.01064.07980.0,43329.0,43330.038.0285.0,43332.010050.05025.0,43332.0,43334.01739.013043.0,43340.011430.02.629718.0,43342.01400.016800.0,43342.01140.08550.0,450.03375.0,1160.06.06960.0,780.05.03900.0,43346.0375.02812.5,43352.0225.09.282088.0,43354.0400.03000.0,43358.0669.05018.0,43358.01700.012750.0,43361.01190.08925.0,43361.09810.04905.0,43366.0,43368.030.0210.0,43369.0820.06150.0,43369.0236.01770.0,43372.0200000.012000.0,840.05460.0,320.02400.0,670.04355.0,43377.0710.04615.0,43384.0,1660.012450.0,6490.03245.0,1017.07628.0,43386.01.0,43391.01227.09203.0,43395.01010.012120.0,43412.0,43417.01800.0,43419.0790.05925.0,43423.0290.02175.0,1359.010193.0,2009.015068.0,420.03150.0,43425.0,43434.012060.02.226532.0,43438.01389.012.517363.0,43439.0,43439.0,43451.0270.02025.0,43457.05100.033150.0,43457.06370.03185.0,43458.011440.085800.0,43459.01200.09000.0,43461.01300.08.511050.0,43464.01458.010935.0,43464.0202.012.52525.0,日期客户名称送货单号送货地址车牌号码品名数量单价金额收款备注,43102.0496.05952.0,43103.03310.023170.0,107.0749.0,360.02700.0,3500.0,236.01770.0,43111.01120.08400.0,43111.0,43112.0580.04060.0,43113.06170.046275.0,43121.070.0490.0,43123.0,43124.0116.0870.0,43127.0240.0,43127.0465.0,928.06960.0,13.015.0205.0,440.03080.0,336.02520.0,43133.0400.02800.0,43136.04982.037365.0,43136.06568.049260.0,43138.046095.0,43138.012960.0,43141.018020.0,43165.02130.010650.0,43165.012630.031575.0,43166.07940.019850.0,43167.01170.08775.0,43167.01160.08700.0,43166.01260.09395.0,43173.08.839600.0,70000.0,2421.018157.5,2576.019320.0,2118.015885.0,10413.078097.5,43178.01506.011295.0,43178.03200.024000.0,43181.030000.0,43180.0520.0,43185.0390.02925.0,43188.08400.0,43190.01390.010425.0,43191.0614.04605.0,43191.010120.022264.0,43192.01330.09975.0,43198.02680.020100.0,43201.0130.0260.0,43201.0131.0982.5,43209.01090.08175.0,43212.01000.07500.0,43214.014310.0107325.0,43215.04836.036270.0,43215.0382.02865.0,43217.040000.0,720.05400.0,9060.0,43228.01230.09225.0,10110.022242.0,257.01927.5,43229.0930.011160.0,43233.01450.010875.0,43233.0920.011040.0,43236.0650.04875.0,43236.01661.09.014949.0,43235.010990.05495.0,客户5河南18300.0,436.03270.0,580.04350.0,18630.027389.0,1490.0,640000.0,1090.08175.0,70000.0,7000.052500.0,43234.01564.011730.0,43248.07950.015900.0,300.0,300.0,43249.03570.03.010710.0,43249.0855.04275.0,43251.0195650.011739.0,43252.0310.02325.0,1068.012816.0,1720.012900.0,3920.029400.0,43261.0126.0945.0,43263.0270.02025.0,43263.040.0280.0,43266.0,43267.0550.04125.0,43271.01450.010875.0,43271.0250.01750.0,43273.01080.08100.0,43273.010050.05025.0,43276.024.0180.0,43277.01354.016248.0,43277.0520.0,178.51250.0,5251.039382.5,922.06915.0,43281.0206328.0,43283.04648.034860.0,43286.0,43286.01190.0,43290.0140.01050.0,43294.02520.018900.0,43296.038.0285.0,43296.02840.034080.0,43297.097.0679.0,43297.0353.04236.0,43300.01614.012105.0,43300.0323.02422.5,43301.0710.08520.0,43301.01259.08813.0,43302.063.0472.5,43305.0200000.0,43304.0432.03024.0,43304.0180.05.5990.0,43306.0150000.09000.0,43307.0326.02445.0,43309.030000.0,43311.01110.08325.0,43312.02120.015900.0,43313.033975.0,43317.06830.03415.0,43318.0890.06675.0,43319.01920.014400.0,43320.0530.03975.0,43320.0500.0500.0,43321.0420.03150.0,43325.0702.04563.0,43327.01064.07980.0,43329.03890.029175.0,43329.0,43330.038.0285.0,43332.010050.05025.0,43332.0,43333.01600.012000.0,43333.03590.026925.0,43334.01739.013043.0,43334.018.0116.672100.0,43336.0,3620.027150.0,82.0615.0,1490.017880.0,1317.06585.0,650.01625.0,43340.011430.02.629718.0,43342.01400.016800.0,43342.01140.08550.0,450.03375.0,1160.06.06960.0,600.0,780.0,43346.0375.02812.5,43350.03104.023280.0,43352.0225.09.282088.0,43354.0400.03000.0,43358.0669.05018.0,43358.01700.012750.0,43361.01190.08925.0,43361.09810.04905.0,43366.0,43368.030.0210.0,43368.01062.07965.0,43369.0820.06150.0,43369.0236.01770.0,43371.08190.02.419656.0,43372.0200000.012000.0,43373.01550.011.517825.0,43373.0750.0,840.05460.0,320.02400.0,670.04355.0,43377.0710.04615.0,43383.01310.09825.0,43384.0,1660.012450.0,6490.03245.0,1017.07628.0,43386.0,43391.01227.09203.0,43395.01010.012120.0,43402.01470.018375.0,43402.018375.0,5427.044501.4,2185.017917.0,792.06494.4,8399.068872.0,43406.0,43410.0254000.0254000.0,43412.0,43412.0,43417.06.0185.01110.0,43417.01800.0,43418.01512.012398.0,924.07577.0,1515.012423.0,2861.023460.0,790.05925.0,5440.044608.0,4180.034276.0,1134.59303.0,2664.021845.0,43423.04130.02.49912.0,43423.0290.02175.0,1359.010193.0,2009.015068.0,420.03150.0,1000.02000.0,846.010152.0,43434.012060.026532.0,43437.03570.029274.0,43437.01896.07.8514893.0,43438.01389.017363.0,43439.0,43439.0,43444.0566.04641.0,43450.0370.02775.0,2775.0,43451.0270.02025.0,0.41812.0,43453.0客户5河南260.07.651990.0,43455.0470.05875.0,43455.02378.019500.0,43457.05100.033150.0,43457.06370.03185.0,43458.011440.085800.0,43459.01200.09000.0,43460.01144.09381.0,客户7浙江2.611700.0,客户7浙江3160.06320.0,1300.08.511050.0,43464.01458.010935.0,43464.0202.02525.0