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.
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
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.
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
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.
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
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
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
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