In Black & White

Freeing Finance, Budget, Audit & Treasury Departments from Drudgery One Article at a Time

University of the Fraser Valley Automates Financial Reporting

University of the Fraser Valley Automates Financial Reporting

  • Jamie Black
  • Success Stories
  • minute(s)In the beautiful Fraser River Valley, just east of Vancouver, British Columbia, lies the University of the Fraser Valley (UFV), a fully accredited, public university enrolling approximately 15,000 each year. UFV is consistency ranked as one of the top universities in Canada by the Globe and Mail’s Canadian University Report. In addition to its main campus, the University supports four satellite campuses throughout the region and has a growing presence in Chandigarh, India. UFV implemented CaseWare Working Papers and ASPE Financials as part of an effort to automate and streamline its financial reporting. University Enrolls CaseWare UFV first saw Working Papers demonstrated at a finance conference, where CaseWare consultants F.H. Black & Company Incorporated were highlighting the success of another university’s experience with the solution. “We had heard of CaseWare, of course,” says Nicole Adams, CGA, the Associate Director of Finance for UFV. “As an accountant, I know its reputation well. Many Canadian accountancy firms use CaseWare. Until then, though, we hadn’t really thought of its application to a university like ours. It’s actually a good fit for us.” Style and Substance Like many institutions, UFV relied on spreadsheets and text documents to produce its financial statements. And like many institutions, it struggled to ensure that the reports produced in this way were accurate and properly formatted. Adams says the university has seen a huge improvement in the professionalism of its financial statements. “There is consistency in fonts, columns, spacing, and tables that was very hard to maintain in Word® and Excel®. The statements truly look great.” While the overall appearance of the financial statements is important, accuracy is the critical factor, and using Working Papers gives the university even greater confidence in the quality of its statements. “Adjustments are simple to complete and flow automatically through the statements so we’re assured everything is updated correctly,” explains Adams. “Our schedules and working papers are linked to the statements which efficiently organizes the statements and supporting documentation in one place.” PSAB Compliance Simplified In addition to the university’s desire to automate and streamline its financial reporting tasks, it was facing a required transition to the Public Sector Accounting Standards (PSAS), necessitating significant changes to the way it had been presenting its financial statements. In order to meet transition deadlines, UFV engaged F.H. Black & Company Incorporated to assist with the implementation of Working Papers and to customize the templates to accommodate the university’s Public Sector Accounting Board (PSAB) compliant financial statements. “It went very smoothly,” Adams recalls. “F.H. Black & Company Incorporated understood our goals and objectives and got us operational very quickly. We continue to receive excellent support from them. They go above and beyond to assist us.” Year-Round Value In addition to the annual financial statements, UFV has leveraged its investment in and knowledge of the solution to help produce quarterly reports as well. The university downloads trial balance data from its SCT Banner® accounting system and uploads that data into Working Papers. “We can then produce a quarterly balance sheet and statement of operations,” says Adams. “CaseWare is proving to also be a great tool for interim reporting and being able to use it in this way streamline quarterly reporting requirements.” Time Savings With the efficiencies provided by CaseWare, UFV is able to quickly respond to auditors’ questions and efficiently make late period adjustments. “We’ve shaved a lot of time off the creation of the statements themselves as well,” says Adams. “We can have draft-ready financial statements in just a couple of days.” Adams concludes, “We consider the implementation of CaseWare for our financial statements and supporting documentation a complete success.” F.H. Black & Company Incorporated has helped dozens of governments, universities, large corporations and accounting firms automate their financial reporting tasks. Interested in learning more about what CaseWare Working Papers could do for your organization?Take the first step and sign up for a webinar today. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
University of Fraser Valley uses CaseWare Working Papers to automate PSAB financial reporting
READ MORE
CaseWare Tips and Tricks: 5 Steps to Solving Out of Balance Issues

CaseWare Tips and Tricks: 5 Steps to Solving Out of Balance Issues

  • Jamie Black
  • Tips and Tricks
  • minute(s)Everyone responsible for financial reporting wants as fast and as simple a quarter-end or year-end as possible. Your organization uses CaseWare Working Papers specifically to achieve this goal. It has many excellent tools to prevent mistakes and reduce the time invested by your finance team. It is THE tool that makes finance look good and prevents them from having to spend their evenings and weekends in the office. An obvious prerequisite for this faster financial reporting is starting off with good data. No system, no matter how amazing, is going to help if we start off with a GL that doesn't balance. As a result, another of our CaseWare Tips and Tricks is to immediately confirm the GL in CaseWare Working Papers foots to zero when you have completed importing your account balances. To do this, click on the Trial Balance button on the Navigation toolbar. Now look at the very last line (note it may take a moment to calculate if you have a very large GL). It should appear like this: Depending on your budgeting practices, it may be the case that your budget values may not foot to zero so in this case, a non-zero balance in the budget column could be acceptable. But what if one or more of the "actual" columns do not foot to zero? Step 1 - Repair File On occasion - typically due to either a crash of a work station or a network interruption - your Working Paper's file may need a recalculation. This is essentially what the Repair File feature does. On the Tools tab of the Ribbon, select Repair File. Click all the boxes and select OK. Working Papers will prompt you to make a back up of your data file. We strongly recommend you to say "YES" to this prompt. The repair file may take a few moments, and you will see a number of progress bars appear on your screen. Once completed, go back and review the totals at the bottom of the Working Trial Balance and see if they are now set to zero. If they are now all set to zero, you are able to carry on with the month / quarter / year end. If not, continue on to step 2. Step 2 - Determine What is Out of Balance Review the total row of the Working Trial Balance and note exactly which columns do not equal $0.00. Budget Column If it is the budget column, as we mentioned above, you may not have a problem. Adjustments Column If the Adjustments column does not foot to zero, it means one or more of your adjusting entries are not in balance. You can quickly find these entries by choosing Diagnostics from the Tools tab of the ribbon. Set the Report type to "Out of Balance Entries," choose the 1st option and click the OK button. Any entries that are out of balance will be listed and you can now review and correct them. Opening Balance Column If the column that is out of balance is the Opening Balance column, there could be a number of causes and further investigation is warranted. One thing to be aware of is that this column is editable. Meaning we can not exclude the possibility that someone modified one or more accounts intentionally or otherwise. With this one point in mind, we encourage our clients to see if there are other discernible causes. Step 3 - Sum balance columns in Excel Most of our clients import their end-of-period balances into the Opening Balance column of Working Papers from a Microsoft Excel file, and the remainder of this guide is written based on that common scenario. If you're out of balance after Working Papers generated an opening balance as part of the year-end close process, or if you are importing the Opening Balance directly from an accounting package, contact us to help in troubleshooting your file. When you have populated the Opening Balance column via an import from Excel, it makes sense to check the Excel file to confirm that the balances being imported were good to begin with (i.e. sum to zero). If the Excel file is also out of balance, there could be a number of causes. To start, determine if there is a setting in your ERP that excludes some accounts from the export to Excel. Even scarier, perhaps the GL in your ERP system does not balance to zero.You will want to check on that too. If the balance columns in Excel do balance to zero, move on to Step 4. Step 4 - Look for duplicate accounts in Excel By default if CaseWare encounters two accounts with the same entity and account number it behaves in a very specific way. To understand, let's consider the following example: In the above example, on import, CaseWare would update the Opening Balance column of account 101 Petty Cash to $200. Then when it comes across the second instance of account 101 (with the same entity) on the fourth row, it will update the balance to $1,000. The result is your Working Trial Balance will be out out of balance by $200. Now you must determine why you are getting the same account multiple times in your Excel file. This will likely require some investigation back in your ERP system. In the event that you determine that it is appropriate to have the same account / entity combination presented multiple times with different values, you will need to modify the import layout file to accumulate balances. On the last page of the Excel File Import wizard titled "Advanced Specifications," you need to enable the checkbox for "Accumulate Balances." With this setting enabled, in the above scenario CaseWare will add together the $1,000 balance and the $200, keeping the Working Trial Balance footing to zero. If you could not find any duplicate accounts in Excel, we are now left with three possible causes: Manual over-ride. Intentionally or unintentionally a balance was changed in the Opening Balance column in CaseWare some time after import. Changed Entity - The entity assigned to an account was changed in CaseWare after import.The reason this is a problem may not be immediately apparent however. Consider the following example: On import account, account 107 was associated with Entity GG. Some time after to import, the entity was changed. You may have done this to move a balance from one of your consolidation entities to another. Imagine you opened the "Assign Entities" interface from the Account Ribbon and dragged 101 from the "GG" entity to the "PS" entity. On re-import, if the Excel file still has the account being assigned to GG, CaseWare will not update the manually changed PS-107. It will instead ADD a "new" account GG-107, thereby throwing the GL out of balance. Omitted Accounts - One of the accounts that has a balance in CaseWare is no longed included in Excel file you are importing. This is a problem because by default, CaseWare only updates account values that are in the Excel file. Thus, if an account is not in the Excel file, the old balance will be retained, throwing your GL out of balance. The solution to all three of these final causes is the same, a re-import done properly. Step 5 - Delete Opening Balance column and Re-Import If you have gotten this far, the final step is to re-import your Excel file. But first, we will eliminate existing balances (Note - now is a great time to take a backup of your CaseWare file!). In the Working Trial Balance, right-click on the Opening Balance column header. Choose "Select Column". Then press the Delete key on your keyboard. This will set every account balance to $0. Now you are ready to re-do your import. 99.9% of the time these steps will guarantee you a balanced GL after the import completes. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
CaseWare Tips and Tricks - solve out of balance issues easily to ensure a fast, trouble-free year end
READ MORE
City of Fort Saskatchewan Automates Financial Reporting With CaseWare

City of Fort Saskatchewan Automates Financial Reporting With CaseWare

  • Jamie Black
  • Success Stories
  • minute(s)A Success Story from our 2011 Fort Saskatchewan CaseWare Implementation The City of Fort Saskatchewan in the province of Alberta provides its almost 20,000 residents with a multitude of services and programs and receives its $45 million annual operating budget from various sources including property taxes, provincial and federal grants, and user fees. The City’s financial team is charged with many tasks including preparing year-end processes, working papers and financial statements, and is assisted in its tasks by CaseWare Working Papers, and CaseWare ASPE Financials. A Time-Consuming Process Until recently, the City’s staff relied primarily on spreadsheets to assemble the annual financial statements. “We experienced numerous delays preparing the financials,” recalls Mirjam Brett, Finance Director for the City of Fort Saskatchewan. “There were always manual edits and adjustments as we worked to ensure there were no errors. It was an extensive and time-consuming process.” A Favorite Among Accounting Firms The City’s finance team sought to shorten and simplify the entire year-end process. They spoke to colleagues at other municipalities to gain insight from their experiences. “We learned that other municipalities are using CaseWare,” says Holly Omelchuk, Senior Accountant for the City. “And we know CaseWare is used by many accounting firms, including our auditors.” Based on the positive feedback received from colleagues and the product’s reputation, the City moved ahead with the implementation of CaseWare. “We installed the software ourselves but quickly learned that we needed expert advice on setup, and needed training to ensure we used the product correctly and to its fullest potential,” says Mirjam. Expert Advice Enhances Value At a Government Finance Office Association (GFOA) conference, Mirjam met F.H. Black & Company Incorporated, CaseWare authorized trainers and consultants. “We were impressed and asked them to come in and help us,” says Mirjam. “The experience F.H. Black & Company Incorporated consultants have in setting up and using CaseWare is invaluable to us,” notes Mirjam. “The bonus for us was their knowledge and understanding of the internal processes municipalities experience during year-end preparations and the audit. This meant that we didn’t need to spend time explaining how we operate.” Using the import functionality that is built in to CaseWare Working Papers, the City imported its general ledger data and mapped its accounts, recreating the prior year’s financial statements as a test. “It worked! F.H. Black & Company Incorporated provided the training and support to correctly group the accounts, set up the consolidated structure and worked through our year-end process with us,” notes Holly. “Now, our financial statement generation is almost completely automated. We import the data from our accounting software and make all the adjustments in CaseWare,” says Mirjam. “It is much faster to work in CaseWare, easier to troubleshoot and create any on-the-fly reports we need.” All supporting information is scanned and electronically attached to the CaseWare files, eliminating the need for thick file folders of supporting data. Financial Reporting “We feel like we have only skimmed the surface of the power of CaseWare. We plan to utilize it more this year to create monthly financials and quarterly reports. We are looking into using it to help monitor the costs associated with our infrastructure projects.” In addition to using CaseWare to create its annual PSAB-compliant financial statement, the City also is using the software to automate the FIR (Financial Information Return). An unexpected benefit of the CaseWare solution is its role in helping train junior accounting staff members. “They are able to immediately see the effect a journal entry has on the financial statement,” explains Holly. “It helps them understand the logic and relevance of their work.” Cost Savings Mirjam says that CaseWare is saving the City a tremendous amount of time. “Annual report generation used to involve lots of overtime and lots of weekends at the office,” she says. “Since we started using CaseWare, we have reduced overtime.” Holly adds, “It is almost push-button easy. CaseWare is definitely paying for itself.” Now preparing for annual audits is much simpler for the City, and it is anticipated that audit costs will come down in the subsequent years. “Because our auditors also use CaseWare, we can simply hand them a memory stick with our data rather than the stacks of paper files we used to,” explains Mirjam. Recently, Mirjam attended the Western Canada GFOA Conference, and was invited to speak about the City’s experience with CaseWare at the conference. “I was happy to do so. We are very pleased with CaseWare and the efficiencies it brings us,” concludes Mirjam. F.H. Black & Company Incorporated has helped hundreds of municipalities; accounting firms, universities and large corporations automate their financial reporting. Interested in learning more about what CaseWare Working Papers could do for your organization? Take the first step and sign up for a webinar today. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
We have helped hundreds of municipalities, accounting firms, universities & large corporations automate their financial reporting. Here is another one.
READ MORE
CaseWare Working Papers Update (164) Released

CaseWare Working Papers Update (164) Released

  • Jamie Black
  • What's New
  • minute(s)Software: Working Papers Old Version: 2015.00.142 New Version: 2015.00.164 Release Date: Jan 07, 2016 A CaseWare Working Papers update was released last week. We recommend our clients update immediately. Details: This is a maintenance update that includes many improvements & fixes to numerous features: Excel Exports Imports Tax Integration - US & Canada Adjusting Entries Lockdown Check In/Check Out Installation Automatic Documents Document Manager You can access the update here. Subscribe to this blog and receive current CaseWare updates. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
CaseWare Working Papers update (164 ) released with many fixes and improvements
READ MORE
2015 CaseWare Refresher Course: Guarantee yourself a Faster Year End

2015 CaseWare Refresher Course: Guarantee yourself a Faster Year End

  • Jamie Black
  • What's New
  • minute(s)Can you believe it is almost that time of year again? Where did the year go? It may have been 10 - 12 months since you last looked at CaseWare and you may well have repressed all of your memories of the prior year-end! To ensure you are ready and prepared to face the year-end season and beyond, we offer a 2-hour online course designed to re-acclimate you to CaseWare and cover any new features that may have been added since you last used the tool. We will be hosting our annual “CaseWare Refresher Course” on January 22nd, 2016 from 10:00am - 12:00pm Pacific. This training will ensure you are prepared for the coming busy season and help you achieve a faster year-end. Topics to be covered include: What’s new in Working Papers 2015 and Financials Template v1 Performing a year-end close on your Working Papers file Validating roll-forward of statements, schedules and notes Importing 2015 general ledger balances Assigning map numbers and consolidation structure to new accounts Questions from the attendees! It is free-of-charge to all our clients currently on an unlimited support contract. If you are not on an unlimited support contract, the course is $150 plus tax per person. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
Refresher training to ensure you are ready for your 2015 year-end
READ MORE
CaseWare Financials Print Preview Hotfix Released

CaseWare Financials Print Preview Hotfix Released

  • Jamie Black
  • What's New
  • minute(s)Software: CaseWare Financials Version Affected: Financials 13.00 Announcement Date: January 4, 2016 CaseWare International has recently been made aware of an issue where the financial statements stop working when print preview is accessed multiple times in very specific circumstances. The issue is related to the use of the Format 4: Detailed tables of contents and the addition of external documents (e.g. PDFs, Word or Excel) into the financial statements. If you are using version 13 of the Financials template and the Format 4: Detailed tables of contents, a hotfix is available to ensure that you will not encounter this problem. You are able to determine which version of the Table of Contents you are using by navigating to the Table of Contents tab and verifying that the Configuration button in the Properties grouping is present. If the Configuration button is displayed, please contact support@caseware.com to receive the hotfix created to resolve this issue. Subscribe to this blog and receive current CaseWare updates. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
CaseWare Financials hot-fix released to address specific print preview issues in version 13.
READ MORE
Best Practices for Financial Reporting with Excel (Step 2)

Best Practices for Financial Reporting with Excel (Step 2)

  • Jamie Black
  • Excel
  • minute(s)In the last part of this article series, we recommended taking some time to confirm that spreadsheets are the right tool for a specific financial reporting task. If you do conclude that a spreadsheet is the best tool for the job, you have to be careful to set youself up for success. The wide-open nature of Microsoft Excel means there are ample opportunities to "shoot youself in the foot." By following these best practices, you can avoid some of the pitfalls that come with using such a general-purpose tool for your specialized reporting tasks. Let's get started! Step 2: Minimize Data Sources Take a minute and list all the reports your finance department must create in a year. At a minimum your list likely includes: annual financial statements, quarterly statements, management discussion & analysis (MD&A), financial plan or budget documents, actual to budget reports that you present on a monthly or quarterly basis, forecasts where you analyze actuals and project how well you will meet budget, Tens or hundreds of specific purpose reports. Things like bank covenant reporting or provincial reporting (FIR, LGDE, SOPHI) The point is, there are a lot of reports and each one needs to present data slightly differently. More detail in one, less in another. One includes actuals only, this other adds budget data. This one shows capital expenditures as expenses, but another one treats them as assets. Consequently, folks tackle each one of these reports as a discrete task. Consider the example of a finance department who is working to prepare the Q1 financial statements and the accompanying MD&A. The data from the accounting software (often referred to as the ERP system) is exported to begin building the financial statements. In this case, the Excel file becomes the direct data source for the financial statements. When the statements are nearly complete, either the spreadsheet file that houses the financial statements is copied or another export from the accounting software is created so that the team can work on the MD&A. Now imagine the auditor comes back and requires an adjustment be posted. This change needs to effect both files. Not only must finance make the change twice, but there is also now the need to reconcile the data between the two Excel files to ensure that the Financial Statements and MD&A agree. Compare this to an approach where the MD&A is built off the same Excel file. Changes made in one file necessarily effect both the statements and the MD&A. Reconcilliation of the two reports becomes much faster and simplier. While this may seem obvious, we rarely see this practice implemented consistently. In part this is caused by difficulties in sharing an Excel file across multiple users or difficulty in dealing with variations in grouping of data. Whatever the reason, when you consider all the reports that the team tackles, duplication of data sources leads to massive amounts of wasted time regrouping data, adjusting in multiple locations and then reconciling to ensure the values balance across data sources. The very same only different This same best practice of minimizing data sources also applies within a single spreadsheet. Take Cash as our example. Typically, cash needs to be presented in two or three places: a summary line on the balance sheet a summary line at the bottom of the Statement of Cash Flow a detailed breakdown in a Cash and Cash Equivalents note Option 1: Indiscriminate Linking In this option, the focus is on creating the report as quickly as possible. Consequently, there is little discipline applied to how these values are populated. The result is multiple approaches to getting the same value : The note details are populated by summation of GL accounts. The Statement of Cash Flow value is created by summing the lines above. Finally, the Balance Sheet value is based on linking to the total of the note. This is done to ensure the note and Balance Sheet values agree. Option 2: Minimize Data Sources This option focuses on long term benefits instead of speed of initial creation. The focus is on standardization and consistency. Wherever possible values are derived the same way: The note details are populated by summation of GL accounts. The Balance Sheet value is also populated by summation of GL accounts. The Statement of Cash Flow value is created by summing the lines above. This variation in approach is necessary to ensure the integrity of the statement. At first glance these Option 1 and Option 2 may appear equally good. But, having values derived in lots of differing ways can cause numerous complications: Secession planning - If there are a large variety of methods used to populate statements, it can be much more challenging for new staff to use the existing template properly. Less variety = Easier to Learn. Quality control - Consider that if all cells on the balance sheet are consistent, it is easier to review formulas to ensure accuracy and completeness. If there is great variability in the linking methods (and therefore the formulas) review gets much more complicated. Cross-Linking means 0% or 100% - Notes often contain much higher levels of detail than statements or schedules. As a result, notes regularly take more work and therefore time to complete. If the values on the Balance Sheet are linked from notes, your Balance Sheet will remain out-of-balance and unusable until every last line item detail in the notes is in place. Look for our next article "Best Practices for Financial Reporting with Excel - Step 3" where we'll discuss more ways to mitigate the risks inherent in financial reporting using spreadsheets. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
Best Practices for Financial Reporting with Excel Step 2: Minimize Data Sources
READ MORE
Best Practices for Financial Reporting with Excel (Step 1)

Best Practices for Financial Reporting with Excel (Step 1)

  • Jamie Black
  • Excel
  • minute(s)In the first part of this article series, we discussed why spreadsheets can be problematic. In short, spreadsheets are cheap, available and flexible, but they are very high risk! As finance professionals, how do we improve our processes to mitigate the risk but get all the benefits? Step 1: Confirm spreadsheets are the right tool As with anything else, the key is to find the right tool for the job. The simplest way forward is to calculate (accountants love this part) a score. The higher the score, the more you should be looking to find an alternate approach to spreadsheets: Frequency - How many times a year will this tool be used? Users - How many different people will use the tool? Standardization (1-10) - How much change in format is required for each use (see frequency above) Complexity (1-10) - Are we talking about a 10 row spreadsheet or a series of workbooks linked together with hundreds of tabs? Required Accuracy (Percentage) - What percentage of accuracy must be maintained? Multiplying each of these values results in your Value of Replacement (VR) score. Consider an example with one of our clients: They were being asked to forecast performance 3 times a year. They would take data from the General Ledger, export it out into 20 Excel workbooks. Each spreadsheet contained hundreds or thousands of rows. They then distributed those spreadsheets to 20 users . Users had to go row-by-row, assess actuals and develop a model for how to forecast the balance to the end of the year Finally each user returned their spreadsheet to Finance. Finance then combined the spreadsheets back into one workbook and did analysis. Ultimately Finance needed to summarize the data and prepare a final report (tables of data and narrative explanations) to council. Their VR score: 3f x 20u x 8s x 9c x 99%r = 4,277 Now what if this work was very simple? 3f x 20u x 8s x 1c x 99%r = 475 As you can see, the first scenario yields a much higher value for replacement than the second. And by comparing the VR scores of different processes, you can determine which ones to prioritize to yield the most benefit from new tools and automation efforts. For the others, Excel may be the perfect tool for the job. But that doesn't mean you're done - not all spreadsheets are created equal. Look for our next article "Best Practices for Financial Reporting with Excel - Step 2" where we'll begin discussing ways to mitigate the risks inherent in Excel reporting. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
Spreadsheet applications like Excel are incredibly flexible and easy to use tools but if you are not careful, they can kill your career. Step 1 of this process is covered in this article.
READ MORE
Working Papers Update Released

Working Papers Update Released

  • Jamie Black
  • What's New
  • minute(s)Working Papers & Working Papers SmartSync 2015.00.157 Software: Working Papers & Working Papers - SmartSync Old Version: 2015.00.152 New Version: 2015.00.157 Release Date: Nov 24, 2015 Details: This enhancement includes numerous improvements and bug fixes including that improve performance and reliability. You can access the update here (click on the Enhancements tab) Subscribe to this blog and receive current CaseWare updates. © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
New version (2015.00.152) of Working Papers 2015 released
READ MORE
Want a faster, more accurate year-end? Use Working Papers Checklists

Want a faster, more accurate year-end? Use Working Papers Checklists

  • Jamie Black
  • Tips and Tricks
  • minute(s)CaseWare is a flexible reporting and assurance software tool that allows your team to be completely paperless. It's used by financial professionals throughout the world to automate annual, quarterly and monthly reporting. You know that. That's why you bought it. This article is another in our Tips & Tricks series to ensure you to take full advantage of Working Paper's power to get an even faster year, quarter and month end. Why Checklists? We all use checklists in day-to-day life. If I am sent to the grocery store, I need a list. How else could I be expected to remember all the stuff I was sent for? Without a list to refer to as I shop, it's guaranteed to become 2 or 3 trips, wasted time and frustration. So if I need a checklist for something a simple as getting milk & cheese, why would I not use checklists for something as complex as a year-end, quarter-end, or month-end? Especially when getting everything done properly the first time would save everyone (our team AND the auditor) so much time. Alright, we convinced you. Now, if you are going to use checklists they should be in your CaseWare file (everything related to your year/quarter/month end should be in there). And if you have your checklist in Word or Excel or some other program you should consider converting them to a CaseWare Checklist. Two types of Checklists in Working Papers There are two different ways to use checklists in Working Papers. One is obvious and the other less so, but neither are used as extensively as they should be. Here’s how you add checklists to your documents in Working Papers 2015. 1. Program / Checklist Automatic Document In this example, let us imagine we want to create a list for all the tasks we need to complete related to our cash accounts: Select a leadsheet report from the document manager. We'll use "A - Cash" for this example. Right click on the "Cash" document, select the "New" menu item, and then "Automatic Document". A New Document dialog box will open. By default, our new document has a number of A.1 because CaseWare selected that as the next available number after "A". You can change it here if you like. Modify the name of the document to "Cash Checklist." Under Document Type, select "Program/Checklist." Under Format we will select "Checklist - Format 1". Note - if you choose a different option under Format, it will change what columns appear in your checklist. Click "OK". The "Cash Checklist" document will be created directly under the "Cash" leadsheet report. If you made a mistake, you can rename & renumber the document by right clicking on the document name and selecting "Properties". When you double click on our new document, the blank checklist appears ready for you to copy and paste in all of the procedures. In Format 1, the checklist has a column for the person who has completed the task to sign off (Y/N pick list) and a place for his/her initials. The checklist also has columns for document references, explanation and annotation. You can reorder these columns, by selecting the "View" tab of the Ribbon and then selecting the "Re-order Columns" button under view. Move the columns up or down in the list to change the ordering of the columns. These checklists are stored within the Working Papers file allowing multiple people to work on them.Checklists for different sections can be assigned to different staff members avoiding a duplication of efforts while allowing the supervisor to track everyone's progress. 2. Document Manager as the Master Checklist The Document Manager is a list of all the documents in your audit binder. As you ensure that each document is ready for the auditor, sign it off. This puts a check-mark on the document manager. Presto - the Document Manager is your master checklist! To make this even more powerful: Use the Reorder columns feature to make sure that all of the sign-off roles you use are Active Columns. This means that you will see initials & the date the document was signed off on the document Manager. Review the document properties for all the documents you add to CaseWare as support: If you will need this exact document next year, tick the Roll Forward checkbox. If you don't want this exact document in next year's file but you need next year's version of this document, tick the Roll Forward AND Roll Forward as Placeholder. This will reserve a spot for the document in next year's file and is your reminder to add it before giving the file to the auditor. Remove unnecessary documents to have an accurate list of the things you have to complete/prepare as part of your period end work. Clutter just confuses people and wastes time. Ultimately we want to build a system that produces highly repeatable results in as little time as possible. Using the checklist functions in CaseWare Working Papers might be the little feature that solidifies these results for your team! © 2025 FH Black Inc. All rights reserved. Content may not be reproduced, excerpted, distributed, or transmitted without prior written consent.
Often overlooked, using Checklists in your CaseWare file can have major benefits
READ MORE