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

Stmt Summary/Offset Report

 <<ETA Menu      Home       ETA Features>>

 

Provides a summary of Statement runs from which Disbursements and Net Offset are obtained for the daily balance.

 

o   This report will produce all statement summaries for the last 60 days including any from statements run during the current month.

o   Each statement/invoice is assigned a number, which prints on the statement, for easy reference.

 

The Net Offset report will detail the amount of your payable being applied to the receivables or vice versa. The entry will almost always be a debit to payables and a credit to receivables. This is a simple netting of the Due Us and Due You columns when statements are run. Also be aware, that a negative offset can occur, such as an overpayment by a client. The net offset report properly handles this situation.

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    When statements are run - Net Offset Entry, if applicable(areas highlighted below)

 

 

Text Box: 05-05-2010 22:52 STATEMENT SUMMARY AND NET OFFSET REPORT BY PRINT DATE (CI) PAGE 1 Accounting Month: May 2010 For: 05-05-10 CLIENT WEEK STM DATE BAL FORWARD CLIENT PAID WE COLLECT DIRECT PMTS TOTAL COLL CHECK AMT BILLED AMT 47394 MASSY M R27 05-04-10 900.00 0.00 0.00 0.00 0.00 0.00 900.00 900.00 TOTAL DUE US 0.00 TOTAL DUE YOU 0.00 NET OFFSET 47395 MASSY M R27 05-04-10 2,200.00 0.00 0.00 0.00 0.00 0.00 2,385.00 2,385.00 TOTAL DUE US 0.00 TOTAL DUE YOU 0.00 NET OFFSET 47396 YESTY R27 05-04-10 1,400.00 0.00 0.00 0.00 0.00 0.00 1,750.00 1,750.00 TOTAL DUE US 0.00 TOTAL DUE YOU 0.00 NET OFFSET 47398 ZEBRA CO R27 05-04-10 1,100.00 550.00 0.00 0.00 0.00 0.00 550.00 550.00 TOTAL DUE US 0.00 TOTAL DUE YOU 0.00 NET OFFSET GRAND TOTAL 225,725.67 900.00 33,526.54 2,590.78 36,117.32 27,963.11A 229,146.32 550.00 TOTAL DUE US 0.00 TOTAL DUE YOU 16,043.79B NET OFFSET Notes: A – cells D37 and E38 B – cells D34 and E35
 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 


Prompts for Stmt Summary/Offset Report