G-Accon Help Center

Export Budget vs Actual Report into Google Sheets

SECTIONS IN THIS ARTICLE

What are Formatted Reports
How to generate Formatted Reports
How to design reports using Report Style feature
List of Formatted Reports
Watch a video "How to design reports using Report Style feature

What are Formatted Reports

The "Formatted Reports" deliver a comprehensive overview of your company's financial well-being and performance. These reports present a top-level perspective on your business's crucial financial indicators, empowering you to make informed decisions.

These reports come with pre-designed templates that include default styles, fonts, and layouts. However, G-Accon users have the flexibility to easily customize these templates to align with their unique requirements.

How to generate Formatted Reports

Generating Reports:

• Go to the menu and select "Extensions"
• Choose "G-Accon for Xero".
• Click on "Get Accounting Data/Reports"
• Select "Formatted Reports"

There are multiple business accounting reports you can select from the drop down box which allow you to create reusable templates for later on usage.

For example, you select the Budget vs Actual option from the drop-down menu. G-Accon for Xero provides the ability to set up the Date Range for your data manually or you can refresh your data dynamically.

Select parameters

There are required and optional attributes for the Budget vs Actual report.

Dynamic Date: The report data will be calculated based on pre-populated values like This Month, This Quarter, This Year, Last Month, etc.

Static Date Range: Define specific start and end dates.

Custom Date Range: Utilize cell references in your Google Sheet to set custom dates.

Required Attributes

Make selections for required attributes:

• To compare with a specified number of periods (###).
• Choose the desired Account Types.
• Select relevant Accounts, Cash Basis, Tracking Categories
  

Periods

Account Types (Accrual/Cash)

Accounts

CHANGE PULL SETTINGS

Customize report behavior with these optional features:

• Create a New Google Sheet: Generate the report in a new tab or worksheet.
• Hide Grid Lines: Conceal grid lines in your worksheet for a cleaner look.
• Show Negatives in Red: Negative values will be displayed in red in your Google Sheet report.
• Create Deep Links to QuickBooks: Generate links to QuickBooks for viewing specific items.
• Show Only Whole Numbers: Display only whole numbers in the report.
• Only Total Summaries: Show report summaries without detailed information.
• Add the Last Updated Timestamp to the Title: Include a "Last Update" field showing the latest data refresh date and time.
  

You have the option to specify the template's name in the "Template Name" field.

How to design Formatted Reports using Report Style feature

Report style SETTINGS

Customize the style of your report using Report Style Settings:

• Configure various aspects such as title, header style, colors, background, and fonts.
• Select specific report sections (title, headers, sub-section totals) and customize font styles, sizes, colors, and borders.
  
  

Customize your report to create a unique and distinctive presentation.

Here's the revised design of the Budget vs Actual report:

MULTI-CURRENCY CONVERTER (OPTIONAL FEATURES)

If you need to generate the report in a specific currency, follow these steps:

• Choose the report currency (e.g., "EUR").
  
  Decide how to get exchange rates:
  • Use Latest Rates: The report uses the latest available exchange rate.
  • Use Custom Rates: Set your own exchange rates for a specific date or create a separate tab with multiple custom rates.
  • Use Custom Rates for Periods: Set custom rates for specific periods in the same way.

Using Latest Rates: If you select "Use Latest Rates" and click "Execute," the report uses the latest exchange rate from the provider each time you refresh the report.

Using Custom Rates: Choose "Use Custom Rates," specify a date, and decide whether to get rates directly or create a separate tab with custom rates. This feature lets you manually adjust exchange rates for the report.

Using Custom Rates for Periods: Select "Use Custom Rates for Periods" and set custom rates for specific periods. You can use the exchange rate screen or create a separate tab for this purpose.

Finally, click "Execute" to generate the report in your chosen currency, and it will appear in your Google Sheet.

How to schedule automatic data refresh?

To schedule automatic data refresh, follow these steps:

• Create a workflow by selecting the "Create Workflow" option.
• In this workflow, you can set up auto-refresh and notification processes.
• Automatic workflows allow you to create various workflows, add specific templates, and set different schedules for each workflow.
• You can also notify customers, clients, and team members with various automatic notifications, all within the same spreadsheet.
• For more details, refer to the "Create Workflow" documentation here.
  

How modify your report and update your template?

During the refresh process, if you need to modify your report, follow these steps:

• Click on "Extensions" in the menu.
• Choose "G-Accon for Xero"
• Select "Edit Templates for Current Sheet"
• To Refresh and Modify a template there is no need to be signed in into the organization

Select the template, make the necessary changes to it and Update the template or Update and Execute  the new query.