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
Last revisionBoth sides next revision
cats:procedures:accounting:glfinancialsreports [2015/09/14 19:10] amandacats:procedures:accounting:glfinancialsreports [2017/12/19 03:21] – external edit 127.0.0.1
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 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. 
- +
-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.txt
  • Last modified: 2019/04/04 15:39
  • by jen