汽车4S店财务收支管理系统表

4S店财务收支管理系统当前日期：今天是:2019年5月21日【星期二】,月份收入支出余额,年初,年初金额43466.0,43497.0,43525.0,43556.0,收入金额43586.0,43617.0,43647.0,43678.0,支出金额43709.0,43739.0,43770.0,43800.0,期末金额合计,基础设置,账户设置收支分类部门时间,账户名称期初余额收入支出年份月份,微信整车销售收入整车采购支出管理部2019.01.0,支付宝精品销售收入发放员工工资财务室2020.02.0,农行售后维修收入付保险费销售部2021.03.0,保险精品支出售后部2022.04.0,购置税办公费用2023.05.0,其他提车费用2024.06.0,尾款业务费用2025.07.0,招待费2026.08.0,电话费2027.09.0,电费2028.010.0,水费11.0,房租12.0,税费,其他支出,公账手续费,购置税,首付款,客户设置,客户信息,客户地址电话生日期初余额,客户1100.0,客户2200.0,客户3300.0,一月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,,二月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,三月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门客户,224800.0客户1,43545.051800.0客户2,43542.0五菱宏光尾款57152.0客户2,43544.0别克君越尾款238272.0客户1,首付款38687.0,89400.0,43555.0别克英朗购置税7700.0,整车销售尾款70000.0,收客户3购车差价,吴立冬1750元，客户15652元，客户22865元，客户3：4073付保险费14340.0,43540.0600.0,差旅费,高速公路费50.0,新车贴膜2250.0,脚垫880.0,网购其他支出1697.0,网购528.2,快递费12.0,板车运输费300.0,高速公路费25.0,差旅费24.0,其他支出50.0,39.0,144.0,15.0,143.0,餐费招待费440.0,300.0,102.0,43548.0229.0,23.0,43548.0公账手续费418.0,43549.01510.0,43549.0600.0,43550.023.0,四月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门客户,五月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,六月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,七月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,八月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,九月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,十月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,十一月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,十二月日常收支登记,日期收支摘要收入项目收入金额支出项目支出金额账户部门单据编号客户车型,账户,农行明细账开始日期43525.0,结束日期43616.0,编号日期收支摘要收入项目收入金额支出项目支出金额账户部门结存期初,期初余额收入合计404311.0,1.043540.0600.0-600.0支出合计399042.2,2.0224800.0-225400.0余额5268.8,3.0差旅费-225600.0,4.0-225800.0,5.0高速公路费-225850.0,6.043542.0五菱宏光尾款57152.0-168698.0,7.043544.0别克君越尾款238272.069574.0,8.043545.051800.017774.0,9.0首付款38687.056461.0,10.089400.0-32939.0,11.0新车贴膜2250.0-35189.0,12.0脚垫880.0-36069.0,13.0网购其他支出1697.0-37766.0,14.0-37966.0,15.0网购528.2-38494.2,16.0快递费12.0-38506.2,17.0板车运输费-38806.2,18.0高速公路费25.0-38831.2,19.0差旅费24.0-38855.2,20.0其他支出-38905.2,21.039.0-38944.2,22.0144.0-39088.2,15.0-39103.2,24.0143.0-39246.2,25.0餐费招待费440.0-39686.2,26.0-39986.2,27.0102.0-40088.2,28.0-40111.2,29.043548.0229.0-40340.2,30.043548.0公账手续费418.0-40758.2,31.043549.01510.0-42268.2,32.043549.0600.0-42868.2,33.043550.0-42891.2,34.0整车销售尾款70000.027108.8,35.0收客户3购车差价27308.8,36.0吴立冬1750元，客户15652元，客户22865元，客户3：4073付保险费14340.012968.8,37.043555.0别克英朗购置税7700.05268.8,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,201.0,202.0,203.0,204.0,205.0,206.0,207.0,208.0,209.0,210.0,211.0,212.0,213.0,214.0,215.0,216.0,217.0,218.0,219.0,220.0,221.0,222.0,223.0,224.0,225.0,226.0,227.0,228.0,229.0,230.0,231.0,232.0,233.0,234.0,235.0,236.0,237.0,238.0,239.0,240.0,241.0,242.0,243.0,244.0,245.0,246.0,247.0,248.0,249.0,250.0,251.0,252.0,253.0,254.0,255.0,256.0,257.0,258.0,259.0,260.0,261.0,262.0,263.0,264.0,265.0,266.0,267.0,268.0,269.0,270.0,271.0,272.0,273.0,274.0,275.0,276.0,277.0,278.0,279.0,280.0,281.0,282.0,283.0,284.0,285.0,286.0,287.0,288.0,289.0,290.0,291.0,292.0,293.0,294.0,295.0,296.0,297.0,298.0,299.0,301.0,302.0,303.0,304.0,305.0,306.0,307.0,308.0,309.0,310.0,311.0,312.0,313.0,314.0,315.0,316.0,317.0,318.0,319.0,320.0,321.0,322.0,323.0,324.0,325.0,326.0,327.0,328.0,329.0,330.0,331.0,332.0,333.0,334.0,335.0,336.0,337.0,338.0,339.0,340.0,341.0,342.0,343.0,344.0,345.0,346.0,347.0,348.0,349.0,350.0,351.0,352.0,353.0,354.0,355.0,356.0,357.0,358.0,359.0,360.0,361.0,362.0,363.0,364.0,365.0,366.0,367.0,368.0,369.0,370.0,371.0,372.0,373.0,374.0,375.0,376.0,377.0,378.0,379.0,380.0,381.0,382.0,383.0,384.0,385.0,386.0,387.0,388.0,389.0,390.0,391.0,392.0,393.0,394.0,395.0,396.0,397.0,398.0,399.0,400.0,401.0,402.0,403.0,404.0,405.0,406.0,407.0,408.0,409.0,410.0,411.0,412.0,413.0,414.0,415.0,416.0,417.0,418.0,419.0,420.0,421.0,422.0,423.0,424.0,425.0,426.0,427.0,428.0,429.0,430.0,431.0,432.0,433.0,434.0,435.0,436.0,437.0,438.0,439.0,440.0,441.0,442.0,443.0,444.0,445.0,446.0,447.0,448.0,449.0,450.0,451.0,452.0,453.0,454.0,455.0,456.0,457.0,458.0,459.0,460.0,461.0,462.0,463.0,464.0,465.0,466.0,467.0,468.0,469.0,470.0,471.0,472.0,473.0,474.0,475.0,476.0,477.0,478.0,479.0,480.0,481.0,482.0,483.0,484.0,485.0,486.0,487.0,488.0,489.0,490.0,491.0,492.0,493.0,494.0,495.0,496.0,497.0,498.0,499.0,500.0,账户收支汇总,起始日期43525.0截止日期43585.0,账户期初收入支出余额,合计538937.0593451.16-54514.16,微信,支付宝,538937.0593451.16-54514.16,科目,整车销售收入明细账开始日期43525.0,结束日期43616.0,编号日期收支摘要收入项目收支金额支出项目支出金额账户部门盈余期初,期初余额收入合计,1.043542.0五菱宏光尾款57152.057152.0支出合计0.0,2.043544.0别克君越尾款238272.0295424.0盈余,3.043546.0首付款38687.0334111.0,4.043551.0整车销售尾款70000.0404111.0,5.043551.0收客户3购车差价200.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,200.0,201.0,202.0,203.0,204.0,205.0,206.0,207.0,208.0,209.0,210.0,211.0,212.0,213.0,214.0,215.0,216.0,217.0,218.0,219.0,220.0,221.0,222.0,223.0,224.0,225.0,226.0,227.0,228.0,229.0,230.0,231.0,232.0,233.0,234.0,235.0,236.0,237.0,238.0,239.0,240.0,241.0,242.0,243.0,244.0,245.0,246.0,247.0,248.0,249.0,250.0,251.0,252.0,253.0,254.0,255.0,256.0,257.0,258.0,259.0,260.0,261.0,262.0,263.0,264.0,265.0,266.0,267.0,268.0,269.0,270.0,271.0,272.0,273.0,274.0,275.0,276.0,277.0,278.0,279.0,280.0,281.0,282.0,283.0,284.0,285.0,286.0,287.0,288.0,289.0,290.0,291.0,292.0,293.0,294.0,295.0,296.0,297.0,298.0,299.0,300.0,301.0,302.0,303.0,304.0,305.0,306.0,307.0,308.0,309.0,310.0,311.0,312.0,313.0,314.0,315.0,316.0,317.0,318.0,319.0,320.0,321.0,322.0,323.0,324.0,325.0,326.0,327.0,328.0,329.0,330.0,331.0,332.0,333.0,334.0,335.0,336.0,337.0,338.0,339.0,340.0,341.0,342.0,343.0,344.0,345.0,346.0,347.0,348.0,349.0,350.0,351.0,352.0,353.0,354.0,355.0,356.0,357.0,358.0,359.0,360.0,361.0,362.0,363.0,364.0,365.0,366.0,367.0,368.0,369.0,370.0,371.0,372.0,373.0,374.0,375.0,376.0,377.0,378.0,379.0,380.0,381.0,382.0,383.0,384.0,385.0,386.0,387.0,388.0,389.0,390.0,391.0,392.0,393.0,394.0,395.0,396.0,397.0,398.0,399.0,400.0,401.0,402.0,403.0,404.0,405.0,406.0,407.0,408.0,409.0,410.0,411.0,412.0,413.0,414.0,415.0,416.0,417.0,418.0,419.0,420.0,421.0,422.0,423.0,424.0,425.0,426.0,427.0,428.0,429.0,430.0,431.0,432.0,433.0,434.0,435.0,436.0,437.0,438.0,439.0,440.0,441.0,442.0,443.0,444.0,445.0,446.0,447.0,448.0,449.0,450.0,451.0,452.0,453.0,454.0,455.0,456.0,457.0,458.0,459.0,460.0,461.0,462.0,463.0,464.0,465.0,466.0,467.0,468.0,469.0,470.0,471.0,472.0,473.0,474.0,475.0,476.0,477.0,478.0,479.0,480.0,481.0,482.0,483.0,484.0,485.0,486.0,487.0,488.0,489.0,490.0,491.0,492.0,493.0,494.0,495.0,496.0,497.0,498.0,499.0,500.0,科目收支汇总,起始日期43525.0截止日期43616.0,部门期初收入支出余额,合计399042.25268.8,整车销售收入,精品销售收入,售后维修收入,保险,购置税,其他,尾款,整车采购支出366000.0-366000.0,发放员工工资,付保险费14340.0-14340.0,精品支出5255.0-5255.0,办公费用866.2-866.2,提车费用1579.0-1579.0,业务费用697.0-697.0,招待费440.0-440.0,电话费,电费,水费,房租,税费,其他支出1747.0-1747.0,公账手续费418.0-418.0,购置税7700.0-7700.0,首付款,部门,销售部明细账开始日期43525.0,结束日期43616.0,编号日期收支摘要收入项目收支金额支出项目支出金额账户部门盈余期初,期初余额收入合计404311.0,1.043541.0224800.0-224800.0支出合计388040.0,2.043542.0五菱宏光尾款57152.0-167648.0盈余16271.0,3.043544.0别克君越尾款238272.070624.0,4.043545.051800.018824.0,5.043546.0首付款38687.057511.0,6.043546.089400.0-31889.0,7.0整车销售尾款70000.038111.0,8.0收客户3购车差价200.038311.0,9.0吴立冬1750元，客户15652元，客户22865元，客户3：4073付保险费14340.023971.0,10.043555.0别克英朗购置税7700.016271.0,11.0,12.0,13.0,14.0,15.0,16.0,17.0,18.0,19.0,20.0,21.0,22.0,23.0,24.0,25.0,26.0,27.0,28.0,29.0,30.0,31.0,32.0,33.0,34.0,35.0,36.0,37.0,38.0,39.0,40.0,41.0,42.0,43.0,44.0,45.0,46.0,47.0,48.0,49.0,50.0,51.0,52.0,53.0,54.0,55.0,56.0,57.0,58.0,59.0,60.0,61.0,62.0,63.0,64.0,65.0,66.0,67.0,68.0,69.0,70.0,71.0,72.0,73.0,74.0,75.0,76.0,77.0,78.0,79.0,80.0,81.0,82.0,83.0,84.0,85.0,86.0,87.0,88.0,89.0,90.0,91.0,92.0,93.0,94.0,95.0,96.0,97.0,98.0,99.0,100.0,101.0,102.0,103.0,104.0,105.0,106.0,107.0,108.0,109.0,110.0,111.0,112.0,113.0,114.0,115.0,116.0,117.0,118.0,119.0,120.0,121.0,122.0,123.0,124.0,125.0,126.0,127.0,128.0,129.0,130.0,131.0,132.0,133.0,134.0,135.0,136.0,137.0,138.0,139.0,140.0,141.0,142.0,143.0,144.0,145.0,146.0,147.0,148.0,149.0,150.0,151.0,152.0,153.0,154.0,155.0,156.0,157.0,158.0,159.0,160.0,161.0,162.0,163.0,164.0,165.0,166.0,167.0,168.0,169.0,170.0,171.0,172.0,173.0,174.0,175.0,176.0,177.0,178.0,179.0,180.0,181.0,182.0,183.0,184.0,185.0,186.0,187.0,188.0,189.0,190.0,191.0,192.0,193.0,194.0,195.0,196.0,197.0,198.0,199.0,200.0,201.0,202.0,203.0,204.0,205.0,206.0,207.0,208.0,209.0,210.0,211.0,212.0,213.0,214.0,215.0,216.0,217.0,218.0,219.0,220.0,221.0,222.0,223.0,224.0,225.0,226.0,227.0,228.0,229.0,230.0,231.0,232.0,233.0,234.0,235.0,236.0,237.0,238.0,239.0,240.0,241.0,242.0,243.0,244.0,245.0,246.0,247.0,248.0,249.0,250.0,251.0,252.0,253.0,254.0,255.0,256.0,257.0,258.0,259.0,260.0,261.0,262.0,263.0,264.0,265.0,266.0,267.0,268.0,269.0,270.0,271.0,272.0,273.0,274.0,275.0,276.0,277.0,278.0,279.0,280.0,281.0,282.0,283.0,284.0,285.0,286.0,287.0,288.0,289.0,290.0,291.0,292.0,293.0,294.0,295.0,296.0,297.0,298.0,299.0,300.0,301.0,302.0,303.0,304.0,305.0,306.0,307.0,308.0,309.0,310.0,311.0,312.0,313.0,314.0,315.0,316.0,317.0,318.0,319.0,320.0,321.0,322.0,323.0,324.0,325.0,326.0,327.0,328.0,329.0,330.0,331.0,332.0,333.0,334.0,335.0,336.0,337.0,338.0,339.0,340.0,341.0,342.0,343.0,344.0,345.0,346.0,347.0,348.0,349.0,350.0,351.0,352.0,353.0,354.0,355.0,356.0,357.0,358.0,359.0,360.0,361.0,362.0,363.0,364.0,365.0,366.0,367.0,368.0,369.0,370.0,371.0,372.0,373.0,374.0,375.0,376.0,377.0,378.0,379.0,380.0,381.0,382.0,383.0,384.0,385.0,386.0,387.0,388.0,389.0,390.0,391.0,392.0,393.0,394.0,395.0,396.0,397.0,398.0,399.0,400.0,401.0,402.0,403.0,404.0,405.0,406.0,407.0,408.0,409.0,410.0,411.0,412.0,413.0,414.0,415.0,416.0,417.0,418.0,419.0,420.0,421.0,422.0,423.0,424.0,425.0,426.0,427.0,428.0,429.0,430.0,431.0,432.0,433.0,434.0,435.0,436.0,437.0,438.0,439.0,440.0,441.0,442.0,443.0,444.0,445.0,446.0,447.0,448.0,449.0,450.0,451.0,452.0,453.0,454.0,455.0,456.0,457.0,458.0,459.0,460.0,461.0,462.0,463.0,464.0,465.0,466.0,467.0,468.0,469.0,470.0,471.0,472.0,473.0,474.0,475.0,476.0,477.0,478.0,479.0,480.0,481.0,482.0,483.0,484.0,485.0,486.0,487.0,488.0,489.0,490.0,491.0,492.0,493.0,494.0,495.0,496.0,497.0,498.0,499.0,500.0,部门收支汇总,起始日期43525.0截止日期43616.0,部门期初收入支出余额,合计404311.0399042.25268.8,管理部11002.2-11002.2,财务室,销售部404311.0388040.016271.0,售后部,农行2019年3月收支明细账户农行,年2019.0,日期初收入支出结余月3.0,合计404311.0399042.25268.8,1.0,2.0,3.0,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,13.0,14.0,15.0,16.0600.0-600.0,17.0-600.0225250.0-225850.0,18.0-225850.057152.0,19.0,20.0238272.069574.0,21.069574.051800.017774.0,22.017774.038687.092530.0-36069.0,23.0-36069.04042.2-40111.2,24.0-40111.2647.0-40758.2,25.0-40758.22110.0-42868.2,26.0-42868.223.0-42891.2,27.0-42891.270200.014340.0,28.0,29.0,30.0,31.07700.05268.8,2019年年度盈余分析表年度,月份期初收入支出盈余2019.0,合计404311.0399042.2,年初,1.0,2.0,3.0404311.0399042.2,4.0,5.0,6.0,7.0,8.0,9.0,10.0,11.0,12.0,客户收支汇总,起始日期43586.0截止日期43616.0,客户期初收入支出余额,合计11724.00.00.011724.0,客户113572.013572.0,客户25552.05552.0,客户3-7400.0-7400.0,使用说明,1，基础信息设置，客户信息,录入基础信息,2，1-12月记录对应月份收支业务，点击录入和修改按钮，通过窗体录入和修改收支记录,3，账户明细，点击查询按钮，选择账户和起止日期，明细表自动生成,4，科目明细，点击查询按钮，选择科目和起止日期，明细表自动生成,5，科目汇总，点击查询按钮，选择起始截止日期，自动生成统计报表,6，账户汇总，点击查询按钮，选择起始截止日期，自动生成统计报表,7，月度统计，点击查询按钮，选择具体账户名称，年度，月度，当月该账户每日收支情况自动计算,8，年度统计，点击查询按钮，选择年度，每月收支情况自动计算,9，客户收支汇总，点击查询按钮，选择起止日期，自动生成报表,必看：此模板为宏模板，若下载不能启用宏。可下载插件启用。插件安装后，重新下载打开模板即可正常使用。插件下载地址:https://pan.baidu.com/s/11AUFBYgjQKKMrGHcYOoKuw