Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revisionBoth sides next revision | ||
cats:procedures:accounting:glfinancialsreports [2015/09/14 19:10] – amanda | cats:procedures:accounting:glfinancialsreports [2016/04/04 15:08] – 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> | ||
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: | 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: | ||
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/ | 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/ | ||
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 Acct Range - Select or All | + | |
- | Date Range - All or Select | + | |
- | Condense G/L - No (unless you want to condense divisions/ | + | |
- | + | 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, | |
- | + | ||
- | 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, | + | |
Here is a sample G/L statement: | Here is a sample G/L 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. | ||
+ | [{{: | ||
+ | |||
+ | {{tag>" |