经典表格模板.xls

Company Name ABC Company Current Year Financials Open to Demo Users DashboardCreate an Invoice Profit Loss CY PlanCreate a Purchase Order Profit Loss CY ActualPY ActualPayroll Calculator Open to Demo Users Profit Loss YTY Plan CompareTime Sheet Balance SheetInventory Cash FlowExpense Report Forecast SalesLoan Amortization Schdule Open to Demo Users Record Actual SalesContact List Open to Demo Users Record Actual SpendingHelp Copyright 2004 2012 S Software License Agreement S grants usage of this financial planning software under the following terms and conditions After the purchasing and downloading of this software from S or S the purchaser is granted a license to use this product The licensee may make copies of this product in an amount that does not exceed the number of licenses originally purchased from S or S or for the purpose of creating a backup copy or for use on a secondary computer This file or the software contained in this file shall not be transferred to a non licensee without the written consent from S Limitation of Liability S will not be held liable for damages in the event of but not limited to inaccurate assumptions calculation errors software hardware data and network failure and profit savings losses as a result of using this software 2013 Dashboard Full Year 2012ABC Company OPEN TO DEMO USERS Top Sales CategoriesCost of Goods Sold Product 130 000 Product 228 800 Product 327 600 Product 426 400 Product 525 200 Product 624 000 Product 722 800 Product 821 600 Other74 400 Total Sales280 800 Full Year24 000Full Year5 760Full Year7 200Full Year173 520 N AN AN AN A JanMarMayJulSepNov 0 100 200 300 400 500 600 By Month JanMarMayJulSepNov 0 100 200 300 400 500 600 700 Full Year Salary expenses Payroll Taxes Advertising Maintanence Accounting Finance Travel Other JanMarMayJulSepNov 0 500 1 000 1 500 2 000 2 500 JanMarMayJulSepNov 0 5 000 10 000 15 000 20 000 25 000 2012 Salary Benefits Travel Contractor cost Other Cost Category 30 Other Travel Cost of Goods SoldExpense By MonthSalary expenses Profit Summary in 1 000 s Total Profit By Month By MonthProduct 6 Sales 280 8 28 8 78 5 173 5 SalesCost of Goods ExpenseProfit Profit Loss Statement Current Year Plan 2013ABC Company OPEN TO DEMO USERS CategoryJanFebMar1QAprMayJun2QJulAugSep3QOctNovDec4QFull Year Sales Product 12 5002 5002 5007 5002 5002 5002 5007 5002 5002 5002 5007 5002 5002 5002 5007 50030 000 Product 22 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 20028 800 Product 32 3002 3002 3006 9002 3002 3002 3006 9002 3002 3002 3006 9002 3002 3002 3006 90027 600 Product 42 2002 2002 2006 6002 2002 2002 2006 6002 2002 2002 2006 6002 2002 2002 2006 60026 400 Product 52 1002 1002 1006 3002 1002 1002 1006 3002 1002 1002 1006 3002 1002 1002 1006 30025 200 Product 62 0002 0002 0006 0002 0002 0002 0006 0002 0002 0002 0006 0002 0002 0002 0006 00024 000 Product 71 9001 9001 9005 7001 9001 9001 9005 7001 9001 9001 9005 7001 9001 9001 9005 70022 800 Product 81 8001 8001 8005 4001 8001 8001 8005 4001 8001 8001 8005 4001 8001 8001 8005 40021 600 Product 91 7001 7001 7005 1001 7001 7001 7005 1001 7001 7001 7005 1001 7001 7001 7005 10020 400 Product 101 6001 6001 6004 8001 6001 6001 6004 8001 6001 6001 6004 8001 6001 6001 6004 80019 200 Product 111 5001 5001 5004 5001 5001 5001 5004 5001 5001 5001 5004 5001 5001 5001 5004 50018 000 Product 121 4001 4001 4004 2001 4001 4001 4004 2001 4001 4001 4004 2001 4001 4001 4004 20016 800 Sales Category 1300000 Sales Category 1400000 Sales Category 1500000 Total Sales23 40023 40023 40070 20023 40023 40023 40070 20023 40023 40023 40070 20023 40023 40023 40070 200280 800 Add Sales categories click here then Unhide Cost of Goods Salary5005005001 5005005005001 5005005005001 5005005005001 5006 000 Benefits4904904901 4704904904901 4704904904901 4704904904901 4705 880 Travel4804804801 4404804804801 4404804804801 4404804804801 4405 760 Contractor cost4704704701 4104704704701 4104704704701 4104704704701 4105 640 Other4604604601 3804604604601 3804604604601 3804604604601 3805 520 Cost Category 600000 Cost Category 700000 Cost Category 800000 Cost Category 900000 Cost Category 1000000 Cost Category 1100000 Cost Category 1200000 Cost Category 1300000 Cost Category 1400000 Cost Category 1500000 Total Cost of Goods2 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 20028 800 Add Cost categories click here then Unhide Expense Salary expenses 6006006001 8006006006001 8006006006001 8006006006001 8007 200 Payroll Taxes5905905901 7705905905901 7705905905901 7705905905901 7707 080 Advertising5805805801 7405805805801 7405805805801 7405805805801 7406 960 Maintanence5705705701 7105705705701 7105705705701 7105705705701 7106 840 Accounting Finance5605605601 6805605605601 6805605605601 6805605605601 6806 720 Travel5505505501 6505505505501 6505505505501 6505505505501 6506 600 Depreciation5405405401 6205405405401 6205405405401 6205405405401 6206 480 Rent Lease5305305301 5905305305301 5905305305301 5905305305301 5906 360 Delivery Expenses5205205201 5605205205201 5605205205201 5605205205201 5606 240 Utilities Telephone5105105101 5305105105101 5305105105101 5305105105101 5306 120 Insurance5005005001 5005005005001 5005005005001 5005005005001 5006 000 Property Taxes4904904901 4704904904901 4704904904901 4704904904901 4705 880 Interest00000 Office Expenses00000 Profit Loss Statement Current Year Plan 2013ABC Company OPEN TO DEMO USERS CategoryJanFebMar1QAprMayJun2QJulAugSep3QOctNovDec4QFull Year Amortization00000 Total Expense6 5406 5406 54019 6206 5406 5406 54019 6206 5406 5406 54019 6206 5406 5406 54019 62078 480 Add Expense categories click here then Unhide Profit14 46014 46014 46043 38014 46014 46014 46043 38014 46014 46014 46043 38014 46014 46014 46043 380173 520 Profit Loss Statement Current Year Actual 2013ABC Company Please purchase the Business Planner to access this sheet CategoryJanFebMar1QAprMayJun2QJulAugSep3QOctNovDec4QFull Year Sales Product 11212月月 99 992 5002 5502 6007 6502 6502 7002 7508 1002 8002 8502 9008 5502 9503 0003 0509 00033 300 Product 21212月月 99 992 4002 4502 5007 3502 5502 6002 6507 8002 7002 7502 8008 2502 8502 9002 9508 70032 100 Product 31212月月 99 992 3002 3502 4007 0502 4502 5002 5507 5002 6002 6502 7007 9502 7502 8002 8508 40030 900 Product 41212月月 99 992 2002 2502 3006 7502 3502 4002 4507 2002 5002 5502 6007 6502 6502 7002 7508 10029 700 Product 51212月月 99 992 1002 1502 2006 4502 2502 3002 3506 9002 4002 4502 5007 3502 5502 6002 6507 80028 500 Product 61212月月 99 992 0002 0502 1006 1502 1502 2002 2506 6002 3002 3502 4007 0502 4502 5002 5507 50027 300 Product 71212月月 99 991 9001 9502 0005 8502 0502 1002 1506 3002 2002 2502 3006 7502 3502 4002 4507 20026 100 Product 81212月月 99 991 8001 8501 9005 5501 9502 0002 0506 0002 1002 1502 2006 4502 2502 3002 3506 90024 900 Product 91212月月 99 991 7001 7501 8005 2501 8501 9001 9505 7002 0002 0502 1006 1502 1502 2002 2506 60023 700 Product 101212月月 99 991 6001 6501 7004 9501 7501 8001 8505 4001 9001 9502 0005 8502 0502 1002 1506 30022 500 Product 111212月月 99 991 5001 5501 6004 6501 6501 7001 7505 1001 8001 8501 9005 5501 9502 0002 0506 00021 300 Product 121212月月 99 991 4001 4501 5004 3501 5501 6001 6504 8001 7001 7501 8005 2501 8501 9001 9505 70020 100 Sales Category 131212月月 99 9900000 Sales Category 141212月月 99 9900000 Sales Category 151212月月 99 9900000 Total Sales23 40024 00024 60072 00025 20025 80026 40077 40027 00027 60028 20082 80028 80029 40030 00088 200320 400 Add Sales categories click here then Unhide Cost of Goods Salary1212月月 99 995005005001 5005055055051 5155105105101 5305155155151 5456 090 Benefits1212月月 99 994904904901 4704954954951 4855005005001 5005055055051 5155 970 Travel1212月月 99 994804804801 4404854854851 4554904904901 4704954954951 4855 850 Contractor cost1212月月 99 994704704701 4104754754751 4254804804801 4404854854851 4555 730 Other1212月月 99 994604604601 3804654654651 3954704704701 4104754754751 4255 610 Cost Category 61212月月 99 9900000 Cost Category 71212月月 99 9900000 Cost Category 81212月月 99 9900000 Cost Category 91212月月 99 9900000 Cost Category 101212月月 99 9900000 Cost Category 111212月月 99 9900000 Cost Category 121212月月 99 9900000 Cost Category 131212月月 99 9900000 Cost Category 141212月月 99 9900000 Cost Category 151212月月 99 9900000 Total Cost of Goods2 4002 4002 4007 2002 4252 4252 4257 2752 4502 4502 4507 3502 4752 4752 4757 42529 250 Add Cost categories click here then Unhide Expense Salary expenses 1212月月 99 996006006001 8006256256251 8756506506501 9506756756752 0257 650 Payroll Taxes1212月月 99 995905905901 7706156156151 8456406406401 9206656656651 9957 530 Advertising1212月月 99 995805805801 7406056056051 8156306306301 8906556556551 9657 410 Maintanence1212月月 99 995705705701 7105955955951 7856206206201 8606456456451 9357 290 Accounting Finance1212月月 99 995605605601 6805855855851 7556106106101 8306356356351 9057 170 Travel1212月月 99 995505505501 6505755755751 7256006006001 8006256256251 8757 050 Depreciation1212月月 99 995405405401 6205655655651 6955905905901 7706156156151 8456 930 Rent Lease1212月月 99 995305305301 5905555555551 6655805805801 7406056056051 8156 810 Delivery Expenses1212月月 99 995205205201 5605455455451 6355705705701 7105955955951 7856 690 Utilities Telephone1212月月 99 995105105101 5305355355351 6055605605601 6805855855851 7556 570 Insurance1212月月 99 995005005001 5005255255251 5755505505501 6505755755751 7256 450 Property Taxes1212月月 99 994904904901 4705155155151 5455405405401 6205655655651 6956 330 Interest1212月月 99 9900000 Profit Loss Statement Current Year Actual 2013ABC Company Please purchase the Business Planner to access this sheet CategoryJanFebMar1QAprMayJun2QJulAugSep3QOctNovDec4QFull Year Office Expenses1212月月 99 9900000 Amortization1212月月 99 9900000 Total Expense6 5406 5406 54019 6206 8406 8406 84020 5207 1407 1407 14021 4207 4407 4407 44022 32083 880 Add Expense categories click here then Unhide Profit14 46015 06015 66045 18015 93516 53517 13549 60517 41018 01018 61054 03018 88519 48520 08558 455207 270 Profit Loss Statement Prior Year Actual 2012ABC Company Please purchase the Business Planner to access this sheet CategoryJanFebMar1QAprMayJun2QJulAugSep3QOctNovDec4QFull Year Sales Product 102 5002 5002 5007 5002 5002 5002 5007 5002 5002 5002 5007 5002 5002 5002 5007 50030 000 Product 202 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 20028 800 Product 302 3002 3002 3006 9002 3002 3002 3006 9002 3002 3002 3006 9002 3002 3002 3006 90027 600 Product 402 2002 2002 2006 6002 2002 2002 2006 6002 2002 2002 2006 6002 2002 2002 2006 60026 400 Product 502 1002 1002 1006 3002 1002 1002 1006 3002 1002 1002 1006 3002 1002 1002 1006 30025 200 Product 602 0002 0002 0006 0002 0002 0002 0006 0002 0002 0002 0006 0002 0002 0002 0006 00024 000 Product 701 9001 9001 9005 7001 9001 9001 9005 7001 9001 9001 9005 7001 9001 9001 9005 70022 800 Product 801 8001 8001 8005 4001 8001 8001 8005 4001 8001 8001 8005 4001 8001 8001 8005 40021 600 Product 901 7001 7001 7005 1001 7001 7001 7005 1001 7001 7001 7005 1001 7001 7001 7005 10020 400 Product 1001 6001 6001 6004 8001 6001 6001 6004 8001 6001 6001 6004 8001 6001 6001 6004 80019 200 Product 1101 5001 5001 5004 5001 5001 5001 5004 5001 5001 5001 5004 5001 5001 5001 5004 50018 000 Product 1201 4001 4001 4004 2001 4001 4001 4004 2001 4001 4001 4004 2001 4001 4001 4004 20016 800 Sales Category 13000000 Sales Category 14000000 Sales Category 15000000 Total Sales23 40023 40023 40070 20023 40023 40023 40070 20023 40023 40023 40070 20023 40023 40023 40070 200280 800 Add Sales categories click here then Unhide Cost of Goods Salary1212月月 99 995005005001 5005005005001 5005005005001 5005005005001 5006 000 Benefits1212月月 99 994904904901 4704904904901 4704904904901 4704904904901 4705 880 Travel1212月月 99 994804804801 4404804804801 4404804804801 4404804804801 4405 760 Contractor cost1212月月 99 994704704701 4104704704701 4104704704701 4104704704701 4105 640 Other1212月月 99 994604604601 3804604604601 3804604604601 3804604604601 3805 520 Cost Category 61212月月 99 9900000 Cost Category 71212月月 99 9900000 Cost Category 81212月月 99 9900000 Cost Category 91212月月 99 9900000 Cost Category 101212月月 99 9900000 Cost Category 111212月月 99 9900000 Cost Category 121212月月 99 9900000 Cost Category 131212月月 99 9900000 Cost Category 141212月月 99 9900000 Cost Category 151212月月 99 9900000 Total Cost of Goods2 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 2002 4002 4002 4007 20028 800 Add Cost categories click here then Unhide Expense Salary expenses 1212月月 99 996006006001 8006006006001 8006006006001 8006006006001 8007 200 Payroll Taxes1212月月 99 995905905901 7705905905901 7705905905901 7705905905901 7707 080 Advertising1212月月 99 995805805801 7405805805801 7405805805801 7405805805801 7406 960 Maintanence1212月月 99 995705705701 7105705705701 7105705705701 7105705705701 7106 840 Accounting Finance1212月月 99 995605605601 6805605605601 6805605605601 6805605605601 6806 720 Travel1212月月 99 995505505501 6505505505501 6505505505501 6505505505501 6506 600 Depreciation1212月月 99 995405405401 6205405405401 6205405405401 6205405405401 6206 480 Rent Lease1212月月 99 995305305301 5905305305301 5905305305301 5905305305301 5906 360 Delivery Expenses1212月月 99 995205205201 5605205205201 5605205205201 5605205205201 5606 240 Utilities Telephone1212月月 99 995105105101 5305105105101 5305105105101 5305105105101 5306 120 Insurance1212月月 99 995005005001 5005005005001 5005005005001 5005005005001 5006 000 Property Taxes1212月月 99 994904904901 4704904904901 4704904904901 4704904904901 4705 880 Interest1212月月 99 9900000 Office Expenses1212月月 99 9900000 Profit Loss Statement Prior Year Actual 2012ABC Company Please purchase the Business Planner to access this sheet CategoryJanFebMar1QAprMayJun2QJulAugSep3QOctNovDec4QFull Year Amortization1212月月 99 9900000 Total Expense6 5406 5406 54019 6206 5406 5406 54019 6206 5406 5406 54019 6206 5406 5406 54019 62078 480 Add Expense categories click here then Unhide Profit14 46014 46014 46043 38014 46014 46014 46043 38014 46014 46014 46043 38014 46014 46014 46043 380173 520 Profit Loss Statement Year to Year vs Plan NovemberABC Company Compare Period SELECT COMPARISON PERIOD Category2013 Acts2012 Acts2013 vs 20122013 of 20122013 Acts2013 Plan2013 vs Plan2013 of Plan Sales Product 13 0002 500500120 3 0002 500500120 Product 22 9002 400500121 2 9002 400500121 Product 32 8002 300500122 2 8002 300500122 Product 42 7002 200500123 2 7002 200500123 Product 52 6002 100500124 2 6002 100500124 Product 62 5002 000500125 2 5002 000500125 Product 72 4001 900500126 2 4001 900500126 Product 82 3001 800500128 2 3001 800500128 Product 92 2001 700500129 2 2001 700500129 Product 102 1001 600500131 2 1001 600500131 Product 112 0001 500500133 2 0001 500500133 Product 121 9001 400500136 1 9001 400500136 Sales Category 13000000 Sales Category 14000000 Sales Category 15000000 Total Sales29 40023 4006 000126 29 40023 4006 000126 Add Sales categories click here then Unhide Cost of Goods Salary51550015103 51550015103 Benefits50549015103 50549015103 Travel49548015103 49548015103 Contractor cost48547015103 48547015103 Other47546015103 47546015103 Cost Category 6000000 Cost Category 7000000 Cost Category 8000000 Cost Category 9000000 Cost Category 10000000 Cost Category 11000000 Cost Category 12000000 Cost Category 13000000 Cost Category 14000000 Cost Category 15000000 Total Cost of Goods2 4752 40075103 2 4752 40075103 Add Cost categories click here then Unhide November Profit Loss Statement Year to Year vs Plan NovemberABC Company Compare Period SELECT COMPARISON PERIOD Category2013 Acts2012 Acts2013 vs 20122013 of 20122013 Acts2013 Plan2013 vs Plan2013 of Plan November Expense Salary expenses 67560075113 67560075113 Payroll Taxes66559075113 66559075113 Advertising65558075113 65558075113 Maintanence64557075113 64557075113 Accounting Finance63556075113 63556075113 Travel62555075114 62555075114 Depreciation61554075114 61554075114 Rent Lease60553075114 60553075114 Delivery Expenses59552075114 59552075114 Utilities Telephone58551075115 58551075115 Insurance57550075115 57550075115 Property Taxes56549075115 56549075115 Interest000000 Office Expenses000000 Amortization000000 Total Expense7 4406 540900114 7 4406 540900114 Add Expense categories click here then Unhide Profit19 48514 4605 025135 19 48514 4605 025135 Balance SheetPlease purchase Business Planner to access this sheetABC Company ActualActualActualPlanPlanPlanPlanPlan Category20082009201020112012201320142015 Current Assets Cash20 00030 00040 00050 00060 00070 00080 00090 000 Accounts receivable4 0004 0004 0004 0004 0004 0004 0004 000 Inventory500500500500500500500500 Prepaid expenses500500500500500500500500 Deferred income tax750750750750750750750750 Short term investments Other Other Total current assets25 75035 75045 75055 75065 75075 75085 75095 750 Fixed Assets Long term investments5 0005 0005 0005 0005 0005 0005 0005 000 Property plant and equipment15 00015 00015 00015 00015 00015 00015 00015 000 Less accumulated depreciation 3 000 3 000 3 000 3 000 3 000 3 000 3 000 3 000 Long term cash investments2 0002 0002 0002 0002 0002 0002 0002 000 Equity investments Intangible assets Other Other Total fixed assets19 00019 00019 00019 00019 00019 00019 00019 000 Other Assets Other4 0004 0004 0004 0004 0004 0004 0004 000 Other4 0004 0004 0004 0004 0004 0004 0004 000 Other4 0004 0004 0004 0004 0004 0004 0004 000 Total Other Assets12 00012 00012 00012 00012 00012 00012 00012 000 Total Assets56 75066 75076 75086 75096 750106 750116 750126 750 Current Liabilities Accounts payable5 0005 0005 0005 0005 0005 0005 0005 000 Short term loans Income taxes payable2 0002 0002 0002 0002 0002 0002 0002 000 Sales taxes payable500500500500500500500500 Other taxes payable Accrued salaries and wages500500500500500500500500 2008 Unearned revenue Current portion of long term debt Other Other Total current liabilities8 0008 0008 0008 0008 0008 0008 0008 000 Long Term Liabilities Long term debt10 00010 00010 00010 00010 0