{"id":959,"date":"2022-07-06T13:09:04","date_gmt":"2022-07-06T20:09:04","guid":{"rendered":"https:\/\/goodreports.ca\/?p=959"},"modified":"2022-07-13T14:29:10","modified_gmt":"2022-07-13T21:29:10","slug":"difficult-to-format-reporting-and-finding-strong-users-of-sage-300-resulted-in-conversion-to-quickbook-enterprise","status":"publish","type":"post","link":"https:\/\/goodreports.ca\/case-studies\/difficult-to-format-reporting-and-finding-strong-users-of-sage-300-resulted-in-conversion-to-quickbook-enterprise\/","title":{"rendered":"Difficult to format reporting and finding strong users of Sage 300 resulted in conversion to QuickBook Enterprise"},"content":{"rendered":"\t\t
Home<\/a> >> Case Studies<\/a><\/strong><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t The selection of QuickBooks Enterprise was already made before the engagement. The senior financial officer for the private school wanted to have a Chartered Professional Accountant with the experience for a QBES implementation.<\/p> Over a few initial planning meetings and sharing of financial statements (like budgets, forecasts, chart of accounts) plus evaluating list items (like products or services, sales taxes, employees, and more), we developed a project plan and guided the team throughout the system conversion.<\/p> Created a new company file, and from the planning conversations, we set the system\u2019s preferences to best fit the school\u2019s normal operations. The most complex part of the build and usually the first component is the Chart of Accounts. The reason for focusing on this piece was that the ordering and nesting of accounts (a \u201cparent-child\u201d database relationship) is the format required by the users for their reporting needs.<\/p> Visit our best practices page to learn about the general setup sequence for QuickBooks.<\/p> After setting up the major functional areas of QBES, the project required the loading of month-end financial balances for ten months of data. When reaching system kick-off, we built a custom-macro to flatten (or translate) 115,000 lines of a complex Sage Accounts Receivable report into a filtered report identifying only the 750 outstanding A\/R transactions that we could then load within minutes. Our consultants use Microsoft Excel VBA programming and special software approved by Intuit to assist in the loading\/editing\/deleting thousands of transaction lines without much need for manual entry.<\/p> In the end, our consultant provided customized training sessions along with a guide for general best practices and examples for the school\u2019s unique use-cases.<\/p> Visit our best practices page to learn about how to maintain QuickBooks for optimal performance.<\/p> The process for accounting system conversion is very complex, sometimes more than the original vendor can manage. We are Chartered Professional Accountants, certified in all QuickBooks platforms, with over a decade of software selection, design, and implementation experience. No software conversion or setup is straightforward; we provide customized solutions to bring it in line with your business.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t The key takeaway to this project is to reconsider your accounting system\u2019s total cost of ownership every 3-5 years or when the system is nearing its optimal capacity (and size). Visit our best practices page<\/a> <\/span>to learn how to maintain a system for optimal performance.<\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":" Home >> Case Studies CaseStudy A private school in the heart of Vancouver chose QuickBooks Enterprise (\u201cQBES\u201d) because of recommendations from senior business advisors. The school used Sage 300 but found that report customization was limited and difficult. The solution was to create a new Chart of Accounts in QBES and utilize the \u201cclass\u201d function […]<\/p>\n","protected":false},"author":2,"featured_media":962,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"yoast_head":"\n\n\t\t\t\t\t\tDifficult to format reporting and finding strong users of Sage 300 resulted in conversion to QuickBook Enterprise\t\t\t\t\t<\/h1>\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
Case
Study<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\tThe Problem<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
The Business<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
The Solution<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
Summary of Best Practices<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t