CPA-ezxl.com has been developed for the growing and progressive CPA firm that is searching for an inexpensive, simple and minimal training solution to "paperless" trial balance workpaper preparation. The interactive worksheets have been developed in familiar accounting centric excel, the common tool of accountants, for ease of use and adaptability.

Paperless Solution / Electronic Workpaper Files:

The excel trial balance (eTB) and lead sheets are prepared in this interactive excel worksheets. Combined with Microsoft’s folder segregation and the increasingly ease and ability to scan documents will allow for a simplistic solution for maintaining easy accessible retention filing and index workpapers in traditional CPA firm policies. Microsoft Excel features sharing workbooks or workspace, which allows multiple concurrent users to update information. This comprehensive collection provides a cost-effective way to standardize your Audit & Accounting workpapers, while allowing collaboration with staff members.

Beginning with the working trial balance (WTB), the excel spreadsheets are designed as familiar accounting workpapers. Adjustments are summarized and automatically posted to the WTB and update the lead schedules. Interactive lead schedule workpapers change based on your inputs and was designed by users for functionality.

Standardization of workpapers allows uniformity and is designed to help in audit, review or compilation. Standard analytics were designed into the lead schedules, to satisfy SSARS 1 compliance and aid in the analytic considerations of audit. Comment notes have been built into workpapers for explanations and "help" feature. Hyperlinks have been placed in workbook for easier navigation. Excel format allows quick customization of templates for specific engagements. Features include trial balance, financial statement template, cash flow analysis, lead schedules, and ratio analysis. The program is designed for the practitioner as a tool in the accounting fieldwork and reporting process.

Data Import/Export/Integration:

Import information from any accounting package that can export data in a text file or Excel format. The import process involves opening the exported file information in Excel, copying and pasting the data from the interim spreadsheet, and pasting it into the corresponding areas of the WTB worksheet. The data should be reviewed for accuracy in the WTB worksheet. Lead schedule references are assigned at the trial balance level and an initial set up in on the lead schedules is required. The lead schedules are reconciled to the WTB, to insure completeness and error check.

Financial Statement Preparation:

The basic trial balance functionality adds lead sheets and other grouping schedules, ratio analysis, debt amortization, and financial statements. The basic financial statement (balance sheet, statement of income, statement of stockholders equity and statement of cash flows) can be prepared through the program. Full financial statements, including the cover page, table of contents, accountant’s report, notes to the financial statements, and supplementary schedules are not created through this program. However, through excel's ability to easily transfer information to word documents allows for additional flexibility in formatting of financial statements.