cats:procedures:accounting:reportsandjournals

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:reportsandjournals [2015/10/13 13:06] amandacats:procedures:accounting:reportsandjournals [2017/12/19 03:21] – external edit 127.0.0.1
Line 1: Line 1:
 =====Transaction Reports, Statements, and Journals===== =====Transaction Reports, Statements, and Journals=====
 +{{entry>0;Transaction Reports;-}}{{entry>0;Account/Statement;-}}{{entry>0;Statements;-}}
 From this area, you can see lists of transactions, a detailed report of account-related transactions, G/L statement, Bank Statement, and Account Statement. Here we explore the types of reports available and typical settings you can use.  From this area, you can see lists of transactions, a detailed report of account-related transactions, G/L statement, Bank Statement, and Account Statement. Here we explore the types of reports available and typical settings you can use. 
  
Line 6: Line 7:
 To access these reports, select **Accounting > Trans Reports, Jr** and choose from: To access these reports, select **Accounting > Trans Reports, Jr** and choose from:
  
-**Receipts** - Only receipts entered in the ledger.  +  * **Receipts** - Only receipts entered in the ledger.  
-**Disbursements** - Only disbursements entered in the ledger. +  **Disbursements** - Only disbursements entered in the ledger. 
-**Recpts/Disbursements** - Includes receipts and disbursements on one report. +  **Recpts/Disbursements** - Includes receipts and disbursements on one report. 
-**Invoices** - View invoice entries as they look when posted to the ledger. +  **Invoices** - View invoice entries as they look when posted to the ledger. 
-**G/L Journal Entries**+  **G/L Journal Entries** - Entries created against G/L numbers that do not reference banks or invoices. 
 <note>Note: Bank transfers will be shown under their respective sides - disbursements for withdrawals and receipts for deposits.</note> <note>Note: Bank transfers will be shown under their respective sides - disbursements for withdrawals and receipts for deposits.</note>
 +[{{:cats:procedures:accounting:accountingreports_transactionreportsmenu.png|Transaction report types available in CATS.}}]
  
 The filters, columns, and orders available are basically the same for all types of transaction reports. The most important filter is the **File** filter, which determines which set of data you will be using.  The filters, columns, and orders available are basically the same for all types of transaction reports. The most important filter is the **File** filter, which determines which set of data you will be using. 
 +[{{:cats:procedures:accounting:accountingreports_filefilterscreen1.png|Use the File filter to select a set of records.}}]
  
 Options for which file to look at are: Options for which file to look at are:
-**Journal** - Prints a limited-use journal to keep as a reference. +  * **Journal** - Prints a limited-use journal to keep as a reference. 
-**Pending** - Pending transactions (not posted to the General Ledger). +  **Pending** - Pending transactions (not posted to the General Ledger). 
-**Current** - Usually you will use this option to see all items for the current fiscal year. +  **Current** - Usually you will use this option to see all items for the current fiscal year. 
-**History** - Use this to see items from past years. +  **History** - Use this to see items from past years. 
-**Current and History** - Combines current and past fiscal years.+  **Current and History** - Combines current and past fiscal years.
  
-Account and Date Range filters can also help you narrow the focus of the report. The option to Show Offset - Yes will add a line item to every item on the report showing the opposite side of the transaction. This option helps you see how every transaction affects the entire general ledger.+**Account** and **Date Range** filters can also help you narrow the focus of the report.  
 + 
 +<note tip>The option to **Show Offset - Yes** will add a line item to every item on the report showing the opposite side of the transaction. This option helps you see how every transaction affects the entire general ledger.</note>
  
 A good order to select, especially for Receipts/Disbursement reports, is the one shown here: A good order to select, especially for Receipts/Disbursement reports, is the one shown here:
 +[{{:cats:procedures:accounting:accountingreports_transactionsampleorder.png|Sample order for transaction report types.}}]
  
-First by Type with Subtotal, then by Date, then by Invoice Number.+First by **Type** with Subtotal, then by **Date**, then by **Invoice Number**.
  
 On the bottom of most accounting reports, you can see how these transactions affect the general ledger with an optional Summary of G/L changes. On the bottom of most accounting reports, you can see how these transactions affect the general ledger with an optional Summary of G/L changes.
- +[{{:cats:procedures:accounting:accountingreports_bottomsummary.png|Summary of ledger numbers affected.}}]
  
 Below is a sample Receipts/Disbursements report, with typical filters selected. Below is a sample Receipts/Disbursements report, with typical filters selected.
 +[{{:cats:procedures:accounting:accountingreports_samplerecdisbreport.png|A sample Receipt and Disbursement report.}}]
  
 ====Account Statement==== ====Account Statement====
-The Account statement can be printed from the **Accounting > Account Statement** menu choice. The Account Statement is a unique format, set up like a letter to the counterparty showing all open invoices for one account. If you print a range of accounts, each account’s statement will open in a new file (or print on a new page).+The Account statement can be printed from the **Accounting > Account Statement** menu choice.  
 +[] 
 + 
 +The Account Statement is a unique format, set up like a letter to the counterparty showing all open invoices for one account. If you print a range of accounts, each account’s statement will open in a new file (or print on a new page).
  
 Note: This is a different report format from the report printed under the Accounting > Accts:Name/Addr > Print Report menu option, which includes the Aging report. See Session 5A for that report.  Note: This is a different report format from the report printed under the Accounting > Accts:Name/Addr > Print Report menu option, which includes the Aging report. See Session 5A for that report. 
Line 62: Line 71:
 A sample bank statement report is displayed below. A sample bank statement report is displayed below.
  
 +{{tag>"Transaction Reports" "Account Statement" "Bank Statement"}}
  • cats/procedures/accounting/reportsandjournals.txt
  • Last modified: 2019/04/12 18:39
  • by amanda