cats:procedures:accounting:glfinancialsreports

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
cats:procedures:accounting:glfinancialsreports [2015/09/14 19:10] amandacats:procedures:accounting:glfinancialsreports [2019/04/04 15:39] (current) – [G/L Statement] jen
Line 1: Line 1:
 =====G/L, Financials Reports===== =====G/L, Financials Reports=====
 The G/L, Financials reports section is used to see an overview of the state of the general ledger, along with a detailed G/L statement.  The G/L, Financials reports section is used to see an overview of the state of the general ledger, along with a detailed G/L statement. 
 +{{entry>0;General Ledger/Financial Reports;-}}
 Set up your reports, including names of groups and what sign (negative or positive) each group should display on the report. The specifics of which groups of G/L accounts each of these reports includes is dictated by you and [[cats:procedures:accounting:chartofaccounts|set up from the G/L scan]] using the **Tools > File > Chart** options.  Set up your reports, including names of groups and what sign (negative or positive) each group should display on the report. The specifics of which groups of G/L accounts each of these reports includes is dictated by you and [[cats:procedures:accounting:chartofaccounts|set up from the G/L scan]] using the **Tools > File > Chart** options. 
  
Line 16: Line 16:
   * Current/Opn Bal - Only include accounts with a Current or Opening Balance for the fiscal year.    * Current/Opn Bal - Only include accounts with a Current or Opening Balance for the fiscal year. 
   * MM/DD/YYYY (One Accounting Period) - Only show accounts with activity or balance for that period.   * MM/DD/YYYY (One Accounting Period) - Only show accounts with activity or balance for that period.
-  * +
 The **Condense G/L  - Yes** filter option is useful if you are using Divisions and Departments and want to see all of the same G/L number together, instead of listed as a separate line item by division/department.  The **Condense G/L  - Yes** filter option is useful if you are using Divisions and Departments and want to see all of the same G/L number together, instead of listed as a separate line item by division/department. 
  
Line 47: Line 47:
  
 ====G/L Statement==== ====G/L Statement====
-All details of transactions that involve the general ledger can be viewed using G/L statement reports. Here you can see individual transactions that were posted to the general ledger. +All details of transactions that involve the general ledger can be viewed using G/L statement reports. Here you can see individual transactions that were posted to the general ledger. 
 + 
 Important filters and their usual settings include: Important filters and their usual settings include:
-File - Current Period +  * File - Current Period 
-G/L Accts Bal/Act - Current/Opn Bal +  G/L Accts Bal/Act - Current/Opn Bal 
-G/L Acct Range - Select or All +  G/L Acct Range - Select or All 
-Date Range - All or Select +  Date Range - All or Select 
-Condense G/L - No (unless you want to condense divisions/departments into one G/L account+  Condense G/L - No (unless you want to condense divisions/departments into one G/L account).
  
- +A unique feature of this report is the **Offsetting G/L#** filter, which allows you to search for one G/L in the account range and expand the results by the second offsetting G/L in the Offsetting G/L filter. So if you put in **G/L Acct Range - Select** for 11000-11000, and an **Offsetting G/L#** range of 77000-77000, you would see all transactions that hit 11000 along with the opposite sides going to 77000. 
- +
-A unique feature of this report is the Offsetting GL# filter, which allows you to search for one G/L in the account range and expand the results by the second offsetting G/L in the Offsetting GL filter. So if you put in G/L Acct Range - Select for 11000-11000, and an Offsetting GL# range of 77000-77000, you would see all transactions that hit 11000 along with the opposite sides going to 77000. +
  
 Here is a sample G/L statement: Here is a sample G/L statement:
 +[{{:cats:procedures:accounting:accountingreports_glstatementportionsample.png|Sample GL Statement}}]
  
 +This report is showing all G/L Entries for one month.
  
  
 ====Balance Sheet==== ====Balance Sheet====
-The Balance Sheet typically includes all G/L accounts found under the Assets and Liabilities categories, and is offset on the report by the Retained Earnings G/L account. This report uses the same filters as the Income Statement, such as the G/L Accts Bal/Act filter. +The Balance Sheet typically includes all G/L accounts found under the **Assets** and **Liabilities** categories, and is offset on the report by the **Retained Earnings** G/L account. This report uses the same filters as the Income Statement, such as the **G/L Accts Bal/Act** filter.
  
 +You can compare the balance sheet numbers to the balance sheet portion of the Trial Balance report.
  
 Below is a sample Balance Sheet. Below is a sample Balance Sheet.
 +[{{:cats:procedures:accounting:accountingreports_balancesheetsample.png|A Sample Balance Sheet}}]
 +
  
 +{{tag>"trial balance" "balance sheet"}}
  • cats/procedures/accounting/glfinancialsreports.1442257812.txt.gz
  • Last modified: 2017/12/19 03:21
  • (external edit)