Accounting Bundle - Useful Excel Templates for Accounting Department

Description
These tools have a wide range of target users that go all the way up to accounting managers and/or CFO and down to simple data entry level users.

Models Included: 

3-Statement Modeling Helper for Sales and Purchases on Account
https://www.eloquens.com/tool/Dd45snQK/finance/accounting/3-statement-modeling-sales-on-account-and-inventory-forecasting



General Loan Amortization (static and line-of-credit)
https://www.eloquens.com/tool/zP5PTMzM/finance/amortization-depreciation-excel-templates/general-amortization-schedule-for-startups



Payroll KPIs
https://www.eloquens.com/tool/LR4mU51Q/leadership-hr-human-resources-tips-and-methods/payroll-templates/payroll-kpi-tracker



Adjusted Cost Basis Calculator
https://www.eloquens.com/tool/2aqli1lk/finance/real-estate/adjusted-cost-basis-helper


Job Cost and Bidding Calculator
https://www.eloquens.com/tool/BxELUZwA/finance/cost-analysis-spreadsheets-templates/job-costing-estimator-and-bidding-template



Cost Segregation Study Analysis 
https://www.eloquens.com/tool/ZVLAhgVD/finance/cost-analysis-spreadsheets-templates/cost-segregation-study-100-slots

COGS Inventory Template - (FIFO Based) 
https://www.eloquens.com/tool/3BgVCy0x/finance/inventory-management-excel-templates/fifo-based-cogs-inventory-valuation-template-in-excel

WACC and DCF Analysis
https://www.eloquens.com/tool/0ayECwYB/finance/capital-budgeting/weighted-average-cost-of-capital-dcf-analysis

Depreciation Recapture Analysis
https://www.eloquens.com/tool/GDXjtYdm/finance/accounting/depreciation-recapture-tax-liability-model

Expense Tracker
https://www.eloquens.com/tool/Y3RvSJ3z/finance/excel-tips/excel-template-expense-tracking

Financial Statement Creator Template - Accrual or Cash Basis
https://www.eloquens.com/tool/KKJGI9bD/finance/cash-flow-excel-template/create-your-own-financial-statements-accrual-or-cash-basis

General Contractor KPI Tracker for Gross Margins
https://www.eloquens.com/tool/jk5efjP7/finance/construction-excel-templates/kpi-dashboard-construction-business

Cash Conversion Cycle 
https://www.eloquens.com/tool/yb4zcLAb/finance/accounting/cash-conversion-cycle-ccc-quarterly-tracker-template-in-excel

Payroll Tracker and Calculator 
https://www.eloquens.com/tool/NbJ9UP8X/leadership-hr-human-resources-tips-and-methods/human-resources-methods-tools-templates/payroll-calculator-budget-vs-actual-analysis-included

Budget vs. Actual 
https://www.eloquens.com/tool/kkvmspmM/finance/budgeting-excel-templates/general-budget-vs-actual-template

Inventory Within a 3-Statement Financial Model 
https://www.eloquens.com/tool/xraEhbQ4/finance/inventory-management-excel-templates/integrating-inventory-into-a-3-statement-financial-model

Lending Business or P2P Lending Participant 
https://www.eloquens.com/tool/jDaKIwme/startups/financial-models/10-year-lending-business-startup-model-scaling-3-loan-types

3-Statement Financial Model For Startups 
https://www.eloquens.com/tool/rGaMS7N3/finance/three-statement-financial-models/startup-3-statement-financial-model-general-use-excel

Accounts Receivable and Payable Tracking 
https://www.eloquens.com/tool/7lbeT3Nk/finance/accounts-receivable-excel-model-templates/accounts-receivable-and-payable-invoice-tracking-excel-model-template

Manufacturing Sensitivity Analysis (with data tables)
https://www.eloquens.com/tool/JvPpIgRa/finance/manufacturing-excel-templates/manufacturing-business-analyzer-price-volume-break-even-sensitivity-tables

Volume Discount Pricing Tool
https://www.eloquens.com/tool/lgGqF5LZ/marketing/pricing/volume-pricing-discount-sensitivity-analysis

Inventory Management with Google Sheets and Multiple Locations
https://www.eloquens.com/tool/pdaAfyzn/finance/inventory-management-excel-templates/google-sheets-inventory-management-system

Inventory Tracking: Multiple Locations Excel Version
https://www.eloquens.com/tool/KrbiqN/finance/inventory-management-excel-templates/inventory-tracking-excel-template-multiple-locations

Inventory Template Simplified 
https://www.eloquens.com/tool/vM3tjY/finance/inventory-management-excel-templates/simple-in-out-inventory-management-excel-template-1-location

Inventory Restocking Cash Flow Management 
https://www.eloquens.com/tool/kq0tK5/finance/inventory-management-excel-templates/inventory-cash-flow-management-up-to-36-month-forecast

Inventory Reordering Management
https://www.eloquens.com/tool/01PPcLAA/finance/inventory-management-excel-templates/inventory-manager-for-re-order-planning-excel-model

Profit / Loss and Cash Flow Tracking in Real Time
https://www.eloquens.com/tool/km9DIMZQ/finance/financial-reporting-templates/profit-loss-and-cash-flow-tracking-weekly-monthly-annually-template

Depreciation Expense Tracker
https://www.eloquens.com/tool/Kye4iKmv/finance/amortization-depreciation-excel-templates/depreciation-compare-tool-straight-line-vs-double-declining-balance

Project Management / Milestone Tracker and Visualization
https://www.eloquens.com/tool/ab03Te1K/leadership-hr-human-resources-tips-and-methods/project-management-methodologies-and-frameworks/project-management-tool

Royalty Licensing Analysis
https://www.eloquens.com/tool/vdNXsRwk/finance/financial-forecasting-models/royalty-licensing-model

Equipment Purchase ROI Analysis/Feasibility
https://www.eloquens.com/tool/Bx7EUZmw/jason-varner-smarthelping/new-equipment-cost-benefit-analysis

Staffing / Personnel Cost Planner
https://www.eloquens.com/tool/KmPdfBZr/leadership-hr-human-resources-tips-and-methods/payroll-templates/personnel-planner-up-to-900-employees

90-Day Cash Flow Manager
https://www.eloquens.com/tool/XDgPh1eL/finance/cash-flow-excel-template/real-time-cash-flow-manager

Loan Portfolio Analysis
https://www.eloquens.com/tool/5aybCZ12/finance/loan-amortization-schedule-excel-templates/loan-portfolio-analysis-template

Some of the tools come with a Google Sheet version and Excel version. On those, look for the G sheet link on the instructions tab. After following that link, hit File > Make a Copy for your own editable version. 

All the templates are fully editable and unlocked. You must have a free Gmail account to use the Google Sheet spreadsheets.The most complex template out of all of these is the FIFO Cost of Goods Sold logic. It is one of the most satisfying pieces of programming I have ever done in Excel and should prove very useful for any Accountant trying to quickly figure out cost per unit and total COGS value per month based on multiple purchases and sales when using the FIFO Accounting method.

Want more templates? Check out this:
- All Templates Bundle: https://www.eloquens.com/tool/P8Y4TX4v/finance/financial-forecasting-models/financial-models-120-useful-and-usable-logic