{"id":9930,"date":"2015-09-01T23:20:58","date_gmt":"2015-09-01T23:20:58","guid":{"rendered":"https:\/\/www.okappy.com\/?p=9930"},"modified":"2018-09-04T08:37:50","modified_gmt":"2018-09-04T07:37:50","slug":"export-your-invoice-to-sage","status":"publish","type":"avada_portfolio","link":"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/","title":{"rendered":"Export your invoice raised to Sage"},"content":{"rendered":"<p><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-1 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;margin-bottom: 0px;margin-top: 0px;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-0 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"margin-top:0px;margin-bottom:20px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><style type=\"text\/css\"><\/style><div class=\"fusion-title title fusion-title-1 fusion-sep-none fusion-title-text fusion-title-size-one\" style=\"margin-top:0px;margin-bottom:31px;\"><h1 class=\"title-heading-left\" style=\"margin:0;\">Export your invoice raised to Sage<\/h1><\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-2 nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;margin-bottom: 0px;margin-top: 0px;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-1 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last\" style=\"margin-top:0px;margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><div class=\"fusion-text fusion-text-1\" style=\"transform:translate3d(0,0,0);\"><p>With Okappy, you can easily export your invoices raised to your external accounting packages such as <a title=\"Sage Line 50\" href=\"http:\/\/www.sage.co.uk\/sage-50-accounts\" target=\"_blank\" rel=\"noopener\">Sage Line 50<\/a>, <a href=\"http:\/\/www.okappy.com\/support-article\/export-your-invoice-to-quickbooks\/\">QuickBooks<\/a>, <a href=\"http:\/\/www.okappy.com\/support-article\/export-invoice-clearbooks\/\">Clearbooks<\/a>, <a href=\"http:\/\/www.okappy.com\/support-article\/export-your-invoice-to-kashflow\/\">Kashflow<\/a> and <a title=\"Xero Accounts\" href=\"http:\/\/www.okappy.com\/support-article\/how-to-export-your-invoice-from-okappy-to-xero-accounts\/\" target=\"_blank\" rel=\"noopener\">Xero<\/a>.<\/p>\n<p>From within the <a href=\"http:\/\/www.okappy.com\/view-all-your-invoices-raised-from-the-invoices-screen\/\">Okappy Invoices Screen<\/a>, simply click on the Sage icon ( <img class=\"lazyload size-full wp-image-14464\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%27http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%27%20width%3D%2730%27%20height%3D%2730%27%20viewBox%3D%270%200%2030%2030%27%3E%3Crect%20width%3D%2730%27%20height%3D%27330%27%20fill-opacity%3D%220%22%2F%3E%3C%2Fsvg%3E\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-icon@2x.png\" alt=\"Sage icon\" width=\"30\" height=\"30\" \/> ) to export your invoices. The system will create a CSV file with the following Sage fields pre-populated:<\/p>\n<table class=\"table table-bordered table-striped table-hover\">\n<thead>\n<tr>\n<th>Column<\/th>\n<th>Field<\/th>\n<th>Details<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td>A<\/td>\n<td>Type<\/td>\n<td>Sales invoice<\/td>\n<\/tr>\n<tr>\n<td>B<\/td>\n<td>Account Reference<\/td>\n<td>This a reference you use to recognise a customer in Sage, i.e., MISC<\/td>\n<\/tr>\n<tr>\n<td>C<\/td>\n<td>Nominal AC Ref<\/td>\n<td>The account you are posting the sales invoice to, typically in the range 4000<\/td>\n<\/tr>\n<tr>\n<td>D<\/td>\n<td>Department<\/td>\n<td><\/td>\n<\/tr>\n<tr>\n<td>E<\/td>\n<td>Date<\/td>\n<td>Tax date of the invoice<\/td>\n<\/tr>\n<tr>\n<td>F<\/td>\n<td>Reference<\/td>\n<td>Okappy invoice ID<\/td>\n<\/tr>\n<tr>\n<td>G<\/td>\n<td>Details<\/td>\n<td>This picks up the Job ID (if available) and any description<\/td>\n<\/tr>\n<tr>\n<td>H<\/td>\n<td>Net Amount<\/td>\n<td>Net amount of your invoice<\/td>\n<\/tr>\n<tr>\n<td>I<\/td>\n<td>Tax Code<\/td>\n<td>The tax code, typically T1 for standard rate VAT<\/td>\n<\/tr>\n<tr>\n<td>J<\/td>\n<td>Tax Amount<\/td>\n<td>The amount of VAT on your invoice<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>The following fields are not exported from Okappy, but can be added to the spreadsheet if required before uploading to Sage.<\/p>\n<ul>\n<li>Exchange rate<\/li>\n<li>Extra Reference<\/li>\n<li>User Name<\/li>\n<li>Project Refn<\/li>\n<li>Cost Code Refn<\/li>\n<\/ul>\n<h3>Importing invoices into Sage<\/h3>\n<p>To import your file into Sage:<\/p>\n<p>Open Sage, make sure all other Sage windows are closed and then go to <strong>File &gt; Import<\/strong><\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><\/div><div class=\"fusion-fullwidth fullwidth-box fusion-builder-row-3 hundred-percent-fullwidth non-hundred-percent-height-scrolling\" style=\"background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;margin-bottom: 0px;margin-top: 0px;border-width: 0px 0px 0px 0px;border-color:#eae9e9;border-style:solid;\" ><div class=\"fusion-builder-row fusion-row\"><div class=\"fusion-layout-column fusion_builder_column fusion-builder-column-2 fusion_builder_column_1_1 1_1 fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height\" style=\"margin-top:0px;margin-bottom:0px;\"><div class=\"fusion-column-wrapper fusion-flex-column-wrapper-legacy\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;padding: 0px 0px 0px 0px;\"><span class=\" fusion-imageframe imageframe-none imageframe-1 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-import@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[8415f1a0deb1156ee67]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-import.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-2\" style=\"transform:translate3d(0,0,0);\"><p>The Data Import Wizard will be shown.<\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-2 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-1@2x@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[343556187aaa93938bd]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-1@2x.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-3\" style=\"transform:translate3d(0,0,0);\"><p>To be on the safe side it&#8217;s always worth backing up your data first by clicking on the <strong>Backup<\/strong> button.<\/p>\n<p>I also find it easier if you have made an error with your import, or while testing as you can easily go back to the state of your accounts prior to the upload.<\/p>\n<p>Click <strong>Next<\/strong><\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-3 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-2@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[410169775f520162145]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-2.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-4\" style=\"transform:translate3d(0,0,0);\"><p>Select the data type of <strong>Audit Trail transactions<\/strong> and click <strong>Next<\/strong><\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-4 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-3@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[d857076334573915826]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-3.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-5\" style=\"transform:translate3d(0,0,0);\"><ul>\n<li>Tick the box for the format of the data you will be importing as Comma-separated (*.csv)<\/li>\n<li>Browse to the download file<\/li>\n<li>Tick the box for First row contains headings.<\/li>\n<\/ul>\n<p><strong>Note<\/strong>: Once you&#8217;ve selected the file you may need to again check the option for CSV as Sage sometimes defaults back to xlsx and then shows an error saying the file cannot be read. It also helps to click open rather than double clicking on the file name to select the file.<\/p>\n<p>Click <strong>Next<\/strong><\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-5 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-4@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[b0eb3c0e21c5a24552e]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-4.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-6\" style=\"transform:translate3d(0,0,0);\"><p>Choose Field mappings to match the column in the spreadsheet to your relevant Sage fields. The file is set out in the order required by Sage, so simply select A though I for each Sage field as shown below.<\/p>\n<p>Click <strong>Next<\/strong>, then click <strong>Finish<\/strong> to import your data.<\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-6 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-5@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[d4e1383d2e01f00e68d]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-step-5.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-7\" style=\"transform:translate3d(0,0,0);\"><p>If all goes well, the following screen will show the invoices which have been imported.<\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-7 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-success@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[8ad3c4dce6a5fa1dcae]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-success.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-8\" style=\"transform:translate3d(0,0,0);\"><p>If there are errors with the import file, the errors will be shown.<\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-8 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/sage-line50-error@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[ec5e2961e49d6a26184]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/sage-line50-error.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-9\" style=\"transform:translate3d(0,0,0);\"><h3>Errors with your import<\/h3>\n<p>Typically errors could occur if the file has data for a field which is not matched in Sage, i.e., if you have a client identifier of MISA in Okappy but it is MISC in Sage or if a nominal code is used such as 4200 which is not present in your Sage chart of accounts.<\/p>\n<p>Any errors can be corrected within the spreadsheet and then re-uploaded using the process above.<\/p>\n<p><strong>Note<\/strong>: Once your invoices have been exported from Okappy, they cannot be exported again so it is often worth keeping a copy of the export file.<\/p>\n<p>You can also check the account details from within Okappy to make sure the file is populated correctly the next time.<\/p>\n<\/div><span class=\" fusion-imageframe imageframe-none imageframe-9 hover-type-none\"><a href=\"https:\/\/okappyimages.okappy.com\/web-screenshot-sage-setting@2x.png\" class=\"fusion-lightbox\" data-rel=\"iLightbox[e295f190d69bbc9dc65]\"><img src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-orig-src=\"https:\/\/okappyimages.okappy.com\/web-screenshot-sage-setting.png\" class=\"lazyload img-responsive\"\/><\/a><\/span><div class=\"fusion-text fusion-text-10\" style=\"transform:translate3d(0,0,0);\"><p>More information on <a href=\"http:\/\/www.okappy.com\/job-management\/\">Okappy Job Management<\/a>.<\/p>\n<\/div><div class=\"fusion-clearfix\"><\/div><\/div><\/div><\/div><style type=\"text\/css\">.fusion-fullwidth.fusion-builder-row-3 { overflow:visible; }<\/style><\/div><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Find out how to export invoices raised from Okappy Job Management software to Sage Line 50<\/p>\n","protected":false},"author":1,"featured_media":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"spay_email":""},"portfolio_category":[314],"portfolio_skills":[],"portfolio_tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v16.6.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Export your invoice raised to Sage Line 50<\/title>\n<meta name=\"description\" content=\"Find out more about how to export invoices raised from Okappy Job Management software to Sage Line 50\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Export your invoice raised to Sage Line 50\" \/>\n<meta property=\"og:description\" content=\"Find out more about how to export invoices raised from Okappy Job Management software to Sage Line 50\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/\" \/>\n<meta property=\"og:site_name\" content=\"Okappy\" \/>\n<meta property=\"article:modified_time\" content=\"2018-09-04T07:37:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/okappyimages.okappy.com\/sage-icon@2x.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.okappy.com\/#organization\",\"name\":\"Okappy Limited\",\"url\":\"https:\/\/www.okappy.com\/\",\"sameAs\":[],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.okappy.com\/#logo\",\"inLanguage\":\"en-GB\",\"url\":\"https:\/\/okappyimages.okappy.com\/images\/20171223135158\/okappy-logo%402x-e1547078327884.png\",\"contentUrl\":\"https:\/\/okappyimages.okappy.com\/images\/20171223135158\/okappy-logo%402x-e1547078327884.png\",\"width\":452,\"height\":210,\"caption\":\"Okappy Limited\"},\"image\":{\"@id\":\"https:\/\/www.okappy.com\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.okappy.com\/#website\",\"url\":\"https:\/\/www.okappy.com\/\",\"name\":\"Okappy\",\"description\":\"Rethinking workforce management\",\"publisher\":{\"@id\":\"https:\/\/www.okappy.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.okappy.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/#primaryimage\",\"inLanguage\":\"en-GB\",\"url\":\"https:\/\/okappyimages.okappy.com\/sage-icon@2x.png\",\"contentUrl\":\"https:\/\/okappyimages.okappy.com\/sage-icon@2x.png\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/#webpage\",\"url\":\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/\",\"name\":\"Export your invoice raised to Sage Line 50\",\"isPartOf\":{\"@id\":\"https:\/\/www.okappy.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/#primaryimage\"},\"datePublished\":\"2015-09-01T23:20:58+00:00\",\"dateModified\":\"2018-09-04T07:37:50+00:00\",\"description\":\"Find out more about how to export invoices raised from Okappy Job Management software to Sage Line 50\",\"breadcrumb\":{\"@id\":\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.okappy.com\/support-article\/export-your-invoice-to-sage\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.okappy.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Portfolio\",\"item\":\"https:\/\/www.okappy.com\/support-article\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Export your invoice raised to Sage\"}]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio\/9930"}],"collection":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio"}],"about":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/types\/avada_portfolio"}],"author":[{"embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/comments?post=9930"}],"version-history":[{"count":0,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/avada_portfolio\/9930\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/media?parent=9930"}],"wp:term":[{"taxonomy":"portfolio_category","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_category?post=9930"},{"taxonomy":"portfolio_skills","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_skills?post=9930"},{"taxonomy":"portfolio_tags","embeddable":true,"href":"https:\/\/www.okappy.com\/wp-json\/wp\/v2\/portfolio_tags?post=9930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}