Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: Description: cubslogos_horizontal

Payments Report

<<ETA Menu          Home        ETA Features>>

 

The Payments report is similar to the Daily Trans report except it does not include NSF’s, Reversals or Reposts.

Calculates and reports General Ledger account numbers and includes break out of trust accounts.

 

This report produces an audit trail of the daily postings of debtor payments, client payments, and A/R adjustments. 

Adjustment transactions (such as a Trans Code 3) can optionally be included, but they are not part of the general ledger reporting.

 

Non-Shared is broken out

 

Agency Supplied Entry is an optional feature that CCI can install if requested.

            Batch prompt in Posting – Identifies the posting batches by the type of payment that is being posted.

 

Last page of the report:

The operating and trust amounts are broken out by each trust account number/name.

These numbers are reliable for making deposits into the various trust accounts.

For an example of how the Excel spreadsheet cells would be populated refer to the Daily General Ledger example.

The following entries should be made to your accounting system from this report:

o   Daily Payments entry off the Payments Report (areas highlighted below)

 Text Box: 21:43  05 MAY 2010                     POSTING SUMMARY for [YOUR AGENCY NAME]         (CCI)          PAGE 1
Accounting Month: May 2010                                  05-05-10

                                                             AGN/AMT    INTEREST       OTHER  DUE-CLIENT  COMMISSION      FWD-FEES
GRAND TOTAL ALL PAYMENTS                                  297,805.19      275.94   12,643.00  208,392.81   62,776.40          0.00
GRAND SUBTOTAL PAID CLIENT                                 56,899.57       18.49        0.00        0.00   10,889.62          0.00
GRAND SUBTOTAL NON SHARED                                       0.00        0.00        0.78        0.00   10,889.62          0.00
GRAND TOTAL ADJUSTMENTS                                         0.00        0.00        0.00        0.00        0.00          0.00

                                                                CASH     NON-CASH
                                                             --------    --------
            CASH PRIN pmt-pd agency                   1    27,906.09
            NC PRIN pmt-pd client                     2                 53,245.23
            ACCNTNG CLIENT pmt                        8    12,642.22
            CASH INTEREST pmt-pd agency              15       124.63
            NC ADJ A/R chg/adj                       16                    800.00
            NC INTEREST pmt-pd client                18                     18.49
            CASH ASGN INT pmt-pd agency              38     1,377.07
            NC ASGN INT pmt-pd client                40                    795.94
            CASH AMISC1 pmt-pd agency                60       907.10
            NC AMISC1 pmt-pd client                  62                    965.06
            CASH AMISC2 pmt-pd agency                71        79.87
            NC AMISC2 pmt-pd client                  73                  1,893.34
            OVERPMT pmt-pd agency                   191         0.78
            REPO ADJ/PMT CHRG                       376
            NC ADJ WE PAY OURSELVES                 390                    103.05
            NC ADJ CLIENT ADJUSTMENTS               393                   -408.74
            MG PRIN pmt-pd agency                   425     1,570.60
            MG ASSGN INT pmt-pd agency              426       151.12
            CC V/M PRIN pmt-pd agency               450     7,700.22
            CC V/M ASSGN INT pmt-pd agency          451       302.17
            CC V/M INT pmt-pd agency                452        46.82
            CC V/M AMISC1 pmt-pd agency             453        70.90
            CC V/M/D AMISC2 pmt-pd agency           455        30.00
            WU PRIN pmt-pd agency                   462       965.06
            WU ASSGN INT pmt-pd agency              463        10.61
            CC VMD AMISC3 pmt-pd agency             477         6.00
            DC PRINT pmt-pd agency                  495     2,237.31
            GD PRIN pmt-pd agency                   520       200.00
            RBP INT pmt-pd agency                   814        23.95
  Note: [Not all transactions shown in this example]
                                                       -------------
                           BANK DEPOSIT:                  253,806.07


Payments Report Continued

                           AVAILABLE REVENUE
                                                                      Debit                          Credit
                           TOTAL COMMISSIONS        62,776.40                                     62,776.40A (Fee)
                           LESS FORWARD FEES             0.00          0.00B (FWD Fee)
                           LESS 100% REMITS         19,116.52     19,116.52C1 (A/R)
                           LESS D/P COMM            10,889.62     10,889.62C2 (A/R)
                           AR/AP ADJ                                 494.31D
                           PLUS CLIENT REMIT        12,642.22                                     12,642.22E (A/R)
                           PLUS NON-SHD AGN/AMT          0.00                                          0.00 (NS Fee)
                           PLUS NON-SHD INTEREST         0.00                                          0.00 (NS Fee)
                           PLUS CASH PRIN pmt-pd         0.78                                          0.78F (NS Fee)
                           ----------------------------------
                           Available Cash           45,413.26     45,413.26G (Operating Acct)
                           Trust Cash              208,392.81    208,392.81H (Trust Deposit)     208,392.81H (A/P Due Client)
                           ----------------------------------
                           BANK DEPOSIT:           253,806.07
                                                              _____________________________________________
                                                                 284,306.52                      283,812.21
                                                              _____________________________________________
                              AGENCY SUPPLIED ENTRY                                                  494.31D

                       MEMO TOTALS:
                       DUE FORWARDER                     0.00

                           CASH RECONCILLIATION
                           ACH                     129,373.62
                           CHECK MAIL               34,098.10
                           CREDIT CARD              45,987.20
                           DIRECT PAYMENT            9,458.15
                           WESTEREN UNIOIN          33,889.00
                                                 -------------
                           TOTAL CASH              253,806.07



     Notes:	A – cell E11
		B – cell D7
		C1 + C2 = cell D8
D – cells D9 and E17—detail provided in the A/R Charge/Adjust Report
		E – cell E8
		F – cell E16
		G – cell D5
H – cells D6 and E10



Last Page of the Payments Report


            Trust     Account Summary         Bank Deposit  Operating Acct   Trust Deposit
            1002      General Trust              18,557.17        6,568.96       11,988.21
            1004      Charlie Bank               65,881.79       14,480.81       51,400.98
            1010      Bank of America            81,417.63       16,611.73       64,805.90
            1012      Power play                 64,926.24            0.00       64,926.24
            1014      Try Harder                    426.37          426.37            0.00
            1018      Nike Mikee                  1,476.00        1,140.00          336.00
            1019      Boa Cola                      267.76           91.22          176.54
            1022      Sunni Clerk                   606.74            0.00          606.74
            1028      Horseback Town                749.18          352.84          396.34
            1031      High & Mighty                 471.72          132.08          339.64
            1032      The TOP                        75.00           30.00           45.00
            1033      BRrr Cold                     435.45          152.41          283.04
            1034      EF Hutton                   5,349.07        4,819.07          530.00
            1035      American Motors                25.00            0.00           25.00
            1037      Deep Pockets Bank             413.56            0.00          413.56
            1041      API Banking                 1,135.97          269.56          866.41
            1045      EU Pew                        306.09           81.52          224.57
            1059      Charles Barkley            10,150.67            0.00       10,150.67
            1060      Toying Around                 300.00            0.00          300.00
            1063      Great Scott                   130.00           31.20           98.80
            1064      LPGA Drivers                  704.66          225.49          479.17
                      Total                     253,806.07       45,413.26      208,392.81

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Prompts for Payments Report