1、设设置置-基基础础数数据据NO:NO:部部门门姓姓名名费费用用类类型型费费用用发发生生区区域域1 1行政陈可可移动电话费北京2 2人事张芳扬办公用品天津3 3财务刘留扬购买固定资产上海4 4采购董弘倩酒店住宿费重庆5 5研发张文伦员工用餐河北6 6销售李凯君交通费山西7 7客服都丽邮寄费辽宁8 8外勤邢杨客户招待吉林9 9售后修闪宁XXX1黑龙江1010XX部门1余方霖XXX2江苏1111XX部门2李之娟XXX3浙江1212XX部门3索二英XXX4安徽1313XX部门4郭文1XXX5福建1414XX部门5陈瑞XXX6江西1515陈苗天XXX7山东1616王昊月XXX8河南1717张明欣XXX9
2、湖北1818张欣杰XXX10湖南1919杨艳菲XXX11广东2020XXX12海南2121XXX13四川2222XXX14贵州2323XXX15云南2424XXX16陕西2525XXX17甘肃2626XXX18青海2727XXX19内蒙古2828XXX20广西2929XXX21西藏3030XXX22宁夏3131XXX23新疆3232XXX24香港3333XXX25澳门3434XXX26台湾3535XXX27海外3636XXX283737XXX293838XXX303939XXX314040XXX324141XXX334242XXX344343XXX354444XXX364545XXX37464
3、6XXX384747XXX394848XXX404949XXX415050XXX425151XXX435252XXX445353XXX455454XXX465555XXX475656XXX485757XXX495858XXX505959XXX516060XXX526161XXX536262XXX546363XXX556464XXX566565XXX576666XXX586767XXX596868XXX606969XXX617070XXX627171XXX637272XXX647373XXX657474XXX667575XXX677676XXX687777XXX697878XXX707979XX
4、X718080XXX728181XXX738282XXX748383XXX758484XXX768585XXX778686XXX788787XXX798888XXX808989XXX819090XXX829191XXX839292XXX849393XXX859494XXX869595XXX879696XXX889797XXX899898XXX909999XXX91100100XXX92返返回回主主页页费费用用报报销销记记录录-管管理理系系统统表表格格(个个人人、企企业业兼兼用用)报报销销录录入入费费用用-分分类类汇汇总总报报销销录录入入年年度度汇汇总总报报销销修修改改月月度度汇汇总总欢欢迎迎使
5、使用用!*使使用用前前把把报报销销录录入入中中的的数数据据清清空空;注注意意其其它它有有公公式式的的地地方方不不要要删删除除,如如果果删删除除从从上上方方或或下下方方单单元元格格下下拉拉或或上上拉拉来来添添加加公公式式。如如果果你你熟熟悉悉excelexcel可可自自行行调调整整自自己己的的风风格格。1.1.首首先先:基基础础数数据据-中中按按照照自自己己的的需需求求调调整整写写入入2.2.报报销销录录入入-清清空空报报销销录录入入数数据据信信息息,注注意意隐隐藏藏列列和和带带有有公公式式的的单单元元格格请请勿勿清清除除;如如不不小小心心删删除除或或行行不不够够,打打开开隐隐藏藏列列可可以以从
6、从上上方方或或下下方方下下拉拉填填充充即即可可。3.3.费费用用分分类类汇汇总总-自自动动汇汇总总年年度度及及月月度度总总数数据据4.4.个个人人查查询询-可可以以按按照照年年份份和和月月份份查查询询到到报报账账与与报报销销数数据据5.5.事事件件-计计时时器器 页页面面可可填填入入选选计计时时和和倒倒计计时时的的重重要要事事件件及及日日期期希希望望你你会会喜喜欢欢,谢谢谢谢支支持持!个个人人查查询询报报账账与与报报销销-月月度度报报账账与与报报销销-年年度度费费用用报报销销记记录录-管管理理系系统统表表格格(个个人人、企企业业兼兼用用)费费用用-分分类类汇汇总总年年度度汇汇总总月月度度汇汇总
7、总*使使用用前前把把报报销销录录入入中中的的数数据据清清空空;注注意意其其它它有有公公式式的的地地方方不不要要删删除除,如如果果删删除除从从上上方方或或下下方方单单元元格格下下拉拉或或上上拉拉来来添添加加公公式式。如如果果你你熟熟悉悉excelexcel可可自自行行调调整整自自己己的的风风格格。2.2.报报销销录录入入-清清空空报报销销录录入入数数据据信信息息,注注意意隐隐藏藏列列和和带带有有公公式式的的单单元元格格请请勿勿清清除除;如如不不小小心心删删除除或或行行不不够够,打打开开隐隐藏藏列列可可以以从从上上方方或或下下方方下下拉拉填填充充即即可可。2017/2/12017/2/1星星期期三
8、三当当前前总总报报账账:发发票票数数5 5金金额额¥2,230.002,230.00当当前前未未报报销销:发发票票数数2 2金金额额¥2,090.002,090.00事事件件-计计时时器器基基础础数数据据使使用用说说明明费费用用报报销销记记录录-管管理理系系统统表表格格(个个人人、企企业业兼兼用用)费费用用报报销销明明细细NONO:费费用用发发生生日日期期年年月月报报账账部部门门报报账账人人费费用用发发生生区区域域费费用用类类型型1 12017/1/82017/1/8201720171 1采采购购张张芳芳扬扬上上海海移移动动电电话话费费2 22017/1/92017/1/9201720171
9、1销销售售刘刘留留扬扬重重庆庆办办公公用用品品3 32017/1/102017/1/10201720171 1外外勤勤陈陈可可可可天天津津办办公公用用品品4 42017/1/312017/1/31201720171 1人人事事郭郭文文1 1上上海海移移动动电电话话费费5 5190019001 16 6190019001 17 7190019001 18 8190019001 19 9190019001 11010190019001 11111190019001 11212190019001 11313190019001 11414190019001 11515190019001 1161619
10、0019001 11717190019001 11818190019001 11919190019001 12020190019001 12121190019001 12222190019001 12323190019001 12424190019001 12525190019001 12626190019001 12727190019001 12828190019001 12929190019001 13030190019001 13131190019001 13232190019001 13333190019001 13434190019001 13535190019001 1363619
11、0019001 13737190019001 13838190019001 13939190019001 14040190019001 14141190019001 14242190019001 14343190019001 14444190019001 14545190019001 14646190019001 14747190019001 14848190019001 14949190019001 15050190019001 15151190019001 15252190019001 15353190019001 15454190019001 15555190019001 1565619
12、0019001 15757190019001 15858190019001 15959190019001 16060190019001 16161190019001 16262190019001 16363190019001 16464190019001 16565190019001 16666190019001 16767190019001 16868190019001 16969190019001 17070190019001 17171190019001 17272190019001 17373190019001 17474190019001 17575190019001 1767619
13、0019001 17777190019001 17878190019001 17979190019001 18080190019001 18181190019001 18282190019001 18383190019001 18484190019001 18585190019001 18686190019001 18787190019001 18888190019001 18989190019001 19090190019001 19191190019001 19292190019001 19393190019001 19494190019001 19595190019001 1969619
14、0019001 19797190019001 19898190019001 19999190019001 1100100190019001 1101101190019001 1102102190019001 1103103190019001 1104104190019001 1105105190019001 1106106190019001 1107107190019001 1108108190019001 1109109190019001 1110110190019001 1111111190019001 1112112190019001 1113113190019001 111411419
15、0019001 1115115190019001 1116116190019001 1117117190019001 1118118190019001 1119119190019001 1120120190019001 1121121190019001 1122122190019001 1123123190019001 1124124190019001 1125125190019001 1126126190019001 1127127190019001 1128128190019001 1129129190019001 1130130190019001 1131131190019001 113
16、2132190019001 1133133190019001 1134134190019001 1135135190019001 1136136190019001 1137137190019001 1138138190019001 1139139190019001 1140140190019001 1141141190019001 1142142190019001 1143143190019001 1144144190019001 1145145190019001 1146146190019001 1147147190019001 1148148190019001 11491491900190
17、01 1150150190019001 1151151190019001 1152152190019001 1153153190019001 1154154190019001 1155155190019001 1156156190019001 1157157190019001 1158158190019001 1159159190019001 1160160190019001 1161161190019001 1162162190019001 1163163190019001 1164164190019001 1165165190019001 1166166190019001 11671671
18、90019001 1168168190019001 1169169190019001 1170170190019001 1171171190019001 1172172190019001 1173173190019001 1174174190019001 1175175190019001 1176176190019001 1177177190019001 1178178190019001 1179179190019001 1180180190019001 1181181190019001 1182182190019001 1183183190019001 1184184190019001 11
19、85185190019001 1186186190019001 1187187190019001 1188188190019001 1189189190019001 1190190190019001 1191191190019001 1192192190019001 1193193190019001 1194194190019001 1195195190019001 1196196190019001 1197197190019001 1198198190019001 1199199190019001 1200200190019001 1201201190019001 1202202190019
20、001 1203203190019001 1204204190019001 1205205190019001 1206206190019001 1207207190019001 1208208190019001 1209209190019001 1210210190019001 1211211190019001 1212212190019001 1213213190019001 1214214190019001 1215215190019001 1216216190019001 1217217190019001 1218218190019001 1219219190019001 1220220
21、190019001 1221221190019001 1222222190019001 1223223190019001 1224224190019001 1225225190019001 1226226190019001 1227227190019001 1228228190019001 1229229190019001 1230230190019001 1231231190019001 1232232190019001 1233233190019001 1234234190019001 1235235190019001 1236236190019001 1237237190019001 1
22、238238190019001 1239239190019001 1240240190019001 1241241190019001 1242242190019001 1243243190019001 1244244190019001 1245245190019001 1246246190019001 1247247190019001 1248248190019001 1249249190019001 1250250190019001 1251251190019001 1252252190019001 1253253190019001 1254254190019001 125525519001
23、9001 1256256190019001 1257257190019001 1258258190019001 1259259190019001 1260260190019001 1261261190019001 1262262190019001 1263263190019001 1264264190019001 1265265190019001 1266266190019001 1267267190019001 1268268190019001 1269269190019001 1270270190019001 1271271190019001 1272272190019001 127327
24、3190019001 1274274190019001 1275275190019001 1276276190019001 1277277190019001 1278278190019001 1279279190019001 1280280190019001 1281281190019001 1282282190019001 1283283190019001 1284284190019001 1285285190019001 1286286190019001 1287287190019001 1288288190019001 1289289190019001 1290290190019001
25、1291291190019001 1292292190019001 1293293190019001 1294294190019001 1295295190019001 1296296190019001 1297297190019001 1298298190019001 1299299190019001 1300300190019001 1301301190019001 1302302190019001 1303303190019001 1304304190019001 1305305190019001 1306306190019001 1307307190019001 13083081900
26、19001 1309309190019001 1310310190019001 1311311190019001 1312312190019001 1313313190019001 1314314190019001 1315315190019001 1316316190019001 1317317190019001 1318318190019001 1319319190019001 1320320190019001 1321321190019001 1322322190019001 1323323190019001 1324324190019001 1325325190019001 13263
27、26190019001 1327327190019001 1328328190019001 1329329190019001 1330330190019001 1331331190019001 1332332190019001 1333333190019001 1334334190019001 1335335190019001 1336336190019001 1337337190019001 1338338190019001 1339339190019001 1340340190019001 1341341190019001 1342342190019001 1343343190019001
28、 1344344190019001 1345345190019001 1346346190019001 1347347190019001 1348348190019001 1349349190019001 1350350190019001 1351351190019001 1352352190019001 1353353190019001 1354354190019001 1355355190019001 1356356190019001 1357357190019001 1358358190019001 1359359190019001 1360360190019001 1361361190
29、019001 1362362190019001 1363363190019001 1364364190019001 1365365190019001 1366366190019001 1367367190019001 1368368190019001 1369369190019001 1370370190019001 1371371190019001 1372372190019001 1373373190019001 1374374190019001 1375375190019001 1376376190019001 1377377190019001 1378378190019001 1379
30、379190019001 1380380190019001 1381381190019001 1382382190019001 1383383190019001 1384384190019001 1385385190019001 1386386190019001 1387387190019001 1388388190019001 1389389190019001 1390390190019001 1391391190019001 1392392190019001 1393393190019001 1394394190019001 1395395190019001 139639619001900
31、1 1397397190019001 1398398190019001 1399399190019001 1400400190019001 1401401190019001 1402402190019001 1403403190019001 1404404190019001 1405405190019001 1406406190019001 1407407190019001 1408408190019001 1409409190019001 1410410190019001 1411411190019001 1412412190019001 1413413190019001 141441419
32、0019001 1415415190019001 1416416190019001 1417417190019001 1418418190019001 1419419190019001 1420420190019001 1421421190019001 1422422190019001 1423423190019001 1424424190019001 1425425190019001 1426426190019001 1427427190019001 1428428190019001 1429429190019001 1430430190019001 1431431190019001 143
33、2432190019001 1433433190019001 1434434190019001 1435435190019001 1436436190019001 1437437190019001 1438438190019001 1439439190019001 1440440190019001 1441441190019001 1442442190019001 1443443190019001 1444444190019001 1445445190019001 1446446190019001 1447447190019001 1448448190019001 14494491900190
34、01 1450450190019001 1451451190019001 1452452190019001 1453453190019001 1454454190019001 1455455190019001 1456456190019001 1457457190019001 1458458190019001 1459459190019001 1460460190019001 1461461190019001 1462462190019001 1463463190019001 1464464190019001 1465465190019001 1466466190019001 14674671
35、90019001 1468468190019001 1469469190019001 1470470190019001 1471471190019001 1472472190019001 1473473190019001 1474474190019001 1475475190019001 1476476190019001 1477477190019001 1478478190019001 1479479190019001 1480480190019001 1481481190019001 1482482190019001 1483483190019001 1484484190019001 14
36、85485190019001 1486486190019001 1487487190019001 1488488190019001 1489489190019001 1490490190019001 1491491190019001 1492492190019001 1493493190019001 1494494190019001 1495495190019001 1496496190019001 1497497190019001 1498498190019001 1499499190019001 1500500190019001 1501501190019001 1502502190019
37、001 1503503190019001 1504504190019001 1505505190019001 1506506190019001 1507507190019001 1508508190019001 1509509190019001 1510510190019001 1511511190019001 1512512190019001 1513513190019001 1514514190019001 1515515190019001 1516516190019001 1517517190019001 1518518190019001 1519519190019001 1520520
38、190019001 1521521190019001 1522522190019001 1523523190019001 1524524190019001 1525525190019001 1526526190019001 1527527190019001 1528528190019001 1529529190019001 1530530190019001 1531531190019001 1532532190019001 1533533190019001 1534534190019001 1535535190019001 1536536190019001 1537537190019001 1
39、538538190019001 1539539190019001 1540540190019001 1541541190019001 1542542190019001 1543543190019001 1544544190019001 1545545190019001 1546546190019001 1547547190019001 1548548190019001 1549549190019001 1550550190019001 1551551190019001 1552552190019001 1553553190019001 1554554190019001 155555519001
40、9001 1556556190019001 1557557190019001 1558558190019001 1559559190019001 1560560190019001 1561561190019001 1562562190019001 1563563190019001 1564564190019001 1565565190019001 1566566190019001 1567567190019001 1568568190019001 1569569190019001 1570570190019001 1571571190019001 1572572190019001 157357
41、3190019001 1574574190019001 1575575190019001 1576576190019001 1577577190019001 1578578190019001 1579579190019001 1580580190019001 1581581190019001 1582582190019001 1583583190019001 1584584190019001 1585585190019001 1586586190019001 1587587190019001 1588588190019001 1589589190019001 1590590190019001
42、1591591190019001 1592592190019001 1593593190019001 1594594190019001 1595595190019001 1596596190019001 1597597190019001 1598598190019001 1599599190019001 1600600190019001 1601601190019001 1602602190019001 1603603190019001 1604604190019001 1605605190019001 1606606190019001 1607607190019001 16086081900
43、19001 1609609190019001 1610610190019001 1611611190019001 1612612190019001 1613613190019001 1614614190019001 1615615190019001 1616616190019001 1617617190019001 1618618190019001 1619619190019001 1620620190019001 1621621190019001 1622622190019001 1623623190019001 1624624190019001 1625625190019001 16266
44、26190019001 1627627190019001 1628628190019001 1629629190019001 1630630190019001 1631631190019001 1632632190019001 1633633190019001 1634634190019001 1635635190019001 1636636190019001 1637637190019001 1638638190019001 1639639190019001 1640640190019001 1641641190019001 1642642190019001 1643643190019001
45、 1644644190019001 1645645190019001 1646646190019001 1647647190019001 1648648190019001 1649649190019001 1650650190019001 1651651190019001 1652652190019001 1653653190019001 1654654190019001 1655655190019001 1656656190019001 1657657190019001 1658658190019001 1659659190019001 1660660190019001 1661661190
46、019001 1662662190019001 1663663190019001 1664664190019001 1665665190019001 1666666190019001 1667667190019001 1668668190019001 1669669190019001 1670670190019001 1671671190019001 1672672190019001 1673673190019001 1674674190019001 1675675190019001 1676676190019001 1677677190019001 1678678190019001 1679
47、679190019001 1680680190019001 1681681190019001 1682682190019001 1683683190019001 1684684190019001 1685685190019001 1686686190019001 1687687190019001 1688688190019001 1689689190019001 1690690190019001 1691691190019001 1692692190019001 1693693190019001 1694694190019001 1695695190019001 169669619001900
48、1 1697697190019001 1698698190019001 1699699190019001 1700700190019001 1701701190019001 1702702190019001 1703703190019001 1704704190019001 1705705190019001 1706706190019001 1707707190019001 1708708190019001 1709709190019001 1710710190019001 1711711190019001 1712712190019001 1713713190019001 171471419
49、0019001 1715715190019001 1716716190019001 1717717190019001 1718718190019001 1719719190019001 1720720190019001 1721721190019001 1722722190019001 1723723190019001 1724724190019001 1725725190019001 1726726190019001 1727727190019001 1728728190019001 1729729190019001 1730730190019001 1731731190019001 173
50、2732190019001 1733733190019001 1734734190019001 1735735190019001 1736736190019001 1737737190019001 1738738190019001 1739739190019001 1740740190019001 1741741190019001 1742742190019001 1743743190019001 1744744190019001 1745745190019001 1746746190019001 1747747190019001 1748748190019001 17497491900190