Page tree
Skip to end of metadata
Go to start of metadata

Reports

What are Reports?
AccountingBook provides many standard reports that you can generate for yourself. You can also set up the customized reports in your organizations' data files and memorize them.


 

 

SalesForce for AccountingBook delivers standard report folders containing reports for each record type such as Leads, Accounts and Opportunities. These reports are used as the starting point for your organization's reporting efforts.


SalesForce for AccountingBook allows all users to run, customize and create reports. You may create new report from a standard report and save it in My Personal Custom Reports folder. In the left side you can view all the folders that you as a user have accesses. You can save your custom report in the folder in My Personal Custom Reports.
 
Types of Reports


SalesForce supports four report formats.
1.     Tabular Reports: A simple listing of data without any subtotals
2.     Summary Reports: A listing of data with groupings and subtotals
3.     Matrix Reports: A comparison of related totals, with totals by both rows and column
4.     Joined Reports: Enables you to add up to five report blocks to display different related data.



The default view shows you the most recently viewed reports and Dashboards.
A. Using keywords you can search custom reports, this search looks for the key words in the name and the description fields
B. You can filter reports by Views
C. You can filter reports by Types



 
A. You can click New Report to create a new report through report builder button
B. You can click New Dashboard to create a new report through dashboard builder button
C. You can type the folder name or to find the folder in the search box. You need not type the exact name, instead you can type the part of the folder name and the search will do the rest of the work for you
D. You can also create or manage folders from this plane to control access your reports and dashboards
 
How to run a Report?


Click a standard report title to run a Report. We will select the (1) AccountingBook Reports and then (2) click on Customer Balances

Once you click on the Customer Balances a new page is opened as below



To start with the customization of the report, click on the customize button, new options for the reports gets populated as below.



Now you should be able to add customization to the standard report and save it for the future reference. Consider the below pic
 

 
1.     Drag the columns which you would like to see in the report
2.     The report matrix which can be is customized by adding columns and rows
3.     Once you have added all the fields to the report, to view the customized report you need to click on Run Report
4.     To save the report you need to click on the Save As button, the report gets saved in the My Personal Customs Report


Let us add the Date, Type and Document Type by way of dragging into the reports field and see how it looks


We have summarized information by Customer: Account Name in the Report, which shows us the number of invoices pending for the customer type.


To save this view of the report, click on Save As and give it a name to save the Report.


Financial Reports


Apart from the standard reports, AccountingBook supports financial reports of the business entities or individuals. You can access the financial reports in the home page under AccountingBook links on the top-left hand side of the computer screen
 

 
Profit and Loss Report


On clicking on P&L Report, the Profit and Loss Report is opened


  
1.     You can select the Date Range on clicking on the dropdown via YTD or Quarter to date by the given options and select the start date and end date
2.     You can group the selection by Group by option via Week, Month, Quarter or Year
3.     Click on the Go button to see the selected report below
4.     You can also download the report and save it for future references
 
Trial Balance


Click on the trial balance link in the in the AccountingBook Tab in the Home Page, the Trial Balance page gets opened. You can download the report and save it for future references from the Download button provided
 

Balance Sheet


Click on the balance sheet link in the in the AccountingBook Tab in the Home Page, the Balance Sheet page gets opened
 

 
1.     You can select the Date Range on clicking on the dropdown via YTD or Quarter to date by the given options and select the start date and end date
2.     You can group the selection by Group by option via Week, Month, Quarter or Year
3.     Click on the Go button to see the selected report below
4.     You can also download the report and save it for future references
 

  • No labels