Generate Formatted Profit and Loss by Customer Report into Google Sheets
Design Template
How to design reports using Report Style feature
Schedule Automatic Refresh
Modify Template
Watch a video "How to design reports using Report Style feature"
Formatted Reports are pre-designed templates featuring default styles, fonts, and layouts, but they are easily customizable by G-Accon users to meet their specific needs.
Generating Formatted Report:
Choose the "Profit and Loss By Customer" report from the drop-down menu in Business Overview Reports.
There are required and optional attributes for the Profit and Loss By Customer 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.
Make selections for required attributes:
To compare with ( ### ) periods
Accounting Method
Accounts
Locations
Classes
Items
Customize report behavior with these optional features:
You have the option to specify the template's name in the "Template Name" field, such as "Profit and Loss for Organization ABC."
Customize the style of your report using Report Style Settings:
Customize your report to create a unique and distinctive presentation.
Here's the revised design of the Profit and Loss By Customer report:
If you need to generate the report in a specific currency, follow these steps:
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.
To schedule automatic data refresh, follow these steps:
During the refresh process, if you need to modify your report, follow these steps:
Select the template, make the necessary changes to it and Update the template or Update and Execute the new query.