【财务会计】项目收支明细表模板.xlsx

项目收支明细表序号日期项目摘要收入金额支出金额12021/01/01项目_01+6,883.0-2,141.022021/01/02项目_02+6,124.0-1,393.032021/01/03项目_03+5,316.0-1,522.042021/01/04项目_04+8,898.0-2,071.052021/01/05项目_05+9,886.0-1,035.062021/01/06项目_06+3,153.0-1,063.072021/01/07项目_01+3,029.0-1,247.082021/01/08项目_02+9,934.0-1,216.092021/01/09项目_03+7,857.0-2,719.0102021/01/10项目_04+6,864.0-1,357.0112021/01/11项目_05+8,126.0-2,275.0122021/01/12项目_06+5,653.0-1,917.0132021/01/13项目_03+6,244.0-2,131.0142021/01/14项目_04+6,337.0-1,381.0152021/01/15项目_05+6,167.0-2,858.0162021/01/16项目_01+4,127.0-1,968.0172021/01/17项目_02+3,574.0-1,908.0182021/01/18项目_03+4,474.0-1,835.0192021/01/19项目_04+9,011.0-2,881.0各月份收支利润1月2月3月4月5月6月7月8月9月10月11月12月0.0 50000.0 100000.0 150000.0 200000.0 250000.0 利润金额支出金额收款金额202021/01/20项目_05+7,833.0-1,312.0212021/01/21项目_06+4,185.0-1,224.0222021/01/22项目_01+8,501.0-1,848.0232021/01/23项目_02+3,141.0-2,237.0242021/01/24项目_03+4,754.0-2,205.0252021/01/25项目_04+9,393.0-1,926.0262021/01/26项目_05+9,610.0-2,987.0272021/01/27项目_06+7,001.0-2,096.0282021/01/28项目_03+6,837.0-1,628.0292021/01/29项目_04+8,268.0-1,655.0302021/01/30项目_05+4,917.0-1,920.0312021/01/31项目_01+4,853.0-2,331.0322021/02/01项目_02+8,190.0-2,531.0332021/02/02项目_03+6,231.0-2,766.0342021/02/03项目_04+4,194.0-2,487.0352021/02/04项目_05+6,811.0-2,330.0362021/02/05项目_06+4,556.0-2,775.0372021/02/06项目_01+3,326.0-2,918.0382021/02/07项目_02+3,668.0-1,584.0392021/02/08项目_03+9,089.0-1,720.0402021/02/09项目_04+5,481.0-1,105.0412021/02/10项目_05+9,714.0-1,658.0422021/02/11项目_06+3,469.0-2,054.0432021/02/12项目_03+3,679.0-1,451.0442021/02/13项目_04+7,151.0-2,947.0452021/02/14项目_05+9,561.0-1,737.0462021/02/15项目_01+4,061.0-1,478.0472021/02/16项目_02+6,484.0-1,308.0482021/02/17项目_03+8,504.0-1,139.0492021/02/18项目_04+4,016.0-1,569.0502021/02/19项目_05+6,619.0-1,878.0512021/02/20项目_06+3,397.0-1,557.0522021/02/21项目_01+4,162.0-1,170.0532021/02/22项目_02+7,556.0-1,934.0542021/02/23项目_03+9,445.0-1,437.0552021/02/24项目_04+7,624.0-2,216.0562021/02/25项目_05+4,775.0-1,729.0572021/02/26项目_06+3,844.0-1,375.0582021/02/27项目_03+3,610.0-2,158.0592021/02/28项目_04+8,536.0-2,279.0602021/03/01项目_05+4,176.0-1,696.0612021/03/02项目_01+7,269.0-1,479.0622021/03/03项目_02+9,169.0-2,898.0632021/03/04项目_03+8,841.0-1,619.0642021/03/05项目_04+7,841.0-1,365.0652021/03/06项目_05+7,858.0-2,232.0662021/03/07项目_06+8,877.0-1,172.0672021/03/08项目_01+6,315.0-2,671.0682021/03/09项目_02+8,134.0-2,785.0692021/03/10项目_03+9,202.0-2,785.0702021/03/11项目_04+4,640.0-2,055.0712021/03/12项目_05+7,233.0-1,725.0722021/03/13项目_06+7,480.0-2,101.0732021/03/14项目_03+5,387.0-1,483.0742021/03/15项目_04+8,511.0-2,531.0752021/03/16项目_05+6,279.0-2,050.0762021/03/17项目_01+8,757.0-2,733.0772021/03/18项目_02+3,605.0-1,158.0782021/03/19项目_03+8,205.0-1,896.0792021/03/20项目_04+5,102.0-2,339.0802021/03/21项目_05+6,735.0-1,607.0812021/03/22项目_06+6,644.0-2,018.0822021/03/23项目_01+3,290.0-2,777.0832021/03/24项目_02+5,919.0-1,755.0842021/03/25项目_03+5,364.0-2,947.0852021/03/26项目_04+3,668.0-1,830.0862021/03/27项目_05+9,070.0-1,318.0872021/03/28项目_06+3,556.0-1,592.0882021/03/29项目_03+8,013.0-2,798.0892021/03/30项目_04+7,311.0-2,827.0902021/03/31项目_05+4,901.0-2,029.0912021/04/01项目_01+5,094.0-2,243.0922021/04/02项目_02+8,863.0-1,510.0932021/04/03项目_03+5,971.0-2,187.0942021/04/04项目_04+5,161.0-1,307.0952021/04/05项目_05+9,294.0-1,099.0962021/04/06项目_06+9,234.0-2,671.0972021/04/07项目_01+4,792.0-2,655.0982021/04/08项目_02+6,771.0-2,874.0992021/04/09项目_03+7,926.0-1,704.01002021/04/10项目_04+6,984.0-1,864.01012021/04/11项目_05+7,965.0-1,488.01022021/04/12项目_06+5,172.0-2,348.01032021/04/13项目_03+4,911.0-1,087.01042021/04/14项目_04+7,308.0-2,348.01052021/04/15项目_05+4,942.0-1,711.01062021/04/16项目_01+9,728.0-2,158.01072021/04/17项目_02+9,182.0-1,160.01082021/04/18项目_03+5,305.0-1,522.01092021/04/19项目_04+9,077.0-1,744.01102021/04/20项目_05+7,459.0-2,917.01112021/04/21项目_06+8,269.0-1,790.01122021/04/22项目_01+8,216.0-1,734.01132021/04/23项目_02+3,545.0-1,711.01142021/04/24项目_03+4,671.0-1,710.01152021/04/25项目_04+9,301.0-2,352.01162021/04/26项目_05+9,956.0-1,429.01172021/04/27项目_06+3,013.0-2,160.01182021/04/28项目_03+9,447.0-1,010.01192021/04/29项目_04+3,402.0-1,614.01202021/04/30项目_05+8,465.0-2,680.01212021/05/01项目_01+7,938.0-2,441.01222021/05/02项目_02+6,031.0-2,578.01232021/05/03项目_03+6,571.0-2,009.01242021/05/04项目_04+6,127.0-1,671.01252021/05/05项目_05+7,384.0-2,688.01262021/05/06项目_06+8,720.0-2,786.01272021/05/07项目_01+5,101.0-1,470.01282021/05/08项目_02+5,096.0-1,156.01292021/05/09项目_03+9,496.0-1,468.01302021/05/10项目_04+4,248.0-2,772.01312021/05/11项目_05+3,875.0-1,721.01322021/05/12项目_06+4,484.0-1,897.01332021/05/13项目_03+4,901.0-1,395.01342021/05/14项目_04+9,837.0-1,270.01352021/05/15项目_05+4,420.0-1,208.01362021/05/16项目_01+8,703.0-1,173.01372021/05/17项目_02+8,796.0-2,398.01382021/05/18项目_03+5,059.0-1,166.01392021/05/19项目_04+7,769.0-2,520.01402021/05/20项目_05+6,885.0-1,661.01412021/05/21项目_06+6,233.0-1,509.01422021/05/22项目_01+7,212.0-1,105.01432021/05/23项目_02+3,871.0-1,072.01442021/05/24项目_03+8,438.0-2,242.01452021/05/25项目_04+7,637.0-1,922.01462021/05/26项目_05+7,421.0-2,666.01472021/05/27项目_06+5,764.0-1,438.01482021/05/28项目_03+4,714.0-2,734.01492021/05/29项目_04+3,298.0-1,195.01502021/05/30项目_05+3,013.0-2,651.01512021/05/31项目_01+4,796.0-2,136.01522021/06/01项目_02+9,551.0-1,763.01532021/06/02项目_03+8,785.0-1,435.01542021/06/03项目_04+5,966.0-2,657.01552021/06/04项目_05+3,756.0-2,335.01562021/06/05项目_06+7,464.0-1,646.01572021/06/06项目_01+7,244.0-2,746.01582021/06/07项目_02+3,000.0-2,716.01592021/06/08项目_03+9,628.0-1,867.01602021/06/09项目_04+9,861.0-1,095.01612021/06/10项目_05+7,051.0-1,683.01622021/06/11项目_06+3,266.0-1,018.01632021/06/12项目_03+4,115.0-1,965.01642021/06/13项目_04+9,234.0-1,970.01652021/06/14项目_05+5,745.0-2,115.01662021/06/15项目_01+4,597.0-2,480.01672021/06/16项目_02+7,077.0-2,338.01682021/06/17项目_03+7,921.0-1,311.01692021/06/18项目_04+7,553.0-2,759.01702021/06/19项目_05+8,016.0-2,311.01712021/06/20项目_06+7,552.0-1,007.01722021/06/21项目_01+6,392.0-2,472.01732021/06/22项目_02+3,083.0-1,432.01742021/06/23项目_03+7,059.0-1,596.01752021/06/24项目_04+3,572.0-1,881.01762021/06/25项目_05+3,200.0-2,134.01772021/06/26项目_06+6,260.0-1,365.01782021/06/27项目_03+6,223.0-2,341.01792021/06/28项目_04+8,856.0-1,077.01802021/06/29项目_05+3,907.0-2,887.01812021/06/30项目_01+4,514.0-2,101.01822021/07/01项目_02+9,225.0-2,779.01832021/07/02项目_03+6,964.0-2,634.01842021/07/03项目_04+4,785.0-2,670.01852021/07/04项目_05+9,267.0-1,949.01862021/07/05项目_06+9,193.0-1,695.01872021/07/06项目_01+8,047.0-2,528.01882021/07/07项目_02+4,959.0-1,964.01892021/07/08项目_03+9,307.0-2,005.01902021/07/09项目_04+8,934.0-2,135.01912021/07/10项目_05+5,999.0-1,385.01922021/07/11项目_06+3,650.0-1,387.01932021/07/12项目_03+5,332.0-1,673.01942021/07/13项目_04+5,289.0-1,116.01952021/07/14项目_05+7,176.0-1,250.01962021/07/15项目_01+3,803.0-1,142.01972021/07/16项目_02+3,885.0-1,723.01982021/07/17项目_03+6,221.0-2,609.01992021/07/18项目_04+9,454.0-2,796.02002021/07/19项目_05+9,085.0-2,441.02012021/07/20项目_06+3,558.0-2,842.02022021/07/21项目_01+8,869.0-1,914.02032021/07/22项目_02+4,033.0-1,969.02042021/07/23项目_03+5,006.0-1,379.02052021/07/24项目_04+6,081.0-2,828.02062021/07/25项目_05+6,238.0-2,466.02072021/07/26项目_06+7,511.0-1,232.02082021/07/27项目_03+4,613.0-2,339.02092021/07/28项目_04+9,199.0-1,332.02102021/07/29项目_05+9,102.0-1,733.02112021/07/30项目_01+3,861.0-1,201.02122021/07/31项目_02+9,606.0-2,544.02132021/08/01项目_03+3,123.0-1,690.02142021/08/02项目_04+9,794.0-2,771.02152021/08/03项目_05+9,655.0-2,653.02162021/08/04项目_06+8,405.0-2,774.02172021/08/05项目_01+9,553.0-1,044.02182021/08/06项目_02+5,892.0-1,032.02192021/08/07项目_03+9,580.0-2,860.02202021/08/08项目_04+6,285.0-1,041.02212021/08/09项目_05+5,868.0-2,586.02222021/08/10项目_06+3,060.0-1,082.02232021/08/11项目_03+3,221.0-1,433.02242021/08/12项目_04+7,875.0-2,576.02252021/08/13项目_05+6,644.0-2,743.02262021/08/14项目_01+4,093.0-2,077.02272021/08/15项目_02+3,141.0-1,080.02282021/08/16项目_03+9,017.0-2,692.02292021/08/17项目_04+8,495.0-1,529.02302021/08/18项目_05+5,099.0-1,513.02312021/08/19项目_06+8,955.0-1,076.02322021/08/20项目_01+9,299.0-2,878.02332021/08/21项目_02+9,641.0-1,317.02342021/08/22项目_03+8,048.0-2,817.02352021/08/23项目_04+8,123.0-1,128.02362021/08/24项目_05+5,516.0-1,949.02372021/08/25项目_06+5,428.0-1,544.02382021/08/26项目_03+6,910.0-1,668.02392021/08/27项目_04+9,618.0-2,236.02402021/08/28项目_05+3,629.0-1,281.02412021/08/29项目_01+5,438.0-2,285.02422021/08/30项目_02+8,848.0-1,993.02432021/08/31项目_03+3,262.0-2,695.02442021/09/01项目_04+8,040.0-1,382.02452021/09/02项目_05+7,496.0-1,249.02462021/09/03项目_06+8,560.0-1,865.02472021/09/04项目_01+9,773.0-1,913.02482021/09/05项目_02+7,806.0-2,785.02492021/09/06项目_03+3,860.0-1,910.02502021/09/07项目_04+4,269.0-2,335.02512021/09/08项目_05+5,007.0-1,851.02522021/09/09项目_06+9,782.0-2,825.02532021/09/10项目_03+5,171.0-2,997.02542021/09/11项目_04+4,690.0-1,446.02552021/09/12项目_05+8,918.0-2,625.02562021/09/13项目_01+9,014.0-1,582.02572021/09/14项目_02+4,827.0-1,551.02582021/09/15项目_03+8,489.0-2,503.02592021/09/16项目_04+8,671.0-1,887.02602021/09/17项目_05+4,153.0-1,797.02612021/09/18项目_06+5,616.0-2,694.02622021/09/19项目_01+4,733.0-1,405.02632021/09/20项目_02+3,146.0-2,562.02642021/09/21项目_03+9,670.0-1,436.02652021/09/22项目_04+7,743.0-2,012.02662021/09/23项目_05+8,292.0-2,515.02672021/09/24项目_06+5,034.0-2,982.02682021/09/25项目_03+5,045.0-1,322.02692021/09/26项目_04+5,134.0-2,161.02702021/09/27项目_05+6,298.0-1,152.02712021/09/28项目_01+7,767.0-1,563.02722021/09/29项目_02+6,400.0-1,185.02732021/09/30项目_03+6,571.0-1,487.02742021/10/01项目_04+8,295.0-2,233.02752021/10/02项目_05+8,560.0-1,906.02762021/10/03项目_06+7,657.0-1,149.02772021/10/04项目_01+3,265.0-1,806.02782021/10/05项目_02+4,441.0-2,801.02792021/10/06项目_03+6,911.0-1,150.02802021/10/07项目_04+8,035.0-1,177.02812021/10/08项目_05+3,553.0-1,079.02822021/10/09项目_06+3,887.0-2,635.02832021/10/10项目_03+4,562.0-1,181.02842021/10/11项目_04+9,997.0-1,690.02852021/10/12项目_05+9,359.0-1,605.02862021/10/13项目_01+8,337.0-1,069.02872021/10/14项目_02+4,350.0-1,989.02882021/10/15项目_03+6,540.0-1,675.02892021/10/16项目_04+9,609.0-2,057.02902021/10/17项目_05+5,480.0-2,583.02912021/10/18项目_06+4,723.0-1,338.02922021/10/19项目_01+6,653.0-2,768.02932021/10/20项目_02+5,570.0-2,404.02942021/10/21项目_03+3,479.0-2,845.02952021/10/22项目_04+8,131.0-2,464.02962021/10/23项目_05+4,054.0-1,823.02972021/10/24项目_06+9,498.0-2,910.02982021/10/25项目_03+4,787.0-1,124.02992021/10/26项目_04+8,889.0-2,757.03002021/10/27项目_05+7,499.0-2,632.03012021/10/28项目_01+3,178.0-1,381.03022021/10/29项目_02+8,564.0-1,235.03032021/10/30项目_03+6,826.0-1,863.03042021/10/31项目_04+8,676.0-2,601.03052021/11/01项目_05+6,356.0-1,202.03062021/11/02项目_06+7,340.0-2,711.03072021/11/03项目_01+6,776.0-1,434.03082021/11/04项目_02+9,349.0-2,808.03092021/11/05项目_03+3,158.0-2,608.03102021/11/06项目_04+5,725.0-1,494.03112021/11/07项目_05+8,519.0-1,791.03122021/11/08项目_06+7,031.0-2,218.03132021/11/09项目_03+7,052.0-1,574.03142021/11/10项目_04+7,130.0-1,053.03152021/11/11项目_05+7,564.0-2,997.03162021/11/12项目_01+3,310.0-1,122.03172021/11/13项目_02+4,881.0-2,955.03182021/11/14项目_03+5,920.0-1,417.03192021/11/15项目_04+5,271.0-2,352.03202021/11/16项目_05+4,258.0-2,567.03212021/11/17项目_06+9,168.0-1,847.03222021/11/18项目_01+8,863.0-1,346.03232021/11/19项目_02+7,310.0-2,533.03242021/11/20项目_03+5,003.0-1,919.03252021/11/21项目_04+4,722.0-2,750.03262021/11/22项目_05+9,191.0-1,766.03272021/11/23项目_06+6,198.0-1,337.03282021/11/24项目_03+8,769.0-2,040.03292021/11/25项目_04+7,434.0-1,932.03302021/11/26项目_05+3,886.0-2,402.03312021/11/27项目_01+4,365.0-1,911.03322021/11/28项目_02+6,872.0-2,912.03332021/11/29项目_03+4,743.0-1,844.03342021/11/30项目_04+9,739.0-1,954.03352021/12/01项目_05+8,255.0-2,984.03362021/12/02项目_06+9,495.0-2,593.03372021/12/03项目_01+5,490.0-2,172.03382021/12/04项目_02+8,801.0-2,720.03392021/12/05项目_03+3,041.0-1,460.03402021/12/06项目_04+4,755.0-1,079.03412021/12/07项目_05+6,909.0-1,137.03422021/12/08项目_06+6,056.0-2,346.03432021/12/09项目_03+9,935.0-1,688.03442021/12/10项目_04+7,434.0-1,674.03452021/12/11项目_05+5,710.0-2,872.03462021/12/12项目_01+4,261.0-2,258.03472021/12/13项目_02+7,001.0-1,282.03482021/12/14项目_03+9,945.0-2,636.03492021/12/15项目_04+6,839.0-1,970.03502021/12/16项目_05+6,159.0-1,410.03512021/12/17项目_06+9,951.0-2,464.03522021/12/18项目_01+6,623.0-1,670.03532021/12/19项目_02+7,388.0-1,233.03542021/12/20项目_03+6,810.0-2,113.03552021/12/21项目_04+8,786.0-2,912.03562021/12/22项目_05+4,308.0-1,387.03572021/12/23项目_06+7,849.0-1,613.03582021/12/24项目_03+9,459.0-1,618.03592021/12/25项目_04+4,322.0-1,082.03602021/12/26项目_05+4,601.0-2,052.03612021/12/27项目_01+7,727.0-2,031.03622021/12/28项目_02+4,387.0-2,816.03632021/12/29项目_03+6,516.0-1,741.03642021/12/30项目_04+8,646.0-1,585.03652021/12/31项目_05+4,559.0-2,098.0-经手人合同总金额￥3,300,000.006个项目收款总金额￥2,400,793.00365笔记录支出总金额￥899,207.00365笔记录项目财务概况项目名称合同金额收款金额待收金额项目_01480000.0301998.0178002.0项目_02500000.0310687.0189313.0项目_03600000.0475059.0124941.0项目_04700000.0522951.0177049.0项目_05640000.0485247.0154753.0项目_06380000.0304851.075149.0项目收益分析项目名称收款金额支出金额利润金额项目_01301998.094175.0207823.0项目_02310687.097587.0213100.0项目_03475059.0139633.0335426.0各月份收支利润1月2月3月4月5月6月7月8月9月10月11月12月0.0 50000.0 100000.0 150000.0 200000.0 250000.0 利润金额支出金额收款金额项目_04522951.0143036.0379915.0项目_05485247.0145191.0340056.0项目_06304851.091738.0213113.0月收支分析月份收款金额支出金额利润金额1月200950.058287.0142663.02月167753.053290.0114463.03月207352.064271.0143081.04月209424.056787.0152637.05月193838.058118.0135720.06月190448.058503.0131945.07月208252.061660.0146592.08月211515.060043.0151472.09月199975.058979.0140996.010月203365.059930.0143435.011月195903.060796.0135107.012月212018.060696.0151322.0