The Monthly Activity Report is designed to display all activity for a specific bank account within a given date range.  The resulting report groups the transactions printed into the following categories:

Transaction by Check.  These are the manual, system or salesman checks.

Adjustments.  These are the adjustments added to the reconciliation.

Cash Receipts.  These are the deposits entered into the system through Cash Receipts Application and Cash Receipts Register on the A/R menu.

Prepayments.  These are the cash receipts entered through the Customer Prepayments Register on the OP1 menu.

Miscellaneous Deposits.  These are non-A/R related deposits that are distributed to the General Ledger through a Journal Entry.  These deposits are entered through Deposit Posting on the BRS menu.  Non-A/R cash receipts entered into the system through Cash Receipts Application are included in the Cash Receipts category.

Report Setup

Branch Code.  Enter the branch code for the activity report to print or enter Spacebar for all branches.

Bank Code.  Enter the bank code for the activity report to print.

Period Start and End Date.  Enter the date range for the report to print.

Starting Balance.  This is the starting balance from the bank statement, not the ending balance.

Within each category, the report contains a heading designating which category of entries follows, line item detail of each transaction, and a total for both debits and credits.  These headers are:

Check #.  This is the check number of the transaction, Adjust=Adjustment, CshRec=Cash Receipts, Prepay=Customer Prepayments, and |Misc|=Miscellaneous Deposits

Type.  This header only applies to the Transactions by Check category.  M=Manual Checks, A=System A/P checks, and S=Salesman checks.

Date.  This is the date the transaction was posted to the General Ledger.

Item Description.  This header lists the check payee, the reason for the adjustment, if entered, and the deposit type and reason, if entered.

Debits/Credits.  This is the monetary amount of the transaction.

REMEMBER: The BRS system was written in bank language.  A credit in the General Ledger is a debit in BRS and vice versa.

At the end of the report, a summary reconciliation is printed.  The information given is:

Starting Balance. This is the bank statement starting balance entered in the report setup.

Total Credits. This is the total of all credit transactions listed on the report.

Total Debits. This is the total of all debit transactions listed on the report.

New Balance. This is the total of 1, 2, and 3 above.

The Monthly Activity Report is a good report to print in conjunction with the Reconciliation Report.  The Monthly Activity Report lists all activity and may be used as a guide in reconciling the items on the Bank Reconciliation.