{"id":23746,"date":"2022-04-19T16:26:52","date_gmt":"2022-04-19T15:26:52","guid":{"rendered":"https:\/\/bigredcloud.com\/?post_type=docs&p=23746"},"modified":"2022-11-14T13:14:05","modified_gmt":"2022-11-14T13:14:05","password":"","slug":"power-accounting-guide","status":"publish","type":"docs","link":"https:\/\/bigredcloud.com\/en\/documents\/power-accounting-guide\/","title":{"rendered":"Power Accounting Guide"},"content":{"rendered":"[vc_row type=”full_width_background” full_screen_row_position=”middle” column_margin=”default” equal_height=”yes” content_placement=”middle” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” id=”header_row” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_color=”#faf6ee” shape_divider_position=”bottom” shape_divider_height=”140px” bg_image_animation=”none” shape_type=”curve”][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”center” phone_text_alignment=”center” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_custom_heading text=”Big Red Cloud Power Accounting How To Guide” font_container=”tag:h3|text_align:left|color:%231e2020″ use_theme_fonts=”yes”][divider line_type=”No Line” custom_height=”20″][vc_custom_heading text=”This How To Guide will assist you in using the Big Red Cloud Power Accounting Template in conjunction with the Big Red Cloud Power Accounting Add-in for Excel. Once you have connected this template to your company by entering the API Key, you can then import and export data to\/from your company in Big Red Cloud.” font_container=”tag:p|text_align:left|color:%23757575″ google_fonts=”font_family:Lato%3A100%2C100italic%2C300%2C300italic%2Cregular%2Citalic%2C700%2C700italic%2C900%2C900italic|font_style:400%20regular%3A400%3Anormal”][vc_custom_heading text=”Creating Data within this template prior to connecting to your company, may result in duplication of work at a later date.” font_container=”tag:p|text_align:left|color:%23757575″ google_fonts=”font_family:Lato%3A100%2C100italic%2C300%2C300italic%2Cregular%2Citalic%2C700%2C700italic%2C900%2C900italic|font_style:400%20regular%3A400%3Anormal”][\/vc_column][\/vc_row][vc_row type=”in_container” full_screen_row_position=”middle” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” scene_position=”center” top_padding=”6%” bottom_padding=”6%” text_color=”dark” text_align=”left” row_border_radius=”none” row_border_radius_applies=”bg” overlay_strength=”0.3″ gradient_direction=”left_to_right” shape_divider_position=”bottom” bg_image_animation=”none” shape_type=””][vc_column column_padding=”no-extra-padding” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”none” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/1″ tablet_width_inherit=”default” tablet_text_alignment=”default” phone_text_alignment=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_row_inner equal_height=”yes” content_placement=”top” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” top_padding=”1%” bottom_padding=”1%” text_align=”left”][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\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[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n

    You can interact with each of these tabs in a variety of ways:<\/p>\n

      \n
    1. Manually<\/li>\n
    2. Get Data from BRC function<\/li>\n
    3. Send Data to BRC function<\/li>\n
    4. Get Setup Data function<\/li>\n<\/ol>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_column_text]\n

      The \u201cGet Data from BRC\u201d function:<\/h4>\n

      \u201cGet Data from BRC\u201d will retrieve three types of data for your company.<\/p>\n

        \n
      1. Company Setup Data for VAT Rates, User Defined Fields, Analysis Categories\u00a0\u00a0\u2013 updates the Sales Entries, Sales Invoices, Purchases tabs with the respective Analysis Categories and User Defined Fields<\/li>\n
      2. Master Data for Customers, Suppliers, Products\u00a0\u00a0\u2013 updates the Customers, Suppliers, Products tabs with the Master Data (i.e. setup data) for all existing Customers, Suppliers and Products<\/li>\n
      3. Transnational Data for Sales Entries, Sales Invoices, Purchases \u2013\u00a0\u00a0retrieves transnational data for the period that you define in the \u2018period\u2019 section &\u00a0updates the Sales Entries, Sales Invoices, Purchases tabs with the respective transactions for the period that you have defined.<\/li>\n<\/ol>\n

        The \u201cSend Data to BRC\u201d function:<\/h4>\n

        \u201cSend Data to BRC\u201d will send two data types for your company.<\/p>\n

          \n
        1. Master Data for Customers, Suppliers, Products\u00a0\u00a0\u2013 updates your Big Red Cloud company within the changes you make to the Master Data within the Customers, Suppliers, Products tabs.<\/li>\n
        2. Transnational Data for Sales Entries, Sales Invoices, Purchases \u2013\u00a0posts the changes you make to the transactions within the Sales Entries, Sales Invoices, Purchases tabs.<\/li>\n<\/ol>\n

          Note:\u00a0Changes made to the tabs and sent to BRC cannot be undone, you should consider a backup prior to importing that data to your company.<\/em><\/p>\n

          The \u201cGet Setup Data\u201d function:<\/h4>\n

          \u201cGet Setup Data\u201d will retrieve any new setup data associated with your company, such as Analysis Categories, User Defined Fields and VAT Rates.<\/p>\n

          Running Get Setup Data will overwrite any data within your Excel template and replace it with the Setup data currently associated with your company.<\/p>\n

          Get Setup Data only needs to be run in the event that some setup data has been changed within your company since you last used your Excel Template.<\/p>\n[\/vc_column_text][vc_column_text]\n

          Adding Customer\/Supplier\/Product Master Data<\/span><\/h4>\n[\/vc_column_text][vc_row_inner equal_height=”yes” content_placement=”top” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” top_padding=”1%” bottom_padding=”1%” text_align=”left”][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n
          When creating customers\/suppliers\/products in their respective tabs:
          \nThe following fields will update automatically and should not be edited:
          \n\u2013 Operation
          \n\u2013 Response
          \n\u2013 Id
          \n\u2013 Timestamp
          \nAll other fields can be edited.
          \nThe following fields are required:
          \n\u2013 A\/C Code (Code for Products)
          \n\u2013 Name
          \nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n
          When changing customers\/suppliers\/products in their respective tabs:<\/span><\/div>\n
          The following fields will update automatically and should not be edited:
          \n\u2013 Operation
          \n\u2013 Response
          \n\u2013 Id
          \n\u2013 Time stamp
          \nThe following fields cannot be edited:
          \n\u2013 A\/C Code (Code for Products)
          \nAll other fields can be edited.
          \nThe following fields are required:
          \n\u2013 A\/C Code (Code for Products)
          \n\u2013 Name
          \nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_column_text]\n

          Adding\/Changing Sales Entries or Purchases<\/span><\/h4>\n[\/vc_column_text][vc_row_inner equal_height=”yes” content_placement=”top” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” top_padding=”1%” bottom_padding=”1%” text_align=”left”][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n
          When creating Sales Entries\/Purchases in their respective tabs:
          \nThe following fields will update automatically and should not be edited:
          \n\u2013 Operation
          \n\u2013 Response
          \n\u2013 Id
          \n\u2013 Time stamp
          \nAll other fields can be edited.
          \nThe following fields are required:
          \n\u2013 Period
          \n\u2013 Date
          \n\u2013 Reference
          \n\u2013 Account
          \n\u2013 VAT Type
          \n\u2013 Total
          \n\u2013 Total VAT
          \n\u2013 Net Breakdown across VAT Rates
          \n\u2013 Net Breakdown across Analysis Categories
          \nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n
          When changing Sales Entries\/Purchases in their respective tabs:
          \nThe following fields will update automatically and should not be edited:
          \n\u2013 Operation
          \n\u2013 Response
          \n\u2013 Id
          \n\u2013 Time stamp
          \nThe following fields cannot be edited:
          \n\u2013 Period
          \nAll other fields can be edited.
          \nThe following fields are required:
          \n\u2013 Date
          \n\u2013 Reference
          \n\u2013 Account
          \n\u2013 VAT Type
          \n\u2013 Total
          \n\u2013 Total VAT
          \n\u2013 Net Breakdown across VAT Rates
          \n\u2013 Net Breakdown across Analysis Categories
          \nCell Formatting should not be changed.<\/div>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner equal_height=”yes” content_placement=”top” column_margin=”default” column_direction=”default” column_direction_tablet=”default” column_direction_phone=”default” top_padding=”1%” bottom_padding=”1%” text_align=”left”][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n
          When changing Sales Entries\/Purchases in their respective tabs:
          \nThe following fields will update automatically and should not be edited:
          \n\u2013 Operation
          \n\u2013 Response
          \n\u2013 Id
          \n\u2013 Time stamp
          \nThe following fields cannot be edited:
          \n\u2013 Period
          \nAll other fields can be edited.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=”padding-2-percent” column_padding_tablet=”inherit” column_padding_phone=”inherit” column_padding_position=”all” column_element_spacing=”default” background_color=”#f6f6f8″ background_color_opacity=”1″ background_hover_color_opacity=”1″ column_shadow=”none” column_border_radius=”10px” column_link_target=”_self” gradient_direction=”left_to_right” overlay_strength=”0.3″ width=”1\/2″ tablet_width_inherit=”default” bg_image_animation=”none” border_type=”simple” column_border_width=”none” column_border_style=”solid”][vc_column_text]\n
          The following fields are required:
          \n\u2013 Date
          \n\u2013 Reference
          \n\u2013 Account
          \n\u2013 VAT Type
          \n\u2013 Total
          \n\u2013 Total VAT
          \n\u2013 Net Breakdown across VAT Rates
          \n\u2013 Net Breakdown across Analysis Categories
          \nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_column_text]\n
          Remember, you can refer to this How To Guide at any time.<\/span><\/div>\n
          Think we can make this How To Guide more user friendly? \u00a0We\u2019re always happy to get your feedback! \u00a0Please email us your suggestions on\u00a0support@bigredcloud.com\/<\/a><\/span><\/div>\n
          Click here to return to the Setup Guide<\/a><\/span><\/div>\n[\/vc_column_text][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"

          Read our guide on the Power Accounting add-on for Excel. Simply input your API Key and begin importing and exporting data inside 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":[206],"doc_tag":[],"class_list":{"0":"post-23746","1":"docs","2":"type-docs","3":"status-publish","5":"doc_category-entering-transactions"},"year_month":"2026-04","word_count":2006,"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":"Entering Transactions","term_url":"https:\/\/bigredcloud.com\/en\/docs-category\/entering-transactions\/"}],"doc_tag_info":[],"yoast_head":"\nPower Accounting Guide - Big Red Cloud<\/title>\n<meta name=\"description\" content=\"Read our guide on the Power Accounting add-on for Excel. Simply input your API Key and begin importing and exporting data inside Big Red Cloud.\" \/>\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-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Power Accounting Guide\" \/>\n<meta property=\"og:description\" content=\"Read our guide on the Power Accounting add-on for Excel. Simply input your API Key and begin importing and exporting data inside Big Red Cloud.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bigredcloud.com\/documents\/power-accounting-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-14T13:14:05+00:00\" \/>\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=\"5 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Power Accounting Guide - Big Red Cloud","description":"Read our guide on the Power Accounting add-on for Excel. Simply input your API Key and begin importing and exporting data inside Big Red Cloud.","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-guide\/","og_locale":"en_US","og_type":"article","og_title":"Power Accounting Guide","og_description":"Read our guide on the Power Accounting add-on for Excel. Simply input your API Key and begin importing and exporting data inside Big Red Cloud.","og_url":"https:\/\/bigredcloud.com\/documents\/power-accounting-guide\/","og_site_name":"Big Red Cloud","article_publisher":"https:\/\/www.facebook.com\/SimpleOnlineAccounts","article_modified_time":"2022-11-14T13:14:05+00:00","twitter_card":"summary_large_image","twitter_site":"@BigRedCloud","twitter_misc":{"Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bigredcloud.com\/en\/documents\/power-accounting-guide\/","url":"https:\/\/bigredcloud.com\/documents\/power-accounting-guide\/","name":"Power Accounting Guide - Big Red Cloud","isPartOf":{"@id":"https:\/\/bigredcloud.com\/#website"},"datePublished":"2022-04-19T15:26:52+00:00","dateModified":"2022-11-14T13:14:05+00:00","description":"Read our guide on the Power Accounting add-on for Excel. Simply input your API Key and begin importing and exporting data inside Big Red Cloud.","breadcrumb":{"@id":"https:\/\/bigredcloud.com\/documents\/power-accounting-guide\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bigredcloud.com\/documents\/power-accounting-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bigredcloud.com\/documents\/power-accounting-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 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\/23746","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=23746"}],"version-history":[{"count":0,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/docs\/23746\/revisions"}],"wp:attachment":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/media?parent=23746"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_category?post=23746"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/doc_tag?post=23746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}