{"id":23729,"date":"2022-04-19T10:39:19","date_gmt":"2022-04-19T09:39:19","guid":{"rendered":"https:\/\/bigredcloud.com\/?post_type=docs&p=23729"},"modified":"2022-11-10T17:33:00","modified_gmt":"2022-11-10T17:33:00","password":"","slug":"power-accounting-setup-guide","status":"publish","type":"docs","link":"https:\/\/bigredcloud.com\/en\/documents\/power-accounting-setup-guide\/","title":{"rendered":"Power Accounting Setup Guide"},"content":{"rendered":"

This Add-in can be found in Excel by going to Insert<\/b> > Get Add-ins<\/b>, then finding the Big Red Cloud Power Accounting Add-in<\/b> and adding it.<\/p>\n

\"\"<\/p>\n

Once it is open in Excel (as below), just press on Download Template<\/strong> and then open that template.<\/p>\n

\"\"<\/p>\n

The Big Red Cloud Power Accounting Template consists of the following tabs:<\/p>\n

    \n
  1. Setup Guide<\/li>\n
  2. How To Guide<\/li>\n
  3. Generating an API Key Guide<\/li>\n
  4. Customers<\/li>\n
  5. Suppliers<\/li>\n
  6. Product<\/li>\n
  7. Sales Entries<\/li>\n
  8. Sales Invoices<\/li>\n
  9. Purchases<\/li>\n
  10. VAT Rates<\/li>\n<\/ol>\n

    \"\"<\/p>\n

    The Setup Guide and How To Guide give detailed information on how to start using Power Accounting.<<\/p>\n

    Connect to your Big Red Cloud company<\/h3>\n

    Simply input your API key in the panel on the right hand side, and click “Connect to Company”<\/p>\n

    \"\"<\/p>\n

     <\/p>\n

    An API key is a unique value, specific to your company in Big Red Cloud. A separate API Key should be generated for each Big Red Cloud Power Accounting Template that you wish to connect.<\/p>\n

    Only the administrator of your account may generate, activate or deactivate API keys.<\/p>\n

    Generating an API Key<\/strong><\/p>\n

      \n
    1. Log into Big Red Cloud at https:\/\/app.bigredcloud.com, using your Administrator login and password.<\/li>\n
    2. Open the Administration section by clicking on the \u2018Administration\u2019 button at the top of the screen.<\/li>\n
    3. In the Administration section, select the \u2018API Keys\u2019 button shown below.<\/li>\n<\/ol>\n

      \"\"<\/p>\n

        \n
      1. Click \u2018Add\u2019 at the bottom of the screen.<\/li>\n<\/ol>\n

        \"\"<\/p>\n

          \n
        1. Enter a description for the key you wish to create and click \u2018Save\u2019.
          \nNote: It is best if this description makes it easy to recognise who will be using the API Key or what application the API Key is being used for. This will help you to easily identify the people and applications that have access to your accounts should you wish to deactivate or delete one at a later date. (e.g. \u2018John\u2019s Power Accounting Key\u2019)<\/li>\n
        2. You should now see a new API Key record on the screen.<\/li>\n
        3. Clicking Edit on the API Key record will allow you to copy the API Key.<\/li>\n<\/ol>\n

          \"\"<\/p>\n

            \n
          1. Paste the API Key in the field in the Big Red Cloud Power Accounting Add-in on the right hand side of the downloaded template to connect to your company. (See Step A above)
            \nPlease note: The keys visible in these instructions are not active and will not work if used in order to test the application.<\/em><\/li>\n<\/ol>\n

            Things to note:<\/strong><\/p>\n

              \n
            • You must connect to your company before editing any content or creating any data in this template.<\/li>\n
            • The API Key is retained within this template – you should be mindful that anyone who can access the template, can access\/update the data in your Big Red Cloud company<\/li>\n
            • Distributing your API Key will allow the recipients to access\/update the data in your Big Red Cloud company, using this any software that has the ability to connect to the Big Red Cloud API.<\/li>\n
            • API Keys can be deactivated, reactivated, or deleted at any time from within Big Red Cloud, allowing you to revoke someone\u2019s ability to use their API Key.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

              This Add-in can be found in Excel by going to Insert > Get Add-ins, then finding the Big Red Cloud…<\/p>\n","protected":false},"author":19,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"doc_category":[205],"doc_tag":[],"class_list":{"0":"post-23729","1":"docs","2":"type-docs","3":"status-publish","5":"doc_category-setup"},"year_month":"2026-04","word_count":498,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"apathak","author_nicename":"apathak","author_url":"https:\/\/bigredcloud.com\/en\/author\/apathak\/"},"doc_category_info":[{"term_name":"Setup","term_url":"https:\/\/bigredcloud.com\/en\/docs-category\/setup\/"}],"doc_tag_info":[],"yoast_head":"\nPower Accounting Setup Guide - Big Red Cloud<\/title>\n<meta name=\"description\" content=\"This Add-in can be found in Excel by going to Insert > Get Add-ins, then finding the Big Red Cloud Power Accounting Add-in and adding it. Once it is\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Accounting Setup Guide\" \/>\n<meta property=\"og:description\" content=\"This Add-in can be found in Excel by going to Insert > Get Add-ins, then finding the Big Red Cloud Power Accounting Add-in and adding it. Once it is\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/\" \/>\n<meta property=\"og:site_name\" content=\"Big Red Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SimpleOnlineAccounts\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-10T17:33:00+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/bigredcloud.com\/wp-content\/uploads\/2022\/04\/unnamed-15.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@BigRedCloud\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Accounting Setup Guide - Big Red Cloud","description":"This Add-in can be found in Excel by going to Insert > Get Add-ins, then finding the Big Red Cloud Power Accounting Add-in and adding it. Once it is","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/","og_locale":"en_US","og_type":"article","og_title":"Power Accounting Setup Guide","og_description":"This Add-in can be found in Excel by going to Insert > Get Add-ins, then finding the Big Red Cloud Power Accounting Add-in and adding it. Once it is","og_url":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/","og_site_name":"Big Red Cloud","article_publisher":"https:\/\/www.facebook.com\/SimpleOnlineAccounts","article_modified_time":"2022-11-10T17:33:00+00:00","og_image":[{"url":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2022\/04\/unnamed-15.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_site":"@BigRedCloud","twitter_misc":{"Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bigredcloud.com\/en\/documents\/power-accounting-setup-guide\/","url":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/","name":"Power Accounting Setup Guide - Big Red Cloud","isPartOf":{"@id":"https:\/\/bigredcloud.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/#primaryimage"},"image":{"@id":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/#primaryimage"},"thumbnailUrl":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2022\/04\/unnamed-15.jpg","datePublished":"2022-04-19T09:39:19+00:00","dateModified":"2022-11-10T17:33:00+00:00","description":"This Add-in can be found in Excel by going to Insert > Get Add-ins, then finding the Big Red Cloud Power Accounting Add-in and adding it. Once it is","breadcrumb":{"@id":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/#primaryimage","url":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2022\/04\/unnamed-15.jpg","contentUrl":"http:\/\/bigredcloud.com\/wp-content\/uploads\/2022\/04\/unnamed-15.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/bigredcloud.com\/documents\/power-accounting-setup-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bigredcloud.com\/en\/"},{"@type":"ListItem","position":2,"name":"Docs","item":"https:\/\/bigredcloud.com\/en\/documents\/"},{"@type":"ListItem","position":3,"name":"Power Accounting Setup Guide"}]},{"@type":"WebSite","@id":"https:\/\/bigredcloud.com\/#website","url":"https:\/\/bigredcloud.com\/","name":"Big Red Cloud","description":"Online Accounting Software","publisher":{"@id":"https:\/\/bigredcloud.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/bigredcloud.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/bigredcloud.com\/#organization","name":"Big Red Cloud","url":"https:\/\/bigredcloud.com\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/bigredcloud.com\/#\/schema\/logo\/image\/","url":"https:\/\/bigredcloud.com\/wp-content\/uploads\/2025\/07\/unnamed-1.png","contentUrl":"https:\/\/bigredcloud.com\/wp-content\/uploads\/2025\/07\/unnamed-1.png","width":512,"height":512,"caption":"Big Red Cloud"},"image":{"@id":"https:\/\/bigredcloud.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SimpleOnlineAccounts","https:\/\/x.com\/BigRedCloud","https:\/\/www.linkedin.com\/company\/big-red-cloud\/?originalSubdomain=ie"]}]}},"_links":{"self":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs\/23729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/comments?post=23729"}],"version-history":[{"count":0,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs\/23729\/revisions"}],"wp:attachment":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/media?parent=23729"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_category?post=23729"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_tag?post=23729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}