Accounting Tools for Excel

Accounting Tools

+1 This Page

Accounts Receivable Aging

Quickly calculate the aging of accounts receivable with this AR Aging template. Toggle the aging between aged by due date and aged by invoice date. Use this template to assist in the AR collection process and evaluate your allowance for bad debts. Read More and Download this AR Aging Template.

Balance Sheet Vertical Analysis

This balance sheet template contains many line items commonly found in a classified balance sheet. Setup to contain a vertical analysis, it provides for quick and easy evaluation in a year over year comparison. Read More and Download this Balance Sheet Template

Income Statement Vertical Analysis

This excel template should simplify the preparation of a comparative Income Statement. Template includes a vertical analysis. Read More and Download this Income Statement Template

Bank Reconciliation

This excel template should simplify the preparation of a your monthly bank reconciliation. Conditional formatting has been added to identify balances that don't balance, dynamic formulas have been utilized to decrease the chance of error due to adding and removing rows/columns. Read More and Download this Bank Reconciliation.

Percentage of Completion Schedule

This percentage of completion schedule has been built using an excel table; as rows are added all of the necessary formulas are automatically populated and each row alternates color (the template is setup with blue and white alternating row colors, but you can quickly adjust the color scheme to your choosing). Read More & Download Template

Statement of Cash Flows

This excel template should simplify the preparation of a statement of cash flows. Conditional formatting has been added to identify balances that don't balance but should, alternating row color, and data entry. In addition, dynamic formulas have been included to decrease the chance of error due to adding and removing rows/columns. Read More & Download Template.

Track Open Invoices for Follow-up

Use this excel template to track when follow-up is needed on outstanding invoices. Enter the customer specific information and the length of time until follow-up is necessary and the formulas do the rest. This spreadsheet uses tables only available in Excel 2007 and later. Read More & Download Template

Volatility Calculator

This volatility calculator can be used to establish the volatility of a publicly traded stock based on the inputs you provide. Use this spreadsheet to price options. The historical prices are input on one tab , and then you fill in the remaining inputs shown to the left and the volatility is calculated. Read More and Download Template

Commitment Template

Commonly accountants are required to report a 5 year schedule of commitments, such schedules are susceptible to error as these calculations are prepared manually and summarized information is entered or start and end dates are off. Read More and Download Template

Black Scholes - European Model

This Black Scholes Model will calculate the price of European-style dividend options. Enter the inputs outlined in the red border and the option price is automatically calculated. Read More & Download the Black Scholes Model Here

Proof of Cash Template

Auditors love the idea of a four-column bank reconciliation also known as a Proof of Cash because of its ability to shed light on error, misstatements and fraud. Template includes example data and helpful hints in completing a Proof of Cash. Read More and Download Template

SpreadsheetShoppe