{"id":22570,"date":"2022-01-21T11:56:35","date_gmt":"2022-01-21T11:56:35","guid":{"rendered":"https:\/\/bigredcloud.com\/?page_id=22570"},"modified":"2022-04-19T14:51:07","modified_gmt":"2022-04-19T13:51:07","slug":"big-red-cloud-power-accounting-guide","status":"publish","type":"page","link":"https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-power-accounting-guide\/","title":{"rendered":"Big Red Cloud Power Accounting \u2013 How To Guide"},"content":{"rendered":"[vc_row type=&#8221;full_width_background&#8221; full_screen_row_position=&#8221;middle&#8221; column_margin=&#8221;default&#8221; equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; bg_color=&#8221;#ffffff&#8221; scene_position=&#8221;center&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; row_border_radius=&#8221;none&#8221; row_border_radius_applies=&#8221;bg&#8221; id=&#8221;header_row&#8221; overlay_strength=&#8221;0.3&#8243; gradient_direction=&#8221;left_to_right&#8221; shape_divider_color=&#8221;#faf6ee&#8221; shape_divider_position=&#8221;bottom&#8221; shape_divider_height=&#8221;140px&#8221; bg_image_animation=&#8221;none&#8221; shape_type=&#8221;curve&#8221;][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; tablet_text_alignment=&#8221;center&#8221; phone_text_alignment=&#8221;center&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_custom_heading text=&#8221;Big Red Cloud Power Accounting How To Guide&#8221; font_container=&#8221;tag:h1|text_align:left|color:%231e2020&#8243; use_theme_fonts=&#8221;yes&#8221;][divider line_type=&#8221;No Line&#8221; custom_height=&#8221;20&#8243;][vc_custom_heading text=&#8221;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.&#8221; font_container=&#8221;tag:p|font_size:24px|text_align:left|color:%23757575|line_height:34px&#8221; google_fonts=&#8221;font_family:Lato%3A100%2C100italic%2C300%2C300italic%2Cregular%2Citalic%2C700%2C700italic%2C900%2C900italic|font_style:400%20regular%3A400%3Anormal&#8221;][vc_custom_heading text=&#8221;Creating Data within this template prior to connecting to your company, may result in duplication of work at a later date.&#8221; font_container=&#8221;tag:p|font_size:16px|text_align:left|color:%23757575|line_height:26px&#8221; google_fonts=&#8221;font_family:Lato%3A100%2C100italic%2C300%2C300italic%2Cregular%2Citalic%2C700%2C700italic%2C900%2C900italic|font_style:400%20regular%3A400%3Anormal&#8221;][\/vc_column][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;left-right&#8221; column_element_spacing=&#8221;default&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; font_color=&#8221;#243f9b&#8221; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; tablet_text_alignment=&#8221;default&#8221; phone_text_alignment=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][nectar_cascading_images image_1_url=&#8221;2678&#8243; image_1_offset_x_sign=&#8221;+&#8221; image_1_offset_x=&#8221;0%&#8221; image_1_offset_y_sign=&#8221;+&#8221; image_1_offset_y=&#8221;0%&#8221; image_1_rotate_sign=&#8221;+&#8221; image_1_rotate=&#8221;none&#8221; image_1_scale=&#8221;1&#8243; image_1_padding=&#8221;auto&#8221; image_1_box_shadow=&#8221;none&#8221; image_1_max_width_desktop=&#8221;100%&#8221; image_1_max_width_mobile=&#8221;100%&#8221; image_1_image_width_mobile=&#8221;default&#8221; image_2_url=&#8221;22592&#8243; image_2_offset_x_sign=&#8221;+&#8221; image_2_offset_x=&#8221;0%&#8221; image_2_offset_y_sign=&#8221;+&#8221; image_2_offset_y=&#8221;0%&#8221; image_2_rotate_sign=&#8221;+&#8221; image_2_rotate=&#8221;none&#8221; image_2_scale=&#8221;1&#8243; image_2_padding=&#8221;auto&#8221; image_2_box_shadow=&#8221;none&#8221; image_2_max_width_desktop=&#8221;100%&#8221; image_2_max_width_mobile=&#8221;100%&#8221; image_2_image_width_mobile=&#8221;default&#8221; image_3_offset_x_sign=&#8221;+&#8221; image_3_offset_x=&#8221;0%&#8221; image_3_offset_y_sign=&#8221;+&#8221; image_3_offset_y=&#8221;0%&#8221; image_3_rotate_sign=&#8221;+&#8221; image_3_rotate=&#8221;none&#8221; image_3_scale=&#8221;1&#8243; image_3_padding=&#8221;auto&#8221; image_3_box_shadow=&#8221;none&#8221; image_3_max_width_desktop=&#8221;100%&#8221; image_3_max_width_mobile=&#8221;100%&#8221; image_3_image_width_mobile=&#8221;default&#8221; image_4_offset_x_sign=&#8221;+&#8221; image_4_offset_x=&#8221;0%&#8221; image_4_offset_y_sign=&#8221;+&#8221; image_4_offset_y=&#8221;0%&#8221; image_4_rotate_sign=&#8221;+&#8221; image_4_rotate=&#8221;none&#8221; image_4_scale=&#8221;1&#8243; image_4_padding=&#8221;auto&#8221; image_4_box_shadow=&#8221;none&#8221; image_4_max_width_desktop=&#8221;100%&#8221; image_4_max_width_mobile=&#8221;100%&#8221; image_4_image_width_mobile=&#8221;default&#8221; element_sizing=&#8221;default&#8221; image_loading=&#8221;default&#8221; border_radius=&#8221;none&#8221; parallax_scrolling=&#8221;yes&#8221; layer_1_parallax_scrolling=&#8221;no&#8221; parallax_scrolling_intensity=&#8221;subtle&#8221; overflow=&#8221;visible&#8221;][\/vc_column][\/vc_row][vc_row type=&#8221;in_container&#8221; full_screen_row_position=&#8221;middle&#8221; column_margin=&#8221;default&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; scene_position=&#8221;center&#8221; top_padding=&#8221;6%&#8221; bottom_padding=&#8221;6%&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; row_border_radius=&#8221;none&#8221; row_border_radius_applies=&#8221;bg&#8221; overlay_strength=&#8221;0.3&#8243; gradient_direction=&#8221;left_to_right&#8221; shape_divider_position=&#8221;bottom&#8221; bg_image_animation=&#8221;none&#8221; shape_type=&#8221;&#8221;][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/1&#8243; tablet_width_inherit=&#8221;default&#8221; tablet_text_alignment=&#8221;default&#8221; phone_text_alignment=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;top&#8221; column_margin=&#8221;default&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; top_padding=&#8221;1%&#8221; bottom_padding=&#8221;1%&#8221; text_align=&#8221;left&#8221;][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<p style=\"font-weight: 400;\">The Big Red Cloud Power Accounting Template consists of the following tabs:<\/p>\n<ol style=\"font-weight: 400;\">\n<li>Setup Guide<\/li>\n<li>How To Guide<\/li>\n<li>Generating an API Key Guide<\/li>\n<li>Customers<\/li>\n<li>Suppliers<\/li>\n<li>Product<\/li>\n<li>Sales Entries<\/li>\n<li>Sales Invoices<\/li>\n<li>Purchases<\/li>\n<li>VAT Rates<\/li>\n<\/ol>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<p style=\"font-weight: 400;\">You can interact with each of these tabs in a variety of ways:<\/p>\n<ol style=\"font-weight: 400;\">\n<li>Manually<\/li>\n<li>Get Data from BRC function<\/li>\n<li>Send Data to BRC function<\/li>\n<li>Get Setup Data function<\/li>\n<\/ol>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_column_text]\n<h4 style=\"font-weight: 500;\">The \u201cGet Data from BRC\u201d function:<\/h4>\n<p style=\"font-weight: 400;\">\u201cGet Data from BRC\u201d will retrieve three types of data for your company.<\/p>\n<ol style=\"font-weight: 400;\">\n<li>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<li>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<li>Transnational Data for Sales Entries, Sales Invoices, Purchases \u2013\u00a0\u00a0retrieves transnational data for the period that you define in the \u2018period\u2019 section &amp;\u00a0updates the Sales Entries, Sales Invoices, Purchases tabs with the respective transactions for the period that you have defined.<\/li>\n<\/ol>\n<h4 style=\"font-weight: 500;\">The \u201cSend Data to BRC\u201d function:<\/h4>\n<p style=\"font-weight: 400;\">\u201cSend Data to BRC\u201d will send two data types for your company.<\/p>\n<ol style=\"font-weight: 400;\">\n<li>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<li>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<p style=\"font-weight: 400;\"><em>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<h4 style=\"font-weight: 500;\">The \u201cGet Setup Data\u201d function:<\/h4>\n<p style=\"font-weight: 400;\">\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<p style=\"font-weight: 400;\">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<p style=\"font-weight: 400;\">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<h4 class=\"sh-color-black sh-color\" style=\"text-align: center;\"><span class=\"sh-color-grey sh-color\">Adding Customer\/Supplier\/Product Master Data<\/span><\/h4>\n[\/vc_column_text][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;top&#8221; column_margin=&#8221;default&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; top_padding=&#8221;1%&#8221; bottom_padding=&#8221;1%&#8221; text_align=&#8221;left&#8221;][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">When creating customers\/suppliers\/products in their respective tabs:<br \/>\nThe following fields will update automatically and should not be edited:<br \/>\n\u2013 Operation<br \/>\n\u2013 Response<br \/>\n\u2013 Id<br \/>\n\u2013 Timestamp<br \/>\nAll other fields can be edited.<br \/>\nThe following fields are required:<br \/>\n\u2013 A\/C Code (Code for Products)<br \/>\n\u2013 Name<br \/>\nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">When changing customers\/suppliers\/products in their respective tabs:<\/span><\/div>\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">The following fields will update automatically and should not be edited:<br \/>\n\u2013 Operation<br \/>\n\u2013 Response<br \/>\n\u2013 Id<br \/>\n\u2013 Time stamp<br \/>\nThe following fields cannot be edited:<br \/>\n\u2013 A\/C Code (Code for Products)<br \/>\nAll other fields can be edited.<br \/>\nThe following fields are required:<br \/>\n\u2013 A\/C Code (Code for Products)<br \/>\n\u2013 Name<br \/>\nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_column_text]\n<h4 class=\"sh-color-black sh-color\" style=\"text-align: center;\"><span class=\"sh-color-grey sh-color\">Adding\/Changing Sales Entries or Purchases<\/span><\/h4>\n[\/vc_column_text][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;top&#8221; column_margin=&#8221;default&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; top_padding=&#8221;1%&#8221; bottom_padding=&#8221;1%&#8221; text_align=&#8221;left&#8221;][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">When creating Sales Entries\/Purchases in their respective tabs:<br \/>\nThe following fields will update automatically and should not be edited:<br \/>\n\u2013 Operation<br \/>\n\u2013 Response<br \/>\n\u2013 Id<br \/>\n\u2013 Time stamp<br \/>\nAll other fields can be edited.<br \/>\nThe following fields are required:<br \/>\n\u2013 Period<br \/>\n\u2013 Date<br \/>\n\u2013 Reference<br \/>\n\u2013 Account<br \/>\n\u2013 VAT Type<br \/>\n\u2013 Total<br \/>\n\u2013 Total VAT<br \/>\n\u2013 Net Breakdown across VAT Rates<br \/>\n\u2013 Net Breakdown across Analysis Categories<br \/>\nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<div class=\"sh-color-black sh-color\">When changing Sales Entries\/Purchases in their respective tabs:<br \/>\nThe following fields will update automatically and should not be edited:<br \/>\n\u2013 Operation<br \/>\n\u2013 Response<br \/>\n\u2013 Id<br \/>\n\u2013 Time stamp<br \/>\nThe following fields cannot be edited:<br \/>\n\u2013 Period<br \/>\nAll other fields can be edited.<br \/>\nThe following fields are required:<br \/>\n\u2013 Date<br \/>\n\u2013 Reference<br \/>\n\u2013 Account<br \/>\n\u2013 VAT Type<br \/>\n\u2013 Total<br \/>\n\u2013 Total VAT<br \/>\n\u2013 Net Breakdown across VAT Rates<br \/>\n\u2013 Net Breakdown across Analysis Categories<br \/>\nCell Formatting should not be changed.<\/div>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_row_inner equal_height=&#8221;yes&#8221; content_placement=&#8221;top&#8221; column_margin=&#8221;default&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; top_padding=&#8221;1%&#8221; bottom_padding=&#8221;1%&#8221; text_align=&#8221;left&#8221;][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">When changing Sales Entries\/Purchases in their respective tabs:<br \/>\nThe following fields will update automatically and should not be edited:<br \/>\n\u2013 Operation<br \/>\n\u2013 Response<br \/>\n\u2013 Id<br \/>\n\u2013 Time stamp<br \/>\nThe following fields cannot be edited:<br \/>\n\u2013 Period<br \/>\nAll other fields can be edited.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][vc_column_inner column_padding=&#8221;padding-2-percent&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color=&#8221;#f6f6f8&#8243; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;10px&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/2&#8243; tablet_width_inherit=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">The following fields are required:<br \/>\n\u2013 Date<br \/>\n\u2013 Reference<br \/>\n\u2013 Account<br \/>\n\u2013 VAT Type<br \/>\n\u2013 Total<br \/>\n\u2013 Total VAT<br \/>\n\u2013 Net Breakdown across VAT Rates<br \/>\n\u2013 Net Breakdown across Analysis Categories<br \/>\nCell Formatting should not be changed.<\/span><\/div>\n[\/vc_column_text][\/vc_column_inner][\/vc_row_inner][vc_column_text]\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">Remember, you can refer to this How To Guide at any time.<\/span><\/div>\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\">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\u00a0<a class=\"sh-color-blue sh-color\" href=\"mailto:support@bigredcloud.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">support@bigredcloud.com\/<\/a><\/span><\/div>\n<div class=\"sh-color-black sh-color\"><span class=\"sh-color-grey sh-color\"><a class=\"sh-color-blue sh-color\" href=\"https:\/\/bigredcloud.com\/docs\/power-accounting-setup-guide\/\" target=\"_blank\" rel=\"noopener noreferrer\">Click here to return to the Setup Guide<\/a><\/span><\/div>\n[\/vc_column_text][\/vc_column][\/vc_row][vc_row type=&#8221;full_width_background&#8221; full_screen_row_position=&#8221;middle&#8221; column_margin=&#8221;default&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; scene_position=&#8221;center&#8221; top_padding=&#8221;6%&#8221; bottom_padding=&#8221;6%&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; row_border_radius=&#8221;none&#8221; row_border_radius_applies=&#8221;bg&#8221; class=&#8221;ClientLogos&#8221; overlay_strength=&#8221;0.3&#8243; gradient_direction=&#8221;left_to_right&#8221; shape_divider_position=&#8221;bottom&#8221; bg_image_animation=&#8221;none&#8221; shape_type=&#8221;&#8221;][vc_column column_padding=&#8221;no-extra-padding&#8221; column_padding_tablet=&#8221;inherit&#8221; column_padding_phone=&#8221;inherit&#8221; column_padding_position=&#8221;all&#8221; column_element_spacing=&#8221;default&#8221; background_color_opacity=&#8221;1&#8243; background_hover_color_opacity=&#8221;1&#8243; column_shadow=&#8221;none&#8221; column_border_radius=&#8221;none&#8221; column_link_target=&#8221;_self&#8221; gradient_direction=&#8221;left_to_right&#8221; overlay_strength=&#8221;0.3&#8243; width=&#8221;1\/1&#8243; tablet_width_inherit=&#8221;default&#8221; tablet_text_alignment=&#8221;default&#8221; phone_text_alignment=&#8221;default&#8221; bg_image_animation=&#8221;none&#8221; border_type=&#8221;simple&#8221; column_border_width=&#8221;none&#8221; column_border_style=&#8221;solid&#8221;][vc_column_text]\n<h3 style=\"text-align: center;\">You&#8217;re in Good Company<\/h3>\n[\/vc_column_text][divider line_type=&#8221;No Line&#8221; custom_height=&#8221;30&#8243;][clients columns=&#8221;4&#8243; hover_effect=&#8221;greyscale_to_color&#8221; additional_padding=&#8221;4&#8243; carousel=&#8221;true&#8221;][client image=&#8221;2549&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263126-2&#8243; tab_id=&#8221;1650376263126-7&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][client image=&#8221;2552&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263150-1&#8243; tab_id=&#8221;1650376263150-4&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][client image=&#8221;2550&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263163-0&#8243; tab_id=&#8221;1650376263164-3&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][client image=&#8221;2551&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263178-4&#8243; tab_id=&#8221;1650376263178-7&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][client image=&#8221;2667&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263192-6&#8243; tab_id=&#8221;1650376263192-6&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][client image=&#8221;2666&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263205-9&#8243; tab_id=&#8221;1650376263205-6&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][client image=&#8221;2665&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263220-9&#8243; tab_id=&#8221;1650376263220-7&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][client image=&#8221;2664&#8243; url_target=&#8221;_blank&#8221; title=&#8221;Client&#8221; id=&#8221;1650376263232-3&#8243; tab_id=&#8221;1650376263232-6&#8243;][vc_column_text]Click the edit button to add your testimonial.[\/vc_column_text][\/client][\/clients][\/vc_column][\/vc_row]\n","protected":false},"excerpt":{"rendered":"<p>[vc_row type=&#8221;full_width_background&#8221; full_screen_row_position=&#8221;middle&#8221; column_margin=&#8221;default&#8221; equal_height=&#8221;yes&#8221; content_placement=&#8221;middle&#8221; column_direction=&#8221;default&#8221; column_direction_tablet=&#8221;default&#8221; column_direction_phone=&#8221;default&#8221; bg_color=&#8221;#ffffff&#8221; scene_position=&#8221;center&#8221; text_color=&#8221;dark&#8221; text_align=&#8221;left&#8221; row_border_radius=&#8221;none&#8221; row_border_radius_applies=&#8221;bg&#8221; id=&#8221;header_row&#8221; overlay_strength=&#8221;0.3&#8243; gradient_direction=&#8221;left_to_right&#8221; shape_divider_color=&#8221;#faf6ee&#8221; shape_divider_position=&#8221;bottom&#8221;&#8230;<\/p>\n","protected":false},"author":19,"featured_media":0,"parent":20697,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"inline_featured_image":false,"footnotes":""},"class_list":["post-22570","page","type-page","status-publish"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.3 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Big Red Cloud Power Accounting \u2013 How To Guide - Big Red Cloud<\/title>\n<meta name=\"description\" content=\"Read this guide to help you with Big Red Cloud Power Accounting Template and Big Red Cloud Power Accounting Add-in for Excel.\" \/>\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\/en\/support\/big-red-cloud-power-accounting-guide\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Big Red Cloud Power Accounting \u2013 How To Guide\" \/>\n<meta property=\"og:description\" content=\"Read this guide to help you with Big Red Cloud Power Accounting Template and Big Red Cloud Power Accounting Add-in for Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-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-04-19T13:51:07+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=\"13 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Big Red Cloud Power Accounting \u2013 How To Guide - Big Red Cloud","description":"Read this guide to help you with Big Red Cloud Power Accounting Template and Big Red Cloud Power Accounting Add-in for Excel.","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\/en\/support\/big-red-cloud-power-accounting-guide\/","og_locale":"en_US","og_type":"article","og_title":"Big Red Cloud Power Accounting \u2013 How To Guide","og_description":"Read this guide to help you with Big Red Cloud Power Accounting Template and Big Red Cloud Power Accounting Add-in for Excel.","og_url":"https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-power-accounting-guide\/","og_site_name":"Big Red Cloud","article_publisher":"https:\/\/www.facebook.com\/SimpleOnlineAccounts","article_modified_time":"2022-04-19T13:51:07+00:00","twitter_card":"summary_large_image","twitter_site":"@BigRedCloud","twitter_misc":{"Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-power-accounting-guide\/","url":"https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-power-accounting-guide\/","name":"Big Red Cloud Power Accounting \u2013 How To Guide - Big Red Cloud","isPartOf":{"@id":"https:\/\/bigredcloud.com\/#website"},"datePublished":"2022-01-21T11:56:35+00:00","dateModified":"2022-04-19T13:51:07+00:00","description":"Read this guide to help you with Big Red Cloud Power Accounting Template and Big Red Cloud Power Accounting Add-in for Excel.","breadcrumb":{"@id":"https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-power-accounting-guide\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-power-accounting-guide\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/bigredcloud.com\/en\/support\/big-red-cloud-power-accounting-guide\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/bigredcloud.com\/en\/"},{"@type":"ListItem","position":2,"name":"Support","item":"https:\/\/bigredcloud.com\/en\/support\/"},{"@type":"ListItem","position":3,"name":"Big Red Cloud Power Accounting \u2013 How To 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\/pages\/22570","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/types\/page"}],"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=22570"}],"version-history":[{"count":0,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/pages\/22570\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/pages\/20697"}],"wp:attachment":[{"href":"https:\/\/bigredcloud.com\/en\/wp-json\/wp\/v2\/media?parent=22570"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}