{"id":13676,"date":"2020-02-10T15:13:57","date_gmt":"2020-02-10T19:13:57","guid":{"rendered":"https:\/\/www.cofinia.ca\/?p=13676"},"modified":"2023-04-26T15:39:17","modified_gmt":"2023-04-26T19:39:17","slug":"accounting-how-to-migrate-to-the-cloud","status":"publish","type":"post","link":"https:\/\/www.cofinia.ca\/en\/blogue\/uncategorized\/accounting-how-to-migrate-to-the-cloud\/","title":{"rendered":"Accounting: How to migrate to the cloud?"},"content":{"rendered":"<div class=\"et_pb_column et_pb_column_3_4 et_pb_column_0 et_pb_css_mix_blend_mode_passthrough\">\n<div class=\"et_pb_with_border et_pb_module et_pb_text et_pb_text_0 et_pb_text_align_center et_pb_bg_layout_light\">\n<h1 class=\"et_pb_text_inner\"><span>Accounting: How to migrate to the cloud?<\/span><\/h1>\n<\/div>\n<\/div>\n<p>&nbsp;<\/p>\n<p><span>?There are so many advantages to using a cloud accounting system that for me, the question of migrating from a locally installed system, such as\u00a0<\/span><a href=\"https:\/\/translate.google.com\/website?sl=fr&amp;tl=en&amp;hl=fr&amp;client=webapp&amp;u=https:\/\/www.sage.com\/en-us\/products\/sage-50cloud\/\" target=\"_blank\" rel=\"noopener\"><span>Sage50<\/span><\/a><span>\u00a0,\u00a0<\/span><a href=\"https:\/\/translate.google.com\/website?sl=fr&amp;tl=en&amp;hl=fr&amp;client=webapp&amp;u=https:\/\/www.avantage.ca\/solutions\/avantage-pme\/\" target=\"_blank\" rel=\"noopener\"><span>Avantage<\/span><\/a><span>\u00a0or\u00a0<\/span><a href=\"https:\/\/translate.google.com\/website?sl=fr&amp;tl=en&amp;hl=fr&amp;client=webapp&amp;u=https:\/\/www.acomba.com\/solutions\/acomba-suite-comptabilite\/\" target=\"_blank\" rel=\"noopener\"><span>Acomba<\/span><\/a><span>\u00a0, no longer arises .\u00a0Nevertheless, data migration is a hindrance for many given the lack of knowledge or accounting expertise.<\/span><\/p>\n<p><span>I propose here 4 ways to migrate your accounting data to the cloud, starting from the simplest to the most complex.\u00a0It is important to leave with reliable, up-to-date accounting data and to decide on the date on which you want to migrate.\u00a0Ideally, I recommend choosing the beginning of a fiscal year to make this transition.<\/span><\/p>\n<p><span>Here are\u00a0<\/span><b><span>4 ways to migrate your accounting data to the cloud\u00a0<\/span><\/b><span>:<\/span><\/p>\n<h2><span>1. Only migrate opening balances<\/span><\/h2>\n<p><span>This way is the simplest, but you have to proceed methodically.\u00a0The basic data must be migrated, either:<\/span><\/p>\n<ul>\n<li><span>The list of customers<\/span><\/li>\n<li><span>The list of suppliers<\/span><\/li>\n<li><span>The charter of accounts<\/span><\/li>\n<li><span>The list of projects<\/span><\/li>\n<li><span>The list of items or products<\/span><\/li>\n<\/ul>\n<p><span>Then you have to deal with the auxiliaries.\u00a0<\/span><b><span>What is an auxiliary?\u00a0<\/span><\/b><span>It is an independent journal that reports to the general journal, which accounts for all accounting transactions.\u00a0Auxiliaries provide more detailed information than the general journal.\u00a0For example, it would not be possible to output a list of unpaid customer invoices from the general journal.<\/span><\/p>\n<p><span>It is therefore necessary to have a complete list of invoices not paid on the migration date, whether for accounts payable or accounts receivable.<\/span><\/p>\n<p><span>If you have a stock of products in inventory, you must also have a list of the items that make it up with the purchase costs of each.<\/span><\/p>\n<p><span>Then, you have to obtain the\u00a0<\/span><b><span>trial balance\u00a0<\/span><\/b><span>: the grouping of the income statement and the balance sheet on a given date.\u00a0You have to make sure you have reliable data, that account reconciliations have been done to ensure the accuracy of the data before implementing the migration plan to the cloud.<\/span><\/p>\n<p><span>Since it is impossible to migrate, for example, to January 1st while having the financial results as of December 31st compiled, a transition period must be provided for, where transactions after the implementation date will be processed in the new system while Transactions from the previous period must be processed in the old one.<\/span><\/p>\n<p><span>Once the demarcation is completed, it will be possible to import the data.\u00a0Another point, it is possible to return to correct the opening balances once entered, in particular for tax entries or adjustments by the accountant at the end of the year.<\/span><\/p>\n<h2><span>2. Migrate historical auxiliary data and opening balances<\/span><\/h2>\n<p><span>Sales data is often the most useful data for businesses.\u00a0They are often used to adjust the sales pitch to a customer, make marketing campaigns or send lists of updates related to products.<\/span><\/p>\n<p><span>Since cloud systems calculate revenue based on a date, it is possible to import only sales data from the accounts receivable auxiliary to have historical data, without however migrating more data.<\/span><\/p>\n<p><span>Of course, consulting an income statement for a previous period will not yield significant results for the other items in the chart of accounts.<\/span><\/p>\n<p><span>We must therefore proceed according to method 1, except for the accounts receivable auxiliary where it will be necessary to import all the data for the desired time range.\u00a0<\/span><b><span>We have already done a migration of 8 years of history for a client.<\/span><\/b><\/p>\n<h2><span>3. Migrate end-of-period balances and auxiliaries<\/span><\/h2>\n<p><span>It is interesting to consult the comparative financial data from one year to the next.\u00a0If the auxiliary data has less value for the company, it is possible to migrate to the cloud, by journal entry, the end of period balances.\u00a0Thus, when a statement of results or a balance sheet is requested, it will be possible to compare with the same period the previous year.<\/span><\/p>\n<p><span>Note that some temporary accounts may have to be used since in many cases the software does not allow the use of auxiliary accounts or system accounts (such as accounts payable, accounts receivable) directly in the journal entries.<\/span><\/p>\n<p><span>This may seem simple, but in reality, you have to be sure to take into account the amounts that will be imported into the auxiliaries, since we saw in the 1st method that we need them.<\/span><\/p>\n<h2><span>4. Full historical migration<\/span><\/h2>\n<p><span>This is the most complex and risky method.\u00a0It is complex for several reasons.\u00a0When you migrate, you generally want to take advantage of it to clean up.\u00a0In customers, suppliers, articles, accounts of the chart of accounts.\u00a0This will involve a conversion step between the values \u200b\u200bof the old system to the values \u200b\u200bof the new system.<\/span><\/p>\n<p><span>Then, as mentioned in point 3, some accounts have limitations, which implies that we must find a strategy to circumvent the problem and be able to import the data.<\/span><\/p>\n<p><span>Then, the origin system must be able to provide an output of the data to be migrated, which is not always the case or sometimes, the format of the output requires a certain amount of manipulation to clean the data, put it into shape, convert them and finally import them.<\/span><\/p>\n<p><span>Finally, quality assurance must be carried out to ensure that the two systems, the old and the new, provide equivalent financial information.<\/span><\/p>\n<p><span>On the risk side, we think of the financial risks, there will be a lot of work to be done, involving costs and possibly cost overruns.\u00a0As we know, IT projects are generally underestimated in complexity.<\/span><\/p>\n<p><span>Then the risks associated with human resources.\u00a0Do you have competent resources to support this migration?\u00a0You should ensure a mix of expertise between software skills and accounting skills, because you must ensure the integrity of the information that will have been migrated.<\/span><\/p>\n<p><span>Finally, the risk related to the deadline: will you be able to perform the migration within the desired timeframe and avoid impacts on your operations?\u00a0Too often, deadlines have an impact on invoicing and, by extension, on receipts.\u00a0The company&#8217;s cash flow is affected.<\/span><\/p>\n<p><span>As you can see, a migration project requires thought and preparation.\u00a0It can be scary, but the more time you have, the more you can plan the steps so that you take into account all aspects of your project.\u00a0And if your accounting data is reliable and up-to-date, you already have a great starting point.<\/span><\/p>\n<p><a href=\"https:\/\/translate.google.com\/website?sl=fr&amp;tl=en&amp;hl=fr&amp;client=webapp&amp;u=https:\/\/cofiniatestdev.wpengine.com\/services\/\" target=\"_blank\" rel=\"noopener\"><span>Cofinia\u00a0<\/span><\/a><strong><span>offers migration services for its customers<\/span><\/strong><span>\u00a0.\u00a0Our experts will offer you the best solution adapted to your needs and will choose the optimal migration tool to migrate your accounting data centers.\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<h2><span>Stay tuned and don&#8217;t miss any of our new publications<\/span><\/h2>\n<p>&nbsp;<\/p>\n<h3><span>Access our Tools<\/span><\/h3>\n<p><span>We provide you with completely free tools to help you familiarize yourself with the management tools<\/span><\/p>\n<h3><span>Make an appointment!<\/span><\/h3>\n<p><span>Make a telephone appointment with us to learn more about what we offer as a service and how we can help you.<\/span><\/p>\n<h3><span>Follow us<\/span><\/h3>\n<p><span>Follow us on our social networks to learn more about our company, our values \u200b\u200band our services.<\/span><br \/>\n<span>facebooktwitteryoutube<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Accounting: How to migrate to the cloud? &nbsp; ?There are so many advantages to using a cloud accounting system that for me, the question of migrating from a locally installed system, such as\u00a0Sage50\u00a0,\u00a0Avantage\u00a0or\u00a0Acomba\u00a0, no longer arises .\u00a0Nevertheless, data migration is a hindrance for many given the lack of knowledge or accounting expertise. I propose here [&hellip;]<\/p>\n","protected":false},"author":9,"featured_media":13677,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[3],"tags":[],"class_list":["post-13676","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/posts\/13676","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/comments?post=13676"}],"version-history":[{"count":0,"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/posts\/13676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/media\/13677"}],"wp:attachment":[{"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/media?parent=13676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/categories?post=13676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.cofinia.ca\/en\/wp-json\/wp\/v2\/tags?post=13676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}