Transaction Reports, Statements, and Journals [CATS Knowledge Base]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
=====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. 

====Transaction Reports====
Transaction reports all use general ledger entries to display details about items posted to the ledger. 
To access these reports, select **Accounting > Trans Reports, Jr** and choose from:

  * **Receipts** - Only receipts entered in the ledger. 
  * **Disbursements** - Only disbursements entered in the ledger.
  * **Recpts/Disbursements** - Includes receipts and disbursements on one report.
  * **Invoices** - View invoice entries as they look when posted to the ledger.
  * **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>
[{{: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. 
[{{:cats:procedures:accounting:accountingreports_filefilterscreen1.png|Use the File filter to select a set of records.}}]

Options for which file to look at are:
  * **Journal** - Prints a limited-use journal to keep as a reference.
  * **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.
  * **History** - Use this to see items from past 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. 

<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:
[{{:cats:procedures:accounting:accountingreports_transactionsampleorder.png|Sample order for transaction report types.}}]

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.
[{{:cats:procedures:accounting:accountingreports_bottomsummary.png|Summary of ledger numbers affected.}}]

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====
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. 

There are several format options for printing the **Account Statement** from CATS. The types of reports are described in this section. 

===Standard Report===
Here is a sample Standard Account Statement.


This format can be set up to print with your company’s logo and letterhead, so that you can send it directly to the counterparty as their account statement.

===Transactions===
A Transactions Account Statement shows a list of the transactions that have been entered for that account, usually for a Date Range. Unlike the Open Invoices format, this shows all transactions for the counterparty, not just the 
Below is a sample Transactions Account Statement.

====Bank Statement====
The bank statement shows all transactions affecting one or more banks. It is used in conjunction with the Bank Reconciliation and Import Transactions features (see Session 5B) to reconcile your internal CATS bank statement with the statement sent to you by the bank.

Usually you set the filters to:
Bank - Select or All, with an order and subtotal by bank.
Date Range - Month to Date or Select.
Deposit Slips - Include
Prior Balance - Omit if zero - Hides the prior period amount if it is zero. Useful for eliminating extraneous transactions.

A sample bank statement report is displayed below.

{{tag>"Transaction Reports" "Account Statement" "Bank Statement"}}