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

AR Charge/Adjustment Report

<<ETA Menu      Home       ETA Features>>

 

The AR/AP Report is a real-time sub ledger and TCS general ledger of your client account receivables and payables. The grand total should reconcile to your general ledger balance.

This report needs to ran on individual clients when their remit code is changed, i.e., from Net to Gross and vice versa. Changing the remit code changes how CUBS accounts for the transactions for the client.  Run a snapshot of the report before and after so that you can calculate the change and make the corresponding adjustment to the Accounting system.

 

o   All TC 16’s and clones of TC 16’s show up on this report. 

o   When posting, the clerk must select a ‘REASON’ from a list or enter a reason free form.

o   The REASON and the clerks initials are both reported.

 

This report lists those transactions that pertain to client adjustments only, including all trans code 16 type transactions.

AR Charge/Adjustment Report is optional report that requires controls to be put setup in the Client Posting Screen.

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

To summarize, the following entries should be made to your accounting system.

o    Once entries from the Payments, NSF, Reversal/Repost Reports and Statements are completed.  Run the AR/AP Report against the general ledger to verify that your Accounting system and TCS are in balance (area highlighted in yellow).

 

Text Box: 22:49  05 MAY 2010     AR CHARGE/ADJUSTMENT for [YOUR AGENCY]    (CI)     PAGE 1
Accounting Month: May 2010                   05-05-10

CLIENT                            TC  POST DATE  TRANS AMOUNT  REASON                INIT
18         NATIONAL Ireland Bk    16   05-05-10        400.00  TESTING               XMS
18         NATIONAL Ireland Bk    16   05-05-10        400.00  TESTING               XMS
                                                 ____________
TOTAL FOR CLIENT       18                              800.00

89535      CHASE BANK            393   05-05-10        -36.00  GINNY SAID SO         SBA
                                                 ____________
TOTAL FOR CLIENT    89535                              -36.00

89560      BASIC MONEY           390   05-05-10         13.05  GINNY                 SBA
                                                 ____________
TOTAL FOR CLIENT    89560                               13.05

89570      DANCE BANK            390   05-05-10         90.00  GINNY                 JGL
89570      DANCE BANK            393   05-05-10       -372.74  GINNY                 JRL
                                                 ____________
TOTAL FOR CLIENT    89570                             -282.74

                                                 ____________
GRAND TOTAL                                            494.31A



Notes: A – cells D9 and E17

                         

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Prompts for AR Charge/Adj Report