Personal tools

Difference between revisions of "34 Summary Sheet"

From TrueERP wiki

Jump to: navigation, search
(Created page with "Summary Sheet Can you open the summary sheet? The Summary Report can be used to look at a snapshot of your Company accounts. It includes: Cash At Bank, Accounts Payable & Rece...")
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
Summary Sheet
+
'''Summary Sheet'''
  
Can you open the summary sheet?
+
Can you open the '''Summary Sheet?'''
  
The Summary Report can be used to look at a snapshot of your Company accounts. It includes:
+
The '''Summary Report''' can be used to look at a snapshot of your Company accounts. It includes the following '''Cash In Bank''', '''Accounts Payable & Receivable''' amounts, '''Sales''', '''COGS''', '''Expenses '''and '''P & L''' for the last week; last month; last three months; and last year. The user has the ability to '''Drill Into''' any of these options to view the details.
  
Cash At Bank, Accounts Payable & Receivable amounts, Sales, COGS, Expenses and P & L for the last week; last month;
+
*To use the '''Summary Report''' select the '''Accounts''' module then the '''Summary Sheet''' button  
last three months; and last year. The user has the ability to drill into any of these options to view the details.
+
*Set the '''As Of Date''' in the top Right hand Corner  
 
+
*'''Drilling''' into the fields within the report will open another window revealing relevant information and details about the field you have drilled into '''E.g''' Drilling into the field '''Cash in Bank''' will open the '''Balance Transaction List''' displaying the same '''Date Range'''
How to Use the Summary Report.
+
*Drilling into the '''Accounts Receivable''' Field opens the '''Accounts Receivable''' List.  
 
+
*'''Accounts Payable''' field opens the '''Accounts Payable''' window.  
Opening the Summary Report.
+
*'''Balance Sheet''' Field opens the '''Balance Sheet''' window  
Select Accounts tab
+
*In the '''Sales''' section all fields open the '''Details By Account''' window  
Click on the Summary Report button
+
*In the '''Cost of Goods Sold''' section all fields open the '''Details By Account''' window  
Set the Date of the "Summary Report" in the top Right hand Corner
+
*In the '''Expenses''' section all fields open the '''Details By Account''' window  
 
+
*In the '''Profit and Loss''' section all fields open the '''Profit and Loss''' window  
Drilling into the Report
+
*For details on Exporting and Printing see '''Global Options'''
Drilling into the fields within the report will open another window revealing relevant information and details about the field  
+
you have drilled into. For Example Drilling into the field " Cash in Bank" will open the "Balance Transaction List" displaying the  
+
same "Date Range"
+
 
+
Drilling into the…
+
"Accounts Receivable" Field opens the "Accounts Receivable" List.
+
"Accounts Payable" Filed opens the "Accounts Payable" window.
+
"Balance Sheet" Field opens the "Balance Sheet" window
+
In the "Sales" section all fields open the "Details By Account" window
+
In the "Cost of Goods Sold" section all fields open the "Details By Account" window
+
In the "Expenses" section all fields open the "Details By Account" window
+
In the "Profit and Loss" section all fields open the "Profit and Loss" window
+
 
+
For details on Exporting and Printing see Global Options
+

Latest revision as of 12:41, 27 September 2011

Summary Sheet

Can you open the Summary Sheet?

The Summary Report can be used to look at a snapshot of your Company accounts. It includes the following Cash In Bank, Accounts Payable & Receivable amounts, Sales, COGS, Expenses and P & L for the last week; last month; last three months; and last year. The user has the ability to Drill Into any of these options to view the details.

  • To use the Summary Report select the Accounts module then the Summary Sheet button
  • Set the As Of Date in the top Right hand Corner
  • Drilling into the fields within the report will open another window revealing relevant information and details about the field you have drilled into E.g Drilling into the field Cash in Bank will open the Balance Transaction List displaying the same Date Range
  • Drilling into the Accounts Receivable Field opens the Accounts Receivable List.
  • Accounts Payable field opens the Accounts Payable window.
  • Balance Sheet Field opens the Balance Sheet window
  • In the Sales section all fields open the Details By Account window
  • In the Cost of Goods Sold section all fields open the Details By Account window
  • In the Expenses section all fields open the Details By Account window
  • In the Profit and Loss section all fields open the Profit and Loss window
  • For details on Exporting and Printing see Global Options